public int UpdateInfor(Models.Course.MXSpecialCourse Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update [MXSpecialCourse] set CompanyId=@CompanyId,CourseContent=@CourseContent,StartDate=@StartDate,EndDate=@EndDate,Locked=@Locked where SpecialCourseId=@SpecialCourseId");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
public int InsertInfor(Models.Course.MXSpecialCourse Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into [MXSpecialCourse] ( SpecialCourseId,CompanyId,CourseContent,StartDate,EndDate,Locked ) values(@SpecialCourseId,@CompanyId,@CourseContent,@StartDate,@EndDate,@Locked)");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(XueFuShop.Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//读取信息
public SqlDataReader GetInfor(Models.Course.MXSpecialCourse Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from [MXSpecialCourse] where SpecialCourseId=@SpecialCourseId");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
protected IDbDataParameter[] ValueParas(Models.Course.MXSpecialCourse Model)
{
SqlParameter[] par =
{
new SqlParameter("@SpecialCourseId", SqlDbType.VarChar, 50),
new SqlParameter("@CompanyId", SqlDbType.VarChar, 50),
new SqlParameter("@CourseContent", SqlDbType.VarChar, 50),
new SqlParameter("@StartDate", SqlDbType.VarChar, 50),
new SqlParameter("@EndDate", SqlDbType.VarChar, 50),
new SqlParameter("@Locked", SqlDbType.VarChar, 50)
};
par[0].Value = Model.SpecialCourseId;
par[1].Value = Model.CompanyId;
par[2].Value = Model.CourseContent;
par[3].Value = Model.StartDate;
par[4].Value = Model.EndDate;
par[5].Value = Model.Locked;
return(par);
}
public int UpdateInfor(Models.Course.MXSpecialCourse Model)
{
return(dal.UpdateInfor(Model));
}
public int InsertInfor(Models.Course.MXSpecialCourse Model)
{
return(dal.InsertInfor(Model));
}
