批量修改价格,将DataSet的内容转为Table
1.,首先用Session保存DataSet:
- DataSet dt = WebBusiness.SpecialisticManagement.QzSpecialistic.GetPricesDetail(page, rows, condition);
- HttpContext.Current.Session["dt"]=dt;//保存价格信息
DataSet dt = WebBusiness.SpecialisticManagement.QzSpecialistic.GetPricesDetail(page, rows, condition);
HttpContext.Current.Session["dt"]=dt;//保存价格信息
2.批量改价功能布局:
- //设置控件状态
- 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);
- }
- }
//设置控件状态
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:
- <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>
<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" οnclick="btnAdd_Click" OnClientClick="return fill();" /></td>
</tr>
</table>
</div>
界面显示如下:
4.实现改价功能
- /// <summary>
- ///提交按钮
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- protected void btnAdd_Click(object sender, EventArgs e)
- {
- QZ_SPECIALISTIC_PRICES goods = new QZ_SPECIALISTIC_PRICES();
- DataSet ds = HttpContext.Current.Session["dt"] as DataSet;
- DataTable dt = ds.Tables[1];
- if (ds != null && dt.Rows.Count > 0)
- {
- foreach (DataRow dr in dt.Rows)
- {
- string inputid = dr["id"].ToString();//控件id
- string value = Request[inputid];//控件值
- if (string.IsNullOrEmpty(value))
- {
- AspAlert("销售价格不能为空!");
- return;
- }
- else if (!System.Text.RegularExpressions.Regex.IsMatch(value, @"^\d{1,8}(\.\d{1,2})?$"))
- {
- AspAlert("销售价格格式错误!");
- return;
- }
- goods.PRICE = Convert.ToDecimal(value);//销售价格
- goods.MODIFY_DATE = DateTime.Now;//改价时间
- WebUserInfo user = UserInfo;
- goods.OPERATOR = user.UserName;//操作人
- WebBusiness.SpecialisticManagement.QzSpecialistic.UpdatePrices(goods, inputid);//更新记录
- }
- }
- Response.Redirect("PricesDetail.aspx");//返回专卖店价格信息页面
- }