public int UpdateInfor(Models.Course.MXCourse Model) { StringBuilder sql = new StringBuilder(); sql.Append("Update [MXCourse] set CourseName=@CourseName,CourseScore=@CourseScore,CateId=@CateId,OrderIndex=@OrderIndex where CourseId=@CourseId"); SqlParameter[] par = (SqlParameter[])this.ValueParas(Model); return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
//读取指定信息 public SqlDataReader GetInfor(Models.Course.MXCourse Model) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [MXCourse] where CourseId=@CourseId"); SqlParameter[] par = (SqlParameter[])this.ValueParas(Model); return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); }
public SqlDataReader InsertInfor(Models.Course.MXCourse Model) { StringBuilder sql = new StringBuilder(); sql.Append("Insert into [MXCourse] ( CourseName,CourseScore,CateId,OrderIndex ) values(@CourseName,@CourseScore,@CateId,@OrderIndex)"); sql.Append("SELECT SCOPE_IDENTITY()"); SqlParameter[] par = (SqlParameter[])this.ValueParas(Model); return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); // return Common.DbHelperSQL.ExecuteSql(sql.ToString(), par); }
public int InsertInfor(Models.Course.MXCourse Model) { SqlDataReader dr = dal.InsertInfor(Model); int Identity = 0; if (dr.Read()) { Identity = int.Parse(dr[0].ToString()); } return(Identity); }
/// <summary> /// 该数据访问对象的属性值装载到数据库更新参数数组 /// </summary> /// <remarks></remarks> protected IDbDataParameter[] ValueParas(Models.Course.MXCourse Model) { SqlParameter[] par = { new SqlParameter("@CourseId", SqlDbType.VarChar, 50), new SqlParameter("@CourseName", SqlDbType.VarChar, 50), new SqlParameter("@CourseScore", SqlDbType.VarChar, 50), new SqlParameter("@CateId", SqlDbType.VarChar, 50), new SqlParameter("@OrderIndex", SqlDbType.VarChar, 50) }; par[0].Value = Model.CourseId; par[1].Value = Model.CourseName; par[2].Value = Model.CourseScore; par[3].Value = Model.CateId; par[4].Value = Model.OrderIndex; return(par); }
public int UpdateInfor(Models.Course.MXCourse Model) { return(dal.UpdateInfor(Model)); }