public int Update(OnlineC1_ProductInfo oParam)
{
string sql = @"UPDATE OnlineC1_Product SET
ProductSysNo=@ProductSysNo,ProductBriefName=@ProductBriefName, OrderNum=@OrderNum
WHERE ProductSysNo=@ProductSysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramProductBriefName = new SqlParameter("@ProductBriefName",SqlDbType.NVarChar,200);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
if (oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if (oParam.ProductBriefName != AppConst.StringNull)
paramProductBriefName.Value = oParam.ProductBriefName;
else
paramProductBriefName.Value = System.DBNull.Value;
if (oParam.OrderNum != AppConst.IntNull)
paramOrderNum.Value = oParam.OrderNum;
else
paramOrderNum.Value = System.DBNull.Value;
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramProductBriefName);
cmd.Parameters.Add(paramOrderNum);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int CompareTo(object obj)
{
OnlineC1_ProductInfo b = obj as OnlineC1_ProductInfo;
if (this.OrderNum > b.OrderNum)
{
return(1);
}
else
{
return(-1);
}
}
public int Delete(OnlineC1_ProductInfo oParam)
{
string sql = "DELETE OnlineC1_Product where ProductSysNo=@ProductSysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
if (oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramProductSysNo);
return SqlHelper.ExecuteNonQuery(cmd);
}
private void map(OnlineC1_ProductInfo oParam, DataRow tempdr)
{
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.ProductBriefName = Util.TrimNull(tempdr["ProductBriefName"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
}
public void MoveUp(OnlineC1_ProductInfo oParam)
{
if (oParam.OrderNum == 1)
{
throw new BizException("it's the first one, can't be moved up");
}
SortedList sl = GetOnlineC1_ProductList(oParam.ProductSysNo);
if (sl == null)
{
throw new BizException("no items");
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
OnlineC1_ProductDac o = new OnlineC1_ProductDac();
foreach (OnlineC1_ProductInfo item in sl.Keys)
{
if (item.OrderNum == oParam.OrderNum - 1)
{
item.OrderNum += 1;
o.SetOrderNum(item);
}
}
oParam.OrderNum -= 1;
o.SetOrderNum(oParam);
scope.Complete();
}
}
public OnlineC1_ProductInfo LoadOnlineC1_Product(int ProductSysNo)
{
string sql = "select * from onlineC1_Product(nolock) where productsysno=" + ProductSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
OnlineC1_ProductInfo o = new OnlineC1_ProductInfo();
map(o, ds.Tables[0].Rows[0]);
return o;
}
else
return null;
}
public void Delete(OnlineC1_ProductInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
MoveBottom(oParam);
new OnlineC1_ProductDac().Delete(oParam);
scope.Complete();
}
}
public SortedList GetOnlineC1_ProductList(int ProductSysNo)
{
ProductBasicInfo pb = ProductManager.GetInstance().LoadBasic(ProductSysNo);
Category3Info c3 = CategoryManager.GetInstance().GetC3Hash()[pb.C3SysNo] as Category3Info;
Category2Info c2 = CategoryManager.GetInstance().GetC2Hash()[c3.C2SysNo] as Category2Info;
string sql = @"select op.* from OnlineC1_Product op(nolock) inner join product p(nolock) on op.productsysno=p.sysno
inner join category3 c3(nolock) on p.c3sysno=c3.sysno inner join category2 c2(nolock) on c3.c2sysno=c2.sysno
where c2.sysno=" + c2.SysNo + " order by op.ordernum";
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)
{
OnlineC1_ProductInfo item = new OnlineC1_ProductInfo();
map(item, dr);
sl.Add(item, null);
}
return sl;
}
public int SetOrderNum(OnlineC1_ProductInfo oParam)
{
string sql = "update onlineC1_Product set ordernum = " + oParam.OrderNum + " where productsysno = " + oParam.ProductSysNo;
SqlCommand cmd = new SqlCommand(sql);
return SqlHelper.ExecuteNonQuery(cmd);
}
