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