public int Update(Size1Info oParam)
{
string sql = @"UPDATE Size1 SET
Size1ID=@Size1ID,
Size1Name=@Size1Name, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSize1ID = new SqlParameter("@Size1ID", SqlDbType.NVarChar, 20);
SqlParameter paramSize1Name = new SqlParameter("@Size1Name", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Value = oParam.SysNo;
paramSize1ID.Value = oParam.Size1ID;
paramSize1Name.Value = oParam.Size1Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSize1ID);
cmd.Parameters.Add(paramSize1Name);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(Size1Info oParam)
{
string sql = @"INSERT INTO Size1
(
Size1ID, Size1Name, Status
)
VALUES (
@Size1ID, @Size1Name, @Status
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSize1ID = new SqlParameter("@Size1ID", SqlDbType.NVarChar, 20);
SqlParameter paramSize1Name = new SqlParameter("@Size1Name", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSize1ID.Value = oParam.Size1ID;
paramSize1Name.Value = oParam.Size1Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSize1ID);
cmd.Parameters.Add(paramSize1Name);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
private void map(Size1Info oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.Size1ID = Util.TrimNull(tempdr["Size1ID"]);
oParam.Size1Name = Util.TrimNull(tempdr["Size1Name"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.Size1Type = Util.TrimNull(tempdr["Size1Type"]);
}
public void UpdateSize1(Size1Info oParam)
{
string sql = "select * from size1 where Size1ID=" + oParam.Size1ID + " and SysNo<>" + oParam.SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
throw new BizException("相同ID编号的尺码已存在");
}
new SizeDac().Update(oParam);
}
public Size1Info LoadSize1(int SysNo)
{
string sql = "select * from size1 where sysno=" + SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
{
return(null);
}
Size1Info oInfo = new Size1Info();
map(oInfo, ds.Tables[0].Rows[0]);
return(oInfo);
}
public void InsertSize1(Size1Info oParam)
{
new SizeDac().Insert(oParam);
}
