public int CompareTo(object obj)
{
PrjItemInfo b = obj as PrjItemInfo;
if (this.SysNo > b.SysNo)
{
return(1);
}
else
{
return(-1);
}
}
public int Update(PrjItemInfo oParam)
{
string sql = @"UPDATE Prj_Item SET
PrjSysNo=@PrjSysNo, SlnItemSysNo=@SlnItemSysNo, DefaultProductSysNo=@DefaultProductSysNo, DefaultQty=@DefaultQty,
IsShowPic=@IsShowPic, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4);
SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty",SqlDbType.Int,4);
SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic",SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.PrjSysNo != AppConst.IntNull)
paramPrjSysNo.Value = oParam.PrjSysNo;
else
paramPrjSysNo.Value = System.DBNull.Value;
if (oParam.SlnItemSysNo != AppConst.IntNull)
paramSlnItemSysNo.Value = oParam.SlnItemSysNo;
else
paramSlnItemSysNo.Value = System.DBNull.Value;
if (oParam.DefaultProductSysNo != AppConst.IntNull)
paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo;
else
paramDefaultProductSysNo.Value = System.DBNull.Value;
if (oParam.DefaultQty != AppConst.IntNull)
paramDefaultQty.Value = oParam.DefaultQty;
else
paramDefaultQty.Value = System.DBNull.Value;
if (oParam.IsShowPic != AppConst.IntNull)
paramIsShowPic.Value = oParam.IsShowPic;
else
paramIsShowPic.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjSysNo);
cmd.Parameters.Add(paramSlnItemSysNo);
cmd.Parameters.Add(paramDefaultProductSysNo);
cmd.Parameters.Add(paramDefaultQty);
cmd.Parameters.Add(paramIsShowPic);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(PrjItemInfo oParam)
{
string sql = @"INSERT INTO Prj_Item
(
PrjSysNo, SlnItemSysNo, DefaultProductSysNo, DefaultQty, IsShowPic, Status
)
VALUES (
@PrjSysNo, @SlnItemSysNo, @DefaultProductSysNo, @DefaultQty, @IsShowPic, @Status
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4);
SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4);
SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic",SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PrjSysNo != AppConst.IntNull)
paramPrjSysNo.Value = oParam.PrjSysNo;
else
paramPrjSysNo.Value = System.DBNull.Value;
if (oParam.SlnItemSysNo != AppConst.IntNull)
paramSlnItemSysNo.Value = oParam.SlnItemSysNo;
else
paramSlnItemSysNo.Value = System.DBNull.Value;
if (oParam.DefaultProductSysNo != AppConst.IntNull)
paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo;
else
paramDefaultProductSysNo.Value = System.DBNull.Value;
if (oParam.DefaultQty != AppConst.IntNull)
paramDefaultQty.Value = oParam.DefaultQty;
else
paramDefaultQty.Value = System.DBNull.Value;
if (oParam.IsShowPic != AppConst.IntNull)
paramIsShowPic.Value = oParam.IsShowPic;
else
paramIsShowPic.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjSysNo);
cmd.Parameters.Add(paramSlnItemSysNo);
cmd.Parameters.Add(paramDefaultProductSysNo);
cmd.Parameters.Add(paramDefaultQty);
cmd.Parameters.Add(paramIsShowPic);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public PrjItemInfo LoadPrjItem(int SysNo)
{
string sql = "select * from prj_item where sysno=" + SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
PrjItemInfo oParam = new PrjItemInfo();
if (Util.HasMoreRow(ds))
mapPrjItem(oParam, ds.Tables[0].Rows[0]);
else
oParam = null;
return oParam;
}
public int InsertUpdatePrjItem(PrjItemInfo oParam)
{
string sql = "select * from prj_item where prjsysno = " + oParam.PrjSysNo + " and SlnItemSysNo=" + oParam.SlnItemSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
oParam.SysNo = Util.TrimIntNull(ds.Tables[0].Rows[0]["sysno"]);
return new PrjDac().Update(oParam);
}
else
{
return new PrjDac().Insert(oParam);
}
}
public int InsertPrjItem(PrjItemInfo oParam)
{
string sql = "select * from prj_item where prjsysno = " + oParam.PrjSysNo + " and SlnItemSysNo=" + oParam.SlnItemSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the same exists already");
return new PrjDac().Insert(oParam);
}
public SortedList GetPrjItemList(int PrjSysNo)
{
string sql = @"select * from prj_item where prjsysno = @prjysno";
sql = sql.Replace("@prjysno", PrjSysNo.ToString());
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return null;
SortedList sl = new SortedList(ds.Tables[0].Rows.Count);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PrjItemInfo item = new PrjItemInfo();
mapPrjItem(item, dr);
sl.Add(item, null);
}
return sl;
}
private void mapPrjItem(PrjItemInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.PrjSysNo = Util.TrimIntNull(tempdr["PrjSysNo"]);
oParam.SlnItemSysNo = Util.TrimIntNull(tempdr["SlnItemSysNo"]);
oParam.DefaultProductSysNo = Util.TrimIntNull(tempdr["DefaultProductSysNo"]);
oParam.DefaultQty = Util.TrimIntNull(tempdr["DefaultQty"]);
oParam.IsShowPic = Util.TrimIntNull(tempdr["IsShowPic"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
public void UpdatePrjItem(PrjItemInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
new PrjDac().Update(oParam);
scope.Complete();
}
}
