商店批量改价功能实现

批量修改价格，将DataSet的内容转为Table

1.,首先用Session保存DataSet:

[csharp] view plain copy print ?

1. DataSet dt = WebBusiness.SpecialisticManagement.QzSpecialistic.GetPricesDetail(page, rows, condition);   
2. HttpContext.Current.Session["dt"]=dt;//保存价格信息  

DataSet dt = WebBusiness.SpecialisticManagement.QzSpecialistic.GetPricesDetail(page, rows, condition); 
HttpContext.Current.Session["dt"]=dt;//保存价格信息

2.批量改价功能布局：

[csharp] view plain copy print ?

1. //设置控件状态  
2.         protected void BindControl()  
3.         {  
4.             DataSet ds = HttpContext.Current.Session["dt"] as DataSet;  
5.             DataTable dt = ds.Tables[1];  
6.             StringBuilder sb = new StringBuilder();  
7.   
8.             if (ds != null && dt.Rows.Count > 0)  
9.             {  
10.                 foreach (DataRow dr in dt.Rows)  
11.                 {   
12.                     sb.Append("\n<tr>");  
13.                     sb.Append("<td>商品编码:" + dr["meat_code"].ToString() + "</td>");  
14.                     sb.Append("<td>商品名称:" + dr["meat_name"].ToString() + "</td>");  
15.                     sb.Append("<td>销售价格:");  
16.                     sb.Append("<input type='text' size='10'  value=" + dr["price"].ToString() + " name='" + dr["id"].ToString() + "' /></td>");  
17.                     sb.Append("</tr>");  
18.                 }  
19.                 Response.Write(sb);  
20.             }    
21.         }  

//设置控件状态
		protected void BindControl()
		{
			DataSet ds = HttpContext.Current.Session["dt"] as DataSet;
			DataTable dt = ds.Tables[1];
			StringBuilder sb = new StringBuilder();

			if (ds != null && dt.Rows.Count > 0)
			{
				foreach (DataRow dr in dt.Rows)
				{ 
					sb.Append("\n<tr>");
					sb.Append("<td>商品编码:" + dr["meat_code"].ToString() + "</td>");
					sb.Append("<td>商品名称:" + dr["meat_name"].ToString() + "</td>");
					sb.Append("<td>销售价格:");
					sb.Append("<input type='text' size='10'  value=" + dr["price"].ToString() + " name='" + dr["id"].ToString() + "' /></td>");
					sb.Append("</tr>");
				}
				Response.Write(sb);
			}  
		}

3.前台HTML：

[html] view plain copy print ?

1. <div id="edit">  
2.               <table cellpadding="10" cellspacing="5" class="edittb">  
3.                <%BindControl(); %>  
4.               <tr>  
5.                    <td style="padding-right:10px;text-align:right;" colspan="3"><asp:Button ID="btnAdd"  runat="server" Text="提交" CssClass="btn_search" onclick="btnAdd_Click"  OnClientClick="return fill();" /></td>  
6.               </tr>  
7.           </table>  
8.       </div>  

  <div id="edit">
                <table cellpadding="10" cellspacing="5" class="edittb">
                 <%BindControl(); %>
                <tr>
                     <td style="padding-right:10px;text-align:right;" colspan="3"><asp:Button ID="btnAdd"  runat="server" Text="提交" CssClass="btn_search" onclick="btnAdd_Click"  OnClientClick="return fill();" /></td>
                </tr>
            </table>
        </div>

界面显示如下：

4.实现改价功能

[csharp] view plain copy print ?

1. /// <summary>  
2.         ///提交按钮  
3.         /// </summary>  
4.         /// <param name="sender"></param>  
5.         /// <param name="e"></param>  
6.         protected void btnAdd_Click(object sender, EventArgs e)  
7.         {  
8.             QZ_SPECIALISTIC_PRICES goods = new QZ_SPECIALISTIC_PRICES();  
9.             DataSet ds = HttpContext.Current.Session["dt"] as DataSet;  
10.             DataTable dt = ds.Tables[1];  
11.             if (ds != null && dt.Rows.Count > 0)  
12.             {  
13.                 foreach (DataRow dr in dt.Rows)  
14.                 {  
15.                     string inputid = dr["id"].ToString();//控件id  
16.                     string value = Request[inputid];//控件值  
17.                     if (string.IsNullOrEmpty(value))  
18.                     {  
19.                         AspAlert("销售价格不能为空！");  
20.                         return;  
21.                     }  
22.                     else if (!System.Text.RegularExpressions.Regex.IsMatch(value, @"^\d{1,8}(\.\d{1,2})?$"))  
23.                     {  
24.                         AspAlert("销售价格格式错误！");  
25.                         return;  
26.                     }  
27.                     goods.PRICE = Convert.ToDecimal(value);//销售价格  
28.                     goods.MODIFY_DATE = DateTime.Now;//改价时间  
29.                     WebUserInfo user = UserInfo;  
30.                     goods.OPERATOR = user.UserName;//操作人  
31.                     WebBusiness.SpecialisticManagement.QzSpecialistic.UpdatePrices(goods, inputid);//更新记录  
32.                 }  
33.             }  
34.             Response.Redirect("PricesDetail.aspx");//返回专卖店价格信息页面  
35.               
36.         }