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