/// <summary>
/// 从数据库中移动商品相关信息
/// </summary>
public bool RealDelByIDS(string ids)
{
SafeSC.CheckIDSEx(ids);
DataTable dt = DBCenter.Sel(TbName, "ID IN (" + ids + ")");
string items = StrHelper.GetIDSFromDT(dt, "ItemID");
return(RealDelByIDS(ids, items));
}
public void ClearRecycle()
{
DataTable dt = DBCenter.SelWithField(TbName, "ID,ItemID", "Recycler=1");
string ids = StrHelper.GetIDSFromDT(dt, "ID");
string items = StrHelper.GetIDSFromDT(dt, "ItemID");
RealDelByIDS(ids, items);
}
protected void Save_Btn_Click(object sender, EventArgs e)
{
M_UserInfo mu = buser.GetLogin();
M_Shop_Bonus bnMod = new M_Shop_Bonus();
DataTable dt = JsonConvert.DeserializeObject <DataTable>(Data_Hid.Value);
if (Mid > 0)
{
bnMod = bnBll.SelReturnModel(Mid);
}
bnMod.Alias = Alias_T.Text.Trim();
bnMod.IsDefault = IsDefault_Chk.Checked ? 1 : 0;
bnMod.ParentID = 0;
bnMod.Remark = Remark_T.Text;
bnMod.BonusType = Convert.ToInt32(dt.Rows[0]["BonusType"]);
bnMod.BonusValue1 = DataConvert.CDouble(dt.Rows[0]["BonusValue1"]).ToString("F2");
if (bnMod.IsDefault == 1)
{
DBCenter.UpdateSQL(bnMod.TbName, "IsDefault=0", "IsDefault=1");
}
if (bnMod.ID > 0)
{
bnBll.UpdateByID(bnMod);
}
else
{
bnMod.StoreID = mu.SiteID;
bnMod.ID = bnBll.Insert(bnMod);
}
//更新子类目信息
if (dt.Rows.Count > 1)
{
string ids = StrHelper.GetIDSFromDT(dt, "ID");
DBCenter.DelByWhere(bnMod.TbName, "ID NOT IN (" + ids + ") AND ParentID=" + bnMod.ID);
for (int i = 1; i < dt.Rows.Count; i++)
{
//为防止信息修改,增加店铺验证
DataRow dr = dt.Rows[i];
M_Shop_Bonus model = new M_Shop_Bonus().GetModelFromReader(dr);
model.ParentID = bnMod.ID;
model.StoreID = bnMod.StoreID;
if (model.ID > 0)
{
bnBll.UpdateByID(model);
}
else
{
model.ID = bnBll.Insert(model);
}
}
}
function.WriteSuccessMsg("操作成功", "Bonus.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
B_User.CheckIsLogged(Request.RawUrl);
if (!IsPostBack)
{
M_UserInfo mu = buser.GetLogin();
//双方均同意,且未完结的订单
DataTable nowDT = ExOrder.SelPage(1, int.MaxValue, new F_Order()
{
tuid = mu.UserID,
s_order = "99"
}).dt;
//双方均同意,且已完结的订单
DataTable hisDT = ExOrder.SelPage(1, int.MaxValue, new F_Order()
{
tuid = mu.UserID,
s_order = "100"
}).dt;
{
string uids = StrHelper.GetIDSFromDT(nowDT, "xsrid");
if (string.IsNullOrEmpty(uids))
{
uids = "-1";
}
DataTable dt = userBll.SelPage(new Com_Filter()
{
uids = uids
});
RPT.DataSource = dt;
RPT.DataBind();
if (dt.Rows.Count < 1)
{
function.Script(this, "$('#empty1').show();");
}
}
{
string uids = StrHelper.GetIDSFromDT(hisDT, "xsrid");
if (string.IsNullOrEmpty(uids))
{
uids = "-1";
}
DataTable dt = userBll.SelPage(new Com_Filter()
{
uids = uids
});
RPT2.DataSource = dt;
RPT2.DataBind();
if (dt.Rows.Count < 1)
{
function.Script(this, "$('#empty2').show();");
}
}
}
}
/// <summary>
/// 获取广告绑定了哪些版位
/// </summary>
public string Zone_GetIDS(int adid)
{
DataTable dt = DBCenter.Sel(BindTbName, "ADID=" + adid);
if (dt.Rows.Count < 1)
{
return("");
}
string zoneIds = StrHelper.GetIDSFromDT(dt, "ZoneID");
return(zoneIds);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
M_UserInfo mu = buser.GetLogin();
DataTable nowDT = ExOrder.SelPage(1, int.MaxValue, new F_Order()
{
uid = mu.UserID,
s_order = "99"
}).dt;
DataTable hisDT = ExOrder.SelPage(1, int.MaxValue, new F_Order()
{
uid = mu.UserID,
s_order = "100"
}).dt;
{
string uids = StrHelper.GetIDSFromDT(nowDT, "spfbrid");
if (string.IsNullOrEmpty(uids))
{
uids = "-1";
}
DataTable dt = teaBll.SelPage(new F_Teacher()
{
uids = uids
});
RPT.DataSource = dt;
RPT.DataBind();
if (dt.Rows.Count < 1)
{
function.Script(this, "$('#empty1').show();");
}
}
{
string uids = StrHelper.GetIDSFromDT(hisDT, "spfbrid");
if (string.IsNullOrEmpty(uids))
{
uids = "-1";
}
DataTable dt = teaBll.SelPage(new F_Teacher()
{
uids = uids
});
RPT2.DataSource = dt;
RPT2.DataBind();
if (dt.Rows.Count < 1)
{
function.Script(this, "$('#empty2').show();");
}
}
}
}
public ActionResult AddProduct()
{
VM_Product vm = new VM_Product();
if (Mid < 1)
{
if (ModelID < 1)
{
function.WriteErrMsg("没有指定要添加内容的模型ID!"); return(null);
}
if (NodeID < 1)
{
function.WriteErrMsg("没有指定要添加内容的栏目节点ID!"); return(null);
}
vm.proMod = new M_Product()
{
Stock = 10, Rateset = 1, Dengji = 3
};
vm.NodeID = NodeID;
vm.ModelID = ModelID;
vm.proMod.ProCode = B_Product.GetProCode();
}
else
{
vm.proMod = proBll.GetproductByid(Mid);
vm.NodeID = vm.proMod.Nodeid;
vm.ModelID = vm.proMod.ModelID;
vm.ValueDT = proBll.GetContent(vm.proMod.TableName, vm.proMod.ItemID);
if (!string.IsNullOrEmpty(vm.proMod.BindIDS))//捆绑商品
{
DataTable dt = proBll.SelByIDS(vm.proMod.BindIDS, "id,Thumbnails,Proname,LinPrice");
vm.bindList = JsonConvert.SerializeObject(dt);
}
#region 特选商品
{
string where = string.Format("(ProIDS LIKE '%,{0},%' OR ProIDS LIKE '{0},%' OR ProIDS LIKE '%,{0}')", vm.proMod.ID.ToString());
DataTable dt = DBCenter.SelWithField("ZL_User_BindPro", "UserID", where);
string uids = StrHelper.GetIDSFromDT(dt, "UserID");
ViewBag.prouids = uids;
}
#endregion
}
//------------------------------------------------------------------------------------------------
vm.nodeMod = nodeBll.SelReturnModel(vm.NodeID);
if (vm.nodeMod.IsNull)
{
function.WriteErrMsg("节点[" + NodeID + "]不存在"); return(null);
}
return(View(vm));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
moa = boa.SelReturnModel(Mid);
minfo = buser.SeachByID(moa.UserID);
this.LBTitle.Text = moa.Title;
this.LBKeyWords.Text = moa.Keywords;
this.AddUSer.Text = minfo.HoneyName;
this.AddTime.Text = moa.CreateTime.ToString();
title_lab.Text = moa.Title;
docType_Tr.Visible = false;
switch (moa.ProType)
{
case (int)M_MisProcedure.ProTypes.Admin:
//M_MisProLevel stepMod = stepBll.SelByProIDAndStepNum(moa.ProID,1);
//RUserName_Lab.Text = buser.GetUserNameByIDS(stepMod.ReferUser);
break;
default:
M_MisProLevel freeMod = freeBll.SelByDocID(Mid);
if (freeMod != null)
{
if (freeMod.ProID == 0)
{
preViewBtn.Visible = false;
}
RUserName_Lab.Text = buser.GetUserNameByIDS(freeMod.ReferUser);
//CUserName_Lab.Text = buser.GetUserNameByIDS(freeMod.CCUser);
//RUserID_Hid.Value = freeMod.ReferUser;
//CUserID_Hid.Value = freeMod.CCUser;
}
break;
}
string steps = StrHelper.GetIDSFromDT(stepBll.SelByProID(moa.ProID), "StepName");
if (!string.IsNullOrEmpty(steps))
{
function.Script(this, "$(\"#prog_div\").ZLSteps(\"" + steps + "\");");
}
}
}
private M_Product FillProductModel(ref DataTable table, M_Product proMod = null)
{
if (proMod == null)
{
proMod = new M_Product();
}
//DataTable gpdt = gpBll.GetGroupList();
/*--------------proMod------------*/
if (proMod.ID < 1)
{
proMod.Nodeid = NodeID;
proMod.FirstNodeID = nodeBll.SelFirstNodeID(proMod.Nodeid);
proMod.ModelID = ModelID;
proMod.TableName = modBll.SelReturnModel(ModelID).TableName;
proMod.AddUser = mu.UserName;
proMod.UserID = mu.UserID;
}
DataTable dt = fieldBll.GetModelFieldList(proMod.ModelID);
table = new Call().GetDTFromMVC(dt, Request);
//-------------------------------------------
proMod.ProCode = Request.Form["ProCode"];
proMod.BarCode = Request.Form["BarCode"];
proMod.Proname = Request.Form["Proname"];
proMod.ShortProName = Request.Form["ShortProName"];
proMod.Kayword = Request.Form["tabinput"];
keyBll.AddKeyWord(proMod.Kayword, 1);
proMod.ProUnit = Request.Form["ProUnit"];
proMod.AllClickNum = DataConverter.CLng(Request.Form["AllClickNum"]);
proMod.Weight = DataConvert.CDouble(Request.Form["Weight_T"]);
proMod.ProClass = DataConverter.CLng(Request.Form["proclass_rad"]);
proMod.IDCPrice = Request.Form["IDC_Hid"];
proMod.PointVal = DataConverter.CLng(Request.Form["PointVal_T"]);
proMod.Proinfo = Request.Form["Proinfo"];
proMod.Procontent = Request.Form["Procontent"];
proMod.Clearimg = Request.Form["txt_Clearimg"];
proMod.Thumbnails = Request.Form["txt_Thumbnails"];
//proMod.Producer = Request.Form["Producer"];
//proMod.Brand = Request.Form["Brand"];
//proMod.Quota = DataConverter.CLng(Quota.Text);
//proMod.DownQuota = DataConverter.CLng(DownQuota.Text);
proMod.StockDown = DataConverter.CLng(Request.Form["StockDown"]);
proMod.Rate = DataConverter.CDouble(Request.Form["Rate"]);
proMod.Rateset = DataConverter.CLng(Request.Form["Rateset"]);
proMod.Dengji = DataConverter.CLng(Request.Form["Dengji"]);
proMod.ShiPrice = DataConverter.CDouble(Request.Form["ShiPrice"]);
proMod.LinPrice = DataConverter.CDouble(Request.Form["LinPrice"]);
//proMod.Preset = (OtherProject.SelectedValue == null) ? "" : OtherProject.SelectedValue; //促销
//proMod.Integral = DataConverter.CLng(Integral.Text);
//proMod.Propeid = DataConverter.CLng(Propeid.Text);
proMod.Recommend = DataConverter.CLng(Request.Form["Recommend"]);
//proMod.Largesspirx = DataConverter.CLng(Largesspirx.Text);
proMod.Largess = DataConvert.CLng(Request.Form["Largess"]);
//更新时间，若没有指定则为当前时间
proMod.UpdateTime = DataConverter.CDate(Request.Form["UpdateTime"]);
proMod.AddTime = DataConverter.CDate(Request.Form["AddTime"]);
proMod.ModeTemplate = Request.Form["ModeTemplate_hid"];
//proMod.bookDay = DataConverter.CLng(BookDay_T.Text);
proMod.BookPrice = DataConverter.CDouble(Request.Form["BookPrice"]);
proMod.FarePrice = Request.Form["FareTlp_Rad"];
//proMod.UserShopID = DataConvert.CLng(Request.Form["UserShopID"]);//店铺页面应该禁止此项
proMod.UserType = DataConverter.CLng(Request.Form["UserPrice_Rad"]);
proMod.Quota = DataConvert.CLng(Request.Form["Quota_Rad"]);
proMod.DownQuota = DataConvert.CLng(Request.Form["DownQuota_Rad"]);
switch (proMod.UserType)
{
case 1:
proMod.UserPrice = Request.Form["UserPrice"];
break;
case 2:
proMod.UserPrice = Request.Form["Price_Group_Hid"];
break;
}
switch (proMod.Quota)
{
case 0:
break;
case 2:
proMod.Quota_Json = Request.Form["Quota_Group_Hid"];
break;
}
switch (proMod.DownQuota)
{
case 0:
break;
case 2:
proMod.DownQuota_Json = Request.Form["DownQuota_Group_Hid"];
break;
}
proMod.Sales = DataConverter.CLng(Request.Form["Sales_Chk"]);
proMod.Istrue = DataConverter.CLng(Request.Form["istrue_chk"]);
proMod.Ishot = DataConverter.CLng(Request.Form["ishot_chk"]);
proMod.Isnew = DataConverter.CLng(Request.Form["isnew_chk"]);
proMod.Isbest = DataConverter.CLng(Request.Form["isbest_chk"]);
proMod.Allowed = DataConverter.CLng(Request.Form["Allowed"]);
proMod.GuessXML = Request.Form["GuessXML"];
proMod.Wholesalesinfo = Request.Form["ChildPro_Hid"];
proMod.DownCar = DataConvert.CLng(Request.Form["DownCar"]);
////捆绑商品
if (!string.IsNullOrEmpty(Request.Form["Bind_Hid"]))
{
//获取绑定商品
DataTable binddt = JsonHelper.JsonToDT(Request.Form["Bind_Hid"]);
proMod.BindIDS = StrHelper.GetIDSFromDT(binddt, "ID");
}
else
{
proMod.BindIDS = "";
}
return(proMod);
}
public ActionResult AddProduct()
{
VM_Product vm = new VM_Product();
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.shop, "product"))
{
return(null);
}
if (Mid < 1)
{
if (ModelID < 1)
{
function.WriteErrMsg("没有指定要添加内容的模型ID!"); return(null);
}
if (NodeID < 1)
{
function.WriteErrMsg("没有指定要添加内容的栏目节点ID!"); return(null);
}
vm.proMod = new M_Product()
{
Stock = 10, Rateset = 1, Dengji = 3
};
vm.NodeID = NodeID;
vm.ModelID = ModelID;
vm.proMod.ProCode = B_Product.GetProCode();
vm.ProGuid = Guid.NewGuid().ToString();
}
else
{
int VerID = DataConvert.CLng(Request.QueryString["Ver"]);
if (VerID > 0)
{
M_Content_VerBak verMod = verBll.SelReturnModel(VerID);
vm.proMod = JsonConvert.DeserializeObject <M_Product>(verMod.ContentBak);
if (vm.proMod.ID != Mid)
{
function.WriteErrMsg("加载的版本与商品不匹配"); return(null);
}
vm.ValueDT = JsonConvert.DeserializeObject <DataTable>(verMod.TableBak);
}
else
{
vm.proMod = proBll.GetproductByid(Mid);
vm.ValueDT = proBll.GetContent(vm.proMod.TableName, vm.proMod.ItemID);
}
vm.ProGuid = vm.proMod.ID.ToString();
if (vm.proMod.Class == 2)
{
Response.Redirect(CustomerPageAction.customPath + "Shop/Arrive/SuitProAdd.aspx?ID=" + vm.proMod.ID);
}
vm.NodeID = vm.proMod.Nodeid;
vm.ModelID = vm.proMod.ModelID;
if (!string.IsNullOrEmpty(vm.proMod.BindIDS))//捆绑商品
{
DataTable dt = proBll.SelByIDS(vm.proMod.BindIDS, "id,Thumbnails,Proname,LinPrice");
vm.bindList = JsonConvert.SerializeObject(dt);
}
//多区域价格
vm.regionMod = regionBll.SelModelByGuid(vm.ProGuid);
if (vm.regionMod == null)
{
vm.regionMod = new M_Shop_RegionPrice();
}
#region 特选商品
{
string where = string.Format("(ProIDS LIKE '%,{0},%' OR ProIDS LIKE '{0},%' OR ProIDS LIKE '%,{0}')", vm.proMod.ID.ToString());
DataTable dt = DBCenter.SelWithField("ZL_User_BindPro", "UserID", where);
string uids = StrHelper.GetIDSFromDT(dt, "UserID");
ViewBag.prouids = uids;
}
#endregion
}
//------------------------------------------------------------------------------------------------
vm.nodeMod = nodeBll.SelReturnModel(vm.NodeID);
if (vm.nodeMod.IsNull)
{
function.WriteErrMsg("节点[" + vm.NodeID + "]不存在"); return(null);
}
return(View(vm));
}
