/// <summary>
/// 转账
/// </summary>
/// <param name="context"></param>
public void transfer(HttpContext context)
{
string ID = context.Request.Params["ID"];
string number = context.Request.Params["number"];
var db = sugar.GetInstance("mydb");
var get = db.Queryable <userstable>().Where(it => it.ID == st.ID).Select(it => new {
ID = it.ID,
number = (it.number == null ? 0 : it.number) - Convert.ToDecimal(number),
it.zztype
}).ToList();
if (get.Select(it => it.number).Take(1).First() < 0)
{
context.Response.Write(new responsejson(1, "余额不足"));
return;
}
if (get.Select(it => it.zztype).Take(1).First() == 1)
{
context.Response.Write(new responsejson(1, "请联系客服QQ2855919898进行人工实名认证，通过后可进行此操作。"));
return;
}
userstable im = new userstable();
im.ID = get.Select(it => it.ID).Take(1).First();
im.number = get.Select(it => it.number).Take(1).First();
var get1 = db.Queryable <userstable>().Where(it => it.ID == ID).Select(it => new {
ID = it.ID,
number = it.number + Convert.ToDecimal(number)
}).ToList();
userstable imone = new userstable();
if (get1.Count > 0)
{
imone.ID = get1.Select(it => it.ID).Take(1).First();
imone.number = get1.Select(it => it.number).Take(1).First();
}
else
{
context.Response.Write(new responsejson(1, "对方ID不存在"));
return;
}
int t3 = db.Updateable(im).UpdateColumns(it => new { it.number }).ExecuteCommand();
int t4 = db.Updateable(imone).UpdateColumns(it => new { it.number }).ExecuteCommand();
if (t3 > 0 && t4 > 0)
{
context.Response.Write(new responsejson(0, "转账成功"));
}
else
{
context.Response.Write(new responsejson(1, "转账失败"));
}
}
/// <summary>
/// pc端获取登录信息验证
/// </summary>
/// <param name="context">context对象</param>
/// <returns>返回loginusercookie类</returns>
public static userstable getcookieinfo(HttpContext context)
{
//读取coolie
if (context.Request.Cookies["LandingOne"] != null)
{
string ID = context.Request.Cookies["LandingOne"]["ID"];
//检查用户是否是正常状态或者是否能找到此用户
var db = sugar.GetInstance("mydb");
userstable st = db.Queryable <userstable>()
.Where(it => it.ID == ID && it.type == 0)
.First();
return(st);
}
else
{
return(null);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
st = getcookieinfo(context);
if (st == null)
{
context.Response.Write(new responsejson(1, "鉴权失败"));
return;
}
string functiontype = context.Request.Params["functiontype"];
switch (functiontype)
{
case "fsyzm": fsyzm(context); break;
// case "registered": registered(context); break;//注册
// case "login": login(context); break;
case "transfer": transfer(context); break;
case "all": all(context); break;
case "td": td(context); break;
}
}
/// <summary>
/// 注册
/// </summary>
/// <param name="context"></param>
public void registered(HttpContext context)
{
string email = context.Request.Params["email"];
string tj_email = context.Request.Params["tj_email"];
string password = context.Request.Params["password"];
string towpassword = context.Request.Params["towpassword"];
var db = sugar.GetInstance("mydb");
var get = db.Queryable <userstable>().Where(it => it.email == email).ToList();
if (get.Count > 0)
{
context.Response.Write(new responsejson(1, "当前邮箱已注册"));
return;
}
var lisget = db.Queryable <userstable>().Where(it => it.email == tj_email).ToList();
if (lisget.Count == 0)
{
context.Response.Write(new responsejson(1, "推荐人邮箱不正确"));
return;
}
else
{
var tjlist = db.Queryable <userstable>().Where(it => it.tj_email == tj_email)
.Where("convert(varchar(10),addtime,120) = convert(varchar(10),getdate(),120)")
.Select(it => new
{
it.email
}).ToList();
if (tjlist.Count >= 100)
{
context.Response.Write(new responsejson(1, "推荐人邮箱今日可用次数为0"));
return;
}
foreach (var item in lisget)
{
item.number += Convert.ToDecimal(0.1);
}
var t3 = db.Updateable(lisget).UpdateColumns(it => new { it.number }).ExecuteCommand();
}
List <userstable> list = new List <userstable>();
userstable im = new userstable();
im.ID = Convert.ToString(DateTime.Now.ToString("HHmmssMMfffyydd"));
im.password = password;
im.tj_email = tj_email;
im.towpassword = towpassword;
im.email = email;
im.number = 0;
im.type = 0;
im.zztype = 1;
im.addtime = DateTime.Now;
list.Add(im);
int t2 = db.Insertable(list).ExecuteCommand();
if (t2 > 0)
{
context.Response.Write(new responsejson(0, "注册成功"));
}
else
{
context.Response.Write(new responsejson(1, "注册失败"));
}
}
