public bool UpdateCheckByTeacher(StudyAndReadingModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_StudyAndReading set "); strSql.Append("TeacherCheck=@TeacherCheck"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@TeacherCheck", SqlDbType.NVarChar, 50), new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.TeacherCheck; parameters[1].Value = model.Id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public List <StudyAndReadingModel> GetListById(string Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,TeacherId,TeacherName,ActivityForm,ActivityContent,ActivityDate,LanguageType,ClassHour,MainSpeaker,SuperiorDoctor,Comment from GP_StudyAndReading "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = Id; DataTable dt = db.RunDataTable(strSql.ToString(), parameters); List <StudyAndReadingModel> list = null; if (dt.Rows.Count > 0) { list = new List <StudyAndReadingModel>(); StudyAndReadingModel model = null; foreach (DataRow row in dt.Rows) { model = new StudyAndReadingModel(); model = DataRowToModel(row); list.Add(model); } } return(list); }
public List <Model.StudyAndReadingModel> GetPagedList(string StudentsName, string TrainingBaseCode, string DeptName, string ActivityForm, string ActivityDate, string LanguageType, string SuperiorDoctor, int start, int end) { string sql = "select * from (select row_number() over(order by RegisterDate desc) as num,* from GP_StudyAndReading where StudentsName='" + StudentsName + "' and TrainingBaseCode='" + TrainingBaseCode + "'"; if (!string.IsNullOrEmpty(DeptName)) { sql += "and DeptName like '%" + DeptName + "%'"; } if (ActivityForm != "-1" && !string.IsNullOrEmpty(ActivityForm)) { sql += "and ActivityForm ='" + ActivityForm + "'"; } if (!string.IsNullOrEmpty(ActivityDate)) { sql += "and ActivityDate like '%" + ActivityDate + "%'"; } if (LanguageType != "-1" && !string.IsNullOrEmpty(LanguageType)) { sql += "and LanguageType ='" + LanguageType + "'"; } if (!string.IsNullOrEmpty(SuperiorDoctor)) { sql += "and SuperiorDoctor like '%" + SuperiorDoctor + "%'"; } sql += ")as t where t.num>=@start and t.num<=@end"; SqlParameter[] pars = { new SqlParameter("@start", SqlDbType.Int), new SqlParameter("@end", SqlDbType.Int) }; pars[0].Value = start; pars[1].Value = end; DataTable dt = db.RunDataTable(sql, pars); List <StudyAndReadingModel> list = null; if (dt.Rows.Count > 0) { list = new List <StudyAndReadingModel>(); StudyAndReadingModel model = null; foreach (DataRow row in dt.Rows) { model = new StudyAndReadingModel(); model = DataRowToModel(row); list.Add(model); } } return(list); }
public StudyAndReadingModel GetModelById(string Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,TeacherId,TeacherName,ActivityForm,ActivityContent,ActivityDate,LanguageType,ClassHour,MainSpeaker,SuperiorDoctor,Comment from GP_StudyAndReading "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = Id; StudyAndReadingModel model = new StudyAndReadingModel(); DataSet ds = db.RunDataSet(strSql.ToString(), parameters, "tbName"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public bool UpdateCheckByTeacher(StudyAndReadingModel model) { return(studyAndReadingDAL.UpdateCheckByTeacher(model)); }
public bool Update(StudyAndReadingModel model, string id) { return(studyAndReadingDAL.Update(model, id)); }
public bool Add(StudyAndReadingModel model) { return(studyAndReadingDAL.Add(model)); }
public bool Update(StudyAndReadingModel model, string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_StudyAndReading set "); strSql.Append("StudentsRealName=@StudentsRealName,"); strSql.Append("StudentsName=@StudentsName,"); strSql.Append("TrainingBaseCode=@TrainingBaseCode,"); strSql.Append("TrainingBaseName=@TrainingBaseName,"); strSql.Append("ProfessionalBaseCode=@ProfessionalBaseCode,"); strSql.Append("ProfessionalBaseName=@ProfessionalBaseName,"); strSql.Append("DeptCode=@DeptCode,"); strSql.Append("DeptName=@DeptName,"); strSql.Append("RegisterDate=@RegisterDate,"); strSql.Append("Writor=@Writor,"); strSql.Append("TeacherId=@TeacherId,"); strSql.Append("TeacherName=@TeacherName,"); strSql.Append("ActivityForm=@ActivityForm,"); strSql.Append("ActivityContent=@ActivityContent,"); strSql.Append("ActivityDate=@ActivityDate,"); strSql.Append("LanguageType=@LanguageType,"); strSql.Append("ClassHour=@ClassHour,"); strSql.Append("MainSpeaker=@MainSpeaker,"); strSql.Append("SuperiorDoctor=@SuperiorDoctor,"); strSql.Append("Comment=@Comment"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@StudentsRealName", SqlDbType.NVarChar, 50), new SqlParameter("@StudentsName", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@DeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@DeptName", SqlDbType.NVarChar, 500), new SqlParameter("@RegisterDate", SqlDbType.NVarChar, 50), new SqlParameter("@Writor", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50), new SqlParameter("@ActivityForm", SqlDbType.NVarChar, 50), new SqlParameter("@ActivityContent", SqlDbType.NVarChar, 2000), new SqlParameter("@ActivityDate", SqlDbType.NVarChar, 50), new SqlParameter("@LanguageType", SqlDbType.NVarChar, 50), new SqlParameter("@ClassHour", SqlDbType.NVarChar, 50), new SqlParameter("@MainSpeaker", SqlDbType.NVarChar, 50), new SqlParameter("@SuperiorDoctor", SqlDbType.NVarChar, 50), new SqlParameter("@Comment", SqlDbType.NVarChar, 1000), new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.StudentsRealName; parameters[1].Value = model.StudentsName; parameters[2].Value = model.TrainingBaseCode; parameters[3].Value = model.TrainingBaseName; parameters[4].Value = model.ProfessionalBaseCode; parameters[5].Value = model.ProfessionalBaseName; parameters[6].Value = model.DeptCode; parameters[7].Value = model.DeptName; parameters[8].Value = model.RegisterDate; parameters[9].Value = model.Writor; parameters[10].Value = model.TeacherId; parameters[11].Value = model.TeacherName; parameters[12].Value = model.ActivityForm; parameters[13].Value = model.ActivityContent; parameters[14].Value = model.ActivityDate; parameters[15].Value = model.LanguageType; parameters[16].Value = model.ClassHour; parameters[17].Value = model.MainSpeaker; parameters[18].Value = model.SuperiorDoctor; parameters[19].Value = model.Comment; parameters[20].Value = id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Add(StudyAndReadingModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GP_StudyAndReading("); strSql.Append("Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,TeacherId,TeacherName,ActivityForm,ActivityContent,ActivityDate,LanguageType,ClassHour,MainSpeaker,SuperiorDoctor,Comment)"); strSql.Append(" values ("); strSql.Append("@Id,@StudentsRealName,@StudentsName,@TrainingBaseCode,@TrainingBaseName,@ProfessionalBaseCode,@ProfessionalBaseName,@DeptCode,@DeptName,@RegisterDate,@Writor,@TeacherCheck,@KzrCheck,@BaseCheck,@ManagerCheck,@TeacherId,@TeacherName,@ActivityForm,@ActivityContent,@ActivityDate,@LanguageType,@ClassHour,@MainSpeaker,@SuperiorDoctor,@Comment)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50), new SqlParameter("@StudentsRealName", SqlDbType.NVarChar, 50), new SqlParameter("@StudentsName", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@DeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@DeptName", SqlDbType.NVarChar, 500), new SqlParameter("@RegisterDate", SqlDbType.NVarChar, 50), new SqlParameter("@Writor", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherCheck", SqlDbType.NVarChar, 50), new SqlParameter("@KzrCheck", SqlDbType.NVarChar, 50), new SqlParameter("@BaseCheck", SqlDbType.NVarChar, 50), new SqlParameter("@ManagerCheck", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50), new SqlParameter("@ActivityForm", SqlDbType.NVarChar, 50), new SqlParameter("@ActivityContent", SqlDbType.NVarChar, 2000), new SqlParameter("@ActivityDate", SqlDbType.NVarChar, 50), new SqlParameter("@LanguageType", SqlDbType.NVarChar, 50), new SqlParameter("@ClassHour", SqlDbType.NVarChar, 50), new SqlParameter("@MainSpeaker", SqlDbType.NVarChar, 50), new SqlParameter("@SuperiorDoctor", SqlDbType.NVarChar, 50), new SqlParameter("@Comment", SqlDbType.NVarChar, 1000) }; parameters[0].Value = model.Id; parameters[1].Value = model.StudentsRealName; parameters[2].Value = model.StudentsName; parameters[3].Value = model.TrainingBaseCode; parameters[4].Value = model.TrainingBaseName; parameters[5].Value = model.ProfessionalBaseCode; parameters[6].Value = model.ProfessionalBaseName; parameters[7].Value = model.DeptCode; parameters[8].Value = model.DeptName; parameters[9].Value = model.RegisterDate; parameters[10].Value = model.Writor; parameters[11].Value = model.TeacherCheck; parameters[12].Value = model.KzrCheck; parameters[13].Value = model.BaseCheck; parameters[14].Value = model.ManagerCheck; parameters[15].Value = model.TeacherId; parameters[16].Value = model.TeacherName; parameters[17].Value = model.ActivityForm; parameters[18].Value = model.ActivityContent; parameters[19].Value = model.ActivityDate; parameters[20].Value = model.LanguageType; parameters[21].Value = model.ClassHour; parameters[22].Value = model.MainSpeaker; parameters[23].Value = model.SuperiorDoctor; parameters[24].Value = model.Comment; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public StudyAndReadingModel DataRowToModel(DataRow row) { StudyAndReadingModel model = new StudyAndReadingModel(); if (row != null) { if (row["Id"] != null) { model.Id = row["Id"].ToString(); } if (row["StudentsRealName"] != null) { model.StudentsRealName = row["StudentsRealName"].ToString(); } if (row["StudentsName"] != null) { model.StudentsName = row["StudentsName"].ToString(); } if (row["TrainingBaseCode"] != null) { model.TrainingBaseCode = row["TrainingBaseCode"].ToString(); } if (row["TrainingBaseName"] != null) { model.TrainingBaseName = row["TrainingBaseName"].ToString(); } if (row["ProfessionalBaseCode"] != null) { model.ProfessionalBaseCode = row["ProfessionalBaseCode"].ToString(); } if (row["ProfessionalBaseName"] != null) { model.ProfessionalBaseName = row["ProfessionalBaseName"].ToString(); } if (row["DeptCode"] != null) { model.DeptCode = row["DeptCode"].ToString(); } if (row["DeptName"] != null) { model.DeptName = row["DeptName"].ToString(); } if (row["RegisterDate"] != null) { model.RegisterDate = row["RegisterDate"].ToString(); } if (row["Writor"] != null) { model.Writor = row["Writor"].ToString(); } if (row["TeacherCheck"] != null) { model.TeacherCheck = row["TeacherCheck"].ToString(); } if (row["KzrCheck"] != null) { model.KzrCheck = row["KzrCheck"].ToString(); } if (row["BaseCheck"] != null) { model.BaseCheck = row["BaseCheck"].ToString(); } if (row["ManagerCheck"] != null) { model.ManagerCheck = row["ManagerCheck"].ToString(); } if (row["TeacherId"] != null) { model.TeacherId = row["TeacherId"].ToString(); } if (row["TeacherName"] != null) { model.TeacherName = row["TeacherName"].ToString(); } if (row["ActivityForm"] != null) { model.ActivityForm = row["ActivityForm"].ToString(); } if (row["ActivityContent"] != null) { model.ActivityContent = row["ActivityContent"].ToString(); } if (row["ActivityDate"] != null) { model.ActivityDate = row["ActivityDate"].ToString(); } if (row["LanguageType"] != null) { model.LanguageType = row["LanguageType"].ToString(); } if (row["ClassHour"] != null) { model.ClassHour = row["ClassHour"].ToString(); } if (row["MainSpeaker"] != null) { model.MainSpeaker = row["MainSpeaker"].ToString(); } if (row["SuperiorDoctor"] != null) { model.SuperiorDoctor = row["SuperiorDoctor"].ToString(); } if (row["Comment"] != null) { model.Comment = row["Comment"].ToString(); } } return(model); }