public static string GetUserPartInfo(string seeID, string seename, string cname, string userid, string username, string leveid, string operateip) { object obj = CommonBusiness.Select("M_Users", cname, " Userid='" + seeID + "'"); if (obj != null) { LogBusiness.AddOperateLog(userid, username, leveid, seeID, seename, EnumUserOperateType.SeeLink, "联系方式", operateip); return(obj.ToString()); } return(""); }
public static string GetIssueNumFee(string cpcode, string userid, string issuenum = "", string type = "") { string where = " CPCode='" + cpcode + "' and Status in(0,1,2,4) and UserID='" + userid + "'"; //if (!string.IsNullOrEmpty(issuenum)) //{ where += " and issuenum='" + issuenum + "' "; //} if (!string.IsNullOrEmpty(type)) { where += " and type='" + type + "' "; } return(CommonBusiness.Select("lotteryorder (nolock) ", "Sum(PayFee)", where).ToString()); }
/// <summary> /// 验证APPKey /// </summary> /// <param name="account"></param> /// <param name="imei"></param> /// <returns></returns> public static string ValidateAPPKey(string account, string imei) { int ishas = Convert.ToInt32(CommonBusiness.Select("M_Users", "count(1)", " sourcetype=0 and Appkey='" + account + "'")); if (ishas < 1) { return("账号APPkey不存在"); } string sysImei = CommonBusiness.Select("M_Users", "isnull(appsecret,'')", " sourcetype=0 and Appkey='" + account + "'").ToString(); if (sysImei != "" || sysImei.ToLower() != imei.TrimEnd().ToLower()) { return("您的账号密钥不正确"); } return(""); }
public static int GetFeedBacksCount(string beginDate, string endDate, int status) { string sqlWhere = "1=1"; if (status != -1) { sqlWhere += " and status=" + status; } if (!string.IsNullOrEmpty(beginDate)) { sqlWhere += " and createtime>='" + beginDate + "'"; } if (!string.IsNullOrEmpty(endDate)) { sqlWhere += " and createtime<='" + DateTime.Parse(endDate).AddDays(1).ToString("yyyy-MM-dd") + "'"; } int result = Convert.ToInt32(CommonBusiness.Select("FeedBack", "count(1)", sqlWhere)); return(result); }
public static bool CheckEmail(string email) { var result = CommonBusiness.Select("M_Users", "count(1)", " email='" + email + "' "); return(Convert.ToInt32(result) > 0); }