public static object[,] GetTimetableData(string timetableid, int userid) { if (!TimetableField.Id.TestValue(timetableid)) { return new object[, ] { { "" } } } ; SqlQueryCondition[] sqlconditions = new SqlQueryCondition[] { new SqlQueryCondition(TimetableField.Id, SqlQueryConditionOperator.Equal, timetableid), new SqlQueryCondition(TimetableField.Owner, SqlQueryConditionOperator.Equal, userid) //加入此条件防止非法查看他人课表 }; UserLogDAO.Insert(userid, "gettbdat{" + timetableid + "}"); return(TimetableDAO.Select(new TimetableField[] { TimetableField.Data }, new SqlQueryCondition(sqlconditions, SqlQueryLogicalOperator.And))); }
public static string AddTimetable(string timetablename, string data, int userid) { if (!TimetableField.Name.TestValue(timetablename) || !TimetableField.Data.TestValue(data)) { return("数据错误 请联系管理员!"); } SqlQueryCondition[] sqlconditions = new SqlQueryCondition[] { new SqlQueryCondition(TimetableField.Owner, SqlQueryConditionOperator.Equal, userid), new SqlQueryCondition(TimetableField.Name, SqlQueryConditionOperator.Equal, timetablename) }; if (TimetableDAO.Select(new TimetableField[] { TimetableField.Id }, new SqlQueryCondition(sqlconditions, SqlQueryLogicalOperator.And)).Length != 0) { return("课表名重复!"); } else { UserLogDAO.Insert(userid, "addtb{" + timetablename + "}"); return("true:" + TimetableDAO.Insert(timetablename, userid, data)); //加上id一起返回 } }
public static string ActiveTimetable(string timetableid, int userid) { if (!TimetableField.Id.TestValue(timetableid)) { return(""); } SqlQueryCondition sqlcondition1 = new SqlQueryCondition(TimetableField.Id, SqlQueryConditionOperator.Equal, timetableid); SqlQueryCondition sqlcondition2 = new SqlQueryCondition(TimetableField.Status, SqlQueryConditionOperator.Equal, 1); SqlQueryCondition sqlcondition3 = new SqlQueryCondition(TimetableField.Owner, SqlQueryConditionOperator.Equal, userid); //加入此条件防止非法更改他人课表 if (TimetableDAO.Select(new TimetableField[] { TimetableField.Id }, new SqlQueryCondition(new SqlQueryCondition[] { sqlcondition1, sqlcondition3 }, SqlQueryLogicalOperator.And)).Length != 0) { TimetableDAO.Update(new TimetableField[] { TimetableField.Status }, new object[] { 0 }, new SqlQueryCondition(new SqlQueryCondition[] { sqlcondition2, sqlcondition3 }, SqlQueryLogicalOperator.And)); TimetableDAO.Update(new TimetableField[] { TimetableField.Status }, new object[] { 1 }, new SqlQueryCondition(new SqlQueryCondition[] { sqlcondition1 }, SqlQueryLogicalOperator.And)); } UserLogDAO.Insert(userid, "acttb{" + timetableid + "}"); return("true"); }
public static string RenameTimetable(string timetableid, string newname, int userid) { if (!TimetableField.Id.TestValue(timetableid) || !TimetableField.Name.TestValue(newname)) { return("数据错误 请联系管理员!"); } SqlQueryCondition sqlcondition1 = new SqlQueryCondition(TimetableField.Owner, SqlQueryConditionOperator.Equal, userid); //加入此条件防止非法更改他人课表 SqlQueryCondition sqlcondition2 = new SqlQueryCondition(TimetableField.Id, SqlQueryConditionOperator.Equal, timetableid); SqlQueryCondition sqlcondition3 = new SqlQueryCondition(TimetableField.Name, SqlQueryConditionOperator.Equal, newname); if (TimetableDAO.Select(new TimetableField[] { TimetableField.Id }, new SqlQueryCondition(new SqlQueryCondition[] { sqlcondition1, sqlcondition3 }, SqlQueryLogicalOperator.And)).Length != 0) { return("课表名重复!"); } else { TimetableDAO.Update(new TimetableField[] { TimetableField.Name }, new object[] { newname }, new SqlQueryCondition(new SqlQueryCondition[] { sqlcondition1, sqlcondition2 }, SqlQueryLogicalOperator.And)); UserLogDAO.Insert(userid, "rntb{" + timetableid + '\r' + newname + "}"); return("true"); } }
public static object[,] GetTimetables(int userid) { UserLogDAO.Insert(userid, "gettbs{}"); TimetableField[] fields = new TimetableField[] { TimetableField.Id, TimetableField.Name, TimetableField.Status }; return(TimetableDAO.Select(fields, new SqlQueryCondition(TimetableField.Owner, SqlQueryConditionOperator.Equal, userid))); }