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);
}
