public int CompareTo(object obj)
{
Size2Info b = obj as Size2Info;
if (this.Status < b.Status)
{
return(1);
}
else if (this.Status > b.Status)
{
return(-1);
}
else
{
int result = String.Compare(this.Size2ID, b.Size2ID);
if (result > 0)
{
return(1);
}
else
{
return(-1);
}
}
}
public int Insert(Size2Info oParam)
{
string sql = @"INSERT INTO Size2
(
Size1SysNo, Size2ID, Size2Name,
Status
)
VALUES (
@Size1SysNo, @Size2ID, @Size2Name,
@Status
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSize1SysNo = new SqlParameter("@Size1SysNo", SqlDbType.Int, 4);
SqlParameter paramSize2ID = new SqlParameter("@Size2ID", SqlDbType.NVarChar, 20);
SqlParameter paramSize2Name = new SqlParameter("@Size2Name", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSize1SysNo.Value = oParam.Size1SysNo;
paramSize2ID.Value = oParam.Size2ID;
paramSize2Name.Value = oParam.Size2Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSize1SysNo);
cmd.Parameters.Add(paramSize2ID);
cmd.Parameters.Add(paramSize2Name);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
public void Insert(Size2Info oParam)
{
foreach (Size2Info item in Size2Hash.Values)
{
if (item.Size2ID == oParam.Size2ID)
throw new BizException("the same second Size ID exists");
}
oParam.SysNo = SequenceDac.GetInstance().Create("Size_Sequence");
new SizeDac().Insert(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Category);
Size2Hash.Add(oParam.SysNo, oParam);
}
private void Map(Size2Info oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.Size1SysNo = Util.TrimIntNull(tempdr["Size1SysNo"]);
oParam.Size2ID = Util.TrimNull(tempdr["Size2ID"]);
oParam.Size2Name = Util.TrimNull(tempdr["Size2Name"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
private void InitSize2()
{
lock (categoryLocker)
{
Size2Hash.Clear();
string sql = " select * from Size2 ";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return;
foreach (DataRow dr in ds.Tables[0].Rows)
{
Size2Info item = new Size2Info();
Map(item, dr);
Size2Hash.Add(item.SysNo, item);
}
}
}
public void Update(Size2Info oParam)
{
foreach (Size2Info item in Size2Hash.Values)
{
if (item.SysNo != oParam.SysNo && item.Size2ID == oParam.Size2ID)
throw new BizException("the same Size ID exists");
}
new SizeDac().Update(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Category);
if (Size2Hash.ContainsKey(oParam.SysNo))
{
Size2Hash.Remove(oParam.SysNo);
Size2Hash.Add(oParam.SysNo, oParam);
}
}
public void UpdateSize2(Size2Info oParam)
{
string sql = "select * from size2 where Size2ID=" + oParam.Size2ID + " and SysNo<>" + oParam.SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("��ͬID��ŵij����Ѵ���");
new SizeDac().Update(oParam);
}
public Size2Info LoadSize2(int SysNo)
{
string sql = "select * from size2 where sysno=" + SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return null;
Size2Info oInfo = new Size2Info();
map(oInfo, ds.Tables[0].Rows[0]);
return oInfo;
}
public void InsertSize2(Size2Info oParam)
{
new SizeDac().Insert(oParam);
}
public int Update(Size2Info oParam)
{
string sql = @"UPDATE Size2 SET
Size1SysNo=@Size1SysNo,
Size2ID=@Size2ID, Size2Name=@Size2Name,
Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSize1SysNo = new SqlParameter("@Size1SysNo", SqlDbType.Int, 4);
SqlParameter paramSize2ID = new SqlParameter("@Size2ID", SqlDbType.NVarChar, 20);
SqlParameter paramSize2Name = new SqlParameter("@Size2Name", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Value = oParam.SysNo;
paramSize1SysNo.Value = oParam.Size1SysNo;
paramSize2ID.Value = oParam.Size2ID;
paramSize2Name.Value = oParam.Size2Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSize1SysNo);
cmd.Parameters.Add(paramSize2ID);
cmd.Parameters.Add(paramSize2Name);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}