public IActionResult func_smscallback(string message, string telnumber, int port)
{
ValidinfoInfo mode = Validinfo.hasRecord(telnumber, message);
if (mode != null)
{
if (!mode.Is待验证)
{
return(this.FuncResult(new APIReturn(10000, "验证码已验证或者过期")));
}
mode.State = (int)ESTATE.已验证;
mode.Updatetime = DateTime.Now;
int i = Validinfo.Update(mode);
if (i > 0)
{
return(this.FuncResult(new APIReturn(0, "Ok")));
}
else
{
return(this.FuncResult(new APIReturn(10000, "WRONG")));
}
}
else
{
return(this.FuncResult(new APIReturn(10000, "WRONG")));
}
}
public static ValidinfoInfo GetItem(int?Pkid)
{
if (Pkid == null)
{
return(null);
}
if (itemCacheTimeout <= 0)
{
return(dal.GetItem(Pkid));
}
string key = string.Concat("DC2016_BLL_Validinfo_", Pkid);
string value = RedisHelper.Get(key);
if (!string.IsNullOrEmpty(value))
{
try { return(new ValidinfoInfo(value)); } catch { }
}
ValidinfoInfo item = dal.GetItem(Pkid);
if (item == null)
{
return(null);
}
RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
return(item);
}
private static void RemoveCache(ValidinfoInfo item)
{
if (item == null)
{
return;
}
RedisHelper.Remove(string.Concat("DC2016_BLL_Validinfo_", item.Pkid));
}
public static DC2016.DAL.Validinfo.SqlUpdateBuild UpdateDiy(ValidinfoInfo item, int?Pkid)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item != null ? item : GetItem(Pkid));
}
return(new DC2016.DAL.Validinfo.SqlUpdateBuild(item, Pkid));
}
public static int Update(ValidinfoInfo item)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(dal.Update(item));
}
public static ValidinfoInfo Insert(ValidinfoInfo item)
{
item = dal.Insert(item);
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(item);
}
public ValidinfoInfo Insert(ValidinfoInfo item)
{
int loc1;
if (int.TryParse(string.Concat(SqlHelper.ExecuteScalar(TSQL.Insert, GetParameters(item))), out loc1))
{
item.Pkid = loc1;
}
return(item);
}
public int Update(ValidinfoInfo item)
{
return(new SqlUpdateBuild(null, item.Pkid)
.SetAddtime(item.Addtime)
.SetCode(item.Code)
.SetGate(item.Gate)
.SetMobile(item.Mobile)
.SetNumber(item.Number)
.SetParam(item.Param)
.SetServer(item.Server)
.SetState(item.State)
.SetType(item.Type)
.SetUpdatetime(item.Updatetime)
.SetUserid(item.Userid).ExecuteNonQuery());
}
protected static MySqlParameter[] GetParameters(ValidinfoInfo item)
{
return(new MySqlParameter[] {
GetParameter("?pkid", MySqlDbType.Int32, 11, item.Pkid),
GetParameter("?addtime", MySqlDbType.DateTime, -1, item.Addtime),
GetParameter("?code", MySqlDbType.VarChar, 10, item.Code),
GetParameter("?gate", MySqlDbType.VarChar, 8, item.Gate),
GetParameter("?mobile", MySqlDbType.VarChar, 18, item.Mobile),
GetParameter("?number", MySqlDbType.Int32, 11, item.Number),
GetParameter("?param", MySqlDbType.VarChar, 200, item.Param),
GetParameter("?server", MySqlDbType.Int32, 11, item.Server),
GetParameter("?state", MySqlDbType.Int32, 11, item.State),
GetParameter("?type", MySqlDbType.Int32, 11, item.Type),
GetParameter("?updatetime", MySqlDbType.DateTime, -1, item.Updatetime),
GetParameter("?userid", MySqlDbType.Int32, 11, item.Userid)
});
}
public SqlUpdateBuild(ValidinfoInfo item, int?Pkid)
{
_item = item;
_where = SqlHelper.Addslashes("`pkid` = {0}", Pkid);
}
