CRM客户关系管理系统修改(十四)

修改的流程:

二:获取绑定数据依据

1.通过地址栏传参:Request.Query["ID"]
2.判断Request.Query["ID"]是否为空,如果不为空,则取出数据,用于绑定的条件筛选。
根据ID获取对应的城市:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
/// <summary>
     /// 根据省份ID获取对应的城市
     /// </summary>
     /// <param name="ProvinceID"></param>
     /// <returns></returns>
     public static DataTable getCityListByProvinceID(string ProvinceID)
     {
         SqlParameter[] pars;
 
         if (ProvinceID == null || ProvinceID == "")
         {
             pars = new SqlParameter[]{
               new SqlParameter("@tableName","tbCityInfo"),
               new SqlParameter("@columns"," * "),
               new SqlParameter("@condition"," 1=1")
             };
         }
         else
         {
             pars = new SqlParameter[]{
               new SqlParameter("@tableName","tbCityInfo"),
               new SqlParameter("@columns"," * "),
               new SqlParameter("@condition"," ProvinceInfoID ="+ProvinceID)
             };
         }
 
         return DataBaseHelper.SelectSQLReturnDataSet("GetDataByCondition", CommandType.StoredProcedure, pars).Tables[0];
     }

显示的页面:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CustomerListShow.aspx.cs" Inherits="BioErpWeb.CRMSystem.CustomerListShow" %>
 
<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />
    <link href="../Styles/AspNetPagerStyle.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    td{ text-align:center;}
    .tdsearch{ line-height:30px;}
    .menubar{ background:url(../Web/images/block_hd_bg.png); height:25px; width:100%;}
    .menubar ul{ margin:0px; padding:0px; list-style:none;}
    .menubar ul li{ display:inline; line-height:25px;}
    .menubar ul li a{display:inline-block;  text-align:center; width:100px; color:#0066CC; text-decoration:none;}
 
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div class="menubar">
     <ul>
      <li>
          <asp:HyperLink ID="HyperLink1" NavigateUrl="~/CRMSystem/CustomerListShow.aspx" Target="MainFrame" runat="server">客户资料管理</asp:HyperLink>
      </li>
 
        <li>
         <asp:HyperLink ID="HyperLink2"  NavigateUrl="~/CRMSystem/LinkManAdd.aspx"  runat="server">客户联系人管理</asp:HyperLink>
      </li>
        <li>
         <asp:HyperLink ID="HyperLink3" runat="server">联系记录管理</asp:HyperLink>
      </li>
        <li>
         <asp:HyperLink ID="HyperLink4" runat="server">客户文档管理</asp:HyperLink>
      </li>
        <li>
         <asp:HyperLink ID="HyperLink5" runat="server">客户反馈信息管理</asp:HyperLink>
      </li>
     </ul>
    </div>
    <div>
         <table class="maintable" style=" width:900px;">
             <tr>
                 <td colspan="5" class="titlebar">
                     客户<span>信息管理系统</span>
                 </td>
             </tr>
             <tr>
                 <td class="tdsearch">
                     <asp:Label ID="Label1" runat="server" Text="客户名称:"></asp:Label>
                     <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                 </td>
                 <td class="tdsearch">
                     <asp:Label ID="Label2" runat="server" Text="等级"></asp:Label>
                         <asp:DropDownList ID="ddlCustomerLevel" runat="server">
                              <asp:ListItem>一级</asp:ListItem>
                              <asp:ListItem>二级</asp:ListItem>
                              <asp:ListItem>三级</asp:ListItem>
                              <asp:ListItem>四级</asp:ListItem>
                          </asp:DropDownList>
              </td>
                 <td class="tdsearch">
                     <asp:Label ID="Label3" runat="server" Text="客户是否删除"></asp:Label>
                     <asp:DropDownList ID="ddlState" runat="server">
                         <asp:ListItem Value="0">否</asp:ListItem>
                         <asp:ListItem Value="1">是</asp:ListItem>
                     </asp:DropDownList>
                 </td>
                   <td class="tdsearch">
                     <asp:Label ID="Label11" runat="server" Text="省份"></asp:Label>
                           <asp:DropDownList ID="ddlProvince" runat="server" Width="150px">
                                                     </asp:DropDownList>
                 </td>
                 <td class="tdsearch">
                     <asp:ImageButton ID="imgbutnSearch" Width="60" Height="22" runat="server"
                         ImageUrl="~/Web/images/Btnsearch.gif" onclick="imgbutnSearch_Click" /> 
                     <asp:ImageButton ID="imgbtnNew" runat="server"  Width="60" Height="22"
                         ImageUrl="~/Web/images/btnadd.gif" onclick="imgbtnNew_Click"/>
                 </td>
             </tr>
             <tr>
                 <td colspan="5" class="bottomtd">
                     <asp:GridView ID="GridView1" Width="100%"  runat="server"  AutoGenerateColumns="False" DataKeyNames="CustomerID">
                         <Columns>                  
                             <asp:TemplateField HeaderText="客户编号" HeaderStyle-HorizontalAlign="Center">
                                 <ItemTemplate>
                                  
                                     <asp:Label ID="Label4" runat="server" Text='<%# Eval("CustomerNumber") %>'></asp:Label>
                                 </ItemTemplate>
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="客户名称" HeaderStyle-HorizontalAlign="Center">
                                 <ItemTemplate>
                                     <asp:Label ID="Label5" runat="server" Text='<%# Eval("CustomerName") %>'></asp:Label>
                                 </ItemTemplate>
                                 <ItemStyle Width="120px" HorizontalAlign="Center" />
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="法人代表" HeaderStyle-HorizontalAlign="Center">
                                 <ItemTemplate>
                                      <asp:Label ID="Label6" runat="server" Text='<%# Eval("JuridicalPerson") %>'></asp:Label>
                                 </ItemTemplate>
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="电话号码" HeaderStyle-HorizontalAlign="Center">
                                 <ItemTemplate>
                                      <asp:Label ID="Label7" runat="server" Text='<%# Eval("Tel1") %>'></asp:Label>
                                 </ItemTemplate>
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="Email" HeaderStyle-HorizontalAlign="Center">
                                <ItemTemplate>
                                      <asp:Label ID="Label8" runat="server" Text='<%# Eval("Email") %>'></asp:Label>
                                 </ItemTemplate>
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="客户等级" HeaderStyle-HorizontalAlign="Center">
                                <ItemTemplate>
                                      <asp:Label ID="Label9" runat="server" Text='<%# Eval("CustomerLevel") %>'></asp:Label>
                                 </ItemTemplate>  
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                 <ItemStyle HorizontalAlign="Center" />                         
                             </asp:TemplateField>
                              <asp:TemplateField HeaderText="客户等级" HeaderStyle-HorizontalAlign="Center">
                                <ItemTemplate>
                                      <asp:Label ID="Label9" runat="server" Text='<%# Eval("CustomerLevel") %>'></asp:Label>
                                 </ItemTemplate>  
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                 <ItemStyle HorizontalAlign="Center" />                         
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="下次联系时间" HeaderStyle-HorizontalAlign="Center">
                                <ItemTemplate>
                                      <asp:Label ID="Label10" runat="server" Text='<%# Convert.ToDateTime(Eval("NextTime")).ToString("yyyy/MM/dd") %>'></asp:Label>
                                 </ItemTemplate>
 
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
 
                                 <ItemStyle HorizontalAlign="Center" />
                             </asp:TemplateField>                     
                             <asp:HyperLinkField DataNavigateUrlFields="CustomerID"
                                 DataNavigateUrlFormatString="CustomerUpdate.aspx?ID={0}" HeaderText="操作"
                                 Text="查看并修改客户信息">
                             <HeaderStyle HorizontalAlign="Center" />
                             <ItemStyle HorizontalAlign="Center" />
                             </asp:HyperLinkField>
                         </Columns>
                     </asp:GridView>
                 </td>
             </tr>
             <tr>
              <td  colspan="5">
                  <webdiyer:AspNetPager ID="AspNetPager1" runat="server"   CssClass="paginator" CurrentPageButtonClass="cpb"
                      onpagechanged="AspNetPager1_PageChanged">
                  </webdiyer:AspNetPager>
                 </td>
             </tr>
 
     </table>
 
    </div>
    </form>
</body>
</html>

 后台代码:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
public partial class CustomerListShow : System.Web.UI.Page
   {
        
       public static int pageindex = 0;
       public static int pagesize = 10;
       public static string condition = "";
 
       protected void Page_Load(object sender, EventArgs e)
       {
           if (!IsPostBack)
           {
 
               ddlProvinceBind();
               getallCustomerList();
           }
       }
 
       /// <summary>
       /// 绑定省份
       /// </summary>
       public void ddlProvinceBind()
       {
           this.ddlProvince.DataSource = SqlComm.getProvinceInfoList();
           this.ddlProvince.DataTextField = "ProvinceInfoName";
           this.ddlProvince.DataValueField = "ProvinceInfoID";
           this.ddlProvince.DataBind();
           this.ddlProvince.Items.Add(new ListItem("--请选择省份--", "0"));
           this.ddlProvince.SelectedValue = "0";
       }
 
 
       /// <summary>
       /// 查询所有员工信息
       /// </summary>
       private void getallCustomerList()
       {
           this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_CRMCustomerInfo", condition);
         this.AspNetPager1.PageSize = pagesize;
         this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_CRMCustomerInfo", "*", "CustomerID", condition, pageindex, pagesize);
         this.GridView1.DataBind();
       }
 
       protected void AspNetPager1_PageChanged(object sender, EventArgs e)
       {
           pageindex = this.AspNetPager1.CurrentPageIndex - 1;
           getallCustomerList();
       }
 
       protected void imgbutnSearch_Click(object sender, ImageClickEventArgs e)
       {
           pageindex = 0;
           condition = "";
           if (txtName.Text.Trim() != null && this.txtName.Text.Trim().Length != 0)
           {
               condition = condition + " and CustomerName like '" + txtName.Text + "%'";
           }
                     
 
          
           if (this.ddlState.SelectedValue == "1")
           {
               condition = condition + " and DeleteState ='True'";
           }
           else
           {
               condition = condition + " and DeleteState ='False'";
           }
 
            condition = condition + " and CustomerLevel='" + this.ddlCustomerLevel.SelectedItem.Text+"' ";
 
           if (this.ddlProvince.SelectedValue != "0")
           {
               condition = condition +" and Province='"+ this.ddlProvince.SelectedItem.Text+"'";
           }
               
           
 
           getallCustomerList();
 
 
       }
 
       protected void btnNew_Click(object sender, EventArgs e)
       {
 
       }
 
       protected void imgbtnNew_Click(object sender, ImageClickEventArgs e)
       {
           Server.Transfer("CustomerAdd.aspx");
       }
 
   }

 

 

修改的前台页面:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CustomerUpdate.aspx.cs" Inherits="BioErpWeb.CRMSystem.CustomerUpdate"  %>
 
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />
    <link href="../Styles/CalenderStyle.css" rel="stylesheet" type="text/css" />
    <script src="../JS/CheckUserName.js" type="text/javascript"></script>
 
    <script src="../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <style type="text/css">
        .style1
        {
            height: 22px;
        }
        .style3
        {
            width: 252px;
        }
        .style4
        {
            width: 94px;
        }
        .style5
        {
            width: 71px;
        }
    </style>
 
    <script type="text/javascript">
        $(document).ready(function () {
            $("#btnSubmit").click(function () {
                var customer = $("#txtCustomerName");
                if (customer.val() == '') {
                    alert('必须填写客户名称');
                    return false;
                }
 
                var JuridicalPerson = $("#txtJuridicalPerson");
                if (JuridicalPerson.val() == '') {
                    alert('必须填写法人代表');
                    return false;
                }
 
                var txtRegisterTime = $("#txtRegisterTime");
                if (txtRegisterTime.val() == '') {
                    alert('公司注册时间必须填写');
                    txtRegisterTime.focus();
                    return false;
                }
 
                var txtNextTime = $("#txtNextTime");
                if (txtNextTime.val() == '') {
                    alert('下次联系时间必须填写');
                    txtNextTime.focus();
                    return false;
                }
 
                var txtUserName = $("#txtUserName");
                if (txtUserName.val() == '') {
                    alert('所属销售代表');
                    txtRegisterTime.focus();
                    return false;
                }
 
           
                var txtIntegral = $("#txtIntegral");
                if (txtIntegral.val() == '') {
                    alert('请填写用户积分');
                    txtIntegral.focus();
                    return false;
                }
 
                return true;
 
 
            });
 
        });
     
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div>
     <table class="maintable">
      <tr>
       <td colspan="4" class="titlebar"><span>客户信息编辑</span></td>
      </tr>
       <tr>
           <td>客户名</td><td><asp:TextBox ID="txtCustomerName" runat="server"></asp:TextBox></td>
           <td>法人代表</td><td><asp:TextBox ID="txtJuridicalPerson" runat="server"></asp:TextBox></td>
       </tr>
        <tr>
           <td>企业地址</td><td><asp:TextBox ID="txtAddress" runat="server"></asp:TextBox></td>
           <td>传真</td><td><asp:TextBox ID="txtFax" runat="server"></asp:TextBox></td>
       </tr>
          <tr>
           <td>电话号码1</td><td><asp:TextBox ID="txtTel1" runat="server"></asp:TextBox></td>
           <td>电话号码2</td><td><asp:TextBox ID="txtTel2" runat="server"></asp:TextBox></td>
       </tr>
           <tr>
           <td>Email邮件</td><td><asp:TextBox ID="txtEmail" runat="server"></asp:TextBox></td>
           <td>公司网址</td><td><asp:TextBox ID="txtWebSite" runat="server"></asp:TextBox></td>
       </tr>
              <tr>
           <td>注册时间</td><td><asp:TextBox ID="txtRegisterTime" runat="server"></asp:TextBox>
              <cc1:CalendarExtender ID="ceRegisterTime" TargetControlID="txtRegisterTime" Format="yyyy-MM-dd" runat="server">
               </cc1:CalendarExtender>
           </td>
           <td>所属销售代表</td><td><asp:TextBox ID="txtUserName" runat="server"></asp:TextBox><input type="button" style=" width:60px" value="选择" onclick="showDialog()"/></td>
       </tr>
             <tr>
           <td>税号</td><td><asp:TextBox ID="txtTaxNumber" runat="server"></asp:TextBox></td>
           <td>下次联系时间</td><td><asp:TextBox ID="txtNextTime" runat="server"></asp:TextBox>
            
               <cc1:CalendarExtender ID="ceNextTime" TargetControlID="txtNextTime" Format="yyyy-MM-dd" runat="server">
               </cc1:CalendarExtender>
           </td>
       </tr>
           <tr>
           <td>客户状态</td><td>
               <asp:DropDownList ID="ddlState" runat="server">
                   <asp:ListItem>良好</asp:ListItem>
                   <asp:ListItem>一般</asp:ListItem>
               </asp:DropDownList>
               </td>
           <td>客户来源</td><td>
               <asp:DropDownList ID="ddlSource" runat="server">
                   <asp:ListItem>国内</asp:ListItem>
                   <asp:ListItem>国外</asp:ListItem>
               </asp:DropDownList>
               </td>
       </tr>
          <tr>
           <td class="style1">客户类型</td><td class="style1">
              <asp:DropDownList ID="ddlType" runat="server">
                  <asp:ListItem>国有</asp:ListItem>
                  <asp:ListItem>民营</asp:ListItem>
                  <asp:ListItem>外资</asp:ListItem>
                  <asp:ListItem>合资</asp:ListItem>
                  <asp:ListItem>个体</asp:ListItem>
              </asp:DropDownList>
              </td>
           <td class="style1">所属行业</td><td class="style1">
              <asp:DropDownList ID="ddlVocation" runat="server">
                  <asp:ListItem>制造</asp:ListItem>
                  <asp:ListItem>服务</asp:ListItem>
                  <asp:ListItem>教育</asp:ListItem>
                  <asp:ListItem>医疗</asp:ListItem>
              </asp:DropDownList>
              </td>
       </tr>
          <tr>
           <td>客户性质</td><td>
              <asp:DropDownList ID="ddlProperty" runat="server">
                  <asp:ListItem>高端客户</asp:ListItem>
                  <asp:ListItem>中端客户</asp:ListItem>
                  <asp:ListItem>低端客户</asp:ListItem>
              </asp:DropDownList>
              </td>
           <td>客户等级</td><td>
              <asp:DropDownList ID="ddlCustomerLevel" runat="server">
                  <asp:ListItem>一级</asp:ListItem>
                  <asp:ListItem>二级</asp:ListItem>
                  <asp:ListItem>三级</asp:ListItem>
                  <asp:ListItem>四级</asp:ListItem>
              </asp:DropDownList>
              </td>
       </tr>
       <tr>
       <td colspan="4">
 
          <asp:UpdatePanel ID="UpdatePanel1" runat="server">
         <ContentTemplate>
         <table style=" width:100%; border:0px;">
          <tr>
           <td class="style5">省份</td><td class="style3">
              <asp:DropDownList ID="ddlProvince" runat="server" Width="150px" AutoPostBack="True"
                  onselectedindexchanged="ddlProvince_SelectedIndexChanged">
              </asp:DropDownList>
              </td>
           <td class="style4">城市</td>
           <td>
              <asp:DropDownList ID="ddlCity" Width="150px" runat="server">
              </asp:DropDownList>
              </td>
       </tr>
       </table>
         </ContentTemplate>
         </asp:UpdatePanel>
          
       </td>
       </tr>
       
          <tr>
           <td>开户银行</td><td><asp:TextBox ID="txtBank" runat="server"></asp:TextBox></td>
           <td>银行账号</td><td><asp:TextBox ID="txtAccounts" runat="server"></asp:TextBox></td>
       </tr>
 
          <tr>
           <td>积分</td><td><asp:TextBox ID="txtIntegral" runat="server"></asp:TextBox></td>
           <td>信用级别</td><td><asp:TextBox ID="txtCredit" runat="server"></asp:TextBox></td>
       </tr>
 
          <tr>
           <td>所属区域</td><td>
              <asp:DropDownList ID="ddlArea" runat="server" Width="150px"
                  >
                  <asp:ListItem>东</asp:ListItem>
                  <asp:ListItem>西</asp:ListItem>
                  <asp:ListItem>南</asp:ListItem>
                  <asp:ListItem>北</asp:ListItem>
              </asp:DropDownList>
              </td>
           <td>是否删除</td><td>
               <asp:DropDownList ID="ddlDelete" runat="server">
                   <asp:ListItem Value="0">否</asp:ListItem>
                   <asp:ListItem Value="1">是</asp:ListItem>
               </asp:DropDownList>
           </td>
       </tr>
 
          <tr>
           <td> </td><td>
               </td>
           <td> </td><td>
                </td>
       </tr>
 
          <tr>
           <td>备注:</td><td colspan="3">
              <asp:TextBox ID="txtRemark" runat="server" Rows="2" TextMode="MultiLine"
                  Width="580px"></asp:TextBox>
              </td>
       </tr>
 
         <tr>
             <td colspan="4" class="bottomtd">
              
                 <asp:Button ID="btnSubmit" runat="server" Text="客户资料编辑"
                     onclick="btnSubmit_Click" />
                                   
                 <asp:Button ID="btnReturn" runat="server" Text="返回列表" onclick="btnReturn_Click"
                     />
              
             </td>
         </tr>
 
     </table>
        <br />
    </div>
    </form>
</body>
</html>

 后台代码:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
public partial class CustomerUpdate : System.Web.UI.Page
   {
 
       BioCrmCustomerBLL cbll = new BioCrmCustomerBLL();
       static BioCrmCustomer customer = new BioCrmCustomer();
       protected void Page_Load(object sender, EventArgs e)
       {
           if (!IsPostBack)
           {
               ddlProvinceBind();
               ddlCityBind();
               pageinfoband();
           }
       }
 
       /// <summary>
       /// 绑定页面信息
       /// </summary>
       public void pageinfoband()
       {
           if (Request.QueryString["ID"] == null)
           {
               Server.Transfer("CustomerListShow.aspx");
           }
           else
           {
               string id = Request.QueryString["ID"].ToString();
               customer= cbll.GetCustomerByID(id);
                   this.txtCustomerName.Text = customer.CustomerName;           
                   this.txtJuridicalPerson.Text=customer.JuridicalPerson ;
                   this.txtAddress.Text=customer.Address ;
                   this.txtFax.Text=customer.Fax ;
                   this.txtTel1.Text=customer.Tel1  ;
                   this.txtTel2.Text= customer.Tel2  ;
                   this.txtEmail.Text= customer.Email;
                   this.txtWebSite.Text= customer.WebSite;
                   this.txtRegisterTime.Text=   customer.RegisterTime.ToString() ;
                   this.txtUserName.Text=customer.UserID.ToString()  ;
                   this.txtTaxNumber.Text= customer.TaxNumber ;
                   this.txtNextTime.Text=customer.NextTime.ToString();
                   this.ddlState.SelectedItem.Text =  customer.State ;
                   this.ddlState.SelectedItem.Text= customer.Source ;
                   this.ddlCustomerLevel.SelectedItem.Text=   customer.CustomerLevel ;
                   this.ddlProperty.SelectedItem.Text=  customer.Property ;
                   this.ddlType.SelectedItem.Text=  customer.Type ;
                   this.ddlVocation.SelectedItem.Text=customer.Vocation ;
                   this.ddlProvince.SelectedItem.Text=customer.Province;
                   this.ddlCity.SelectedItem.Text=customer.City  ;
                   this.txtBank.Text=customer.Bank  ;
                   this.txtAccounts.Text=customer.Accounts  ;
                   this.txtIntegral.Text=customer.Integral.ToString();
                   this.txtCredit.Text= customer.Credit ;
                   this.txtRemark.Text=customer.Remark  ;
                   this.ddlArea.SelectedValue=customer.Area  ;
                   this.ddlDelete.SelectedValue = customer.DeleteState == true ? "1" : "0";
           }
       }
       //绑定省份信息
       public void ddlProvinceBind()
       {
           this.ddlProvince.DataSource = SqlComm.getProvinceInfoList();
           this.ddlProvince.DataTextField = "ProvinceInfoName";
           this.ddlProvince.DataValueField = "ProvinceInfoID";
           this.ddlProvince.DataBind();
           this.ddlProvince.Items.Add(new ListItem("--请选择省份--","0"));
           this.ddlProvince.SelectedValue="0";
       }
 
       public void ddlCityBind()
       {
           this.ddlCity.DataSource = SqlComm.getCityListByProvinceID(null);
           this.ddlCity.DataTextField = "CityInfoName";
           this.ddlCity.DataValueField = "CityInfoID";
           this.ddlCity.DataBind();
           this.ddlCity.Items.Add(new ListItem("--请选择城市--", "0"));
           this.ddlCity.SelectedValue = "0";
       }
 
 
       protected void btnSubmit_Click(object sender, EventArgs e)
       {
           
           customer.CustomerName = this.txtCustomerName.Text;
           customer.JuridicalPerson = this.txtJuridicalPerson.Text;
           customer.Address = this.txtAddress.Text;
           customer.Fax = this.txtFax.Text;
           customer.Tel1 = this.txtTel1.Text;
           customer.Tel2 = this.txtTel2.Text;
           customer.Email = this.txtEmail.Text;
           customer.WebSite = this.txtWebSite.Text;
           customer.RegisterTime = Convert.ToDateTime(this.txtRegisterTime.Text);
           customer.UserID = int.Parse(this.txtUserName.Text);
           customer.TaxNumber = this.txtTaxNumber.Text;
           customer.NextTime = Convert.ToDateTime(this.txtNextTime.Text);
           customer.State=  this.ddlState.SelectedItem.Text;
           customer.Source = this.ddlState.SelectedItem.Text;
           customer.CustomerLevel = this.ddlCustomerLevel.SelectedItem.Text;
           customer.Property = this.ddlProperty.SelectedItem.Text;
           customer.Type = this.ddlType.SelectedItem.Text;
           customer.Vocation = this.ddlVocation.SelectedItem.Text;
           customer.Province = this.ddlProvince.SelectedItem.Text;
           customer.City = this.ddlCity.SelectedItem.Text;
           customer.Bank = this.txtBank.Text;
           customer.Accounts = this.txtAccounts.Text;
           customer.Integral =int.Parse(this.txtIntegral.Text.Trim());
           customer.Credit = this.txtCredit.Text;
           customer.Remark = this.txtRemark.Text;
           customer.Area = this.ddlArea.SelectedValue;
           customer.DeleteState = this.ddlDelete.SelectedValue == "0" ? false : true;
           BioCrmCustomerBLL custormerbll = new BioCrmCustomerBLL();
           if (custormerbll.CustomerUpdate(customer) != 0)
           {
               ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('编辑成功')", true);
               Server.Transfer("CustomerListShow.aspx");
           }
           else
           {
               ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('编辑失败')", true);
               Server.Transfer("CustomerListShow.aspx");
           }
 
 
 
 
       }
 
       protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e)
       {
           if (this.ddlProvince.SelectedValue != "0")
           {
               string ProvinceId = this.ddlProvince.SelectedValue.ToString();
               ddlCity.DataSource = SqlComm.getCityListByProvinceID(ProvinceId);
               ddlCity.DataTextField = "CityInfoName";
               ddlCity.DataValueField = "CityInfoID";
               ddlCity.DataBind();
           }
       }
 
       protected void btnReturn_Click(object sender, EventArgs e)
       {
           Server.Transfer("CustomerListShow.aspx");
       
   }

 

 

posted @   石shi  阅读(347)  评论(0编辑  收藏  举报
编辑推荐:
· Java 中堆内存和栈内存上的数据分布和特点
· 开发中对象命名的一点思考
· .NET Core内存结构体系(Windows环境)底层原理浅谈
· C# 深度学习:对抗生成网络(GAN)训练头像生成模型
· .NET 适配 HarmonyOS 进展
阅读排行:
· 用 DeepSeek 给对象做个网站,她一定感动坏了
· DeepSeek+PageAssist实现本地大模型联网
· 手把手教你更优雅的享受 DeepSeek
· 腾讯元宝接入 DeepSeek R1 模型,支持深度思考 + 联网搜索,好用不卡机!
· 从 14 秒到 1 秒:MySQL DDL 性能优化实战
点击右上角即可分享
微信分享提示