-
大小: 11.05M文件類型: .rar金幣: 1下載: 0 次發(fā)布日期: 2023-07-27
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: 其他??
資源簡(jiǎn)介
vs2010+sqlserver2017.rar
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data;
using?System.Configuration;
using?System.Data.SqlClient;
public?partial?class?add_customer?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????if?(!IsPostBack)?{?}
????}
????protected?void?Button1_Click(object?sender?EventArgs?e)?????//錄入按鈕
????{
????????if?(this.IsValid)
????????{
????????????try
????????????{
????????????????string?cu_id?=?TextBox1.Text.Trim();??//獲取客戶編號(hào)
????????????????string?cu_name?=?TextBox2.Text.Trim();//獲取姓名
????????????????string?cu_sex?=?null;
????????????????if?(RadioButton1.Checked)
????????????????{
????????????????????cu_sex?=?RadioButton1.Text;
????????????????}
????????????????else
????????????????{
????????????????????cu_sex?=?RadioButton2.Text;
????????????????}
????????????????string?cu_tel?=?TextBox3.Text.Trim();??//獲取電話
????????????????string?cu_address?=?TextBox4.Text.Trim();??//獲取地址
????????????????string?cu_goods?=?TextBox5.Text.Trim();//?獲取所購(gòu)商品
????????????????string?cu_num?=?TextBox6.Text.Trim();??//獲取所購(gòu)商品數(shù)量
????????????????string?cu_state?=?DropDownList1.SelectedItem.Text.Trim();??//獲取付款狀態(tài)
????????????????string?cu_time?=?TextBox7.Text.Trim();????//獲取購(gòu)買時(shí)間
????????????????ConnSql?con?=?new?ConnSql();
????????????????string?sqltext?=?“select?*?from?tb_customer?where?cu_id=‘“?+?cu_id?+?“‘“;
????????????????if?(con.RunSqlReturnTable(sqltext).Rows.Count?==?0)
????????????????{????????????
????????????????????SqlParameter[]?prams?=?new?SqlParameter[]?{?new?SqlParameter(“@cu_id“?cu_id)?new?SqlParameter(“@cu_name“?cu_name)?new?SqlParameter(“@cu_sex“?cu_sex)?new?SqlParameter(“@cu_tel“?cu_tel)?new?SqlParameter(“@cu_address“?cu_address)?new?SqlParameter(“@cu_goods“?cu_goods)?new?SqlParameter(“@cu_num“?cu_num)?new?SqlParameter(“@cu_state“?cu_state)?new?SqlParameter(“@cu_time“cu_time)};
????????????????????int?i?=?con.add_staff(“pr_add_customer“?prams);
????????????????????if?(i?>?0)
????????????????????{
????????????????????????Response.Write(“ript>alert(‘信息錄入成功!‘); ript>“);
????????????????????????Response.Redirect(“customer_list.aspx“);
????????????????????}
????????????????????else
????????????????????{
????????????????????????Response.Write(“ript>alert(‘信息錄入失敗!‘); ript>“);
????????????????????}
????????????????}
????????????????else
????????????????{
????????????????????Response.Write(“ript>alert(‘該信息已存在!‘); ript>“);
????????????????}
????????????}
????????????catch?(Exception)
????????????{
????????????????Response.Write(“ript>alert(\‘信息錄入失?。‘); ript>“);
????????????}
????????}
????}
????protected?void?Button2_Click(object?sender?EventArgs?e)???//取消按鈕
????{
????????TextBox2.Text?=?TextBox3.Text?=?TextBox4.Text?=?TextBox5.Text?=?TextBox6.Text?=?TextBox7.Text?=?string.Empty;
????????TextBox1.Text?=?““;
?
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????8388608??2019-12-26?10:13??vs?2010?+sql?server?2017\數(shù)據(jù)庫\com.mdf
?????文件????8388608??2019-12-26?10:13??vs?2010?+sql?server?2017\數(shù)據(jù)庫\com_log.ldf
?????文件??????17764??2019-12-16?10:26??vs?2010?+sql?server?2017\程序源代碼\com\add_customer.aspx
?????文件???????3413??2019-12-16?09:18??vs?2010?+sql?server?2017\程序源代碼\com\add_customer.aspx.cs
?????文件??????15554??2019-12-21?15:35??vs?2010?+sql?server?2017\程序源代碼\com\add_staff.aspx
?????文件???????3742??2019-12-16?09:18??vs?2010?+sql?server?2017\程序源代碼\com\add_staff.aspx.cs
?????文件??????16156??2019-12-16?09:12??vs?2010?+sql?server?2017\程序源代碼\com\add_supplier.aspx
?????文件???????4068??2019-12-16?09:18??vs?2010?+sql?server?2017\程序源代碼\com\add_supplier.aspx.cs
?????文件???????6612??2019-12-22?13:42??vs?2010?+sql?server?2017\程序源代碼\com\analy.aspx
?????文件???????3922??2019-12-22?14:55??vs?2010?+sql?server?2017\程序源代碼\com\analy.aspx.cs
?????文件???????2391??2019-12-08?19:55??vs?2010?+sql?server?2017\程序源代碼\com\analysis.aspx
?????文件????????280??2019-12-07?14:37??vs?2010?+sql?server?2017\程序源代碼\com\analysis.aspx.cs
?????文件???????2616??2019-12-22?14:29??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\analysis.cs
?????文件???????1100??2019-11-30?10:40??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\BLL.cs
?????文件???????6287??2019-12-19?20:10??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\ConnSql.cs
?????文件???????2331??2019-12-21?15:29??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\Controller.cs
?????文件???????1005??2019-12-05?19:03??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\ConView.cs
?????文件???????1013??2019-11-30?10:39??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\DAL.cs
?????文件????????168??2019-12-02?21:19??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\Export.cs
?????文件????????884??2019-12-22?15:05??vs?2010?+sql?server?2017\程序源代碼\com\App_Code\Message.cs
?????文件???????1266??2014-06-06?08:54??vs?2010?+sql?server?2017\程序源代碼\com\assets\css\reset.css
?????文件??????16269??2014-10-21?00:22??vs?2010?+sql?server?2017\程序源代碼\com\assets\css\thems.css
?????文件????????475??2014-10-18?20:54??vs?2010?+sql?server?2017\程序源代碼\com\assets\images\btn2.png
?????文件????????495??2014-10-19?14:27??vs?2010?+sql?server?2017\程序源代碼\com\assets\images\btn3.png
?????文件????????478??2014-10-19?15:57??vs?2010?+sql?server?2017\程序源代碼\com\assets\images\btn4.png
?????文件????????466??2014-10-19?15:57??vs?2010?+sql?server?2017\程序源代碼\com\assets\images\btn5.png
?????文件????????605??2014-10-17?20:41??vs?2010?+sql?server?2017\程序源代碼\com\assets\images\btn_bg.png
?????文件?????570792??2019-11-09?00:56??vs?2010?+sql?server?2017\程序源代碼\com\Bin\Newtonsoft.Json.dll
?????文件????????146??2019-12-20?18:15??vs?2010?+sql?server?2017\程序源代碼\com\Bin\Newtonsoft.Json.dll.refresh
?????文件?????217260??2019-11-09?00:52??vs?2010?+sql?server?2017\程序源代碼\com\Bin\Newtonsoft.Json.pdb
............此處省略819個(gè)文件信息
評(píng)論
共有 條評(píng)論