public static UrsuserInfo GetItem(int?UrsNumber)
{
if (UrsNumber == null)
{
return(null);
}
if (itemCacheTimeout <= 0)
{
return(dal.GetItem(UrsNumber));
}
string key = string.Concat("DC2016_BLL_Ursuser_", UrsNumber);
string value = RedisHelper.Get(key);
if (!string.IsNullOrEmpty(value))
{
try { return(new UrsuserInfo(value)); } catch { }
}
UrsuserInfo item = dal.GetItem(UrsNumber);
if (item == null)
{
return(null);
}
RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
return(item);
}
private static void RemoveCache(UrsuserInfo item)
{
if (item == null)
{
return;
}
RedisHelper.Remove(string.Concat("DC2016_BLL_Ursuser_", item.UrsNumber));
}
public static DC2016.DAL.Ursuser.SqlUpdateBuild UpdateDiy(UrsuserInfo item, int?UrsNumber)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item != null ? item : GetItem(UrsNumber));
}
return(new DC2016.DAL.Ursuser.SqlUpdateBuild(item, UrsNumber));
}
public static int Update(UrsuserInfo item)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(dal.Update(item));
}
public static UrsuserInfo Insert(UrsuserInfo item)
{
item = dal.Insert(item);
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(item);
}
public int Update(UrsuserInfo item)
{
return(new SqlUpdateBuild(null, item.UrsNumber)
.SetUrsBirthDay(item.UrsBirthDay)
.SetUrsIDCard(item.UrsIDCard)
.SetUrsMobile(item.UrsMobile)
.SetUrsQQ(item.UrsQQ)
.SetUrsTime(item.UrsTime).ExecuteNonQuery());
}
protected static MySqlParameter[] GetParameters(UrsuserInfo item)
{
return(new MySqlParameter[] {
GetParameter("?UrsNumber", MySqlDbType.Int32, 11, item.UrsNumber),
GetParameter("?UrsBirthDay", MySqlDbType.Int32, 11, item.UrsBirthDay),
GetParameter("?UrsIDCard", MySqlDbType.VarChar, 32, item.UrsIDCard),
GetParameter("?UrsMobile", MySqlDbType.VarChar, 32, item.UrsMobile),
GetParameter("?UrsQQ", MySqlDbType.Int32, 11, item.UrsQQ),
GetParameter("?UrsTime", MySqlDbType.DateTime, -1, item.UrsTime)
});
}
public static bool CreateUser(int number, string acct, int qq, string mobile, string idcard, string extinfo)
{
if (number < 10000)
{
return(false);
}
bool isexisted = Ursacct.IsExistNumber(number);
UrsacctInfo acctInfo = new UrsacctInfo()
{
AcctNumber = number,
AcctEMail = acct
};
Ursacct.Insert(acctInfo);
if (!isexisted)
{
//rc &= URSUserInfo.Create(Operator, ACCT_Number, USRI_QQ, USRI_Mobile, USRI_IDCard);
UrsuserInfo userInfo = new UrsuserInfo()
{
UrsNumber = number,
UrsQQ = qq,
UrsMobile = mobile,
UrsIDCard = idcard,
UrsBirthDay = null,
UrsTime = null
};
Ursuser.Insert(userInfo);
//rc &= URSUserExtInfo.Create(Operator, ACCT_Number, UEXT_CHTInfo);
UrsuserextInfo userExtInfo = new UrsuserextInfo()
{
ExtNumber = number,
ExtCHTInfo = extinfo
};
Ursuserext.Insert(userExtInfo);
}
return(true);
}
public IActionResult func_IsExistAcct(string account, int checkactive)
{
if (account.IsNullOrEmpty() || !this.IsMobile(account) && !Utilities.IsValidEmail(account))
{
return(this.FuncResult(new APIReturn(10000, "参数错误(account)")));
}
#region 2980帐号
Hashtable htb = new Hashtable();
if (this.IsMobile(account) || account.EndsWith("@2980.com"))
{
string checkType;
string phoneUserName;
if (this.IsMobile(account))
{
checkType = "phone";
phoneUserName = account;
}
else
{
checkType = "name";
phoneUserName = account.Substring(0, account.LastIndexOf('@'));
}
Dictionary <string, object> argus = new Dictionary <string, object>();
argus.Add("act", "dy_gs_checknamephone");
argus.Add("portkey", DC2Conf.Passport2980);
argus.Add("checktype", checkType);
argus.Add("phoneUserName", phoneUserName);
ReturnMsg2980 ret = P2980Invoker.InvokeHttp("funswregister", argus);
#region 返回码处理
int code;
string msg;
if (ret.Code == 250)
{
code = 0;
msg = "帐号不存在";
}
else if (ret.Code == 625)
{
if (checkactive == 1)
{
htb.Add("isActive", true);
}
return(this.FuncResult(new APIReturn(10303, "帐号已存在", htb)));
}
else if (ret.Code == 609)
{
//参数不能为空、重要参数长度不足
code = 10000;
msg = "部分参数缺失";
}
else if (ret.Code == 611)
{
//检测超出规定次数
code = 19902;
msg = "操作太频繁";
}
else if (ret.Code == 500)
{
//服务器错误
code = -98;
msg = "未知系统错误";
}
else if (ret.Code == 614)
{
//你不具备访问权限
code = -97;
msg = "IP没有权限";
}
else if (ret.Code == 583)
{
//无任何执行动作
code = 10000;
msg = "部分参数缺失";
}
else
{
code = 19801;
msg = $"参数或其它错误({ret.Code},{ret.Message})";
}
#endregion
return(this.FuncResult(new APIReturn(code, msg)));
}
#endregion
bool isActive = false;
UrsacctInfo acctInfo = Ursacct.GetItem(account);
if (acctInfo != null)
{
UrsuserInfo userInfo = Ursuser.GetItem(acctInfo.AcctNumber);
if (userInfo.UrsTime.HasValue && userInfo.UrsTime.HasValue && userInfo.UrsTime.Value.Year > 2000 && (DateTime.Now - userInfo.UrsTime.Value).TotalDays > 3)//兼容之前没写日期的
{
isActive = true;
}
if (checkactive == 1)
{
D2unactiveInfo activeInfo = D2unactive.GetItemByNumber(acctInfo.AcctNumber.Value);
isActive = activeInfo != null && activeInfo.UavState == (int)EUAS.已激活2;
htb.Add("isActive", isActive);
}
return(this.FuncResult(new APIReturn(10303, "帐号已存在", htb)));
}
//请求DC验证
//DCRequest dcr = new DCRequest(DCProdTypes.URS, DCMethodTypes.R);
List <object> listobj = new List <object>();
listobj.AddRange(new object[] { "email", account });
//ReturnMsgDC rc = dcr.ExecRequest("acct_getinfoforupgrade.php", listobj.ToArray());
DCResult dcr = DCInvoker.HttpInvoke(DCProdTypes.URS, DCMethodTypes.R, "acct_getinfoforupgrade", listobj.ToArray());
DicDCValue rc = dcr.GetDicDCValue();
if (rc.Code == 23)
{
//帐号不存在
return(this.FuncResult(new APIReturn(0, "帐号不存在")));
}
else if (rc.Code == 99)
{
//帐号未激活
isActive = false;
}
else
{
//帐号已存在
isActive = true;
int number = rc["number"].ToInt();
}
if (checkactive == 1)
{
htb.Add("isActive", isActive);
}
return(this.FuncResult(new APIReturn(10303, "帐号已存在", htb)));
}
public SqlUpdateBuild(UrsuserInfo item, int?UrsNumber)
{
_item = item;
_where = SqlHelper.Addslashes("`UrsNumber` = {0}", UrsNumber);
}
public UrsuserInfo Insert(UrsuserInfo item)
{
SqlHelper.ExecuteNonQuery(TSQL.Insert, GetParameters(item));
return(item);
}