public List <userinfo> getUserInfoByToken(int flag, string strToken, int commentid)
{
List <userinfo> retUserinfos = new List <userinfo>();
if (strToken != null && strToken.Trim() != "")
{
switch (flag)
{
case 1:
using (dataserverEntities db = new dataserverEntities())
{
var strUserid = db.uts.FirstOrDefault(p => p.token == strToken).userid;
retUserinfos = db.userinfo.Where(p => p.userid == strUserid).ToList();
}
break;
case 2:
using (organizeEntities db = new organizeEntities())
{
var strUserid = db.uts.FirstOrDefault(p => p.token == strToken).userid;
retUserinfos = db.userinfo.Where(p => p.userid == strUserid).ToList();
}
break;
case 3:
using (masterEntities db = new masterEntities())
{
if (commentid > 0)
{
var strUserid = db.uts.FirstOrDefault(p => p.token == strToken).userid;
List <String> userArry = new List <string>();
userArry.Add(strUserid);
var ltmrcrinfo = db.mrcrinfo.Where(p => p.mrcrid == commentid).ToList();
var userid = "";
if (ltmrcrinfo != null && ltmrcrinfo.Count > 0)
{
userid = ltmrcrinfo[0].suserid.ToString();
userArry.Add(userid);
}
foreach (var aa in userArry)
{
var tt = db.userinfo.Where(p => p.userid == aa).FirstOrDefault();
if (tt != null)
{
retUserinfos.Add(tt);
}
}
}
else
{
var strUserid = db.uts.FirstOrDefault(p => p.token == strToken).userid;
retUserinfos = db.userinfo.Where(p => p.userid == strUserid).ToList();
}
}
break;
}
}
return(retUserinfos);
}
public string getAmoutByDataId(int dataId)
{
string amout = null;
using (dataserverEntities db = new dataserverEntities())
{
var di = db.datainfo.Find(dataId);
amout = (int.Parse(di.amount) * 100).ToString();
}
return(amout);
}
public string getOpenIDByToken(string strToken)
{
string strUserid = strToken;
string openID = "";
if (strToken != null && strToken.Trim() != "")
{
using (dataserverEntities db = new dataserverEntities())
{
strUserid = db.uts.Where(p => p.token == strToken).Select(t => t.userid.ToString()).FirstOrDefault();
openID = db.userinfo.Where(p => p.userid == strUserid).Select(t => t.openid.ToString()).FirstOrDefault();
}
}
return(openID);
}
public string getUserIDByToken(string strToken)
{
string strUserid = null;
if (strToken != null && strToken.Trim() != "")
{
using (dataserverEntities db = new dataserverEntities())
{
//strUserid = db.uts.FirstOrDefault(p => p.token == strToken).userid;
var ups = from uts in db.uts
where uts.token == strToken
select uts;
List <uts> ua = ups.ToList <uts>();
strUserid = db.uts.Where(p => p.token == strToken).Select(t => t.userid.ToString()).FirstOrDefault();
}
}
return(strUserid);
}
public void tokenMake(string openID, string session_key, int flag)
{
string strUserid = "";
switch (flag)
{
case 1:
using (dataserverEntities db = new dataserverEntities())
{
userinfo lui = db.userinfo.FirstOrDefault(x => x.openid == openID);
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
int iHave = -1;
if (lui != null && lui.userid.Length > 0)
{
strUserid = lui.userid.ToString().Trim();
iHave = 0;
}
else
{
Guid uGid = Guid.NewGuid();
strUserid = uGid.ToString();
userinfo ui = new userinfo();
ui.openid = openID;
ui.userid = strUserid;
db.userinfo.Add(ui);
db.SaveChanges();
}
DateTime ExpireTime = DateTime.Now;
var hash = System.Security.Cryptography.MD5.Create();
var signStr = openID + strUserid + ExpireTime;
var sortStr = string.Concat(signStr.OrderBy(d => d));
var bytes = System.Text.Encoding.UTF8.GetBytes(sortStr);
//使用MD5加密
var md5Val = hash.ComputeHash(bytes);
//把二进制转化为大写的十六进制
System.Text.StringBuilder result = new System.Text.StringBuilder();
foreach (var c in md5Val)
{
result.Append(c.ToString("X2"));
}
token = result.ToString().ToUpper();
uts luts = new uts();
luts.token = token;
luts.userid = strUserid;
luts.session_key = session_key;
if (iHave == 0)
{
db.Entry(luts).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
db.uts.Add(luts);
}
db.SaveChanges();
scope.Complete();
}
}
break;
case 2:
using (organizeEntities db = new organizeEntities())
{
userinfo lui = db.userinfo.FirstOrDefault(x => x.openid == openID);
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
int iHave = -1;
if (lui != null && lui.userid.Length > 0)
{
strUserid = lui.userid.ToString().Trim();
iHave = 0;
}
else
{
Guid uGid = Guid.NewGuid();
strUserid = uGid.ToString();
userinfo ui = new userinfo();
ui.openid = openID;
ui.userid = strUserid;
db.userinfo.Add(ui);
db.SaveChanges();
}
DateTime ExpireTime = DateTime.Now;
var hash = System.Security.Cryptography.MD5.Create();
var signStr = openID + strUserid + ExpireTime;
var sortStr = string.Concat(signStr.OrderBy(d => d));
var bytes = System.Text.Encoding.UTF8.GetBytes(sortStr);
//使用MD5加密
var md5Val = hash.ComputeHash(bytes);
//把二进制转化为大写的十六进制
System.Text.StringBuilder result = new System.Text.StringBuilder();
foreach (var c in md5Val)
{
result.Append(c.ToString("X2"));
}
token = result.ToString().ToUpper();
uts luts = new uts();
luts.token = token;
luts.userid = strUserid;
luts.session_key = session_key;
if (iHave == 0)
{
db.Entry(luts).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
db.uts.Add(luts);
}
db.SaveChanges();
scope.Complete();
}
}
break;
case 3:
using (masterEntities db = new masterEntities())
{
userinfo lui = db.userinfo.FirstOrDefault(x => x.openid == openID);
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
int iHave = -1;
if (lui != null && lui.userid.Length > 0)
{
strUserid = lui.userid.ToString().Trim();
iHave = 0;
}
else
{
Guid uGid = Guid.NewGuid();
strUserid = uGid.ToString();
userinfo ui = new userinfo();
ui.openid = openID;
ui.userid = strUserid;
db.userinfo.Add(ui);
db.SaveChanges();
}
DateTime ExpireTime = DateTime.Now;
var hash = System.Security.Cryptography.MD5.Create();
var signStr = openID + strUserid + ExpireTime;
var sortStr = string.Concat(signStr.OrderBy(d => d));
var bytes = System.Text.Encoding.UTF8.GetBytes(sortStr);
//使用MD5加密
var md5Val = hash.ComputeHash(bytes);
//把二进制转化为大写的十六进制
System.Text.StringBuilder result = new System.Text.StringBuilder();
foreach (var c in md5Val)
{
result.Append(c.ToString("X2"));
}
token = result.ToString().ToUpper();
uts luts = new uts();
luts.token = token;
luts.userid = strUserid;
luts.session_key = session_key;
if (iHave == 0)
{
db.Entry(luts).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
db.uts.Add(luts);
}
db.SaveChanges();
scope.Complete();
}
}
break;
}
}
