public int Insert(Questions data) { //QuestionsSqlmapDao dal = new QuestionsSqlmapDao(); //data.Qid = dal.GetMaxID("staff"); aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.Qid = dal.GetMaxID("questions"); String stmtId = "Questions_Insert"; Hashtable ht = new Hashtable(); ht.Add("Qid", data.Qid); ht.Add("ChapterID", data.ChapterID); ht.Add("TypeName", data.TypeName); ht.Add("TitleName", data.TitleName); ht.Add("SpellNo", data.SpellNo); ht.Add("A", data.A); ht.Add("B", data.B); ht.Add("C", data.C); ht.Add("D", data.D); ht.Add("E", data.E); ht.Add("F", data.F); ht.Add("Score", data.Score); ht.Add("Result", data.Result); ht.Add("OperatorID", data.OperatorID); ht.Add("ModifyDate", data.ModifyDate); try { ExecuteInsert(stmtId, ht); return(1); } catch (Exception ex) { return(0); } }
public string Insert(aers_tbl_registereduser data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.ReguserId = dal.GetMaxID("registereduser"); String stmtId = "aers_tbl_registereduser_Insert"; Hashtable ht = new Hashtable(); ht.Add("ReguserId", data.ReguserId); ht.Add("LoginName", data.LoginName); ht.Add("Password", data.Password); ht.Add("IsFlag", data.IsFlag); ht.Add("Remarks", data.Remarks); ht.Add("OperatorId", data.OperatorId); ht.Add("OperatorDate", data.OperatorDate); try { ExecuteInsert(stmtId, ht); return(data.ReguserId); } catch (Exception ex) { return(""); } }
public int Insert(aers_tbl_hospital data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.HospId = dal.GetMaxID("hospital"); String stmtId = "aers_tbl_hospital_Insert"; Hashtable ht = new Hashtable(); ht.Add("HospId", data.HospId); ht.Add("HospName", data.HospName); ht.Add("Address", data.Address); ht.Add("Phone", data.Phone); ht.Add("Contact", data.Contact); ht.Add("Grade", data.Grade); ht.Add("Validitytime", data.Validitytime); ht.Add("IsFlag", data.IsFlag); ht.Add("Remarks", data.Remarks); ht.Add("OperatorId", data.OperatorId); ht.Add("OperatorDate", data.OperatorDate); try { ExecuteInsert(stmtId, ht); return(1); } catch (Exception ex) { return(0); } }
public DataSet GetFavor(int TypeID, string UserID, string MainID) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); string sql = "select * from Favour where TypeID=" + TypeID + " and UserID='" + UserID + "' and MainID='" + MainID + "'"; return(QueryDataSet(sql)); }
public DataSet DeleteCourseUser(string UserID, string CourseID) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); string sql = "delete from CourseUser where UserID='" + UserID + "' and CourseID='" + CourseID + "'"; return(QueryDataSet(sql)); }
public void CourseInsert(Course data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.CourseID = dal.GetMaxID("Course"); String stmtId = "Course_Insert"; Hashtable ht = new Hashtable(); ht.Add("CourseID", data.CourseID); ht.Add("CourseType", data.CourseType); ht.Add("CourseName", data.CourseName); ht.Add("CourseTeacher", data.CourseTeacher); ht.Add("CourseIntro", data.CourseIntro); ht.Add("CourseDuration", data.CourseDuration); ht.Add("CourseLevel", data.CourseLevel); ht.Add("CourseTag", data.CourseTag); ht.Add("CourseThumb", data.CourseThumb); ht.Add("SuitableDuty", data.SuitableDuty); ht.Add("SuitableYearUp", data.SuitableYearUp); ht.Add("SuitableYearDown", data.SuitableYearDown); ht.Add("CourseHot", data.CourseHot); ht.Add("CourseSort", data.CourseSort); ht.Add("AuthorID", data.AuthorID); ht.Add("OperatorID", data.OperatorID); ht.Add("OperateTime", data.OperateTime); ht.Add("Recommend", data.Recommend); ht.Add("TeacherIntroduction", data.TeacherIntroduction); ht.Add("ChapterPoints", data.ChapterPoints); ht.Add("HospId", data.HospId); ht.Add("HospdepId", data.HospdepId); ExecuteInsert(stmtId, ht); }
public int Insert(aers_tbl_hospdep data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.HospdepId = dal.GetMaxID("hospdep"); String stmtId = "aers_tbl_hospdep_Insert"; Hashtable ht = new Hashtable(); ht.Add("HospdepId", data.HospdepId); ht.Add("BasedepId", data.BasedepId); ht.Add("HospId", data.HospId); ht.Add("HospdepName", data.HospdepName); ht.Add("SpellNo", data.SpellNo); ht.Add("HospdepLogo", data.HospdepLogo); ht.Add("DisplayOrder", data.DisplayOrder); ht.Add("IsFlag", data.IsFlag); ht.Add("Remarks", data.Remarks); ht.Add("OperatorId", data.OperatorId); ht.Add("OperatorDate", data.OperatorDate); try { ExecuteInsert(stmtId, ht); return(1); } catch (Exception ex) { return(0); } }
public int Insert(aers_tbl_staff data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.StaffId = dal.GetMaxID("staff"); String stmtId = "aers_tbl_staff_Insert"; Hashtable ht = new Hashtable(); ht.Add("StaffId", data.StaffId); ht.Add("ReguserId", data.ReguserId); ht.Add("DepId", data.DepId); ht.Add("Name", data.Name); ht.Add("RoleState", data.RoleState); ht.Add("Sex", data.Sex); ht.Add("Position", data.Position); ht.Add("Phone", data.Phone); ht.Add("Address", data.Address); ht.Add("IDNumber", data.IDNumber); ht.Add("IsFlag", data.IsFlag); ht.Add("Remarks", data.Remarks); ht.Add("OperatorId", data.OperatorId); ht.Add("OperatorDate", data.OperatorDate); ht.Add("HeadImg", data.HeadImg); try { ExecuteInsert(stmtId, ht); return(1); } catch (Exception ex) { return(0); } }
public DataSet FindGroupByName(DateTime time1, DateTime time2) { //select EveycId from aers_tbl_events_yc_parts where EveresName='149' GROUP BY EveycId aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); Hashtable ht = new Hashtable(); string sql = " select DetailTypeQt,count(*) as ccc from aers_tbl_events_qt where HappenedDate>='" + time1 + "' and HappenedDate<'" + time2 + "' and DetailType=112 and DetailTypeQt!='' GROUP BY DetailTypeQt order by ccc desc "; return(ExecutQueryForDataSet(sql, ht)); }
public int AddCourseUser(string UserID, string CourseID) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); string sql = "insert into CourseUser values (@ID,@CourseID,@UserID)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@ID", dal.GetMaxID("CourseUser")), new MySqlParameter("@CourseID", CourseID), new MySqlParameter("@UserID", UserID) }; return(ExecSQLParam(sql, para)); }
public int AddFavor(int TypeID, string UserID, string MainID) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); string sql = "insert into Favour values (@ID,@TypeID,@UserID,@MainID,@OperatorDate)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@ID", dal.GetMaxID("Favor")), new MySqlParameter("@TypeID", TypeID), new MySqlParameter("@UserID", UserID), new MySqlParameter("@MainID", MainID), new MySqlParameter("@OperatorDate", DateTime.Now) }; return(ExecSQLParam(sql, para)); }
public void CourseCatalogInsert(CourseCatalog data) { //String stmtId = "CourseCatalog_Insert"; //ExecuteInsert(stmtId, courseCatalog); aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.CourseID = dal.GetMaxID("CourseCatalog"); String stmtId = "CourseCatalog_Insert"; Hashtable ht = new Hashtable(); ht.Add("CatalogID", data.CatalogID); ht.Add("CourseID", data.CourseID); ht.Add("CatalogName", data.CatalogName); ht.Add("CatalogSort", data.CatalogSort); ExecuteInsert(stmtId, data); }
public Int32 Insert(Answer answer) { try { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); answer.AID = dal.GetMaxID("Answer"); //2017-6-2 DH answer.ModifyDate = DateTime.Now; //2017-6-2 DH String stmtId = "Answer_Insert"; ExecuteInsert(stmtId, answer); return(1); } catch (Exception ex) { return(0); } }
public string Insert(Problem data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.QID = dal.GetMaxID("Problem"); String stmtId = "Problem_Insert"; Hashtable ht = new Hashtable(); ht.Add("QID", data.QID); ht.Add("CourseID", data.CourseID); ht.Add("Title", data.Title); ht.Add("UserID", data.UserID); ht.Add("ModifyDate", DateTime.Now); ht.Add("FavorCount", data.FavorCount); ExecuteInsert(stmtId, ht); return(data.QID); }
public string Insert(Notes data) { aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao(); data.NoteID = dal.GetMaxID("Notes"); String stmtId = "Notes_Insert"; Hashtable ht = new Hashtable(); ht.Add("NoteID", data.NoteID); ht.Add("CourseID", data.CourseID); ht.Add("Content", data.Content); ht.Add("UserID", data.UserID); ht.Add("ModifyDate", DateTime.Now); ht.Add("IsShare", data.IsShare); ht.Add("FavorCount", data.FavorCount); ExecuteInsert(stmtId, ht); return(data.NoteID); }