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); }