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);
}
