/// <summary> /// 清空目标站点页面,拷贝模板,并返回新加入的模板index页面的guid /// </summary> public string CopyTlp(int tlpID, M_Design_SiteInfo sfMod) { if (tlpID < 1 || sfMod == null || sfMod.ID < 1) { return(""); } //后期扩展为只覆盖指定页?? DBCenter.DelByWhere("ZL_Design_Page", "SiteID=" + sfMod.ID); string guid = ""; DataTable dt = SelByTlpID(tlpID); dt.TableName = pageTbName; dt.Columns.Remove("ID"); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; dr["Guid"] = System.Guid.NewGuid().ToString(); dr["UserID"] = sfMod.UserID; dr["SiteID"] = sfMod.ID; //dr["Comp"] = dr["Comp"].ToString().Replace("/UploadFiles/", B_Design_SiteInfo.GetSiteUpDir(sfMod.ID)); string path = dt.Rows[i]["Path"].ToString().ToLower().Replace(" ", ""); if (path.Equals("/") || path.Equals("/index")) { guid = dr["Guid"].ToString(); } } SqlHelper.Insert_Bat(dt, SqlHelper.ConnectionString); return(guid); }
public void Del(int suid, int tuid) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "UserID=" + suid + " AND TUserID=" + tuid; DBCenter.DelByWhere(TbName, where); }
/// <summary> /// 消赞操作 /// </summary> public bool DelLike(int uid, int infoID, string source) { List <SqlParameter> splist = new List <SqlParameter> { new SqlParameter("source", source) }; return(DBCenter.DelByWhere(TbName, "CUser="******" AND MsgID=" + infoID + " AND Source=@source", splist)); }
/// <summary> /// 删除节点,并删除该节点的子节点 /// </summary> public void DelNode(int NodeID) { if (NodeID < 1) { throw new Exception("NodeID不能小于或等于0"); } DBCenter.DelByWhere(TbName, "NodeID=" + NodeID + " OR ParentID=" + NodeID); }
public void DelByUid(int uid, string plat) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("plat", plat.Trim()) }; DBCenter.DelByWhere(TbName, "UserID=" + uid + " AND SourcePlat=@plat", sp); }
public void DelByOpenID(string openid) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("openid", openid.Trim()) }; DBCenter.DelByWhere(TbName, "OpenID=@openid", sp); }
//------------------------ public void U_Del(int uid, string ids) { if (string.IsNullOrEmpty(ids)) { return; } SafeSC.CheckIDSEx(ids); DBCenter.DelByWhere(TbName, "CommentID IN (" + ids + ") AND UserID=" + uid); }
public void Del(string ids) { if (string.IsNullOrEmpty(ids)) { return; } SafeSC.CheckIDSEx(ids); DBCenter.DelByWhere(TbName, PK + " IN (" + ids + ")"); }
/// <summary> /// 删除不属于指定会员模型ID组合的会员模型记录 /// </summary> public bool DelGroupModel(int GroupID, string modelids = "") { string where = "GroupID=" + GroupID; if (!string.IsNullOrEmpty(modelids)) { SafeSC.CheckIDSEx(modelids); where += " AND GroupModel IN (" + modelids + ")"; } return(DBCenter.DelByWhere("ZL_GroupModel", where)); }
/// <summary> /// 删除节点,并删除该节点的子节点 /// </summary> public void DelNode(string nids) { if (string.IsNullOrEmpty(nids)) { return; } SafeSC.CheckIDSEx(nids); DBCenter.DelByWhere(TbName, "NodeID IN(" + nids + ")"); }
/// <summary> /// 取消订阅,移除微信用户信息,移除绑定信息 /// </summary> public bool DelByOpenid(string openid) { List <SqlParameter> sp = new List <SqlParameter> { new SqlParameter("@openid", openid) }; DBCenter.DelByWhere(TbName, "OpenID=@openid", sp); new B_UserAPP().DelByOpenID(openid); return(true); }
public void DelByIDS(string ids, int uid = 0) { SafeSC.CheckIDSEx(ids); string where = "ID IN(" + ids + ") "; if (uid > 0) { where += " AND UserID=" + uid; } DBCenter.DelByWhere(TbName, where); }
public void DelModelTemplate(int NodeID, string ModelIDs) { ModelIDs = StrHelper.PureIDSForDB(ModelIDs); if (string.IsNullOrEmpty(ModelIDs)) { return; } SafeSC.CheckIDSEx(ModelIDs); DBCenter.DelByWhere("ZL_Node_ModelTemplate", "NodeID=" + NodeID + " AND ModelID Not IN (" + ModelIDs + ")"); }
public bool DelByIDS(string ids, int uid = 0) { SafeSC.CheckIDSEx(ids); string where = PK + " IN (" + ids + ")"; if (uid > 0) { where += " AND Owner=" + uid; } return(DBCenter.DelByWhere(TbName, where)); }
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"); }
public void DelByIDS(string ids, int storeid = -100) { if (string.IsNullOrEmpty(ids)) { return; } SafeSC.CheckIDSEx(ids); string where = "ID IN (" + ids + ") "; if (storeid != -100) { where += " AND StoreID=" + storeid; } DBCenter.DelByWhere(TbName, where); }
public void DelByIDS(string ids, int uid = 0) { if (string.IsNullOrEmpty(ids)) { return; } SafeSC.CheckIDSEx(ids); string where = PK + " IN (" + ids + ") "; if (uid > 0) { where += " AND UserID=" + uid; } DBCenter.DelByWhere(TbName, where); }
public bool DelByIDS(string ids, int storeID = -100) { if (string.IsNullOrEmpty(ids)) { return(false); } SafeSC.CheckIDSEx(ids); string where = PK + " IN (" + ids + ")"; if (storeID != -100) { where += " AND StoreID=" + storeID; } return(DBCenter.DelByWhere(TbName, where)); }
public bool DelByIDS(string ids, int uid = -100) { string where = " 1=1 "; if (string.IsNullOrEmpty(ids)) { return(false); } if (uid != -100) { where += " AND CUser="******" AND ID IN (" + ids + ")"; SafeSC.CheckIDSEx(ids); return(DBCenter.DelByWhere(TbName, where)); }
public void BatInsert(int proID, string json) { //先清除再重新写入 DBCenter.DelByWhere(TbName, "ProID=" + proID); if (string.IsNullOrEmpty(json) || json.Equals("[]")) { return; } DataTable dt = JsonConvert.DeserializeObject <DataTable>(json); for (int i = 0; i < dt.Rows.Count; i++) { M_Shop_Present ptMod = new M_Shop_Present().GetModelFromReader(dt.Rows[i]); ptMod.ProID = proID; Insert(ptMod); } }
public bool DelByIDS(string cartid, string uname, string ids) { SafeSC.CheckIDSEx(ids); List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("cartid", cartid), new SqlParameter("uname", uname) }; string where = " ID IN (" + ids + ") "; if (!string.IsNullOrEmpty(uname)) { where += " AND (CartID=@cartid OR UserName=@uname)"; } else { where += " AND CartID=@cartid"; } return(DBCenter.DelByWhere(TbName, where, sp)); }
public void U_Del(int uid, int infoID, int type) { string where = "Owner=" + uid + " AND InfoID=" + infoID + " AND FavoriType=" + type; DBCenter.DelByWhere(TbName, where); }
public void DelByWhere(string where, List <SqlParameter> splist) { DBCenter.DelByWhere(TbName, where, splist); }
protected void Page_Load(object sender, EventArgs e) { ExHelper.CheckUserAuth("cash"); if (function.isAjax()) { //string action = Request.Form["action"]; string result = ""; M_UserInfo mu = buser.GetLogin(); //直接生成新单,无效的订单一定时间自动清理(未付款) int uid = DataConvert.CLng(Request.Form["uid"]); string cart = Request.Form["cart"]; if (string.IsNullOrEmpty(cart)) { throw new Exception("未指定消费项目"); } if (string.IsNullOrEmpty(Request.Form["uid"])) { throw new Exception("未指定用户"); } //---------------------------根据信息生成订单 DataTable cartDT = JsonConvert.DeserializeObject <DataTable>(cart); M_User_StoreUser suMod = new M_User_StoreUser(); if (uid > 0) { suMod = suBll.SelModelByUid(uid, mu.SiteID); } List <M_CartPro> cpList = new List <M_CartPro>(); //----------------- M_OrderList orderMod = null; if (Mid > 0) { orderMod = orderBll.SelReturnModel(Mid); } else { orderMod = orderBll.NewOrder(mu, M_OrderList.OrderEnum.Normal); } //每次均重新获取 orderMod.Userid = mu.UserID; orderMod.AddUser = mu.UserName;//收银员名称 orderMod.Receiver = suMod.UserID.ToString(); orderMod.Rename = suMod.HoneyName; orderMod.StoreID = mu.SiteID; orderMod.Ordersamount = 0; foreach (DataRow dr in cartDT.Rows) { int cid = Convert.ToInt32(dr["ID"]); M_CartPro cpMod = new M_CartPro(); if (cid > 0) { cpMod = cpBll.SelReturnModel(cid); if (cpMod.Orderlistid != Mid) { throw new Exception("购物车数据与订单不匹配"); } } else { cpMod.StoreID = mu.SiteID; } //------------------- M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["ProID"])); cpMod.ProID = proMod.ID; cpMod.Proname = proMod.Proname; cpMod.Danwei = proMod.ProUnit; cpMod.Shijia = proMod.LinPrice; cpMod.Pronum = Convert.ToInt32(dr["Pronum"]); cpMod.AllMoney = cpMod.Shijia * cpMod.Pronum; orderMod.Ordersamount += cpMod.AllMoney; //------------------------- cpMod.Username = suMod.HoneyName; cpMod.code = DataConvert.CStr(dr["code"]); //技师ID cpMod.Attribute = DataConvert.CStr(dr["Attribute"]); //技师姓名 cpList.Add(cpMod); //city,bindpro, } if (orderMod.id > 0) { orderBll.UpdateByID(orderMod); } else { orderMod.id = orderBll.insert(orderMod); } string cpIds = ""; foreach (M_CartPro cpMod in cpList) { if (cpMod.ID > 0) { cpBll.UpdateByID(cpMod); } else { cpMod.Orderlistid = orderMod.id; cpMod.ID = cpBll.GetInsert(cpMod); } cpIds += cpMod.ID + ","; } //删除未提交的购物车信息 cpIds = cpIds.TrimEnd(','); DBCenter.DelByWhere("ZL_CartPro", "OrderListID=" + orderMod.id + " AND ID NOT IN (" + cpIds + ")"); result = orderMod.id.ToString(); //--------------------------------------------- Response.Clear(); Response.Write(result); Response.Flush(); Response.End(); return; } if (!IsPostBack) { M_UserInfo mu = buser.GetLogin(); if (Mid > 0) { M_OrderList orderMod = orderBll.SelReturnModel(Mid); if (orderMod.StoreID != mu.SiteID) { function.WriteErrMsg("你无权操作该订单"); } if (orderMod.OrderStatus != (int)M_OrderList.StatusEnum.Normal) { function.WriteErrMsg("该订单不可修改"); } DataTable cpDT = cpBll.SelByOrderID(orderMod.id); Cart_Hid.Value = JsonConvert.SerializeObject(cpDT); } } }
public bool Del(string strWhere) { return(DBCenter.DelByWhere(strTableName, strWhere)); }
public void U_Del(int uid, int id) { DBCenter.DelByWhere(TbName, "CUser="******" AND ID=" + id); }
public void U_Del(int uid, string ids) { SafeSC.CheckIDSEx(ids); DBCenter.DelByWhere(TbName, "ID IN (" + ids + ") AND UserID=" + uid); }
public void U_Del(int uid, int id) { DBCenter.DelByWhere(TbName, PK + "=" + id + " AND UserID=" + uid); }
public void ClearRecycle() { DBCenter.DelByWhere(TbName, "Aside=1"); }
/// <summary> /// 清空回收站 /// </summary> public bool DelAll(int cateid) { return(DBCenter.DelByWhere(TbName, "CateID = " + cateid + "AND Status=" + (int)ConStatus.Recycle)); }