public static void AddIntoWechatIds(string wechatid)
{
using (var db = new ElearnDBDataContext())
{
_addintowechatids(db, wechatid);
}
}
/// <summary>
/// 如果partcode错误，返回魔值:int.Minvalue
/// </summary>
/// <param name="partcode"></param>
/// <returns></returns>
public static int GetFirstWordOfPart(string partcode)
{
using (var db = new ElearnDBDataContext())
{
return(_getfirstwordofpart(db, partcode));
}
}
private static void _updateprocesses(ElearnDBDataContext db, int userid, string partcode, int wordid, int?index)
{
index = index ?? 0;
var hasexistid = db.processes.SingleOrDefault(user => user.user_id == userid);
if (hasexistid == null)
{
processes insertone = new processes
{
user_id = userid,
part_code = partcode,
eword_id = wordid,
process_index = index,
oralsentence_id = null
};
db.processes.InsertOnSubmit(insertone);
}
else
{
hasexistid.part_code = partcode;
hasexistid.eword_id = wordid;
hasexistid.process_index = index;
hasexistid.oralsentence_id = null;
}
db.SubmitChanges();
}
private static string _getexamplesentence(ElearnDBDataContext db, ewords word)
{
var sentence = db.sentences.Where(sen => sen.eword_id == word.eword_id).Select(sen => sen.sentence);
string result = "";
int last = 2;
foreach (var item in sentence)
{
string newitem = Regex.Replace(item, "<[/]?vocab>", "");
result += newitem;
if (last == 2)
{
result += "\r\n\r\n";
}
last--;
if (last == 0)
{
break;
}
}
if (string.IsNullOrEmpty(result))
{
result += "暂无例句\r\n";
}
return(result);
}
public static string GetNextWord(string wechatid)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
var process = _getaprocess(db, userid);
if (process == null)
{
return(null);
}
else
{
if (process.process_index != 0 && process.process_index % 5 == 0)
{
return(null);
}
var result = GetNextWord(userid, process);
if (result == null)
{
return(null);
}
else
{
return(result.eword + ":" + result.chinese + "\r\n" + _getexamplesentence(db, result));
}
}
}
}
public static string GetStudentNum(string wechatid)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
return(_getstudentnum(db, userid));
}
}
public static string GetNowWord(string wechatid)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
return(_getnowword(db, userid));
}
}
public static void UpdateStudents(string wechatid, string studentnum, string jwcpassword)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
_updatestudents(db, userid, studentnum, jwcpassword);
}
}
public static bool HaveProcess(string wechatid)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
return(_haveprocess(db, userid));
}
}
/// <summary>
/// 如果partcode错误，返回魔值:int.Minvalue
/// </summary>
/// <param name="partcode"></param>
/// <returns></returns>
private static int _getfirstwordofpart(ElearnDBDataContext db, string partcode)
{
var firstwords = db.ewords.Where(word => string.Equals(word.part_code, partcode));
foreach (var item in firstwords)
{
return(item.eword_id);
}
return(int.MinValue);
}
public static int tryGetUserId(string wechatid)
{
int result = 0;
using (var db = new ElearnDBDataContext())
{
result = _getuserid(db, wechatid);
}
return(result);
}
private static bool _haveprocess(ElearnDBDataContext db, int userid)
{
var process = db.processes.SingleOrDefault(user => user.user_id == userid);
if (process != null && process.eword_id != null)
{
return(true);
}
else
{
return(false);
}
}
private static bool _havebinding(ElearnDBDataContext db, int userid)
{
var student = db.students.Single(studentnow => studentnow.user_id == userid);
if (string.IsNullOrEmpty(student.jwcpassword))
{
return(false);
}
else
{
return(true);
}
}
private static void _addintowechatids(ElearnDBDataContext db, string wechatid)
{
var hasexistid = db.wechatids.SingleOrDefault(wc => wc.wechat_id == wechatid);
if (hasexistid == null)
{
wechatids insertone = new wechatids
{
wechat_id = wechatid
};
db.wechatids.InsertOnSubmit(insertone);
db.SubmitChanges();
}
}
private static void _updatestudents(ElearnDBDataContext db, int userid, string studentnum, string jwcpassword)
{
var student = db.students.Single(studentnow => studentnow.user_id == userid);
if (studentnum != null)
{
student.studentnum = studentnum;
student.jwcpassword = null;
}
if (jwcpassword != null)
{
student.jwcpassword = HttpUtility.UrlEncode(jwcpassword);
}
db.SubmitChanges();
}
private static ewords _getnextword(ElearnDBDataContext db, string partcode, int?wordid)
{
var words = db.ewords.Where(word => string.Equals(word.part_code, partcode));
bool isgetnow = false;
foreach (var item in words)
{
if (isgetnow)
{
return(item);
}
if (item.eword_id == wordid)
{
isgetnow = true;
}
}
return(null);
}
private static int _getuserid(ElearnDBDataContext db, string wechatid)
{
var hasexistid = db.wechatids.SingleOrDefault(wc => wc.wechat_id == wechatid);
if (hasexistid == null)
{
wechatids insertone = new wechatids
{
wechat_id = wechatid
};
db.wechatids.InsertOnSubmit(insertone);
db.SubmitChanges();
return(_getuserid(db, wechatid));
}
else
{
return(hasexistid.user_id);
}
}
public static string _getnowword(ElearnDBDataContext db, int userid)
{
var process = _getaprocess(db, userid);
if (process != null && process.eword_id != null)
{
var words = db.ewords.Where(word => string.Equals(word.part_code, process.part_code));
foreach (var item in words)
{
if (item.eword_id == process.eword_id)
{
return(item.eword);
}
}
return(null);
}
else
{
return(null);
}
}
public static bool tryUpdateProcesses(string wechatid, string partcode)
{
using (var db = new ElearnDBDataContext())
{
int userid = _getuserid(db, wechatid);
if (!_havebinding(db, userid))
{
return(false);
}
int wordid = _getfirstwordofpart(db, partcode);
if (wordid == int.MinValue)
{
return(false);
}
else
{
_updateprocesses(db, userid, partcode, wordid, 0);
return(true);
}
}
}
public static ewords GetNextWord(int userid, processes process)
{
using (var db = new ElearnDBDataContext())
{
ewords nextword = null;
if (_haveprocess(db, userid))
{
nextword = _getnextword(db, process.part_code, process.eword_id);
if (nextword == null)
{
return(null);
}
else
{
_updateprocesses(db, userid, process.part_code, nextword.eword_id, process.process_index + 1);
return(nextword);
}
}
else
{
return(null);
}
}
}
private static processes _getaprocess(ElearnDBDataContext db, int userid)
{
return(db.processes.SingleOrDefault(thisprocess => thisprocess.user_id == userid));
}
private static string _getstudentnum(ElearnDBDataContext db, int userid)
{
var student = db.students.Single(studentnow => studentnow.user_id == userid);
return(student.studentnum);
}