public void Product_AddToNew()
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.shop, "product"))
{
return;
}
DataTable table = new DataTable();
M_Product proMod = proBll.GetproductByid(Mid);
proMod = FillProductModel(ref table, proMod);
//------------------
proMod.ProCode = B_Product.GetProCode();
proMod.AddUser = B_Admin.GetLogin().AdminName;
proMod.Stock = 0;
proMod.AddTime = DateTime.Now;
proMod.UpdateTime = DateTime.Now;
proMod.ID = 0;
proMod.ID = proBll.Add(table, proMod);
//------------------
IsNeedVerBak(proMod);
IsHaveMaterial(proMod);
IsAddStock(proMod, DataConvert.CLng(Request.Form["Stock"]));
IsUserProduct(proMod, Request.Form["uprouids_old_hid"], Request.Form["uprouids_hid"]);
IsHavePresent(proMod);
Response.Redirect(CustomerPageAction.customPath + "Shop/ProductShow.aspx?ID=" + proMod.ID);
}
public VM_Product(M_Product proMod, HttpRequest Request)
{
groupList = JsonConvert.SerializeObject(DBCenter.SelWithField("ZL_Group", "GroupID,GroupName"));
fareDT = fareBll.Sel();
this.proMod = proMod;
if (proMod.ID > 0)
{
this.NodeID = proMod.Nodeid;
this.ModelID = proMod.ModelID;
this.ProGuid = proMod.ID.ToString();
//捆绑商品
if (!string.IsNullOrEmpty(proMod.BindIDS))
{
DataTable dt = proBll.SelByIDS(proMod.BindIDS, "id,Thumbnails,Proname,LinPrice");
bindList = JsonConvert.SerializeObject(dt);
}
//if (!string.IsNullOrEmpty(proMod.TableName))
//{
// DataTable valueDT = proBll.Getmodetable(proMod.TableName.ToString(), proMod.ItemID);
// if (valueDT != null && valueDT.Rows.Count > 0)
// {
// modelHtml = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig() { ValueDT = valueDT });
// }
//}
}
else
{
this.NodeID = DataConvert.CLng(Request.GetParam("NodeID"));
this.ModelID = DataConvert.CLng(Request.GetParam("ModelID"));
this.ProGuid = System.Guid.NewGuid().ToString();
this.proMod.ProCode = B_Product.GetProCode();
//modelHtml = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig() { Source = ModelConfig.SType.Admin });
}
nodeMod = nodeBll.SelReturnModel(NodeID);
}
/// <summary>
/// 拷贝一份至ZL_CartPro长久保存
/// </summary>
public void CopyToCartPro(M_UserInfo mu, DataTable dt, int oid)
{
B_Product proBll = new B_Product();
string[] fields = "Additional,StoreID,AllMoney_Json,code".Split(',');
foreach (string field in fields)
{
if (!dt.Columns.Contains(field))
{
dt.Columns.Add(new DataColumn(field, typeof(string)));
}
}
foreach (DataRow dr in dt.Rows)
{
M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"]));
M_CartPro model = new M_CartPro();
model.Orderlistid = oid;
model.ProID = proMod.ID;
model.Pronum = DataConverter.CLng(dr["Pronum"]);
model.Proname = proMod.Proname;
model.Shijia = Convert.ToDouble(dr["FarePrice"]);
model.Danwei = proMod.ProUnit;
model.Addtime = DateTime.Now;
model.StoreID = DataConvert.CLng(dr["StoreID"]);
model.code = DataConvert.CStr(dr["code"]);
model.Attribute = DataConvert.CStr(dr["ProAttr"]);
if (!dt.Columns.Contains("AllMoney"))
{
model.AllMoney = proMod.LinPrice * model.Pronum;
}
else
{
model.AllMoney = Convert.ToDouble(dr["AllMoney"]);
}
//model.Additional = DataConvert.CStr(dr["Additional"]);
//model.AllMoney_Json = DataConvert.CStr(dr["AllMoney_Json"]);
//如果非促销组合,则不保存商品简介和详情
if (proMod.Class != 2)
{
proMod.Procontent = ""; proMod.Proinfo = "";
}
//原价与优惠信息(便于展示)
//model.Usepoint = 0;
//model.UsePointArrive = 0;
//model.FarePrice = "0";
//model.ArriveMoney = 0;
//model.ArriveRemind = "";
#region 保存购买时用户的信息
model.Username = mu.UserName;
model.Additional = DataConvert.CStr(dr["Additional"]);
//model.Additional = JsonHelper.GetJson(new string[] { "UserID", "GroupID", "PUserID" }, new object[] { mu.UserID, mu.GroupID, mu.ParentUserID });
#endregion
#region 将整个商品信息备份(主要是价格和配置部分)
model.PClass = proMod.Class.ToString();
//model.ProInfo = JsonConvert.SerializeObject(backup);
#endregion
model.ID = cartProBll.GetInsert(model);
}
}
public VM_Product(M_Product proMod, HttpRequestBase Request)
{
groupList = JsonConvert.SerializeObject(DBCenter.SelWithField("ZL_Group", "GroupID,GroupName"));
gpriceDT = gpBll.GetGroupList();
gpriceDT.Columns.Add(new DataColumn("gprice", typeof(string)));
fareDT = fareBll.Sel();
this.proMod = proMod;
if (proMod.ID > 0)
{
this.NodeID = proMod.Nodeid;
this.ModelID = proMod.ModelID;
this.ProGuid = proMod.ID.ToString();
//会员组价
if (proMod.UserType == 2 && proMod.UserPrice.Contains("[") && !proMod.UserPrice.Equals("[]"))
{
DataTable upDT = JsonConvert.DeserializeObject <DataTable>(proMod.UserPrice);
foreach (DataRow dr in upDT.Rows)
{
DataRow[] drs = gpriceDT.Select("GroupID='" + dr["gid"] + "'");
if (drs.Length > 0)
{
drs[0]["gprice"] = DataConvert.CDouble(dr["price"]).ToString("F2");
}
}
}
//捆绑商品
if (!string.IsNullOrEmpty(proMod.BindIDS))
{
DataTable dt = proBll.SelByIDS(proMod.BindIDS, "id,Thumbnails,Proname,LinPrice");
bindList = JsonConvert.SerializeObject(dt);
}
if (!string.IsNullOrEmpty(proMod.TableName))
{
DataTable valueDT = proBll.Getmodetable(proMod.TableName.ToString(), proMod.ItemID);
if (valueDT != null && valueDT.Rows.Count > 0)
{
modelHtml = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
ValueDT = valueDT
});
}
}
}
else
{
this.NodeID = DataConvert.CLng(Request.QueryString["NodeID"]);
this.ModelID = DataConvert.CLng(Request.QueryString["ModelID"]);
this.ProGuid = System.Guid.NewGuid().ToString();
this.proMod.ProCode = B_Product.GetProCode();
modelHtml = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
Source = ModelConfig.SType.Admin
});
}
nodeMod = nodeBll.SelReturnModel(NodeID);
}
protected void Page_Load(object sender, EventArgs e)
{
B_Product pll = new B_Product();
int id = DataConverter.CLng(Request.QueryString["id"]);
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='ProductManage.aspx'>商城管理</a></li><li><a href='PresentProject.aspx'>促销方案管理</a></li><li>添加促销方案</li>");
if (!IsPostBack)
{
if (id > 0)
{
M_Promotions pinfo = bll.GetPromotionsByid(id);
this.HiddenID.Value = id.ToString();
this.Promoname.Text = pinfo.Promoname.ToString();
this.Promostart.Text = pinfo.Promostart.ToString();
this.Promoend.Text = pinfo.Promoend.ToString();
this.Pricetop.Text = pinfo.Pricetop.ToString();
this.Priceend.Text = pinfo.Priceend.ToString();
this.Integral.Text = pinfo.Integral.ToString();
this.GetPresent.Checked = (pinfo.GetPresent == 1) ? true : false;
this.Presentmoney.Text = pinfo.Presentmoney.ToString();
this.IntegralTure.Checked = (pinfo.IntegralTure == 1) ? true : false;
if (!string.IsNullOrEmpty(pinfo.PromoProlist))
{
if (pinfo.PromoProlist.IndexOf(",") > -1)
{
string[] listarr = pinfo.PromoProlist.Split(new string[] { "," }, StringSplitOptions.None);
for (int i = 0; i < listarr.Length; i++)
{
string pronames = pll.GetproductByid(DataConverter.CLng(listarr[i])).Proname;
this.PromoProlist.Items.Add(new ListItem(pronames, listarr[i].ToString()));
}
}
else
{
string pronames = pll.GetproductByid(DataConverter.CLng(pinfo.PromoProlist)).Proname;
this.PromoProlist.Items.Add(new ListItem(pronames, pinfo.PromoProlist));
}
}
if (this.PromoProlist.Items.Count > 0)
{
for (int p = 0; p < this.PromoProlist.Items.Count; p++)
{
this.PromoProlist.Items[p].Selected = true;
}
}
//this.PromoProlist.Text = pinfo.PromoProlist.ToString();
this.Label1.Text = "修改促销方案";
this.Save_B.Text = "修改";
}
}
}
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));
}
/// <summary>
/// 产生幸运码,并返回用于输出的Html
/// </summary>
public string CreateLuckCode(M_OrderList orderMod)
{
List <M_Product> proList = new List <M_Product>();
B_Product proBll = new B_Product();
B_Order_LuckCode codeBll = new B_Order_LuckCode();
B_CartPro cartBll = new B_CartPro();
string result = "";
//*一个购物车中，可能会有多个商品,
DataTable cartDT = cartBll.GetCartProOrderID(orderMod.id);//购物车记录
//判断出购物车中哪些是云购商品
for (int i = 0; i < cartDT.Rows.Count; i++)
{
int proID = Convert.ToInt32(cartDT.Rows[i]["ProID"]);
M_Product proMod = proBll.GetproductByid(proID);
if (proMod.ProClass == 5)
{
//减去相应的库存
proMod.Stock = proMod.Stock - Convert.ToInt32(cartDT.Rows[i]["ProNum"]);
proBll.updateinfo(proMod);
proMod.Class = Convert.ToInt32(cartDT.Rows[i]["ProNum"]);//购买数量,用备用字段存着
proList.Add(proMod);
}
}
//根据购买的数量与信息,生成对应条数的幸运码,与上面分离开,便于后期扩展
for (int i = 0; i < proList.Count; i++)
{
//获取该商品在数据库中的最大幸运码数
int code = codeBll.GetMaxLuckCode(proList[i].ID);
M_Order_LuckCode codeMod = new M_Order_LuckCode();
codeMod.ProID = proList[i].ID;
codeMod.UserID = orderMod.Userid;
codeMod.OrderID = orderMod.id;
codeMod.OrderNO = orderMod.OrderNo;
DateTime now = DateTime.Now;
codeMod.CreateTime = now.ToString("yyyy/MM/dd HH:mm:ss:fff");
codeMod.CreateTime2 = now.ToString("yyyyMMddHHmmssfff");
result += "商品名:" + proList[i].Proname + "<br/>幸运码:";
for (int j = 1; j <= proList[i].Class; j++)
{
codeMod.Code = (code + j);
codeBll.Insert(codeMod);
result += codeMod.Code + ",";
}
result += "<br/>";
}
return(result.TrimEnd(','));;
}
public static ILE.IResult PrintBing(ILE.IJob job, ServiceReference.ServiceClient client, string val, IResult res)
{
////////////////////////////////////////////////////////
string product_code = job.Product;
string ResultProduct = client.RunServerAPI("BLL.SSW", "GetProduct", product_code);
B_Product productObj = JsonConvert.DeserializeObject <B_Product>(ResultProduct);
string Print_bind = string.Empty;
if (productObj != null)
{
Print_bind = productObj.print_bind.ToString();
}
if (Print_bind == "1")
{
//根据工单号查询主工单
string order = job.OrderNO;
string ResultMainOrder = client.RunServerAPI("BLL.SSW", "GetMainOrderByOrderNo", order);
List <P_WorkOrder> workorder = JsonConvert.DeserializeObject <List <P_WorkOrder> >(ResultMainOrder);
string Main_Order = workorder[0].main_order;
//通过电池块批次查询主工单
string SFC = val.Replace("#", "");
string Result = client.RunServerAPI("BLL.Pack", "GetMainWorder", SFC);
List <P_BarCodeBing> MainWork = JsonConvert.DeserializeObject <List <P_BarCodeBing> >(Result);
if (MainWork != null)
{
string Main_Or = MainWork[0].main_order;
string order_no = MainWork[0].order;
if (Main_Order != Main_Or || order_no != order)
{
res.ExtMessage = "该批次不属于当前工单下的批次";
res.Result = false;
return(res);
}
}
else
{
res.ExtMessage = "该批次不存在于条码清单";
res.Result = false;
return(res);
}
}
////////////////////////////////////////////////////////
res.Result = true;
return(res);
}
public void fahuo(int id, String Email)
{
B_CartPro cpl = new B_CartPro();
B_OrderList oll = new B_OrderList();
B_Product pll = new B_Product();
B_Stock Sll = new B_Stock();
//历遍清单所有商品数量，查找库存///////////////////
DataTable Unew = cpl.GetCartProOrderID(id); //获得详细清单列表
M_OrderList orlist = oll.GetOrderListByid(id);
for (int s = 0; s < Unew.Rows.Count; s++)
{
int Onum = ZoomLa.Common.DataConverter.CLng(Unew.Rows[s]["Pronum"]);
int Opid = ZoomLa.Common.DataConverter.CLng(Unew.Rows[s]["ProID"]);
M_Product pdin = pll.GetproductByid(Opid);//获得商品信息
if (pdin.JisuanFs == 0)
{
int pstock = pdin.Stock - Onum;//库存结果,返回的商品数量
pll.ProUpStock(Opid, pstock);
}
M_Stock SData = new M_Stock();
SData.id = 0;
SData.proid = Opid;
SData.stocktype = 1;
SData.proname = pdin.Proname;
SData.danju = "CK" + orlist.OrderNo.ToString();
SData.adduser = orlist.Reuser.ToString();
SData.addtime = DateTime.Now;
SData.content = "订单:" + orlist.Reuser.ToString() + "发货";
SData.Pronum = ZoomLa.Common.DataConverter.CLng(Unew.Rows[0]["Pronum"]);
Sll.AddStock(SData);
}
string str = "StateLogistics=1";
if (!string.IsNullOrEmpty(Email))
{
str += ",ExpressDelivery='" + Email + "'";
}
oll.UpOrderinfo(str, id);
PromotionComfirm(orlist);
}
public void Product_AddToNew()
{
DataTable table = new DataTable();
M_Product srcMod = proBll.GetproductByid(Mid);
srcMod = FillProductModel(ref table, srcMod);
//------------------
srcMod.ProCode = B_Product.GetProCode();
srcMod.AddUser = mu.UserName;
srcMod.Stock = 0;
srcMod.AddTime = DateTime.Now;
srcMod.UpdateTime = DateTime.Now;
srcMod.ID = 0;
srcMod.ID = proBll.Add(table, srcMod);
//------------------
IsAddStock(srcMod, DataConvert.CLng(Request.Form["Stock"]));
IsHavePresent(srcMod);
function.WriteSuccessMsg("操作成功", "ProductList");
}
public IActionResult Product_AddToNew()
{
DataTable table = new DataTable();
M_Product srcMod = proBll.GetproductByid(Mid);
srcMod = FillProductModel(ref table, srcMod);
//------------------
srcMod.ProCode = B_Product.GetProCode();
srcMod.AddUser = mu.UserName;
srcMod.Stock = 0;
srcMod.AddTime = DateTime.Now;
srcMod.UpdateTime = DateTime.Now;
srcMod.ID = 0;
srcMod.ID = proBll.Add(table, srcMod);
//------------------
IsAddStock(srcMod, DataConvert.CLng(RequestEx["Stock"]));
IsHavePresent(srcMod);
return(WriteOK("操作成功", "ProductList"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null && !(Request.QueryString["id"].Equals("")))
{
int productId = DataConverter.CLng(Request.QueryString["id"]);
if (productId == 0)
{
function.WriteErrMsg("参数错误");
}
else
{
bll = new B_Product();
node = new B_Node();
pinfo = bll.GetproductByid(productId);
if (pinfo != null)
{
int nodeId = pinfo.Nodeid;
M_Node m_node = node.GetNodeXML(nodeId);
NodeName.Text = m_node.NodeName;
AddUser_L.Text = pinfo.AddUser;
shopState.Text = pinfo.Sales == 1 ? "销售中" : "停售状态";
codes.Text = pinfo.ProClass == 1 ? "正常销售" : "特价处理";
codes.Text += pinfo.Isnew == 1 ? "|新品" : "";
codes.Text += pinfo.Ishot == 1 ? "|热销" : "";
codes.Text += pinfo.Isbest == 1 ? "|精品" : "";
ProID_L.Text = pinfo.ID.ToString();
title_T.Text = pinfo.Proname;
lblCountHits.Text = pinfo.AllClickNum.ToString();
ckPrice.Text = pinfo.ShiPrice.ToString();
nowPrice.Text = pinfo.LinPrice.ToString();
B_Model m_model = new B_Model();
M_ModelInfo MM = m_model.GetModelById(pinfo.Nodeid);
string bar = " <span><a href=\"ProductManage.aspx?NodeID=" + nodeId + "\">" + node.GetNodeXML(nodeId).NodeName + "</a></span>";
Call.SetBreadCrumb(Master, "<li>商城管理</li><li><a href='ProductManage.aspx'>商品管理</a></li><li>" + bar + "</li>" +
"<div class='pull-right hidden-xs'><span onclick=\"opentitle('../Content/EditNode.aspx?NodeID=" + nodeId + "','配置本节点');\" class='fa fa-cog' title='配置本节点' style='cursor:pointer;margin-left:5px;'></span></div>");
}
}
}
}
//需处理,这里只负责View部分,页务与逻辑操作全部放入Notify
private void FinalStep(M_OrderList mod)
{
//对第一张订单处理,后期改为对支付单处理
if (mod.Ordertype == (int)M_OrderList.OrderEnum.Domain)//域名订单
{
Response.Redirect("~/Plugins/Domain/DomReg2.aspx?OrderNo=" + mod.OrderNo);
}
else if (mod.Ordertype == (int)M_OrderList.OrderEnum.Purse)//余额充值,不支持银币
{
Response.Redirect("~/Plugins/Domain/ChargePurse.aspx?OrderNo=" + mod.OrderNo);
}
else if ((mod.Ordertype == (int)M_OrderList.OrderEnum.IDCRen))//IDC服务续费
{
B_Product proBll = new B_Product();
//更新旧订单的期限
if (string.IsNullOrEmpty(mod.Ordermessage))
{
function.WriteErrMsg("出错,无需续费订单信息,请联系管理员!!!");
}
M_CartPro newCartMod = cartBll.SelModByOrderID(mod.id);
M_Product proMod = proBll.GetproductByid(newCartMod.ProID);
//更新延长旧服务的到期时间，旧服务是存在CartPro的EndTime当中
M_CartPro oldCartMod = cartBll.SelReturnModel(Convert.ToInt32(mod.Ordermessage));
if (oldCartMod.EndTime < DateTime.Now)
{
oldCartMod.EndTime = DateTime.Now; //如已过期，则将时间更新至今日
}
//oldCartMod.EndTime = proBll.GetEndTime(proMod, newCartMod.Pronum, oldCartMod.EndTime);
cartBll.UpdateByID(oldCartMod);
paylogMod.Remind = "为" + mod.Ordermessage + "订单续费(购物车)";
remindHtml.Text = "<span>付款成功--></span><a style='color:red;' href='/Plugins/Domain/ViewHave.aspx' title='已购服务'>点击查看已购服务</a><br />";
}
else if (mod.Ordertype == (int)M_OrderList.OrderEnum.Cloud)//云购订单
{
//根据份数生成幸运码,写入表中,并减去库存 ZL_Order_LuckCode
remindHtml.Text = "<span style='color:red;'>付款成功,你的云购幸运码是<br/>" + orderBll.CreateLuckCode(mod) + "</span>";
}
}
public ProductController(B_Product product)
{
_product = product;
}
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));
}
/// <summary>
/// 拷贝一份至ZL_CartPro长久保存
/// </summary>
public void CopyToCartPro(M_UserInfo mu, DataTable dt, int oid)
{
B_Product proBll = new B_Product();
string[] fields = "Additional,StoreID,AllMoney_Json,code".Split(',');
foreach (string field in fields)
{
if (!dt.Columns.Contains(field))
{
dt.Columns.Add(new DataColumn(field, typeof(string)));
}
}
foreach (DataRow dr in dt.Rows)
{
M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"]));
M_CartPro model = new M_CartPro();
model.Orderlistid = oid;
model.ProID = proMod.ID;
model.Pronum = DataConverter.CLng(dr["Pronum"]);
model.Proname = proMod.Proname;
model.Shijia = Convert.ToDouble(dr["FarePrice"]);
model.Danwei = proMod.ProUnit;
model.Addtime = DateTime.Now;
model.StoreID = DataConvert.CLng(dr["StoreID"]);
model.code = DataConvert.CStr(dr["code"]);
model.Attribute = DataConvert.CStr(dr["ProAttr"]);
if (!dt.Columns.Contains("AllMoney"))
{
model.AllMoney = proMod.LinPrice * model.Pronum;
}
else
{
model.AllMoney = Convert.ToDouble(dr["AllMoney"]);
}
//后期加上记录优惠信息
//model.AllMoney_Init = DataConvert.CDouble(dr["AllMoney_Init"]);
//model.AllMoney_Arrive= DataConvert.CDouble(dr["AllMoney_Arrive"]);
//model.ArriveRemark = DataConvert.CStr(dr["ArriveRemark"]);
//如果非促销组合,则不保存商品简介和详情
if (proMod.Class != 2)
{
proMod.Procontent = ""; proMod.Proinfo = "";
}
#region 保存购买时用户的信息
model.Username = mu.UserName;
model.Additional = DataConvert.CStr(dr["Additional"]);
model.Remark = DataConvert.CStr(dr["Remark"]);
//model.Additional = JsonHelper.GetJson(new string[] { "UserID", "GroupID", "PUserID" }, new object[] { mu.UserID, mu.GroupID, mu.ParentUserID });
#endregion
#region 将整个商品信息备份(主要是价格和配置部分)
M_Product backup = new M_Product();
backup.ID = proMod.ID;
backup.ParentID = proMod.ParentID;
backup.Class = proMod.Class;
backup.Nodeid = proMod.Nodeid;
backup.ModelID = proMod.ModelID;
backup.Proname = proMod.Proname;
backup.ProClass = proMod.ProClass;
backup.Proinfo = proMod.Proinfo;
backup.Procontent = proMod.Procontent;
backup.ShiPrice = proMod.ShiPrice;
backup.LinPrice = proMod.LinPrice;
backup.MemberPrice = proMod.MemberPrice;
backup.ActPrice = proMod.ActPrice;
backup.Wholesales = proMod.Wholesales;
backup.Wholesaleone = proMod.Wholesaleone;
backup.Wholesalesinfo = proMod.Wholesalesinfo;
backup.Thumbnails = proMod.Thumbnails;
backup.Recommend = proMod.Recommend;
backup.Largess = proMod.Largess;
backup.GuessXML = proMod.GuessXML;
backup.PointVal = proMod.PointVal;
backup.UserShopID = proMod.UserShopID;
backup.BookPrice = proMod.BookPrice;
backup.UserType = proMod.UserType;
backup.UserPrice = proMod.UserPrice;
backup.Recycler = proMod.Recycler;
backup.FarePrice = proMod.FarePrice;
backup.BindIDS = proMod.BindIDS;
model.PClass = proMod.Class.ToString();
model.ProInfo = JsonConvert.SerializeObject(backup);
#endregion
model.ID = GetInsert(model);
#region 是否包含赠品,将赠品信息保存
{
B_Shop_Present ptBll = new B_Shop_Present();
DataTable ptDT = ptBll.WhereLogical(new W_Filter(dr));
cptBll.BatInsert(model.ID, ptDT);
}
#endregion
}
}
//----------Logical
////用户无微站信息,则自动创建
//public M_Design_MBSite AutoCreate(M_UserInfo mu)
//{
// if (mu == null || mu.IsNull) { return null; }
// if (DBCenter.IsExist(TbName, "UserID=" + mu.UserID)) { return null; }
// M_Design_MBSite mbMod = new M_Design_MBSite();
// mbMod.UserID = mu.UserID;
// mbMod.TlpID = 1;
// mbMod.SiteID = mu.SiteID;
// mbMod.ID = Insert(mbMod);
// return mbMod;
//}
/// <summary>
/// 根据用户与模板信息,创建站点
/// </summary>
public M_Design_MBSite CreateSite(M_UserInfo mu, M_Design_MBSite mbMod, out string err)
{
B_Design_Node desNodeBll = new B_Design_Node();
B_Node nodeBll = new B_Node();
B_Product proBll = new B_Product();
//int mbsitecount = SiteConfig.SiteOption.DN_MBSiteCount;
int mbsitecount = 10000;//取消数量限制
if (mu == null || mu.IsNull)
{
err = "用户不存在"; return(null);
}
else if (mbMod.TlpID < 1 || mbMod.TlpID > 8)
{
err = "未指定模板或模板[" + mbMod.TlpID + "]不存在"; return(null);
}
else if (GetSiteCount(mu.UserID) >= mbsitecount)
{
err = "用户只能创建" + mbsitecount + "个微站"; return(null);
}
if (string.IsNullOrEmpty(mbMod.SiteName))
{
mbMod.SiteName = B_User.GetUserName(mu.HoneyName, mu.UserName) + "的微站" + DBCenter.Count(TbName, "UserID=" + mu.UserID) + 1;
}
mbMod.UserID = mu.UserID;
mbMod.ID = Insert(mbMod);
//-----建立微站节点信息,从指定的模板处拷节点数据,父节点需要自建
M_Node pnode = desNodeBll.GetUserRootNode(mu);
if (pnode.IsNull)
{
pnode = desNodeBll.CreateUserRootNode(mu);
}
M_Node nodeMod = new M_Node();
nodeMod.NodeName = "微建站";
nodeMod.NodeDir = function.GetRandomString(6);
nodeMod.CUser = mu.UserID;
nodeMod.CUName = mu.UserName;
nodeMod.NodeBySite = mbMod.ID;
nodeMod.NodeType = 1;//标识自身为主栏目
nodeMod.ParentID = pnode.NodeID;
nodeMod.NodeID = nodeBll.Insert(nodeMod);
//---导入对应的模板节点数据
string nodename = "微建站" + mbMod.TlpID;
DataTable nodeDT = SelNodeByPName(nodename);
CopyNodeAndContent(nodeDT, nodeMod);
//---如果有商品数据,则导入商品
DataTable proDT = SelProByPName(nodename);
foreach (DataRow dr in proDT.Rows)
{
M_Product proMod = new M_Product().GetModelFromReader(dr);
proMod.ID = 0;
proMod.ParentID = mbMod.ID;//所属哪个站点
proMod.UserID = mu.UserID;
proMod.AddUser = mu.UserName;
proMod.Nodeid = UserShopNodeID;
proMod.AddTime = DateTime.Now;
proMod.UpdateTime = DateTime.Now;
proBll.Insert(proMod);
}
err = "";
return(mbMod);
}
/// <summary>
/// 拷贝一份至ZL_CartPro长久保存
/// </summary>
public void CopyToCartPro(M_UserInfo mu, DataTable dt, int oid)
{
B_Product proBll = new B_Product();
string[] fields = "Additional,StoreID,AllMoney_Json,code".Split(',');
foreach (string field in fields)
{
if (!dt.Columns.Contains(field))
{
dt.Columns.Add(new DataColumn(field, typeof(string)));
}
}
foreach (DataRow dr in dt.Rows)
{
M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"]));
M_CartPro model = new M_CartPro();
model.Orderlistid = oid;
model.ProID = proMod.ID;
model.Pronum = DataConverter.CLng(dr["Pronum"]);
model.Proname = proMod.Proname;
model.Username = mu.UserName;
model.Shijia = proMod.LinPrice;
if (!dt.Columns.Contains("AllMoney"))
{
model.AllMoney = proMod.LinPrice * model.Pronum;
}
else
{
model.AllMoney = Convert.ToDouble(dr["AllMoney"]);
}
model.Danwei = proMod.ProUnit;
model.Addtime = DateTime.Now;
model.Additional = DataConvert.CStr(dr["Additional"]);
model.StoreID = DataConvert.CLng(dr["StoreID"]);
model.AllMoney_Json = DataConvert.CStr(dr["AllMoney_Json"]);
model.code = DataConvert.CStr(dr["code"]);
model.Attribute = DataConvert.CStr(dr["ProAttr"]);
int id = GetInsert(model);
//用于支持购物车扩展字段
//DataTable cartFieldDT = fieldBll.Select_Type(1);
//if (cartFieldDT.Rows.Count > 1)
//{
// string sql = "Update ZL_CartPro Set ", fieldstr = "";
// SqlParameter[] sp = new SqlParameter[cartFieldDT.Rows.Count];
// for (int i = 0; i < cartFieldDT.Rows.Count; i++)
// {
// DataRow fdr = cartFieldDT.Rows[i];
// string field = fdr["FieldName"].ToString();
// string vname = "@val" + i;
// string value = dr[field].ToString();
// if (string.IsNullOrEmpty(value)) continue;
// sp[i] = new SqlParameter(vname, value);
// fieldstr += field + "=" + vname + ",";
// }
// fieldstr = fieldstr.TrimEnd(',');
// sql = sql + fieldstr + " Where ID=" + id;
// if (!string.IsNullOrEmpty(fieldstr))
// SqlHelper.ExecuteSql(sql, sp);
//}
}
}
public void MyBind()
{
M_Product pinfo = null;
if (ProID > 0)
{
proMod = pinfo = proBll.GetproductByid(ProID); NodeID = pinfo.Nodeid;
}
//-------------------------------
M_Node nodeMod = nodeBll.SelReturnModel(NodeID);
if (nodeMod.IsNull)
{
function.WriteErrMsg("节点[" + NodeID + "]不存在");
}
Node_RPT.DataSource = ExHelper.Store_NodeSel();
Node_RPT.DataBind();
function.ScriptRad(this, "node_rad", NodeID.ToString());
UpdateTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
AddTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ProCode.Text = B_Product.GetProCode();
if (ProID > 0)
{
#region 修改
ModelID = pinfo.ModelID;
AllClickNum_T.Text = pinfo.AllClickNum.ToString();
ClickType.Value = "update";
btnAdd.Visible = true;
istrue_chk.Checked = pinfo.Istrue == 1 ? true : false;
ProCode.Text = pinfo.ProCode;
BarCode.Text = pinfo.BarCode;
Proname.Text = pinfo.Proname;
ProUnit.Text = pinfo.ProUnit;
Recommend_T.Text = pinfo.Recommend.ToString();
Proinfo.Text = pinfo.Proinfo;
procontent.Value = pinfo.Procontent;
//txt_Clearimg.Text = pinfo.Clearimg;
//txt_Thumbnails.Text = pinfo.Thumbnails;
//Quota.Text = pinfo.Quota.ToString();
//DownQuota.Text = pinfo.DownQuota.ToString();
ShiPrice.Text = pinfo.ShiPrice.ToString();
LinPrice.Text = pinfo.LinPrice.ToString();
UpdateTime.Text = pinfo.UpdateTime.ToString();
AddTime.Text = pinfo.AddTime.ToString();
isnew_chk.Checked = pinfo.Isnew == 1;//是否新品,热,等
ishot_chk.Checked = pinfo.Ishot == 1;
isbest_chk.Checked = pinfo.Isbest == 1;
Sales_Chk.Checked = pinfo.Sales == 1;
DataTable valueDT = proBll.GetContent(pinfo.TableName.ToString(), pinfo.ItemID);
if (valueDT != null && valueDT.Rows.Count > 0)
{
ModelHtml.Text = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
ValueDT = valueDT
});
}
#endregion
}
else
{
isnew_chk.Checked = true;
Sales_Chk.Checked = true;
ModelHtml.Text = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
Source = ModelConfig.SType.Admin
});
btnAdd.Visible = false;
}
}
/// <summary>
/// 异步回调后-->验证支付单状态-->如果正常,更新订单状态
/// </summary>
/// <param name="mod">订单模型</param>
/// <param name="paylogMod">订单支付日志模型</param>
public static void FinalStep(M_Payment pinfo, M_OrderList mod, M_Order_PayLog paylogMod)
{
B_OrderList orderBll = new B_OrderList();
B_CartPro cartBll = new B_CartPro();
B_Order_PayLog paylogBll = new B_Order_PayLog();
B_User buser = new B_User();
//订单已处理,避免重复（如已处理过,则继续处理下一张订单）
if (mod.OrderStatus >= 99)
{
ZLLog.L(ZoomLa.Model.ZLEnum.Log.safe, new M_Log()
{
Action = "支付回调异常,订单状态已为99",
Message = "订单号:" + mod.OrderNo + ",支付单:" + pinfo.PayNo
});
return;
}
//已经收到钱了,所以先执行
orderBll.UpOrderinfo("Paymentstatus=1,Receivablesamount=" + pinfo.MoneyTrue, mod.id);
if (mod.Ordertype == (int)M_OrderList.OrderEnum.Domain)//域名订单
{
orderBll.UpOrderinfo("OrderStatus=1", mod.id);
//Response.Redirect("~/Plugins/Domain/DomReg2.aspx?OrderNo=" + mod.OrderNo);
}
else if (mod.Ordertype == (int)M_OrderList.OrderEnum.IDC)//IDC服务
{
orderBll.UpOrderinfo("OrderStatus=99", mod.id);
cartBll.IDC_UpdateEndTimeByOid(mod.id);
}
else if (mod.Ordertype == (int)M_OrderList.OrderEnum.Purse)//余额充值,不支持银币
{
buser.ChangeVirtualMoney(mod.Userid, new M_UserExpHis()
{
score = (int)mod.Ordersamount,
ScoreType = (int)M_UserExpHis.SType.Purse,
detail = "余额充值,订单号:" + mod.OrderNo
});
orderBll.UpOrderinfo("OrderStatus=99", mod.id); //成功的订单
}
else if ((mod.Ordertype == (int)M_OrderList.OrderEnum.IDCRen)) //IDC服务续费
{
orderBll.UpOrderinfo("OrderStatus=99", mod.id);
B_Product proBll = new B_Product();
//更新旧订单的期限
if (string.IsNullOrEmpty(mod.Ordermessage))//购物车ID
{
//function.WriteErrMsg("出错,无需续费订单信息,请联系管理员!!!");
throw new Exception("出错,无续费订单信息,请联系管理员");
}
M_CartPro newCartMod = cartBll.SelModByOrderID(mod.id);//新购物车只是取其商品ID与数量等
M_Product proMod = proBll.GetproductByid(newCartMod.ProID);
//更新延长旧服务的到期时间，旧服务是存在CartPro的EndTime当中
M_CartPro oldCartMod = cartBll.SelReturnModel(Convert.ToInt32(mod.Ordermessage));
if (oldCartMod.EndTime < DateTime.Now)
{
oldCartMod.EndTime = DateTime.Now; //如已过期，则将时间更新至今日
}
oldCartMod.EndTime = proBll.GetEndTime(proMod, newCartMod.Pronum, oldCartMod.EndTime);
cartBll.UpdateByID(oldCartMod);
//paylogMod.Remind = "为" + mod.Ordermessage + "订单续费(购物车)";
}
else if (mod.Ordertype == (int)M_OrderList.OrderEnum.Cloud)//云购订单
{
//根据份数生成幸运码,写入表中,并减去库存 ZL_Order_LuckCode
}
else//其他旅游订单等,只更新状态
{
orderBll.UpOrderinfo("OrderStatus=99", mod.id);//成功的订单
}
//-------支付成功处理,并写入日志
paylogMod.Remind += "订单" + mod.OrderNo + "购买生效";
paylogMod.OrderID = mod.id;
paylogMod.PayMoney = mod.Ordersamount;
paylogMod.PayMethod = (int)M_Order_PayLog.PayMethodEnum.Other;//外部指定
paylogMod.PayPlatID = pinfo.PayPlatID;
paylogBll.insert(paylogMod);
}
//保存
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
string adminname = badmin.GetAdminLogin().AdminName;
DataTable dt = fieldBll.GetModelFieldList(ModelID);
DataTable gpdt = gpBll.GetGroupList();
DataTable table = new Call().GetDTFromPage(dt, Page, ViewState);
M_CommonData CCate = new M_CommonData();
M_Product proMod = new M_Product();
if (ProID > 0)
{
proMod = proBll.GetproductByid(ProID);
}
CCate.Status = istrue_chk.Checked ? 99 : 0;
CCate.NodeID = NodeID;
CCate.ModelID = ModelID;
CCate.TableName = modBll.GetModelById(ModelID).TableName;
CCate.Title = Proname.Text;
CCate.Inputer = adminname;
CCate.PdfLink = "";
CCate.FirstNodeID = nodeBll.SelFirstNodeID(NodeID);
CCate.EliteLevel = DataConverter.CLng(Dengji.SelectedValue) > 3 ? 1 : 0;
CCate.InfoID = "";
CCate.SpecialID = "";
CCate.Template = ModeTemplate_hid.Value;
CCate.DefaultSkins = 0;
/*--------------proMod------------*/
proMod.Class = 0;
proMod.Nodeid = NodeID;
proMod.ModelID = ModelID;
proMod.Properties = 0;
proMod.Isgood = 0;
proMod.MakeHtml = 0;
proMod.AddUser = adminname;
if (string.IsNullOrEmpty(proMod.ProCode))
{
proMod.ProCode = B_Product.GetProCode();
}
proMod.BarCode = BarCode.Text.Trim();
proMod.Proname = Proname.Text.Trim();
proMod.Kayword = Request.Form["tabinput"];
keyBll.AddKeyWord(proMod.Kayword, 1);
proMod.ProUnit = ProUnit.Text;
proMod.AllClickNum = DataConverter.CLng(Request.Form["AllClickNum"]);
proMod.Weight = DataConverter.CLng(Weight.Text);
proMod.ProClass = DataConverter.CLng(ProClass_Hid.Value);
proMod.IDCPrice = IDC_Hid.Value;
proMod.PointVal = DataConverter.CLng(PointVal_T.Text);
proMod.Proinfo = Proinfo.Text;
proMod.Procontent = procontent.Value;
proMod.Clearimg = txt_Clearimg.Text;
proMod.Thumbnails = txt_Thumbnails.Text;
proMod.Producer = Producer.Text;
proMod.Brand = Brand.Text;
//proMod.Quota = DataConverter.CLng(Quota.Text);
//proMod.DownQuota = DataConverter.CLng(DownQuota.Text);
proMod.StockDown = DataConverter.CLng(StockDown.Text);
proMod.JisuanFs = DataConverter.CLng(Request.Form["JisuanFs"]);
proMod.Rate = DataConverter.CDouble(Rate.Text);
proMod.Rateset = DataConverter.CLng(Rateset.SelectedValue);
proMod.Dengji = DataConverter.CLng(Dengji.SelectedValue);
proMod.ShiPrice = DataConverter.CDouble(ShiPrice.Text);
proMod.LinPrice = DataConverter.CDouble(LinPrice.Text);
proMod.LinPrice_Json = JsonHelper.AddVal("purse,sicon,point".Split(','), LinPrice_Purse_T.Text, LinPrice_Sicon_T.Text, LinPrice_Point_T.Text);
proMod.Preset = (OtherProject.SelectedValue == null) ? "" : OtherProject.SelectedValue; //促销
//proMod.Integral = DataConverter.CLng(Integral.Text);
proMod.Propeid = DataConverter.CLng(Propeid.Text);
proMod.Recommend = DataConverter.CLng(Recommend_T.Text);
proMod.Recommend = proMod.Recommend < 1 ? 0 : proMod.Recommend;//不允许负数
//proMod.Largesspirx = DataConverter.CLng(Largesspirx.Text);
proMod.Largess = Largess.Checked?1:0;
proMod.AllClickNum = DataConverter.CLng(AllClickNum_T.Text);
//更新时间，若没有指定则为当前时间
proMod.UpdateTime = DataConverter.CDate(UpdateTime.Text);
proMod.AddTime = DataConverter.CDate(AddTime.Text);
proMod.ModeTemplate = ModeTemplate_hid.Value;
proMod.FirstNodeID = CCate.FirstNodeID;
proMod.bookDay = DataConverter.CLng(BookDay_T.Text);
proMod.BookPrice = DataConverter.CDouble(BookPrice_T.Text);
proMod.FarePrice = FareTlp_Rad.SelectedValue;
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 = Price_Member_T.Text.Trim();
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;
}
int ProjectTypeRad = 0;
if (ProjectType2_Rad.Checked)
{
ProjectTypeRad = 2;
}
if (ProjectType3_Rad.Checked)
{
ProjectTypeRad = 3;
}
if (ProjectType4_Rad.Checked)
{
ProjectTypeRad = 4;
}
if (ProjectType5_Rad.Checked)
{
ProjectTypeRad = 5;
}
if (ProjectType6_Rad.Checked)
{
ProjectTypeRad = 6;
}
if (ProjectType7_Rad.Checked)
{
ProjectTypeRad = 7;
}
proMod.ProjectType = ProjectTypeRad;
switch (proMod.ProjectType)
{
#region 促销
case 1:
proMod.ProjectPronum = 0;
proMod.ProjectMoney = 0;
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = "";
proMod.PesentNameid = 0;
break;
case 2:
proMod.ProjectPronum = DataConverter.CLng(ProjectPronum2.Text);
proMod.ProjectMoney = 0;
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = "";
proMod.PesentNameid = 0;
break;
case 3:
proMod.ProjectPronum = DataConverter.CLng(ProjectPronum3.Text);
proMod.ProjectMoney = 0;
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = Productsname3.Text;
proMod.PesentNameid = DataConverter.CLng(HiddenField3.Value);
break;
case 4:
proMod.ProjectPronum = DataConverter.CLng(ProjectPronum4.Text);
proMod.ProjectMoney = 0;
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = "";
proMod.PesentNameid = 0;
break;
case 5:
proMod.ProjectPronum = DataConverter.CLng(ProjectPronum5.Text);
proMod.ProjectMoney = 0;
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = Productsname5.Text;
proMod.PesentNameid = DataConverter.CLng(HiddenField5.Value);
break;
case 6:
proMod.ProjectPronum = 0;
proMod.ProjectMoney = DataConverter.CDouble(ProjectMoney6.Text);
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = Productsname6.Text;
proMod.PesentNameid = DataConverter.CLng(HiddenField6.Value);
break;
case 7:
proMod.ProjectPronum = 0;
proMod.ProjectMoney = DataConverter.CDouble(ProjectMoney7.Text);
//proMod.IntegralNum = DataConverter.CLng(IntegralNum.Text);
proMod.PesentNames = Productsname7.Text;
proMod.PesentNameid = DataConverter.CLng(HiddenField7.Value);
break;
#endregion
}
proMod.TableName = modBll.GetModelById(ModelID).TableName;
proMod.Sales = Sales_Chk.Checked ? 1 : 2;
proMod.Istrue = istrue_chk.Checked ? 1 : 0;
proMod.Ishot = ishot_chk.Checked ? 1 : 0;
proMod.Isnew = isnew_chk.Checked ? 1 : 0;
proMod.Isbest = isbest_chk.Checked ? 1 : 0;
proMod.Allowed = Allowed.Checked ? 1 : 0;
proMod.GuessXML = Request.Form["GuessXML"];
proMod.Wholesalesinfo = ChildPro_Hid.Value;
proMod.DownCar = DataConvert.CLng(DownCar_T.Text);
//捆绑商品
if (!string.IsNullOrEmpty(Bind_Hid.Value))
{
//获取绑定商品
DataTable binddt = JsonHelper.JsonToDT(Bind_Hid.Value);
proMod.BindIDS = "";
foreach (DataRow dr in binddt.Rows)
{
proMod.BindIDS += dr["ID"] + ",";
}
proMod.BindIDS = proMod.BindIDS.TrimEnd(',');
}
else
{
proMod.BindIDS = "";
}
string danju = proMod.UserShopID + DateTime.Now.ToString("yyyyMMddHHmmss");
if (proMod.ID < 1 || ClickType.Value.Equals("addasnew"))
{
proMod.Priority = 0;
proMod.Nodeid = NodeID;
proMod.AddTime = DateTime.Now;
proMod.UpdateTime = DateTime.Now;
proMod.ID = proBll.Add(table, proMod, CCate);
proMod.Stock = DataConverter.CLng(Stock.Text);
//多区域价格
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("guid", ProGuid) };
SqlHelper.ExecuteSql("UPDATE ZL_Shop_RegionPrice SET [ProID]=" + proMod.ID + " WHERE [Guid]=@guid", sp);
M_Stock stockMod = new M_Stock()
{
proid = proMod.ID,
proname = proMod.Proname,
adduser = adminname,
StoreID = proMod.UserShopID,
};
int proStock = DataConverter.CLng(Stock.Text);
if (proStock > 0)
{
stockMod.proid = proMod.ID;
stockMod.stocktype = 0;
stockMod.Pronum = proStock;
stockMod.danju = "RK" + danju;
stockMod.content = "添加商品:" + proMod.Proname + "入库";
stockBll.AddStock(stockMod);
}
Response.Redirect("ContentShow.aspx?id=" + proMod.ID + "&ModelId=" + proMod.ModelID + "&NodeId=" + proMod.Nodeid);
}
else
{
proBll.Update(table, proMod, CCate);
//int stock = proStock - DataConverter.CLng(Stock_Hid.Value);
//if (stock != 0)
//{
// stockMod.stocktype = stock > 0 ? 0 : 1;
// stockMod.Pronum = Math.Abs(stock);
// stockMod.danju = (stockMod.stocktype > 0 ? "RK" : "CK") + danju;
// stockMod.content = stockMod.stocktype > 0 ? "添加商品:" + proMod.Proname + "入库" : "减少商品:" + proMod.Proname + "出库";
// stockBll.AddStock(stockMod);
//}
Response.Redirect("ContentShow.aspx?id=" + proMod.ID + "&ModelId=" + proMod.ModelID + "&NodeId=" + proMod.Nodeid);
}
}
public void MyBind()
{
M_Product pinfo = null;
if (ProID > 0)
{
pinfo = proBll.GetproductByid(ProID); NodeID = pinfo.Nodeid;
}
//-------------------------------
M_Node nodeMod = nodeBll.SelReturnModel(NodeID);
if (nodeMod.IsNull)
{
function.WriteErrMsg("节点[" + NodeID + "]不存在");
}
string bread1 = "<a href=\"ProductManage.aspx?NodeID=" + NodeID + "\">" + nodeMod.NodeName + "</a>", bread2 = "添加商品";
NodeName_L.Text = "<a href=\"ProductManage.aspx?NodeID=" + NodeID + "\">" + nodeMod.NodeName + "</a>";
UpdateTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
AddTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ProCode.Text = B_Product.GetProCode();
OtherBind(pinfo);//组,运费模板
if (ProID > 0)
{
#region 修改
StoreID = pinfo.UserShopID > 0 ? -1 : 0;
ModelID = pinfo.ModelID;
AllClickNum_T.Text = pinfo.AllClickNum.ToString();
bread2 = "修改商品";
ClickType.Value = "update";
btnAdd.Visible = true;
istrue_chk.Checked = pinfo.Istrue == 1 ? true : false;
ProCode.Text = pinfo.ProCode;
BarCode.Text = pinfo.BarCode.ToString();
Proname.Text = pinfo.Proname.ToString();
Keywords.Text = pinfo.Kayword.ToString();
ProUnit.Text = pinfo.ProUnit.ToString();
Weight.Text = pinfo.Weight.ToString();
restate_hid.Value = pinfo.GuessXML;
Propeid.Text = pinfo.Propeid.ToString();
//Largesspirx.Text = pinfo.Largesspirx.ToString();
Largess.Checked = pinfo.Largess == 1 ? true : false;
Recommend_T.Text = pinfo.Recommend.ToString();
//ServerPeriod.Text = pinfo.ServerPeriod.ToString();
//ServerType.SelectedValue = pinfo.ServerType.ToString();
//expRemindDP.SelectedValue = pinfo.ExpRemind.ToString();
ProClass_Hid.Value = pinfo.ProClass.ToString();
PointVal_T.Text = pinfo.PointVal.ToString();
Proinfo.Text = pinfo.Proinfo.ToString();
procontent.Value = pinfo.Procontent.ToString();
txt_Clearimg.Text = pinfo.Clearimg.ToString();
txt_Thumbnails.Text = pinfo.Thumbnails.ToString();
//Quota.Text = pinfo.Quota.ToString();
//DownQuota.Text = pinfo.DownQuota.ToString();
Stock.Text = pinfo.Stock.ToString();
SetStock_B.Visible = true;
StockDown.Text = pinfo.StockDown.ToString();
function.Script(this, "SetRadVal('JisuanFs','" + pinfo.JisuanFs + "');");
Rate.Text = pinfo.Rate.ToString();
Rateset.SelectedValue = pinfo.Rateset.ToString();
Dengji.Text = pinfo.Dengji.ToString();
ShiPrice.Text = pinfo.ShiPrice.ToString();
Brand.Text = pinfo.Brand.ToString();
Producer.Text = pinfo.Producer.ToString();
LinPrice.Text = pinfo.LinPrice.ToString();
LinPrice_Purse_T.Text = JsonHelper.GetDBVal(pinfo.LinPrice_Json, "purse").ToString("f2");
LinPrice_Sicon_T.Text = JsonHelper.GetDBVal(pinfo.LinPrice_Json, "sicon").ToString("f2");
LinPrice_Point_T.Text = JsonHelper.GetDBVal(pinfo.LinPrice_Json, "point").ToString("f2");
FareTlp_Rad.SelectedValue = pinfo.FarePrice;
ChildPro_Hid.Value = pinfo.Wholesalesinfo; //多价格
IDC_Hid.Value = pinfo.IDCPrice;
Stock.ReadOnly = true;
if (!string.IsNullOrEmpty(pinfo.BindIDS))//捆绑商品
{
DataTable dt = proBll.SelByIDS(pinfo.BindIDS, "id,Thumbnails,Proname,LinPrice");
Bind_Hid.Value = JsonConvert.SerializeObject(dt);
}
if (!string.IsNullOrEmpty(pinfo.Preset))
{
if (pinfo.Preset.IndexOf(",") > -1)
{
string[] presetarr = pinfo.Preset.Split(new string[] { "," }, StringSplitOptions.None);
for (int s = 0; s < presetarr.Length; s++)
{
M_Promotions proinfo = promoBll.GetPromotionsByid(DataConverter.CLng(presetarr[s]));
if (proinfo == null)
{
continue;
}
OtherProject.Items.Add(new ListItem(proinfo.Promoname, proinfo.Id.ToString()));
}
}
else
{
M_Promotions proinfo = promoBll.GetPromotionsByid(DataConverter.CLng(pinfo.Preset));
if (proinfo != null)
{
OtherProject.Items.Add(new ListItem(proinfo.Promoname, proinfo.Id.ToString()));
}
}
}
if (OtherProject.Items.Count > 0)
{
for (int d = 0; d < OtherProject.Items.Count; d++)
{
OtherProject.Items[d].Selected = true;
}
}
//填充显示会员价
switch (pinfo.UserType)
{
case 1:
Price_Member_T.Text = DataConverter.CDouble(pinfo.UserPrice).ToString("f2");
price_member_div.Attributes["style"] = "";
break;
case 2:
price_group_div.Attributes["style"] = "";
break;
default:
break;
}
function.Script(this, "SetRadVal('UserPrice_Rad','" + pinfo.UserType + "');");
function.Script(this, "SetRadVal('DownQuota_Rad','" + pinfo.DownQuota + "');");
function.Script(this, "SetRadVal('Quota_Rad','" + pinfo.Quota + "');");
DownCar_T.Text = pinfo.DownCar.ToString();
BookPrice_T.Text = pinfo.BookPrice.ToString("f2");
BookDay_T.Text = pinfo.bookDay.ToString();
//Integral.Text = pinfo.Integral.ToString();
UpdateTime.Text = pinfo.UpdateTime.ToString();
AddTime.Text = pinfo.AddTime.ToString();
ModeTemplate_hid.Value = pinfo.ModeTemplate.ToString();
isnew_chk.Checked = pinfo.Isnew == 1;//是否新品,热,等
ishot_chk.Checked = pinfo.Ishot == 1;
isbest_chk.Checked = pinfo.Isbest == 1;
Sales_Chk.Checked = pinfo.Sales == 1;
Allowed.Checked = pinfo.Allowed == 1;
DataTable valueDT = proBll.Getmodetable(pinfo.TableName.ToString(), pinfo.ItemID);
if (valueDT != null && valueDT.Rows.Count > 0)
{
ModelHtml.Text = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
ValueDT = valueDT
});
}
//IntegralNum.Text = pinfo.IntegralNum.ToString();
switch (pinfo.ProjectType)
{
case 1:
break;
case 2:
ProjectType2_Rad.Checked = true;
ProjectPronum2.Text = pinfo.ProjectPronum.ToString();
break;
case 3:
ProjectType3_Rad.Checked = true;
ProjectPronum3.Text = pinfo.ProjectPronum.ToString();
Productsname3.Text = pinfo.PesentNames.ToString();
HiddenField3.Value = pinfo.PesentNameid.ToString();
break;
case 4:
ProjectType4_Rad.Checked = true;
ProjectPronum4.Text = pinfo.ProjectPronum.ToString();
break;
case 5:
ProjectType5_Rad.Checked = true;
ProjectPronum5.Text = pinfo.ProjectPronum.ToString();
Productsname5.Text = pinfo.PesentNames.ToString();
HiddenField5.Value = pinfo.PesentNameid.ToString();
break;
case 6:
ProjectType6_Rad.Checked = true;
ProjectMoney7.Text = pinfo.ProjectMoney.ToString();
Productsname6.Text = pinfo.PesentNames.ToString();
HiddenField6.Value = pinfo.PesentNameid.ToString();
break;
case 7:
ProjectType7_Rad.Checked = true;
ProjectMoney7.Text = pinfo.ProjectMoney.ToString();
Productsname7.Text = pinfo.PesentNames.ToString();
HiddenField7.Value = pinfo.PesentNameid.ToString();
break;
}
#endregion
#region 多区域价格
ProGuid = pinfo.ID.ToString();
M_Shop_RegionPrice regionMod = regionBll.SelModelByGuid(ProGuid);
if (regionMod != null && !string.IsNullOrEmpty(regionMod.Info))
{
function.Script(this, "region.fill(" + regionMod.Info + ");");
}
#endregion
}
else
{
isnew_chk.Checked = true;
Sales_Chk.Checked = true;
ModelHtml.Text = fieldBll.InputallHtml(ModelID, NodeID, new ModelConfig()
{
Source = ModelConfig.SType.Admin
});
btnAdd.Visible = false;
}
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='ProductManage.aspx'>商城管理</a></li><li><a href='ProductManage.aspx?NodeID='>" + bread1 + "</a></li><li class='active'>" + bread2 + "</li>"
+ "<div class='pull-right hidden-xs'><span onclick=\"opentitle('../Content/EditNode.aspx?NodeID=" + NodeID + "','配置本节点');\" class='fa fa-cog' title='配置本节点' style='cursor:pointer;margin-left:5px;'></span></div>");
}
public void Product_Add()
{
int NodeID = DataConvert.CLng(Request["NodeID"]);
int ModelID = DataConvert.CLng(Request["ModelID"]);
string adminname = mu.UserName;
DataTable dt = fieldBll.GetModelFieldList(ModelID);
DataTable table;
try
{
table = new Call().GetDTFromMVC(dt, Request);
}
catch (Exception e)
{
function.WriteErrMsg(e.Message); return;
}
M_CommonData CCate = new M_CommonData();
M_Product proMod = new M_Product();
if (Mid > 0)
{
proMod = proBll.GetproductByid(Mid);
NodeID = proMod.Nodeid;
ModelID = proMod.ModelID;
}
else
{
proMod.Nodeid = NodeID;
proMod.ModelID = ModelID;
//------------------------
CCate.NodeID = proMod.Nodeid;
CCate.ModelID = proMod.ModelID;
CCate.Inputer = adminname;
CCate.TableName = modBll.GetModelById(ModelID).TableName;
CCate.FirstNodeID = nodeBll.SelFirstNodeID(NodeID);
}
/*--------------proMod------------*/
proMod.Istrue = 1;
proMod.Properties = 0;
proMod.Class = 0;
proMod.Isgood = 0;
proMod.MakeHtml = 0;
proMod.DownCar = 1;
proMod.AddUser = adminname;
if (string.IsNullOrEmpty(proMod.ProCode))
{
proMod.ProCode = B_Product.GetProCode();
}
proMod.BarCode = Request.Form["BarCode"];
proMod.Proname = Request.Form["Proname"];
proMod.Kayword = Request.Form["tabinput"];
keyBll.AddKeyWord(proMod.Kayword, 1);
proMod.ProUnit = Request.Form["ProUnit"];
proMod.AllClickNum = DataConverter.CLng(Request.Form["AllClickNum"]);
proMod.Weight = DataConverter.CLng(Request.Form["Weight"]);
proMod.ProClass = DataConverter.CLng(Request.Form["ProClass_Hid"]);
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(Request.Form["Quota"]);
proMod.DownQuota = DataConverter.CLng(Request.Form["DownQuota"]);
proMod.StockDown = DataConverter.CLng(Request.Form["StockDown"]);
proMod.JisuanFs = DataConverter.CLng(Request.Form["JisuanFs"]);
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.LinPrice_Json = JsonHelper.AddVal("purse,sicon,point".Split(','), Request.Form["LinPrice_Purse_T"], Request.Form["LinPrice_Sicon_T"], Request.Form["LinPrice_Point_T"]);
proMod.Propeid = DataConverter.CLng(Request.Form["Propeid"]);
proMod.Recommend = DataConverter.CLng(Request.Form["Recommend_T"]);
proMod.Recommend = proMod.Recommend < 1 ? 0 : proMod.Recommend;//不允许负数
proMod.Largesspirx = DataConverter.CLng(Request.Form["Largesspirx"]);
proMod.AllClickNum = DataConverter.CLng(Request.Form["AllClickNum_T"]);
//更新时间，若没有指定则为当前时间
proMod.UpdateTime = DataConverter.CDate(Request.Form["UpdateTime"]);
proMod.AddTime = DataConverter.CDate(Request.Form["AddTime"]);
//proMod.ModeTemplate = ModeTemplate_hid.Value;
proMod.FirstNodeID = CCate.FirstNodeID;
proMod.bookDay = DataConverter.CLng(Request.Form["BookDay_T"]);
proMod.BookPrice = DataConverter.CDouble(Request.Form["BookPrice_T"]);
proMod.FarePrice = Request.Form["FareTlp_Rad"];
proMod.UserType = DataConverter.CLng(Request.Form["UserPrice_Rad"]);
//--------------------------------------
CCate.Status = 99;
CCate.Title = proMod.Proname;
CCate.PdfLink = "";
CCate.EliteLevel = DataConverter.CLng(Request.Form["Dengji"]) > 3 ? 1 : 0;
CCate.InfoID = "";
CCate.SpecialID = "";
//CCate.Template = ModeTemplate_hid.Value;
CCate.DefaultSkins = 0;
switch (proMod.UserType)
{
case 1:
proMod.UserPrice = DataConvert.CDouble(Request["Price_Member_T"]).ToString("F2");
break;
case 2:
DataTable updt = new DataTable();
updt.Columns.Add(new DataColumn("gid", typeof(int)));
updt.Columns.Add(new DataColumn("price", typeof(double)));
string[] prices = Request.Form["Price_Group_T"].Split(',');
string[] gids = Request.Form["GroupID_Hid"].Split(',');
for (int i = 0; i < gids.Length; i++)
{
DataRow dr = updt.NewRow();
dr["gid"] = Convert.ToInt32(gids[i]);
dr["price"] = DataConverter.CDouble(prices[i]);
updt.Rows.Add(dr);
}
proMod.UserPrice = JsonConvert.SerializeObject(updt);
break;
}
proMod.TableName = modBll.GetModelById(ModelID).TableName;
proMod.Sales = string.IsNullOrEmpty(Request.Form["Sales_Chk"]) ? 2 : 1;
proMod.Ishot = string.IsNullOrEmpty(Request.Form["ishot_chk"]) ? 0 : 1;
proMod.Isnew = string.IsNullOrEmpty(Request.Form["isnew_chk"]) ? 0 : 1;
proMod.Isbest = string.IsNullOrEmpty(Request.Form["isbest_chk"]) ? 0 : 1;
proMod.Allowed = string.IsNullOrEmpty(Request.Form["Allowed"]) ? 0 : 1;
proMod.GuessXML = Request.Form["GuessXML"];
proMod.Wholesalesinfo = Request.Form["ChildPro_Hid"];
//捆绑商品
if (!string.IsNullOrEmpty(Request.Form["Bind_Hid"]))
{
//获取绑定商品
DataTable binddt = JsonHelper.JsonToDT(Request.Form["Bind_Hid"]);
proMod.BindIDS = "";
foreach (DataRow dr in binddt.Rows)
{
proMod.BindIDS += dr["ID"] + ",";
}
proMod.BindIDS = proMod.BindIDS.TrimEnd(',');
}
else
{
proMod.BindIDS = "";
}
string ClickType = Request.Form["ClickType"];
string danju = proMod.UserShopID + DateTime.Now.ToString("yyyyMMddHHmmss");
{
//店铺专用
M_CommonData storeMod = conBll.SelMyStore_Ex(ref err);
if (!string.IsNullOrEmpty(err))
{
function.WriteErrMsg(err); return;
}
proMod.UserShopID = storeMod.GeneralID;
proMod.UserID = mu.UserID;
}
if (proMod.ID < 1 || ClickType.Equals("addasnew"))
{
proMod.Priority = 0;
proMod.Nodeid = NodeID;
proMod.AddTime = DateTime.Now;
proMod.UpdateTime = DateTime.Now;
proMod.ID = proBll.Add(table, proMod, CCate);
//多区域价格
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("guid", Request.Form["ProGuid"]) };
SqlHelper.ExecuteSql("UPDATE ZL_Shop_RegionPrice SET [ProID]=" + proMod.ID + " WHERE [Guid]=@guid", sp);
M_Stock stockMod = new M_Stock()
{
proid = proMod.ID,
proname = proMod.Proname,
adduser = adminname,
StoreID = proMod.UserShopID,
};
int proStock = DataConverter.CLng(Request.Form["Stock"]);
if (proStock > 0)
{
stockMod.proid = proMod.ID;
stockMod.stocktype = 0;
stockMod.Pronum = proStock;
stockMod.danju = "RK" + danju;
stockMod.content = "添加商品:" + proMod.Proname + "入库";
stockBll.AddStock(stockMod);
}
}
else
{
proBll.Update(table, proMod, CCate);
}
function.WriteSuccessMsg("操作成功", "ProductList"); return;
}
