/// <summary> /// 账号是否存在 /// </summary> /// <param name="loginName">账号</param> /// <returns></returns> public static bool IsExistLoginName(string loginName) { if (string.IsNullOrEmpty(loginName)) { return(false); } object count = CommonBusiness.Select("Users", "count(0)", " Status=1 and (LoginName='" + loginName + "' or BindMobilePhone='" + loginName + "')"); return(Convert.ToInt32(count) > 0); }
/// <summary> /// 编辑部门状态 /// </summary> /// <param name="departid">部门ID</param> /// <param name="status">状态</param> /// <param name="operateid">操作人</param> /// <param name="operateip">操作IP</param> /// <returns></returns> public EnumResultStatus UpdateDepartmentStatus(string departid, EnumStatus status, string operateid, string operateip) { if (status == EnumStatus.Delete) { object count = CommonBusiness.Select(" UserDepart ", " count(0) ", " DepartID='" + departid + "' and Status=1 "); if (Convert.ToInt32(count) > 0) { return(EnumResultStatus.Exists); } } if (CommonBusiness.Update(" Department ", " Status ", (int)status, " DepartID='" + departid + "'")) { return(EnumResultStatus.Success); } else { return(EnumResultStatus.Failed); } }
/// <summary> /// 编辑部门状态 /// </summary> /// <param name="departid">部门ID</param> /// <param name="status">状态</param> /// <param name="operateid">操作人</param> /// <param name="operateip">操作IP</param> /// <returns></returns> public EnumResultStatus UpdateDepartmentStatus(string departid, EnumStatus status, string operateid, string operateip, string agentid) { if (status == EnumStatus.Delete) { object count = CommonBusiness.Select("UserDepart", "count(0)", "DepartID='" + departid + "' and Status=1"); if (Convert.ToInt32(count) > 0) { return(EnumResultStatus.Exists); } } if (CommonBusiness.Update("Department", "Status", (int)status, "DepartID='" + departid + "' and AgentID='" + agentid + "'")) { var model = GetDepartments(agentid).Where(d => d.DepartID == departid).FirstOrDefault(); model.Status = (int)status; return(EnumResultStatus.Success); } else { return(EnumResultStatus.Failed); } }
public bool IsExistProductCode(string code, string clientid) { object obj = CommonBusiness.Select("Products", " Count(0) ", "ClientID='" + clientid + "' and ProductCode='" + code + "'"); return(Convert.ToInt32(obj) > 0); }
public static int GetShoppingCartCount(EnumDocType ordertype, string guid) { object obj = CommonBusiness.Select("ShoppingCart", "count(0)", "ordertype=" + (int)ordertype + " and [GUID]='" + guid + "'"); return(Convert.ToInt32(obj)); }
/// <summary> /// 是否明道网络已注册 /// </summary> /// <param name="projectid"></param> /// <returns></returns> public static bool IsExistsMDProject(string projectid) { var count = CommonBusiness.Select("Agents", "count(0)", "MDProjectID='" + projectid + "'"); return(Convert.ToInt32(count) > 0); }
/// <summary> /// 客户端账号是否存在 /// </summary> /// <param name="loginName">账号</param> /// <returns></returns> public static bool IsExistLoginName(string loginName) { object count = CommonBusiness.Select("Users", "count(0)", "LoginName='" + loginName + "'"); return(Convert.ToInt32(count) > 0); }