private CodeDefData GetCodeDef(SqlDataReader dr)
{
CodeDefData data = new CodeDefData();
data.CodePK = ((int)(dr["CodePK"]));
data.CodeType = dr["CodeType"].ToString();
data.Description = dr["Description"].ToString();
data.Sort = dr["Sort"].Equals(DBNull.Value) ? 0 : (int)dr["Sort"];
data.Code = dr["Code"].ToString();
return(data);
}
public virtual void Insert(CodeDefData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = "Insert Into CodeDef(CodeType,Sort, Description, Code) Values(@CodeType,@Sort, @Description, @Code)";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@CodeType", data.CodeType);
cmd.Parameters.AddWithValue("@Sort", data.Sort);
cmd.Parameters.AddWithValue("@Description", data.Description);
cmd.Parameters.AddWithValue("@Code", data.Code);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
}
public virtual void Update(CodeDefData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = "Update CodeDef Set CodeType= @CodeType,Sort= @Sort, Description= @Description, Code=@Code Where CodePK =@CodePK";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@CodeType", data.CodeType);
cmd.Parameters.AddWithValue("@Sort", data.Sort);
cmd.Parameters.AddWithValue("@Description", data.Description);
cmd.Parameters.AddWithValue("@Code", data.Code);
cmd.Parameters.AddWithValue("@CodePK", data.CodePK);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
}
