public void Update(M_UserModel info) { dal.Update(info); }
public void ADD(M_UserModel info) { dal.Add(info); }
/// <summary> /// 将模型信息的各属性值传递到参数中 /// </summary> /// <param name="Info"></param> /// <returns></returns> private static SqlParameter[] GetParameters(M_UserModel Info) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ModelID", SqlDbType.Int, 4), new SqlParameter("@ModelName", SqlDbType.NVarChar, 20), new SqlParameter("@Description", SqlDbType.NVarChar, 255), new SqlParameter("@TableName", SqlDbType.NVarChar, 50) }; parameter[0].Value = Info.ModelID; parameter[1].Value = Info.ModelName; parameter[2].Value = Info.Description; parameter[3].Value = Info.TableName; return parameter; }
/// <summary> /// 更新会员模型 /// </summary> /// <param name="info"></param> void ID_UserModel.Update(M_UserModel info) { string strSql = "PR_UserModel_Update"; SqlParameter[] cmdParams = GetParameters(info); SqlHelper.ExecuteProc(strSql, cmdParams); }
/// <summary> /// 从DataReader中读取模型记录 /// </summary> /// <param name="rdr">DataReader</param> /// <returns>M_ModelInfo 模型信息</returns> private static M_UserModel GetInfoFromReader(SqlDataReader rdr) { M_UserModel info = new M_UserModel(); info.ModelID = DataConverter.CLng(rdr["ModelID"].ToString()); info.ModelName = rdr["ModelName"].ToString(); info.Description = rdr["Description"].ToString(); info.TableName = rdr["TableName"].ToString(); return info; }