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);
}
}
}
