//------------- public void Sync(M_Order_Invoice invMod) { if (invMod.UserID < 1 || string.IsNullOrEmpty(invMod.InvHead)) { return; } //数量超过5则不处理 int count = DBCenter.Count(TbName, "UserID=" + invMod.UserID); if (count >= MaxCount) { return; } //head已存在则不处理(不更新) invMod.InvHead = invMod.InvHead.Replace(" ", ""); bool exist = DBCenter.IsExist(TbName, "InvHead=@head AND UserID=" + invMod.UserID, new List <SqlParameter>() { new SqlParameter("head", invMod.InvHead) }); if (exist) { return; } //同步写入 Insert(invMod); }
//----------------权限检测 /// <summary> /// 检测是否有访问用户中心的权限 /// 店长,收银员 /// </summary> public static CommonReturn CheckUserLogin() { M_UserInfo mu = new B_User().GetLogin(); if (mu.IsNull) { return(CommonReturn.Failed("用户未登录")); } //检测用户是否拥有店铺,或为店铺收银员 if (mu.SiteID < 1) { return(CommonReturn.Failed("用户未绑定店铺")); } if (DBCenter.IsExist("ZL_CommonModel", "SuccessfulUserID=" + mu.UserID)) { return(CommonReturn.Success()); } //是否绑定了店铺,是否为收银员 if (mu.GroupID != ExConast.EmployGroup) { return(CommonReturn.Failed("没有访问页面的权限")); } return(CommonReturn.Success()); }
//--------------- public bool Add(M_User_Follow model, ref string err) { bool flag = false; if (model.UserID < 1) { err = "用户未登录"; } else if (model.TUserID < 1) { err = "被关注人不能为空"; } else if (model.UserID == model.TUserID) { err = "关注人与被关注人不能是同用户"; } else if (!new B_User().IsExist("uid", model.TUserID.ToString())) { err = "被关注用户不存在"; } else if (DBCenter.IsExist(TbName, "UserID=" + model.UserID + " AND TUserID=" + model.TUserID)) { err = "关注信息已存在"; } else { Insert(model); flag = true; } return(flag); }
//-------------------------- public bool Exist(int luckid, int uid) { if (luckid < 1 || uid < 1) { return(true); } return(DBCenter.IsExist(TbName, "UserID=" + uid + " AND LuckID=" + luckid)); }
public int Insert(M_User_BindPro model) { if (DBCenter.IsExist(TbName, "UserID=" + model.UserID)) { return(0); } return(DBCenter.Insert(model)); }
public bool IsExist(string key) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("key", key) }; return(DBCenter.IsExist(strTableName, " KeyName=@key", sp)); }
public bool IsExist(string KeyName) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("key", KeyName) }; return(DBCenter.IsExist(TbName, "KeyWordText=@key", sp)); }
/// <summary> /// 组织名是否存在 /// </summary> public bool IsExist(string strName) { strName = strName.Trim(); List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("Name", strName) }; return(DBCenter.IsExist(TbName, "Name=@name", sp)); }
public int Insert(M_User_BindPro model) { //不允许重复,自动读取值 if (DBCenter.IsExist(TbName, "UserID=" + model.UserID)) { M_User_BindPro existMod = SelModelByUid(model.UserID); model.ID = existMod.ID; UpdateByID(model); return(model.ID); } return(DBCenter.Insert(model)); }
/// <summary> /// 内容商城模型不允许重名 /// </summary> public bool IsExistModelName(string modelName) { if (string.IsNullOrEmpty(modelName)) { return(false); } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("name", modelName) }; return(DBCenter.IsExist(TbName, "ModelName=@name AND ModelType NOT IN (3,8,7,6,12)", sp)); }
public bool IsExist(string name, int id = 0) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("name", name.Trim()) }; string where = "PageName =@name"; if (id != 0) { where += " AND ID!=" + id; } return(DBCenter.IsExist(TbName, where, sp)); }
public int Insert(M_WX_User model) { if (string.IsNullOrEmpty(model.OpenID)) { throw new Exception("微信用户的OpenID不能为空"); } if (DBCenter.IsExist(TbName, "OpenID=@openid", new List <SqlParameter>() { new SqlParameter("openid", model.OpenID) })) { return(0); } return(DBCenter.Insert(model)); }
public int Insert(M_WX_User model) { if (string.IsNullOrEmpty(model.OpenID)) { throw new Exception("微信用户的OpenID不能为空"); } if (DBCenter.IsExist(TbName, "OpenID=@openid", new List <SqlParameter>() { new SqlParameter("openid", model.OpenID) })) { throw new Exception("该OpenID已存在,不可重复加入"); } return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
/// <summary> /// 修改模型数据 /// </summary> public void UpdateContent(DataTable ContentDT, string tbname, int itemid) { //需要重处理 if (ContentDT != null && ContentDT.Rows.Count > 0) { List <SqlParameter> splist = new List <SqlParameter>(); splist.AddRange(BLLCommon.GetParameters(ContentDT)); if (DBCenter.IsExist(tbname, "ID=" + itemid)) { DBCenter.UpdateSQL(tbname, BLLCommon.GetFieldAndPara(ContentDT), "ID=" + itemid, splist); } else { DBCenter.Insert(tbname, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), splist.ToArray()); } } }
public static M_Ex_ERole GetERole(M_UserInfo mu) { M_Ex_ERole roleMod = new M_Ex_ERole(); //检测是否为店长 if (DBCenter.IsExist("ZL_CommonModel", "SuccessfulUserID=" + mu.UserID)) { roleMod.RoleName = "店长"; return(roleMod); } if (mu.PageID < 1) { roleMod.RoleName = "未分配"; return(roleMod); } roleMod = new B_Ex_ERole().SelReturnModel(mu.PageID); if (roleMod == null) { roleMod = new M_Ex_ERole(); roleMod.RoleName = "不存在"; return(roleMod); } return(roleMod); }
protected void Page_Init(object sender, EventArgs e) { WxAPI.AutoSync(Request.Url.AbsoluteUri); int sid = DataConvert.CLng(Request.QueryString["ID"]); if (sid > 1) { Response.Cookies["sid"].Value = sid.ToString(); } else if (Request.Cookies["sid"] != null)//看Cookie中是否有信息 { sid = DataConvert.CLng(Request.Cookies["sid"].Value); } if (sid < 1) { function.WriteErrMsg("未指定店铺ID"); return; } if (!DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + sid + " AND ModelID=24")) { function.WriteErrMsg("指定店铺的信息不存在"); } }
/// <summary> /// 校验当前登录用户的角色权限 /// </summary> /// <param name="name"></param> public static CommonReturn CheckUserAuth(string auth) { M_UserInfo mu = new B_User().GetLogin(); if (mu.SiteID < 1) { function.WriteErrMsg("禁止访问,用户未绑定店铺"); } //如果是店铺的所有者,则不需要检测 bool flag = DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + mu.SiteID + " AND SuccessfulUserID=" + mu.UserID); if (flag) { return(CommonReturn.Success()); } //只有店长可访问该页面 if (auth.Equals("manage")) { function.WriteErrMsg("你没有足够的访问权限"); } //-----------------------检测角色权限 if (mu.PageID < 1) { function.WriteErrMsg("操作员未绑定角色"); } if (string.IsNullOrEmpty(auth)) { function.WriteErrMsg("未指定需要校验的权限"); } string auths = DataConvert.CStr(DBCenter.ExecuteScala("ZL_Ex_ERole", "RoleAuth", "ID=" + mu.PageID)); if (!auths.Contains(auth)) { function.WriteErrMsg("你无权访问该页面"); } return(CommonReturn.Success()); }
public bool Update(DataTable ContentDT, M_Product model) { int ItemID = model.ItemID; if (ContentDT != null && ContentDT.Rows.Count > 0) { if (string.IsNullOrEmpty(model.TableName)) { throw new Exception("商品附表为空"); } List <SqlParameter> splist = new List <SqlParameter>(); splist.AddRange(BLLCommon.GetParameters(ContentDT)); if (DBCenter.IsExist(model.TableName, "ID=" + ItemID)) { DBCenter.UpdateSQL(model.TableName, BLLCommon.GetFieldAndPara(ContentDT), "ID=" + ItemID, splist); } else { DBCenter.Insert(model.TableName, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), splist.ToArray()); } } UpdateByID(model); return(true); }
/// <summary> /// 是否已存在未确认的好友申请,True已存在 /// </summary> public bool IsExist(int suid, int tuid) { string where = "UserID=" + suid + " AND TUserID=" + tuid + " AND ZStatus=" + (int)ConStatus.UnAudit; return(DBCenter.IsExist(TbName, where)); }
//-------------------- public bool IsExist(double money) { //同种金额的不能重复添加 return(DBCenter.IsExist(TbName, "Min='" + money + "'")); }
//-------------------Tools public bool IsSeat(int uid) { return(DBCenter.IsExist(strTableName, "S_AdminID=" + uid)); }
public string Register_API() { M_APIResult retMod = new M_APIResult(M_APIResult.Success); string action = GetParam("action"); string value = GetParam("value").Replace(" ", ""); string result = ""; switch (action) { case "uname": if (!CheckUserName(value, ref result)) { retMod.retcode = M_APIResult.Failed; retMod.retmsg = result; } break; case "mobile": //手机号不可重复 { string mobile = GetParam("mobile"); if (string.IsNullOrEmpty(mobile)) { retMod.retmsg = "手机号码不能为空"; } else if (!RegexHelper.IsMobilPhone(mobile)) { retMod.retmsg = "手机号码格式不正确"; } else { bool flag = DBCenter.IsExist("ZL_UserBase", "Mobile=@mobile", new List <SqlParameter>() { new SqlParameter("mobile", mobile) }); if (flag) { retMod.retmsg = "手机号码已存在"; } else { retMod.retcode = M_APIResult.Success; } } } break; case "puser": //推荐人为空则不检测 if (!string.IsNullOrEmpty(value) && CheckParentUser(value).IsNull) { retMod.retcode = M_APIResult.Failed; retMod.retmsg = "推荐人不存在"; } break; case "email": if (!CheckEmail(value, ref result)) { retMod.retcode = M_APIResult.Failed; retMod.retmsg = result; } break; case "birth": if (!CheckBirthDay(value, ref result)) { retMod.retcode = M_APIResult.Failed; retMod.retmsg = result; } break; case "GetModelFied": return(GetUserGorupModel(value)); default: retMod.retmsg = "[" + action + "]接口不存在"; break; } return(retMod.ToString()); }
public bool IsExistTemplate(int NodeID, int ModelID) { return(DBCenter.IsExist("ZL_Node_ModelTemplate", "NodeID=" + NodeID + " AND ModelID=" + ModelID)); }
/// <summary> /// 查看用户是否已对流程审批,是则返回true /// </summary> public bool CheckApproval(int userid, int stepnum, int appid) { string where = "Appid=" + appid + " AND ApproveID=" + userid + " AND ProLevel=" + stepnum; return(DBCenter.IsExist(TbName, where)); }
/// <summary> /// 双方是否为有效的好友,True:是, /// </summary> public bool IsFriend(int uid, int tuid) { string where = GetWhere(uid, tuid) + " AND ZStatus=" + (int)ConStatus.Audited; return(DBCenter.IsExist(TbName, where)); }
public bool SelByIP(string IP) { return(DBCenter.IsExist(TbName, "IP=" + IP)); }
public bool Has(int suid, int tuid) { string where = "UserID=" + suid + " AND TUserID=" + tuid; return(DBCenter.IsExist(TbName, where)); }
public bool IsExistModel(int GroupID, int ModelID) { return(DBCenter.IsExist("ZL_GroupModel", " GroupID=" + GroupID + " and UserModel=" + ModelID)); }
/// <summary> /// 是否已有会员组,没有会员组时新增的第一个会员组自动成默认会员组 /// </summary> public bool HasGroup() { return(DBCenter.IsExist(strTableName, "")); }
protected void Page_Load(object sender, EventArgs e) { if (Pid <= 0) { function.WriteErrMsg("参数错误!不存在此信息!"); } M_Pub mpub = pubBll.GetSelect(Pid); mu = buser.GetLogin(); if (mpub == null || mpub.Pubid < 1) { function.WriteErrMsg("互动信息不存在"); } M_APIResult retMod = new M_APIResult(); int spid = DataConvert.CLng(Request.Form["spfbrid"]); if (mu.UserID < 1) { retMod.retmsg = "未登录不可提交订单"; RepToClient(retMod.ToString()); return; } if (spid < 1) { retMod.retmsg = "未指定教师信息"; RepToClient(retMod.ToString()); return; } { //如果存在与该老师的进行中订单,则忽略 string where = "xsrid=" + mu.UserID + " AND spfbrid=" + spid; where += " AND status_order>=0 AND status_order<100"; if (DBCenter.IsExist("ZL_Pub_dsmx", where)) { retMod.retmsg = "已存在生效中的订单"; RepToClient(retMod.ToString()); return; } } M_UserInfo spmu = buser.SelReturnModel(spid); if (spmu.IsNull) { retMod.retmsg = "老师信息不存在"; RepToClient(retMod.ToString()); return; } //-----------------------获取用户提交的数据 //隐藏字段值 int PubContentid = DataConverter.CLng(Request.Form["PubContentid"]); int Parentid = DataConvert.CLng(Request.Form["Parentid"]); //用户提交 string pbtitle = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubTitle"])); string pbcontent = Server.HtmlEncode(DataConvert.CStr(Request.Form["PubContent"])); if (!pbtitle.Contains("的"))//xxx的课程 { pbtitle = B_User.GetUserName(spmu.HoneyName, spmu.UserName) + "的课程"; } //-----------------------可提交判断 List <SqlParameter> sp = new List <SqlParameter>(); //-----------------------初始化参数 //删除超过保留期限的值 //pubBll.DeleteModel(mpub.PubTableName, "DateDiff(d,PubAddTime,getdate())>" + mpub.Pubkeep); //ModelField表中仅存了自定义的字段 B_CodeModel codeBll = new B_CodeModel(mpub.PubTableName); DataRow dr = codeBll.NewModel(); DataTable mfDT = mfBll.DB_SelByModel(mpub.PubModelID); mfDT.DefaultView.RowFilter = "sys_type=0"; mfDT = mfDT.DefaultView.ToTable(); //-----固定的系统字段 dr["Pubnum"] = 1; dr["PubIP"] = EnviorHelper.GetUserIP(); dr["PubUserID"] = mu.UserID; dr["PubUserName"] = mu.UserName; dr["Pubupid"] = mpub.Pubid; dr["PubAddTime"] = DateTime.Now; dr["Parentid"] = Parentid; dr["PubTitle"] = pbtitle; dr["PubContent"] = pbcontent; dr["Pubstart"] = mpub.PubIsTrue == 1 ? 0 : 1;//取反 dr["PubInputer"] = B_User.GetUserName(mu.HoneyName, mu.UserName); dr["PubContentid"] = PubContentid; //dr["cookflag"] = CookFlag; //=========订单初始化 dr["status_order"] = 0; dr["status_user"] = 0; dr["status_teacher"] = 0; dr["status_money"] = 0; dr["edate"] = ""; dr["fcAmount"] = 0; dr["fcDate"] = ""; //int djid = DataConvert.CLng(mu.ParentUserID); //if (djid < 1) { djid = DataConvert.CLng(Request["djid"]); } dr["djid"] = DataConvert.CLng(Request["djid"]); //------非系统字段 for (int i = 0; i < mfDT.Rows.Count; i++) { M_ModelField mfMod = new M_ModelField().GetModelFromReader(mfDT.Rows[i]); string value = Server.HtmlEncode(Request.Form[mfMod.FieldName] ?? ""); Parentid = DataConvert.CLng(Request.Form["Parentid"]); if (mfMod.IsNotNull && string.IsNullOrEmpty(value)) { RepToClient(mfMod.FieldName + "不能为空"); } dr[mfMod.FieldName] = value; switch (mpub.PubType) { #region 根据互动类型,进行空值判断 case 0: if (string.IsNullOrEmpty(pbcontent)) { RepToClient("评论内容不能为空!"); } break; case 1: if (string.IsNullOrEmpty(pbtitle)) { RepToClient("标题不能为空!"); } break; case 2: if (string.IsNullOrEmpty(pbtitle)) { RepToClient("标题不能为空!"); } if (string.IsNullOrEmpty(pbcontent)) { RepToClient("活动信息不能为空!"); } break; case 3: if (string.IsNullOrEmpty(pbtitle) || string.IsNullOrEmpty(pbcontent)) { RepToClient("标题与内容不能为空!"); } break; case 4: if (string.IsNullOrEmpty(pbtitle)) { RepToClient("标题不能为空!"); } break; case 5: break; case 7: //将评星控件的数据写入数据表中 dr["PubContent"] = Request.Params["scoreVal"]; break; case 8: //互动表单 break; #endregion } } codeBll.Insert(dr); retMod.retcode = M_APIResult.Success; RepToClient(retMod.ToString()); //Upaddnums(mpub); //更新总参与人数 }