/// <summary>
/// 购物车中有则增加数量，否则添加记录
/// </summary>
public int AddModel(M_Cart model)
{
if (string.IsNullOrEmpty(model.Cartid) && model.userid < 1)
{
return(0);
}
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("cartid", model.Cartid)
};
string where = "ProID=" + model.ProID;
if (model.userid > 0)
{
where += " AND UserID=" + model.userid;
}
else
{
where += " AND CartID=@cartid";
}
DataTable dt = DBCenter.SelWithField("ZL_Cart", "ID,Pronum", where, "", sp);
if (dt.Rows.Count > 0)
{
int id = Convert.ToInt32(dt.Rows[0]["ID"]);
DBCenter.UpdateSQL(TbName, "Pronum=" + (Convert.ToInt32(dt.Rows[0]["Pronum"]) + model.Pronum), "ID=" + id);
return(id);
}
else
{
return(insert(model));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!B_ARoleAuth.Check(ZLEnum.Auth.shop, "ProductManage"))
{
function.WriteErrMsg("没有权限进行此项操作");
}
else if (ProID < 1 && ModelID == 0)
{
function.WriteErrMsg("没有指定要添加内容的模型ID!");
}
else if (ProID < 1 && NodeID == 0)
{
function.WriteErrMsg("没有指定要添加内容的栏目节点ID!");
}
if (!IsPostBack)
{
ProGuid = System.Guid.NewGuid().ToString();
Group_Hid.Value = JsonConvert.SerializeObject(DBCenter.SelWithField("ZL_Group", "GroupID,GroupName"));
RangeValidator1.MinimumValue = Convert.ToString(Int32.MinValue);
RangeValidator1.MaximumValue = Convert.ToString(Int32.MaxValue);
RangeValidator2.MinimumValue = Convert.ToString(Int32.MinValue);
RangeValidator2.MaximumValue = Convert.ToString(Int32.MaxValue);
RangeValidator3.MinimumValue = Convert.ToString(Int32.MinValue);
RangeValidator3.MaximumValue = Convert.ToString(Int32.MaxValue);
RangeValidator4.MinimumValue = Convert.ToString(Int32.MinValue);
RangeValidator4.MaximumValue = Convert.ToString(Int32.MaxValue);
MyBind();
}
}
//-----------User操作
public DataTable SelMyFriend(int uid, string skey = "")
{
skey = skey.Replace(" ", "");
string where = "(UserID=" + uid + " OR TUserID =" + uid + ") AND ZStatus=" + (int)ConStatus.Audited;
DataTable dt = DBCenter.SelWithField(TbName, "UserID,TUserID", where);
string uids = "";
foreach (DataRow dr in dt.Rows)
{
if (DataConvert.CLng(dr["UserID"]) == uid)
{
uids += dr["TUserID"] + ",";
}
else
{
uids += dr["UserID"] + ",";
}
}
uids = uids.TrimEnd(',');
if (string.IsNullOrEmpty(uids))
{
return(null);
}
where = "UserID IN (" + uids + ")";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(skey))
{
where += " AND UserName LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey + "%"));
}
return(DBCenter.SelWithField("ZL_User", "UserID,UserName,HoneyName,Salt", where, "RegTime DESC", sp));
}
public PartialViewResult news()
{
string where = "Pid=0 AND Status>0 AND ATUser LIKE '%," + upMod.UserID + ",%'";
DataTable dt = DBCenter.SelWithField("ZL_Plat_Blog", "TOP 9 ID,MsgContent,CUName,CUser,CDate", where, "ID DESC");
return(PartialView(dt));
}
/// <summary>
/// 用于购物车页与订单页面,返回套装促销商品
/// </summary>
public DataTable Suit_GetProduct(string json, int num)
{
DataTable prodt = JsonConvert.DeserializeObject <DataTable>(json);
string ids = "";
foreach (DataRow pro in prodt.Rows)
{
ids += pro["ID"] + ",";
}
DataTable pdt = DBCenter.SelWithField("ZL_Commodities", "A.*,suitnum=1,Pronum=1", "ID IN (" + ids.Trim(',') + ")");
for (int i = 0; i < pdt.Rows.Count; i++)
{
DataRow pdr = pdt.Rows[i];
DataRow[] drs = prodt.Select("ID='" + pdr["id"] + "'");
if (drs.Length > 0)
{
pdr["suitnum"] = drs[0]["suitnum"];
pdr["LinPrice"] = drs[0]["Price"];
pdr["Pronum"] = DataConvert.CLng(num) * DataConvert.CLng(pdr["suitnum"]);
}
}
pdt.Columns["UserShopID"].ColumnName = "StoreID";
pdt.Columns["ID"].ColumnName = "ProID";
return(pdt);
}
public PartialViewResult star()
{
string where = " ColledIDS LIKE '%," + upMod.UserID + ",%' ";
DataTable dt = DBCenter.SelWithField("ZL_Plat_Blog", "TOP 12 ID,MsgContent,CUName,CUser,CDate", where, "ID DESC");
return(PartialView(dt));
}
/// <summary>
/// 返回店铺销售汇总
/// </summary>
/// <param name="sid"></param>
/// <returns></returns>
public DataRow GetSummary(F_Shop_SaleReport filter)
{
string fields = "Count(ID) OrderNum,SUM(Receivablesamount) OrderTotal";
string where = "1=1 ";
if (filter.StoreID != -100)
{
where += " AND StoreID=" + filter.StoreID;
}
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(filter.SDate))
{
where += " AND PayTime>=@stime";
sp.Add(new SqlParameter("stime", Convert.ToDateTime(filter.SDate).ToString("yyyy/MM/dd 00:00:00")));
}
if (!string.IsNullOrEmpty(filter.EDate))
{
where += " AND PayTime<=@etime";
sp.Add(new SqlParameter("etime", Convert.ToDateTime(filter.EDate).ToString("yyyy/MM/dd 23:59:59")));
}
DataTable dt = DBCenter.SelWithField("ZL_Order_PayedView", fields, where, "", sp);
dt.Columns.Add("KDJ", typeof(string));
DataRow dr = dt.Rows[0];
dr["OrderTotal"] = DataConvert.CDouble(dr["OrderTotal"]).ToString("F2");
dr["KDJ"] = (DataConvert.CDouble(dr["OrderTotal"]) / DataConvert.CLng(dr["OrderNum"])).ToString("F2");
return(dr);
}
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);
}
public DataTable Cate_SelByType(M_GuestBookCate.TypeEnum type, int pid = 0)
{
string fields = "A.*,(Select Count(*) From " + TbName + " Where ParentID=A.Cateid)ChildCount";
string where = "GType=" + (int)type;
where += "And ParentID=" + pid;
return(DBCenter.SelWithField(TbName, fields, where, "OrderID"));
}
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);
}
/// <summary>
/// 获取子会员组
/// </summary>
public DataTable GetChildGroup(int GroupID)
{
string fields = "*,";
fields += "(SELECT COUNT(*) FROM ZL_Group WHERE ParentGroupID=A.GroupID) AS Child,";
fields += "(SELECT COUNT(*) FROM ZL_User WHERE GroupID=A.GroupID) AS UserNum,";
fields += "(SELECT TOP 1 UserModel FROM ZL_GroupModel WHERE GroupID=A.GroupID AND UserModel>0)AS UserModel";
return(DBCenter.SelWithField(strTableName, fields, "ParentGroupID=" + GroupID, "OrderID ASC"));
}
//用于旅游,机票页
public DataTable SelByIDS(string ids, string field = "*")
{
ids = StrHelper.PureIDSForDB(ids);
if (string.IsNullOrEmpty(ids))
{
return(null);
}
SafeSC.CheckIDSEx(ids);
return(DBCenter.SelWithField(TbName, field, "ID IN(" + ids + ")"));
}
//--------------------Special
public string SelMonthToJson(DateTime date, int uid)
{
string stime = "", etime = "";
DateHelper.GetMonthSE(date, ref stime, ref etime);
string where = "UserID=" + uid;
where += " AND (StartDate>='" + stime + "' AND StartDate<='" + etime + "')";
DataTable dt = DBCenter.SelWithField(TbName, "id,name,startdate", where, "");
return(JsonConvert.SerializeObject(dt));
}
private DataTable GetGroupDT()
{
DataTable gpdt = DBCenter.SelWithField("ZL_Plat_Group", "ID,GroupName,MemberIDS", "1=0");
DataTable dt = DBCenter.SelWithField("ZL_Plat_Group", "ID,GroupName,MemberIDS");
DataRow dr = gpdt.NewRow();
dr["ID"] = 0;
dr["GroupName"] = "未关联部门用户";
gpdt.Rows.Add(dr);
gpdt.Merge(dt);
return(gpdt);
}
public DataTable SelByStyleAndPid(int sid, int pid)
{
string where = "1=1 ";
if (sid > 0)
{
where += " AND UserGroup=" + sid;
}
if (pid != -100)
{
where += " AND ParentID=" + pid;
}
return(DBCenter.SelWithField(TbName, "*,TemplateID AS ID,TemplateName AS Name", where, "OrderID ASC"));
}
/// <summary>
/// 抽取用户留言栏目
/// </summary>
public DataTable SelByGuest()
{
string where = "GType=0";
//if (parentid != -100) { where += " AND ParentID=" + parentid; }
//if (cateid != -100 && cateid != 0) { where += "A.CateID=" + cateid; }
//switch (order)
//{
// case "asc":
// break;
// case "desc":
// ordersql = "Gid DESC";
// break;
//}
return(DBCenter.SelWithField(TbName, "A.*,GCount=(SELECT COUNT(*) FROM ZL_GuestBook WHERE Cateid=A.Cateid AND ParentID=0 AND Status<>-1),GCountAll=(SELECT COUNT(*) FROM ZL_GuestBook WHERE Cateid=A.Cateid AND Status<>-1)", where));
}
/// <summary>
/// 查询详细销售情况,并按分类统计
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static DataTable SelByClass(F_Order_Sale filter)
{
string where = "(PaymentNO IS NOT NULL AND PaymentNO!='') AND OrderStatus>=0 ";
DateTime time = DateTime.Now;
if (DateTime.TryParse(filter.stime, out time))
{
where += " AND PayTime>='" + time.ToString("yyyy/MM/dd 00:00:00") + "'";
}
if (DateTime.TryParse(filter.etime, out time))
{
where += " AND PayTime<='" + time.ToString("yyyy/MM/dd 23:59:59") + "'";
}
return(DBCenter.SelWithField("ZL_Order_ProSaleView", "SUM(AllMoney)AS AllMoney,NodeID,NodeName", where + " GROUP BY NodeID,NodeName", "ALLMoney DESC"));
}
public PartialViewResult Users()
{
//未关联部门的用户
DataTable UserDT = upBll.SelByCompany(upMod.CompID);
DataTable gpdt = DBCenter.SelWithField("ZL_Plat_Group", "ID,GroupName,MemberIDS", "1=0");
DataTable dt = DBCenter.SelWithField("ZL_Plat_Group", "ID,GroupName,MemberIDS");
DataRow dr = gpdt.NewRow();
dr["ID"] = 0;
dr["GroupName"] = "未关联部门用户";
gpdt.Rows.Add(dr);
gpdt.Merge(dt);
ViewBag.UserDT = UserDT;
return(PartialView(gpdt));
}
