public UpVal()
{
u = new uc();
}
public string Post([FromBody] JObject jObj)
{
DBEntities db = new DBEntities();
List <usr> uData = db.usr.ToList();
List <course> cData = db.course.ToList();
List <uc> ucData = db.uc.ToList();
string type = jObj["type"].ToString(); //客户端操作类型
if (type.Equals("login"))
{
string inNo = jObj["no"].ToString();
string inPw = jObj["pw"].ToString();
//匹配成功,返回users的id,密码错误返回-1， 账号不存在返回0
for (int i = 0; i < uData.Count; i++)
{
if (uData[i].no == inNo)
{
if (uData[i].pw == inPw)
{
return(uData[i].uid.ToString());
}
else
{
return("-1");
}
}
}
return("0");
}
else if (type.Equals("register"))
{
string no = jObj["no"].ToString();
string pw = jObj["pw"].ToString();
string school = jObj["school"].ToString();
string major = jObj["major"].ToString();
usr uTmp = db.usr.Where(usr => usr.no == no).FirstOrDefault();
if (uTmp == null)
{
usr u = new usr()
{
no = no, pw = pw, school = school, major = major
};
db.usr.Add(u);
if (db.SaveChanges() > 0)
{
return("1");
}
return("-1");
}
else
{
return("0");
}
}
else if (type.Equals("getCourseInfo"))
{
int uid = int.Parse(jObj["uid"].ToString()); //得到客户端当前登录用户的id
List <course> cUidData = new List <course>(); //储存匹配到的当前用户的课程信息
for (int i = 0; i < ucData.Count; i++)
{
if (ucData[i].uid == uid)
{
for (int j = 0; j < cData.Count; j++)
{
if (cData[j].cid == ucData[i].cid)
{
course c = new course(); //一条课程记录
c.cid = cData[j].cid;
c.coursename = cData[j].coursename;
c.teacher = cData[j].teacher;
c.classroom = cData[j].classroom;
c.classstart = cData[j].classstart;
c.classend = cData[j].classend;
c.day = cData[j].day;
cUidData.Add(c);
}
}
}
}
return(JsonConvert.SerializeObject(cUidData));
}
else if (type.Equals("addCourse") || type.Equals("editCourse") || type.Equals("delCourse"))
{
int uid = int.Parse(jObj["uid"].ToString()); //得到当前用户的id
int cid = int.Parse(jObj["cid"].ToString()); //得到课程id,若type为edit则为修改前的id，若为del则为要删除的id, 若为add则为0（防止空指针异常）
if (type.Equals("delCourse")) //删除操作
{
uc ucTmp = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault();
db.uc.Remove(ucTmp);
}
else
{
//得到修改后的课程
string cn = jObj["coursename"].ToString();
string tn = jObj["teacher"].ToString();
string cr = jObj["classroom"].ToString();
int cs = int.Parse(jObj["classstart"].ToString());
int ce = int.Parse(jObj["classend"].ToString());
int day = int.Parse(jObj["day"].ToString());
if (type.Equals("addCourse")) //若添加的课程与已存在的课程时间段有重合，则添加失败
{
List <course> cSEList = db.course.Where(course => course.classstart >= cs && course.classend <= ce && course.day == day).ToList();
List <uc> ucUidList = db.uc.Where(uc => uc.uid == uid).ToList();
for (int i = 0; i < cSEList.Count; i++)
{
for (int j = 0; j < ucUidList.Count; j++)
{
if (cSEList[i].cid == ucUidList[j].cid)
{
return("0");
}
}
}
}
course cTmp1 = db.course.Where(course => course.coursename == cn &&
course.teacher == tn &&
course.classroom == cr &&
course.classstart == cs &&
course.classend == ce &&
course.day == day
).FirstOrDefault();
course c = new course();
course cTmp2 = new course();
if (cTmp1 == null)
{
cTmp2.coursename = cn;
cTmp2.teacher = tn;
cTmp2.classroom = cr;
cTmp2.classstart = cs;
cTmp2.classend = ce;
cTmp2.day = day;
db.course.Add(cTmp2);
db.SaveChanges();
c = cTmp2;
}
else
{
c = cTmp1;
}
if (type.Equals("addCourse")) //添加操作
{
uc ucTmp = new uc()
{
uid = uid, cid = c.cid
};
db.uc.Add(ucTmp);
}
else if (type.Equals("editCourse")) //编辑操作
{
uc ucUid = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault();
ucUid.cid = c.cid;
}
cid = c.cid; //便于返回cid
}
if (db.SaveChanges() > 0)
{
return(cid.ToString());
}
return("0");
}
return("0");
}
public CallInfo()
{
u = luaM_newobject <uc> (null);
}
