private void btn_Save_Click(object sender, System.EventArgs e) { if (txtCouponsId.Value != "") { DataTable dt = DataBaseHelper.GetDataTable("Hishop_CouponsRule", " CouponsId=" + txtCouponsId.Value, ""); foreach (ListItem item in chk_cate.Items) { if (item.Selected) { DataRow[] adddrs = dt.Select(string.Format("CategoryId={0}", item.Value)); if (adddrs.Length == 0) { DataRow dr = dt.NewRow(); dr["CouponsId"] = txtCouponsId.Value; dr["CategoryId"] = item.Value; dt.Rows.Add(dr); } } else { DataRow[] deldrs = dt.Select(string.Format("CategoryId={0}", item.Value)); if (deldrs.Length > 0) { deldrs[0].Delete(); } } } DataBaseHelper.CommitDataTable(dt, "select * from Hishop_CouponsRule where CouponsId = " + txtCouponsId.Value); this.ShowMsg("成功删除了选定张优惠券", true); } }
//清除商品区域关系 private void btnRemove_Click(object sender, System.EventArgs e) { //构建条件 string strSqlwhere = string.Format(@"ProductID in ({0})", this.txtProductIds.Value); //得到商品区域关系表结构 DataTable dtProductRegion = DataBaseHelper.GetDataTable("Erp_ProductRegion", strSqlwhere, null); //循环删除所选商品区域关系 foreach (DataRow dr in dtProductRegion.Rows) { dr.Delete(); } //将表提交到数据库 string str = string.Empty;//定义回调提示语变量 if (DataBaseHelper.CommitDataTable(dtProductRegion, "SELECT * from Erp_ProductRegion") != -1) { str = string.Format("ShowMsg(\"{0}\", {1})", "清除商品区域关系生效。", "true");//成功 } else { str = string.Format("ShowMsg(\"{0}\", {1})", "清除商品区域关系失败!", "false");//失败 } //前端(客户端)弹出提示 if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); } }
protected void btnAdd_Click(object sender, EventArgs e) { bool flag = false; int num = 0; if (!int.TryParse(base.Request.QueryString["UserID"], out num)) { base.Response.Redirect("managers.aspx"); } //将选中的地址转换成数组 string[] arrayRegionId = txtRegionScop.Value.ToString().Split(','); string[] arrayRegionName = txtRegionScopName.Value.ToString().Split(','); currentArea = (DataTable)ViewState["currentArea"]; for (int i = 0; i < arrayRegionId.Length; i++) { if (currentArea.Select("RegionID = '" + arrayRegionId[i] + "'").Length == 0) { DataRow drNew = currentArea.NewRow(); drNew["MRegionID"] = Guid.NewGuid(); drNew["UserId"] = Request.QueryString["UserId"]; drNew["RegionID"] = arrayRegionId[i]; drNew["RegionName"] = arrayRegionName[i]; currentArea.Rows.Add(drNew); } } int rowsCount = currentArea.Rows.Count; //减少处理 for (int i = 0; i < rowsCount; i++) { if (this.txtRegionScop.Value.ToString().ToLower().IndexOf(currentArea.Rows[i]["RegionID"].ToString().ToLower()) == -1) { currentArea.Rows[i].Delete(); } } //开始对数据库进行更新操作 string str = ""; if (DataBaseHelper.CommitDataTable(currentArea, "SELECT * from erp_managersregion") != -1) { str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单生效。", "true"); } else { str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单失败!", "false"); } if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); } }
//保存商品区域关系 protected void btnSave_Click(object sender, EventArgs e) { //将选中的地址转换成数组 string[] arrayRegionId = txtRegionScop.Value.ToString().Split(','); string[] arrayRegionName = txtRegionScopName.Value.ToString().Split(','); //得到选择的商品Id值集合 string[] arrayProductId = this.txtProductIds.Value.Split(','); //构建条件 string strSqlwhere = string.Format(@"ProductID in ({0})", this.txtProductIds.Value); //得到商品区域关系表结构 dtProductRegion = DataBaseHelper.GetDataTable("Erp_ProductRegion", strSqlwhere, null); //循环构建数据 if (arrayRegionId.Length == arrayRegionName.Length) { for (int i = 0; i < arrayProductId.Length; i++) { for (int k = 0; k < arrayRegionId.Length; k++) { if (dtProductRegion.Select(string.Format(@"ProductID = '{0}' and RegionID = '{1}'", arrayProductId[i], arrayRegionId[k]), "", DataViewRowState.CurrentRows).Length == 0) { DataRow drNew = dtProductRegion.NewRow(); //构建新行 drNew["ID"] = Guid.NewGuid(); //构建新的Guid值 drNew["ProductID"] = arrayProductId[i]; //插入商品ID drNew["RegionID"] = arrayRegionId[k]; //插入区域ID drNew["RegionName"] = arrayRegionName[k]; //插入区域名称 dtProductRegion.Rows.Add(drNew); //插入行 } } } } //将表提交到数据库 string str = string.Empty;//定义回调提示语变量 if (DataBaseHelper.CommitDataTable(dtProductRegion, "SELECT * from Erp_ProductRegion") != -1) { str = string.Format("ShowMsg(\"{0}\", {1})", "保存商品区域关系生效。", "true");//成功 } else { str = string.Format("ShowMsg(\"{0}\", {1})", "保存商品区域关系失败!", "false");//失败 } //前端(客户端)弹出提示 if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);setTimeout(function(){CloseDialogFrame()},1000);</script>"); } }
/// <summary> /// 提交到订货列表按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBuy_Click(object sender, System.EventArgs e) { btnBuy.Enabled = false;//禁用按钮 if (!string.IsNullOrEmpty(this.txtSkuIds.Value)) { //得到当前登录用户所在区域 ManagerInfo currentManager = ManagerHelper.GetCurrentManager();//当前登录用户信息 //得到商品区域关系表结构 DataTable dtAgentProduct = DataBaseHelper.GetDataTable("Erp_AgentProduct", string.Empty, null); //得到选择的商品Id值集合 string[] arraySkuId = this.txtSkuIds.Value.Split(','); for (int i = 0; i < arraySkuId.Length; i++) { if (dtAgentProduct.Select(string.Format(@"SkuId = '{0}' and UserId = '{1}'", arraySkuId[i].ToString(), currentManager.UserId), "", DataViewRowState.CurrentRows).Length == 0) { DataRow dr = dtAgentProduct.NewRow(); dr["SkuId"] = arraySkuId[i].ToString(); dr["UserId"] = currentManager.UserId; dr["Date"] = DateTime.Now; dtAgentProduct.Rows.Add(dr); } } //将表提交到数据库 string str = string.Empty;//定义回调提示语变量 if (dtAgentProduct.GetChanges() != null) { if (DataBaseHelper.CommitDataTable(dtAgentProduct, "SELECT * from Erp_AgentProduct") != -1) { str = string.Format("ShowMsg(\"{0}\", {1})", "提交到订货列表生效。", "true");//成功 } else { str = string.Format("ShowMsg(\"{0}\", {1})", "提交到订货列表失败!", "false");//失败 } } else { str = string.Format("ShowMsg(\"{0}\", {1})", "提交到订货列表的商品已经存在,不需要重复提交!", "false");//无改变 } //前端(客户端)弹出提示 if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); } btnBuy.Enabled = true;//启用按钮 } }
protected void btnSave_Click(object sender, EventArgs e) { //待处理的数据集 DataTable dtData = (DataTable)ViewState["currentMenuIds"]; this.hiSelectIDS = (HiddenField)this.FindControl("hiSelectIDS"); string[] arrayDataID = hiSelectIDS.Value.ToString().Split(','); //新增处理 foreach (string dataID in arrayDataID) { if (dtData.Select("MRMenuid = '" + dataID + "'").Length == 0) { DataRow drNew = dtData.NewRow(); drNew["MRID"] = Guid.NewGuid(); drNew["MRRoleID"] = Request.QueryString["roleId"]; drNew["MRMenuid"] = dataID; dtData.Rows.Add(drNew); } } int rowsCount = dtData.Rows.Count; //减少处理 for (int i = 0; i < rowsCount; i++) { if (this.hiSelectIDS.Value.ToLower().IndexOf(dtData.Rows[i]["MRMenuid"].ToString().ToLower()) == -1) { dtData.Rows[i].Delete(); } } //开始对数据库进行更新操作 string str = ""; if (DataBaseHelper.CommitDataTable(dtData, "SELECT * from YiHui_MenuRelation") != -1) { str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单生效。", "true"); } else { str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单失败!", "false"); } if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); } }
protected void btnAdd_Click(object sender, EventArgs e) { string Name = txtName.Text.Trim(); txtSkinName.Value = Name; txtSkinID.Value = Guid.NewGuid() + ""; DataTable dt = DataBaseHelper.GetDataTable("YiHui_HomePage_Skin", "1=2"); DataRow dr = dt.NewRow(); dr["SkinID"] = txtSkinID.Value; dr["Name"] = Name; dr["SkinType"] = 2; dt.Rows.Add(dr); DataBaseHelper.CommitDataTable(dt, "select * from YiHui_HomePage_Skin where 1=2"); rptSkin.DataSource = DataBaseHelper.GetDataTable("YiHui_HomePage_Skin"); rptSkin.DataBind(); panelHomePage.Controls.Clear(); }
protected void btnAddButton_Click(object sender, System.EventArgs e) { //得到表的数据源 DataTable dataBase = DataBaseHelper.GetDataTable("Hishop_ProductDistributor", string.Format("ProductId ='{0}'", ProductId)); //获取当前主键表的列数 dataBase.PrimaryKey = new DataColumn[] { dataBase.Columns["id"] }; //新表克隆旧表的架构 DataTable newDt = dataBase.Clone(); //获取当前主键表的列数 newDt.PrimaryKey = new DataColumn[] { newDt.Columns["id"] }; //获取隐藏域的值 string strUserInput = into.Value; //隐藏域的值去分号 string[] strUserInputTrs = strUserInput.Split(';'); //如果隐藏域的值不为空 if (into.Value != "") { //循环 foreach (string UserInputTrs in strUserInputTrs) { //去逗号 string[] sUserInputTr = UserInputTrs.Split(','); //创建相同构架的表 DataRow drNew = newDt.NewRow(); //三元运算符 如果sUserInputTr[0]索引为空 就生成新的Guid drNew["id"] = (string.IsNullOrEmpty(sUserInputTr[0])) ? Guid.NewGuid() : new Guid(sUserInputTr[0]); drNew["ProductId"] = ProductId; drNew["Distributor"] = sUserInputTr[1]; drNew["Price"] = sUserInputTr[2]; newDt.Rows.Add(drNew); } } //根据两个表生成的Datatable 用于整表提交 dataBase = DataBaseHelper.GetDtDifferent(dataBase, newDt); if (DataBaseHelper.CommitDataTable(dataBase, "Select * From Hishop_ProductDistributor") != -1) { this.ShowMsgAndReUrl("保存成功!", true, "ProductDistributor.aspx?ProductId=" + ProductId); } }
protected void btnAddButton_Click(object sender, System.EventArgs e) { //得到原始数据 DataTable dtDataBase = DataBaseHelper.GetDataTable("Hishop_ProductsList", string.Format("CommodityId={0}", ProductId)); //设置表的主键 dtDataBase.PrimaryKey = new DataColumn[] { dtDataBase.Columns["id"] }; //用户输入的DataTable(新表等于旧表) DataTable newDt = dtDataBase.Clone(); newDt.PrimaryKey = new DataColumn[] { newDt.Columns["id"] }; //更新用户输入的数据 //获取隐藏域的值 string strUserInput = info.Value; //(id#code#来源@id2#code2#来源2) //隐藏域的值去分号分割 string[] strUserInputTrs = strUserInput.Split(';'); if (info.Value != "") { foreach (string strUserInputTr in strUserInputTrs) { string[] strProduct = strUserInputTr.Split(','); DataRow drNew = newDt.NewRow(); drNew["id"] = (string.IsNullOrEmpty(strProduct[0])) ? Guid.NewGuid() : new Guid(strProduct[0]); drNew["CommodityId"] = ProductId; drNew["CommoditySource"] = strProduct[1]; drNew["CommodityCode"] = strProduct[2]; newDt.Rows.Add(drNew); } } dtDataBase = DataBaseHelper.GetDtDifferent(dtDataBase, newDt); //根据两个表的不同生成新的dt1,用于整表提交 //整表提交 if (DataBaseHelper.CommitDataTable(dtDataBase, "Select * From Hishop_ProductsList") != -1) { this.ShowMsgAndReUrl("保存成功!", true, "ModifyGoods.aspx?ProductId=" + ProductId); } }
protected void btnSave_Click(object sender, EventArgs e) { string json = hiSelectIDS.Value; DataTable dtData = JsonToDataTable((DataTable)ViewState["allMenus"], json); string str = ""; if (DataBaseHelper.CommitDataTable(dtData, "SELECT * from YiHui_MenuInfo") != -1) { BindData(); str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单生效。", "true"); } else { str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单失败!", "false"); } if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); } /* * SqlDataAdapter SDA = new SqlDataAdapter(); * SqlCommandBuilder SCB = new SqlCommandBuilder(SDA); * SDA.Update(allMenus); * * * //数据 * DataTable dtNew = new DataTable(); * dtNew.Columns.Add("ID",typeof(int)); * dtNew.Columns.Add("Name", typeof(string)); * dtNew.Rows.Add(new string[]{"1","T1"}); * dtNew.Rows.Add(new string[] { "2", "T2" }); * dtNew.AcceptChanges(); */ //用户 //dtNew.Rows[0]["Name"] = "T_New"; //dtNew.Rows[0].RowState /* * string ids = this.hiSelectIDS.Value; * string str = ""; * if (AdminMenuHelper.UpdateSelectMenus(ids)) * { * str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单生效。", "true"); * } * else * { * str = string.Format("ShowMsg(\"{0}\", {1})", "保存功能配置菜单失败!", "false"); * } * if (!this.Page.ClientScript.IsClientScriptBlockRegistered("ServerMessageScript")) * { * this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>"); * } */ /* * xmldoc = new XmlDocument(); * xmldoc.Load(GetMasterSettingsFilename("Menu_Select")); * XmlNode root = xmldoc.SelectSingleNode("Menu"); * root.InnerText = this.hiSelectIDS.Value; * xmldoc.Save(GetMasterSettingsFilename("Menu_Select")); * * string[] arrayID = this.hiSelectIDS.Value.Trim(',').Split(','); * string[] arrayName = this.hiSelectNameS.Value.Split(','); * string[] arrayLink = this.hiSelectLinkS.Value.Split(','); * string strMenuTypeName=string.Empty; * * XmlTextWriter xmlWriter; * string strFilename = GetMasterSettingsFilename("Menu"); * * xmlWriter = new XmlTextWriter(strFilename, Encoding.UTF8);//创建一个xml文档 * xmlWriter.Formatting = Formatting.Indented; * xmlWriter.WriteStartDocument(); * xmlWriter.WriteStartElement("Menu"); * * for (int i=0; i < arrayID.Length; i++) * { * if (i > 0) * { * int j = arrayID[i - 1].Length - arrayID[i].Length + 1; * for (int k = 0; k < j; k++) * xmlWriter.WriteEndElement(); * } * switch (arrayID[i].Length) * { * case 1: * strMenuTypeName="Module"; * break; * case 2: * strMenuTypeName = "Item"; * break; * case 3: * strMenuTypeName = "PageLink"; * break; * } * xmlWriter.WriteStartElement(strMenuTypeName); * xmlWriter.WriteAttributeString("Title", arrayName[i]); * xmlWriter.WriteAttributeString("Link", arrayLink[i]); * } * xmlWriter.Close(); */ }
protected void btnAddWKM_Click(object sender, System.EventArgs e) { //保存背景图 string backimgUrl = backImg.ImageUrl; if (!string.IsNullOrEmpty(backImgUpload.FileName) && backImgUpload.FileContent.Length > 0) { string fileName = activityId + Path.GetExtension(backImgUpload.FileName); backImgUpload.SaveAs(Server.MapPath("/Storage/master/topic/") + fileName); backimgUrl = ("/Storage/master/topic/" + fileName); } else if (string.IsNullOrEmpty(backImg.ImageUrl)) { backimgUrl = (""); } //保存logo string logoImgUrl = logoImg.ImageUrl; if (!string.IsNullOrEmpty(logoImgUpload.FileName) && logoImgUpload.FileContent.Length > 0) { string fileName = activityId + "logo_" + Path.GetExtension(logoImgUpload.FileName); logoImgUpload.SaveAs(Server.MapPath("/Storage/master/topic/") + fileName); logoImgUrl = ("/Storage/master/topic/" + fileName); } else if (string.IsNullOrEmpty(logoImg.ImageUrl)) { logoImgUrl = ""; } //保存微信分享图标 string wxImgUrl = wxImg.ImageUrl; if (!string.IsNullOrEmpty(wxImgUpload.FileName) && wxImgUpload.FileContent.Length > 0) { string fileName = activityId + "WX_" + Path.GetExtension(wxImgUpload.FileName); wxImgUpload.SaveAs(Server.MapPath("/Storage/master/topic/") + fileName); wxImgUrl = ("/Storage/master/topic/" + fileName); } else if (string.IsNullOrEmpty(wxImg.ImageUrl)) { wxImgUrl = ""; } //保存广告图1 IList <string> adImgUrlList = new List <string>(); IList <string> adLinkList = new List <string>(); if (!string.IsNullOrEmpty(adImgUpload1.FileName) && adImgUpload1.FileContent.Length > 0) //&& !string.IsNullOrEmpty(txtAd1.Text.Trim())) { string fileName = activityId + "ad1" + Path.GetExtension(adImgUpload1.FileName); adImgUpload1.SaveAs(Server.MapPath("/Storage/master/topic/") + fileName); adImgUrlList.Add("/Storage/master/topic/" + fileName); adLinkList.Add(txtAd1.Text.Trim()); } else if (string.IsNullOrEmpty(adImg1.ImageUrl)) { adLinkList.Add(""); adImgUrlList.Add(""); } //保存广告图2 if (!string.IsNullOrEmpty(adImgUpload2.FileName) && adImgUpload2.FileContent.Length > 0) //&& !string.IsNullOrEmpty(txtAd2.Text.Trim()) ) { string fileName = activityId + "ad2" + Path.GetExtension(adImgUpload2.FileName); adImgUpload2.SaveAs(Server.MapPath("/Storage/master/topic/") + fileName); adImgUrlList.Add("/Storage/master/topic/" + fileName); adLinkList.Add(txtAd2.Text.Trim()); } else if (string.IsNullOrEmpty(adImg2.ImageUrl)) { adLinkList.Add(""); adImgUrlList.Add(""); } //保存匹配度区间描述信息 IList <string> mStartList = mStart.Value.Split(';'); IList <string> mEndList = mEnd.Value.Split(';'); IList <string> mDesList = mDes.Value.Split(';'); IList <string> mIdList = mId.Value.Split(';'); DataTable dt1 = PromoteHelper.getWKMMatchInfoList(activityId); dt1.PrimaryKey = new DataColumn[] { dt1.Columns["id"] }; DataTable dt2 = dt1.Clone(); dt2.PrimaryKey = new DataColumn[] { dt2.Columns["id"] }; if (mId.Value != "") { for (int i = 0; i < mIdList.Count; i++) { DataRow drNew = dt2.NewRow(); drNew["id"] = mIdList[i]; drNew["matchRateStart"] = mStartList[i]; drNew["matchRateEnd"] = mEndList[i]; drNew["Description"] = mDesList[i]; drNew["activityId"] = activityId; dt2.Rows.Add(drNew); } } int count = dt1.Rows.Count;//DB dt1.PrimaryKey = new DataColumn[] { dt1.Columns["ID"] }; dt2.PrimaryKey = new DataColumn[] { dt2.Columns["ID"] }; dt1 = DataBaseHelper.GetDtDifferent(dt1, dt2);//根据两个表的不同生成新的dt1,用于整表提交 if (PromoteHelper.setGuidePageUrl(txtGuidePageUrl.Text, activityId) && PromoteHelper.addWxImgUrl(activityId, wxImgUrl) && PromoteHelper.addLogoImgUrl(activityId, logoImgUrl) && PromoteHelper.setWKMCopyRight(txtCopyright.Text, activityId) && PromoteHelper.addBackImgUrl(activityId, backimgUrl) && PromoteHelper.addAdImgUrl(activityId, adImgUrlList, adLinkList) && DataBaseHelper.CommitDataTable(dt1, "SELECT * from WKM_MatchInfo where activityid='" + activityId + "'") != -1)//PromoteHelper.setMatchInfoList(activityId, mStartList, mEndList, mDesList)) //保存背景图片地址 { this.ShowMsgAndReUrl("保存成功!", true, "ManageWhoKnowMe.aspx"); } else { this.ShowMsg("保存失败!", false); } }
protected void btnSubmit_Click(object sender, System.EventArgs e) { OrderInfo info = OrderHelper.GetOrderInfo(orderId); //使用批量提交修改OrderItems的信息 DataTable dt1 = new DataTable(); dt1.Columns.Add("orderId"); dt1.Columns.Add("skuId"); dt1.Columns.Add("ItemDescription"); dt1.Columns.Add("ItemAdjustedPrice"); dt1.Columns.Add("ThumbnailsUrl"); dt1.Columns.Add("Quantity"); dt1.PrimaryKey = new DataColumn[] { dt1.Columns["orderId"] }; dt1.PrimaryKey = new DataColumn[] { dt1.Columns["skuId"] }; DataTable dt2 = dt1.Clone(); foreach (LineItemInfo lInfo in info.LineItems.Values) { dt1.Rows.Add(info.OrderId, lInfo.SkuId, lInfo.ItemDescription, lInfo.ItemAdjustedPrice, lInfo.ThumbnailsUrl, lInfo.Quantity); } dt1.AcceptChanges(); foreach (RepeaterItem rInfo in rptOrderGoods.Items) { dt2.Rows.Add(info.OrderId, ((Literal)rInfo.FindControl("litSkuId")).Text, ((Literal)rInfo.FindControl("litProductName")).Text, ((Literal)rInfo.FindControl("litProductAmount")).Text, ((Image)rInfo.FindControl("imgUrl")).ImageUrl, ((TextBox)rInfo.FindControl("quantity")).Text ); } //修改Order主表的OrderTotal,OrderPoint,OrderCostPrice(成本价),ORderProfit(利润),amount(商品总额) SiteSettings masterSettings = SettingsManager.GetMasterSettings(false); decimal OrderTotal = 0M; int OrderPoint = 0; decimal OrderCostPrice = 0M; decimal OrderProfit = 0M; decimal Amount = 0M; foreach (DataRow row in dt2.Rows) { decimal rowPrice = Convert.ToDecimal(row["ItemAdjustedPrice"]); int rowQuantity = Convert.ToInt16(row["Quantity"]); Amount += rowPrice * rowQuantity; OrderTotal += rowPrice * rowQuantity; OrderPoint += Convert.ToInt32(rowPrice * rowQuantity * masterSettings.PointsRate); OrderCostPrice += ProductHelper.GetSkuCostPrice(row["skuId"].ToString()) * rowQuantity; } OrderProfit = Amount - OrderCostPrice; //增加订单备注 bool flag = false; if (this.txtRemark.Text.Length > 300) { this.ShowMsg("备忘录长度限制在300个字符以内", false); } else { Regex regex = new Regex("^[^*?|<>']+$"); if (!regex.IsMatch(this.txtRemark.Text)) { this.ShowMsg("备忘录只能输入汉字,数字,英文,下划线,减号,不能以下划线、减号开头或结尾", false); flag = false; } else { info.ManagerMark = OrderMark.ExclamationMark; //this.orderRemarkImageForRemark.SelectedValue; info.ManagerRemark = Globals.HtmlEncode(this.txtRemark.Text); if (OrderHelper.SaveRemark(info)) { //this.BindOrders(); // this.ShowMsg("保存备忘录成功", true); flag = true; } else { this.ShowMsg("保存失败", false); flag = false; } } } if (!flag) { return; } dt1.PrimaryKey = new DataColumn[] { dt1.Columns["skuId"] }; dt2.PrimaryKey = new DataColumn[] { dt2.Columns["skuId"] }; DataBaseHelper.GetDtDifferent(dt1, dt2); if (OrderHelper.UpdateOrderAmountInfo(orderId, OrderTotal, OrderPoint, OrderCostPrice, OrderProfit, Amount) && DataBaseHelper.CommitDataTable(dt1, "Select orderId,skuId,ItemDescription,ItemAdjustedPrice,ThumbnailsUrl,Quantity From Hishop_OrderItems") != -1) { DataTable dtSku2 = OrderHelper.GetOrderItemSkuInfo(orderId); if (OrderHelper.UpdateOrderQuantity(dtSku, dtSku2)) { this.ShowMsg("退单成功", true); } else { this.ShowMsg("退单失败", false); } } }