public static void AddIntoUsers(string thiswechat_id)
{
using (HualitongDBDataContext db = new HualitongDBDataContext())
{
var hasexistuser = db.users.SingleOrDefault(u => u.wechat_id == thiswechat_id);
if (hasexistuser == null)
{
users auser = new users
{
wechat_id = thiswechat_id,
pwds_id = 0
};
db.users.InsertOnSubmit(auser);
db.SubmitChanges();
db.Dispose();
}
}
}
public static List <StudentInfo> SelectAll()
{
List <StudentInfo> result = new List <StudentInfo>();
using (HualitongDBDataContext db = new HualitongDBDataContext())
{
var all = from a in db.view_wechatpwds
where a.student_num != null && a.jw_pwd != null
select a;
foreach (var item in all)
{
StudentInfo now = new StudentInfo();
now.wechatid = item.wechat_id;
now.pwd = HttpUtility.UrlEncode(item.jw_pwd);
now.studentnum = item.student_num;
result.Add(now);
}
db.Dispose();
}
return(result);
}
public static StudentInfo SelectUser(string wechat_id)
{
StudentInfo result = new StudentInfo();
using (HualitongDBDataContext db = new HualitongDBDataContext())
{
var hasexistdate = db.view_wechatpwds.SingleOrDefault(u => u.wechat_id == wechat_id);
if (hasexistdate == null)
{
AddIntoUsers(wechat_id);
result.hasexistdate = false;
}
else
{
result.pwd = HttpUtility.UrlEncode(hasexistdate.jw_pwd);
result.studentnum = hasexistdate.student_num;
}
result.Check();
db.Dispose();
}
return(result);
}
public static void AddIntoView_Wechatpwds(string pwd, string wechat_id, string whitchpwd)
{
if (pwd == null || pwd.Length == 0)
{
return;
}
using (HualitongDBDataContext db = new HualitongDBDataContext())
{
var hasexistdate = db.users.Single(u => u.wechat_id == wechat_id);
if (hasexistdate == null)
{
AddIntoUsers(wechat_id);
hasexistdate = db.users.Single(u => u.wechat_id == wechat_id);
}
var pwdid = hasexistdate.pwds_id;
if (pwdid == 0)
{
pwds newpwd = new pwds
{
};
db.pwds.InsertOnSubmit(newpwd);
db.SubmitChanges();
pwdid = (from apwd in db.pwds select apwd.pwds_id).Max();
hasexistdate.pwds_id = pwdid;
}
var pwdt = db.pwds.Single(p => p.pwds_id == pwdid);
if (whitchpwd == xhmes)
{
pwdt.student_num = pwd;
}
else if (whitchpwd == jwcmes)
{
pwdt.jw_pwd = pwd;
}
db.SubmitChanges();
db.Dispose();
}
}
