public void Init() { BasicInfo = new ProductBasicInfo(); PriceInfo = new ProductPriceInfo(); AttributeInfo = new ProductAttributeInfo(); StatusInfo = new ProductStatusInfo(); BarcodeInfo = new ProductBarcodeInfo(); }
public void Init() { BasicInfo = new ProductBasicInfo(); PriceInfo = new ProductPriceInfo(); AttributeInfo = new ProductAttributeInfo(); StatusInfo = new ProductStatusInfo(); BarcodeInfo = new ProductBarcodeInfo(); }
public void AddMMbuyProduct(ProductBasicInfo oBasic) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { //Insert Basic Info //oBasic.ProductID = GenerateNewProductID(oBasic.C3SysNo); oBasic.ProductID = oBasic.ProductID; ProductManager.GetInstance().InsertBasic(oBasic); //Insert Status Info ProductStatusInfo oStatus = new ProductStatusInfo(); oStatus.ProductSysNo = oBasic.SysNo; oStatus.AllowStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.InfoStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.PicStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.PriceStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.WarrantyStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.WeightStatus = (int)AppEnum.ProductStatusInfo.Valid; oStatus.PreviewStatus = (int)AppEnum.ProductStatusInfo.Valid; ProductManager.GetInstance().InsertStatus(oStatus); //Insert Price Info ProductPriceInfo oPrice = new ProductPriceInfo(); oPrice.ProductSysNo = oBasic.SysNo; oPrice.ClearanceSale = (int)AppEnum.YNStatus.Yes; oPrice.IsWholeSale = (int)AppEnum.YNStatus.No; oPrice.Q1 = 0; oPrice.Q2 = 0; oPrice.Q3 = 0; oPrice.P1 = AppConst.DefaultPrice; oPrice.P2 = AppConst.DefaultPrice; oPrice.P3 = AppConst.DefaultPrice; oPrice.PointType = (int)AppEnum.ProductPayType.BothSupported; oPrice.Point = 0; oPrice.CashRebate = 0m; oPrice.UnitCost = 0; oPrice.BasicPrice = AppConst.DefaultPrice; oPrice.CurrentPrice = AppConst.DefaultPrice; oPrice.Discount = oPrice.CurrentPrice / oPrice.BasicPrice; ProductManager.GetInstance().InsertPrice(oPrice); //��ʼ����� InventoryManager.GetInstance().InitInventory(oBasic.SysNo); scope.Complete(); } }
public ProductBasicInfo LoadTargetbyRegisterSysNo(int sysno) { ProductBasicInfo oProduct = new ProductBasicInfo(); string sql = "select TargetProductSysNo from RMA_Return_Item (NOLOCK) where RegisterSysNo=" + sysno; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { DataRow dr = ds.Tables[0].Rows[0]; oProduct = ProductManager.GetInstance().LoadBasic(Util.TrimIntNull(dr["TargetProductSysNo"])); } return oProduct; }
public Hashtable GetProductBoundleWithStockPosition1(int stockSysNo, Hashtable sysnoHt) { if (sysnoHt == null || sysnoHt.Count == 0) return null; string sql = "select product.sysno,product.barcode,product.DefaultVendorSysNo, product.productid, product.productname,DMS,OPL,product.MultiPicNum,product.ProductMode,inventory_stock.position1 as stockposition1 from product inner join inventory_stock on product.sysno=inventory_stock.productsysno where inventory_stock.stocksysno=@stocksysno and product.sysno in ("; sql = sql.Replace("@stocksysno", stockSysNo.ToString()); int index = 0; foreach (int item in sysnoHt.Keys) { if (index != 0) sql += ","; sql += item.ToString(); index++; } sql += ")"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; Hashtable ht = new Hashtable(5); foreach (DataRow dr in ds.Tables[0].Rows) { ProductBasicInfo item = new ProductBasicInfo(); mapBasic(item, dr, false); ht.Add(item.SysNo, item); } return ht; }
public Hashtable GetProductBoundle(Hashtable sysnoHt) { if (sysnoHt == null || sysnoHt.Count == 0) return null; string sql = "select sysno, productid, productname,PromotionWord,BriefName,MultiPicNum,ProductMode,DMS,OPL,barcode,DefaultVendorSysNo from product where sysno in ("; int index = 0; foreach (int item in sysnoHt.Keys) { if (index != 0) sql += ","; sql += item.ToString(); index++; } sql += ")"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; Hashtable ht = new Hashtable(5); foreach (DataRow dr in ds.Tables[0].Rows) { ProductBasicInfo item = new ProductBasicInfo(); mapBasic(item, dr, false); ht.Add(item.SysNo, item); } return ht; }
public SortedList GetC3Product(int paramC3SysNo) { Hashtable ht = new Hashtable(); ht.Add("c3sysno", paramC3SysNo); DataSet ds = OnlineListManager.GetInstance().GetC3ProductShowList(ht); if (!Util.HasMoreRow(ds)) return null; SortedList sl = new SortedList(ds.Tables[0].Rows.Count); foreach (DataRow dr in ds.Tables[0].Rows) { ProductBasicInfo item = new ProductBasicInfo(); mapBasic(item, dr, true); sl.Add(item.SysNo, item); } return sl; }
public ProductBasicInfo LoadBasic(int productSysNo) { string sql = "select * from product where sysno=" + productSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); ProductBasicInfo oBasic = new ProductBasicInfo(); if (Util.HasMoreRow(ds)) mapBasic(oBasic, ds.Tables[0].Rows[0], true); else oBasic = null; return oBasic; }
/// <summary> /// ����SysNo�б��ȡ״̬ΪShow����Ʒ��Ϣ /// </summary> /// <param name="sysNoList"></param> /// <returns></returns> public ArrayList GetBrowseHistoryList(string sysNoList) { if (sysNoList == null || sysNoList == string.Empty) { return null; } string sql = @"SELECT sysNo, ProductID, ProductName,PromotionWord,briefname FROM product (NOLOCK) WHERE Status = " + (int)AppEnum.ProductStatus.Show + " AND sysno in (" + sysNoList + ")"; try { DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; //�����ݿ��ȡ�����ݷ���Hashtable Hashtable ht = new Hashtable(10); foreach (DataRow dr in ds.Tables[0].Rows) { ProductBasicInfo oP = new ProductBasicInfo(); oP.SysNo = Util.TrimIntNull(dr["SysNo"]); oP.ProductID = Util.TrimNull(dr["ProductID"]); oP.ProductName = Util.TrimNull(dr["ProductName"]); ht.Add(oP.SysNo.ToString(), oP); } //���ݴ���������� ArrayList al = new ArrayList(10); string[] sysArr = sysNoList.Split(','); for (int i = 0; i < sysArr.Length; i++) { if (ht.Contains(sysArr[i])) //�п�����ƷStatus�仯,����ht���cookie�е��� al.Add(ht[sysArr[i]]); } return al; } catch { return null; } }
public void UpdateBasicInfo(ProductBasicInfo oParam) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { ProductBasicDac pb = new ProductBasicDac(); pb.Update(oParam); scope.Complete(); } }
public int SetOrderNum( ProductBasicInfo oParam) { string sql = "update product set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo; SqlCommand cmd = new SqlCommand(sql); return SqlHelper.ExecuteNonQuery(cmd); }
/// <summary> /// ����С������Ʒ����ʾ˳�� /// </summary> /// <param name="oParam"></param> /// public void MoveTop(ProductBasicInfo oParam) { if (oParam.OrderNum == 1) { throw new BizException("it's the top one already"); } SortedList sl = GetC3Product(oParam.C3SysNo); if (sl == null) { throw new BizException("no attribute for this third category"); } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { ProductBasicDac o = new ProductBasicDac(); foreach (ProductBasicInfo item in sl.Values) { if (oParam.OrderNum == AppConst.IntNull || oParam.OrderNum <= 0 || item.OrderNum < oParam.OrderNum) { if (item.OrderNum != AppConst.IntNull && item.OrderNum > 0) { item.OrderNum = item.OrderNum + 1; o.SetOrderNum(item); } } } oParam.OrderNum = 1; o.SetOrderNum(oParam); scope.Complete(); } }
public void MoveUp(ProductBasicInfo oParam) { if (oParam.OrderNum == 1) { throw new BizException("it's the first one, can't be moved up"); } SortedList sl = GetC3Product(oParam.C3SysNo); if (sl == null) { throw new BizException("no attributes"); } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { ProductBasicDac o = new ProductBasicDac(); foreach (ProductBasicInfo item in sl.Values) { if (item.OrderNum == oParam.OrderNum - 1) { item.OrderNum += 1; o.SetOrderNum(item); } } oParam.OrderNum -= 1; o.SetOrderNum(oParam); scope.Complete(); } }
public Hashtable LoadProducts(Hashtable sysNoHash) { Hashtable productHash = new Hashtable(5); if (sysNoHash.Count != 0) { string strSysNo = "("; foreach (int sysNo in sysNoHash.Keys) { strSysNo += "'" + sysNo + "',"; } strSysNo = strSysNo.TrimEnd(','); strSysNo += ")"; string sql = @"select * from product p where p.sysno in " + strSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { ProductBasicInfo oInfo = new ProductBasicInfo(); mapBasic(oInfo, dr, true); productHash.Add(oInfo.SysNo, oInfo); } } } return productHash; }
public ProductBasicInfo LoadBasicBrief(string productID) { string sql = "select sysno, productid, productname,PromotionWord,briefname, MultiPicNum, ProductMode,DMS,OPL,barcode,DefaultVendorSysNo from Product where ProductID = " + Util.ToSqlString(productID); DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { ProductBasicInfo oBasic = new ProductBasicInfo(); mapBasic(oBasic, ds.Tables[0].Rows[0], false); return oBasic; } else return null; }
public ProductBasicInfo LoadBasic(string productID) { string sql = "select * from product where productid =" + Util.ToSqlString(productID); DataSet ds = SqlHelper.ExecuteDataSet(sql); ProductBasicInfo oBasic = new ProductBasicInfo(); if (Util.HasMoreRow(ds)) mapBasic(oBasic, ds.Tables[0].Rows[0], true); else oBasic = null; return oBasic; }
public void SetReturnTarget(Hashtable ht) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (ht.ContainsKey("ProductID") && ht.ContainsKey("ProductType")) { if (Util.TrimIntNull(ht["ProductType"]) == AppConst.IntNull) { Hashtable htReturn = new Hashtable(); htReturn.Add("SysNo", Util.TrimIntNull(ht["SysNo"])); htReturn.Add("TargetProductSysNo", AppConst.IntNull); htReturn.Add("ReturnProductType", AppConst.IntNull); htReturn.Add("AuditStatus", AppConst.IntNull); htReturn.Add("AuditMemo", AppConst.StringNull); htReturn.Add("AuditUserSysNo", AppConst.IntNull); htReturn.Add("AuditTime", AppConst.DateTimeNull); new RMAReturnDac().UpdateReturnTarget(htReturn); } else { string ProductID = AppConst.StringNull; //����ProductType���ɶ�Ӧ��ProductID if (Util.TrimIntNull(ht["ProductType"]) == (int)AppEnum.ProductType.Normal) { ProductID = GetInitialProductID(ht["ProductID"].ToString()); } else if (Util.TrimIntNull(ht["ProductType"]) == (int)AppEnum.ProductType.SecondHand) { //ProductID = GetInitialProductID(ht["ProductID"].ToString()); //ProductID = ProductID + "R"; ProductID = ht["NewProductID"].ToString(); //�˻����ʱ��Ϊ����ʱ��Ʒid�Ѿ��̶� } else if (Util.TrimIntNull(ht["ProductType"]) == (int)AppEnum.ProductType.Bad) { ProductID = GetInitialProductID(ht["ProductID"].ToString()); ProductID = ProductID + "B"; } else if (Util.TrimIntNull(ht["ProductType"]) == (int)AppEnum.ProductType.OtherProduct) { ProductID = ProductManager.GetInstance().LoadBasic((int)ht["TargetProductSysNo"]).ProductID; } ProductBasicInfo oProduct = new ProductBasicInfo(); oProduct = ProductManager.GetInstance().LoadBasic(ProductID); if (oProduct == null) //û����Ӧ��Ʒ,Clone ��Ʒ { ProductManager.GetInstance().ProductClone(ht["ProductID"].ToString(), ProductID, Util.TrimIntNull(ht["UserSysNo"])); oProduct = ProductManager.GetInstance().LoadBasic(ProductID); } //else //����Ӧ��Ʒ���������ӦTargetProductSyNo�ֶ� Hashtable htSetTarget = new Hashtable(); htSetTarget.Add("SysNo", Util.TrimIntNull(ht["SysNo"])); htSetTarget.Add("TargetProductSysNo", oProduct.SysNo); htSetTarget.Add("ReturnProductType", (int)ht["ProductType"]); if (Util.TrimIntNull(ht["ProductType"]) == (int)AppEnum.ProductType.OtherProduct) { htSetTarget.Add("AuditStatus", (int)AppEnum.TriStatus.Origin); } else { htSetTarget.Add("AuditStatus", AppConst.IntNull); } htSetTarget.Add("AuditMemo", AppConst.StringNull); htSetTarget.Add("AuditUserSysNo", AppConst.IntNull); htSetTarget.Add("AuditTime", AppConst.DateTimeNull); new RMAReturnDac().UpdateReturnTarget(htSetTarget); } } UpdateReturnItemCost(ht); //�������ɱ� scope.Complete(); } }
public void ImportBasic() { if (!AppConfig.IsImportable) throw new BizException("IsImportable is false"); string sql = "select top 1 * from product"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("the table Product is not empty"); string sql_product_distinct = "select productid from ipp2003..product group by productid having count(productid)>=2"; DataSet ds_product_distinct = SqlHelper.ExecuteDataSet(sql_product_distinct); if (Util.HasMoreRow(ds_product_distinct)) throw new BizException("the ipp2003..product has item using the same id"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sqli = @"select p.sysno,p.productid,pl.productmode,pl.productname,pl.productdescription as productdesc, producttype, pl.otherinfo as productdesclong,pl.performance,isnull(pl.warrantyclause,'�ޱ���') as warranty,pl.packlist as packagelist, isnull(p.netweight,0) as weight,c3.newsysno as C3SysNo,m.newsysno as ManufacturerSysNo,su.newsysno as CreateUserSysNo, su1.newsysno as PMUsersysno,su2.newsysno as ppmusersysno,isnull(p.mpicnum,0) as MultiPicNum,p.ProductLink,p.createtime, pl.note as Attention ,p.barcode,p.status,p.memo as note,p.islarge, con_vendor.newsysno as lastvendorsysno from ipp2003..product p left join ipp2003..product_language pl on p.sysno = pl.productsysno left join ippConvert..category3 c3 on c3.oldsysno = p.categorysysno left join ippConvert..manufacturer m on m.oldsysno = p.producersysno left join ippConvert..Sys_User su on su.oldsysno = p.createusersysno left join ippConvert..Sys_User su1 on su1.oldsysno = p.pmusersysno left join ippConvert..Sys_User su2 on su2.oldsysno = p.ppmusersysno left join ippConvert..vendor con_vendor on con_vendor.oldsysno = p.lastvendorsysno where pl.languageid='cn'"; DataSet dsi = SqlHelper.ExecuteDataSet(sqli); foreach (DataRow dr in dsi.Tables[0].Rows) { ProductBasicInfo oBasic = new ProductBasicInfo(); oBasic.ProductID = Util.TrimNull(dr["ProductID"]); oBasic.ProductMode = Util.TrimNull(dr["ProductMode"]); oBasic.ProductType = Util.TrimIntNull(dr["ProductType"]); //old type == new type oBasic.ProductName = Util.TrimNull(dr["ProductName"]); oBasic.ProductDesc = Util.TrimNull(dr["ProductDesc"]); oBasic.ProductDescLong = Util.TrimNull(dr["ProductDescLong"]); oBasic.Performance = Util.TrimNull(dr["Performance"]); oBasic.Warranty = Util.TrimNull(dr["Warranty"]); oBasic.PackageList = Util.TrimNull(dr["PackageList"]); oBasic.Weight = Convert.ToInt32(Util.TrimDecimalNull(dr["Weight"])); oBasic.C3SysNo = Util.TrimIntNull(dr["C3SysNo"]); if (oBasic.C3SysNo == AppConst.IntNull) oBasic.C3SysNo = 3810; oBasic.ManufacturerSysNo = Util.TrimIntNull(dr["ManufacturerSysNo"]); oBasic.ProductLink = Util.TrimNull(dr["ProductLink"]); oBasic.MultiPicNum = Util.TrimIntNull(dr["MultiPicNum"]); oBasic.PMUserSysNo = Util.TrimIntNull(dr["PMUserSysNo"]); oBasic.PPMUserSysNo = Util.TrimIntNull(dr["PPMUserSysNo"]); oBasic.CreateUserSysNo = Util.TrimIntNull(dr["CreateUserSysNo"]); if (oBasic.CreateUserSysNo == AppConst.IntNull) oBasic.CreateUserSysNo = -1; oBasic.CreateTime = Util.TrimDateNull(dr["CreateTime"]); oBasic.Attention = Util.TrimNull(dr["Attention"]); oBasic.Note = Util.TrimNull(dr["Note"]); oBasic.BarCode = Util.TrimNull(dr["BarCode"]); oBasic.Status = Util.TrimIntNull(dr["Status"]); oBasic.IsLarge = Util.TrimIntNull(dr["IsLarge"]); oBasic.LastVendorSysNo = Util.TrimIntNull(dr["LastVendorSysNo"]); oBasic.SysNo = SequenceDac.GetInstance().Create("Product_Sequence"); new ProductBasicDac().Insert(oBasic); //this.InsertBasic(oBasic); productid Ψһ��check��ǰ��ͳһ��ɣ��Լӿ��ٶȡ� //insert into convert table ImportInfo oProductBasicConvert = new ImportInfo(); oProductBasicConvert.OldSysNo = Util.TrimIntNull(dr["SysNo"]); oProductBasicConvert.NewSysNo = oBasic.SysNo; new ImportDac().Insert(oProductBasicConvert, "ProductBasic"); } scope.Complete(); } }
public void EditProduct(ProductBasicInfo oBasic, ProductStatusInfo oStatus) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { ProductManager.GetInstance().UpdateBasicInfo(oBasic); ProductManager.GetInstance().RefreshStatus(oStatus, oBasic.SysNo); scope.Complete(); } }
public int InsertBasic(ProductBasicInfo oParam) { string sql = "select * from product where ProductID=" + Util.ToSqlString(oParam.ProductID); DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("the same ProductID exists already"); oParam.SysNo = SequenceDac.GetInstance().Create("Product_Sequence"); return new ProductBasicDac().Insert(oParam); }
/// <summary> /// ������Ʒ������Ϣ(��Ʒ״̬���ⵥ������) /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int Update(ProductBasicInfo oParam) { string sql = @"UPDATE product SET ProductID=@ProductID, ProductMode=@ProductMode, ProductName=@ProductName, ProductType=@ProductType, ProductDesc=@ProductDesc, ProductDescLong=@ProductDescLong, Performance=@Performance, Warranty=@Warranty, PackageList=@PackageList, Weight=@Weight,C1SysNo=@C1SysNO, C2SysNo=@C2SysNo, C3SysNo=@C3SysNo, ManufacturerSysNo=@ManufacturerSysNo, ProductLink=@ProductLink, MultiPicNum=@MultiPicNum, PMUserSysNo=@PMUserSysNo, PPMUserSysNo=@PPMUserSysNo, Attention=@Attention, Note=@Note, BarCode=@BarCode, IsLarge=@IsLarge, LastVendorSysNo = @LastVendorSysNo, Status=@Status, PromotionWord=@PromotionWord,BriefName=@BriefName,AssessmentTitle=@AssessmentTitle, AssessmentLink=@AssessmentLink,VirtualArriveTime=@VirtualArriveTime, InventoryCycleTime=@InventoryCycleTime, DMSWeight=@DMSWeight, DMS=@DMS, OPL=@OPL ,OrderNum=@OrderNum,APMUserSysNo=@APMUserSysNo, DefaultVendorSysNo=@DefaultVendorSysNo, DefaultPurchasePrice=@DefaultPurchasePrice, Product2ndType=@Product2ndType, MasterProductSysNo=@MasterProductSysNo, ProductColor=@ProductColor, ProductSize=@ProductSize, ProducingArea=@ProducingArea, PackQuantity=@PackQuantity, MinOrderQuantity=@MinOrderQuantity, IsStoreFrontSale=@IsStoreFrontSale, SaleUnit=@SaleUnit, StorageDay=@StorageDay, IsCanPurchase=@IsCanPurchase WHERE SysNo = @SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramProductID = new SqlParameter("@ProductID", SqlDbType.NVarChar, 20); SqlParameter paramProductMode = new SqlParameter("@ProductMode", SqlDbType.NVarChar, 100); SqlParameter paramProductName = new SqlParameter("@ProductName", SqlDbType.NVarChar, 300); SqlParameter paramProductType = new SqlParameter("@ProductType", SqlDbType.Int, 4); SqlParameter paramProductDesc = new SqlParameter("@ProductDesc", SqlDbType.NVarChar, 2000); SqlParameter paramProductDescLong = new SqlParameter("@ProductDescLong", SqlDbType.NText); SqlParameter paramPerformance = new SqlParameter("@Performance", SqlDbType.NText); SqlParameter paramWarranty = new SqlParameter("@Warranty", SqlDbType.NVarChar, 200); SqlParameter paramPackageList = new SqlParameter("@PackageList", SqlDbType.NVarChar, 500); SqlParameter paramWeight = new SqlParameter("@Weight", SqlDbType.Int, 4); SqlParameter paramC1SysNo = new SqlParameter("@C1SysNo", SqlDbType.Int, 4); SqlParameter paramC2SysNo = new SqlParameter("@C2SysNo", SqlDbType.Int, 4); SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4); SqlParameter paramManufacturerSysNo = new SqlParameter("@ManufacturerSysNo", SqlDbType.Int, 4); SqlParameter paramProductLink = new SqlParameter("@ProductLink", SqlDbType.NVarChar, 200); SqlParameter paramMultiPicNum = new SqlParameter("@MultiPicNum", SqlDbType.Int, 4); SqlParameter paramPMUserSysNo = new SqlParameter("@PMUserSysNo", SqlDbType.Int, 4); SqlParameter paramPPMUserSysNo = new SqlParameter("@PPMUserSysNo", SqlDbType.Int, 4); SqlParameter paramAttention = new SqlParameter("@Attention", SqlDbType.NVarChar, 500); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 500); SqlParameter paramBarCode = new SqlParameter("@BarCode", SqlDbType.NVarChar, 30); SqlParameter paramIsLarge = new SqlParameter("@IsLarge", SqlDbType.Int, 4); SqlParameter paramLastVendorSysNo = new SqlParameter("@LastVendorSysNo", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramPromotionWord = new SqlParameter("@PromotionWord", SqlDbType.NVarChar, 30); SqlParameter paramBriefName = new SqlParameter("@BriefName", SqlDbType.NVarChar, 300); SqlParameter paramAssessmentTitle = new SqlParameter("@AssessmentTitle", SqlDbType.NVarChar, 200); SqlParameter paramAssessmentLink = new SqlParameter("@AssessmentLink", SqlDbType.NVarChar, 200); SqlParameter paramVirtualArriveTime = new SqlParameter("@VirtualArriveTime", SqlDbType.Int, 4); SqlParameter paramInventoryCycleTime = new SqlParameter("@InventoryCycleTime", SqlDbType.Int, 4); SqlParameter paramDMSWeight = new SqlParameter("@DMSWeight", SqlDbType.Decimal, 2); SqlParameter paramDMS = new SqlParameter("@DMS", SqlDbType.Decimal, 2); SqlParameter paramOPL = new SqlParameter("@OPL", SqlDbType.Int, 4); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramAPMUserSysNo = new SqlParameter("@APMUserSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultVendorSysNo = new SqlParameter("@DefaultVendorSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultPurchasePrice = new SqlParameter("@DefaultPurchasePrice", SqlDbType.Decimal, 9); SqlParameter paramProduct2ndType = new SqlParameter("@Product2ndType", SqlDbType.Int, 4); SqlParameter paramMasterProductSysNo = new SqlParameter("@MasterProductSysNo", SqlDbType.Int, 4); SqlParameter paramProductColor = new SqlParameter("@ProductColor", SqlDbType.Int, 4); SqlParameter paramProductSize = new SqlParameter("@ProductSize", SqlDbType.Int, 4); SqlParameter paramProducingArea = new SqlParameter("@ProducingArea", SqlDbType.NVarChar, 50); SqlParameter paramPackQuantity = new SqlParameter("@PackQuantity", SqlDbType.Int, 4); SqlParameter paramMinOrderQuantity = new SqlParameter("@MinOrderQuantity", SqlDbType.Int, 4); SqlParameter paramIsStoreFrontSale = new SqlParameter("@IsStoreFrontSale", SqlDbType.Int, 4); SqlParameter paramSaleUnit = new SqlParameter("@SaleUnit", SqlDbType.NVarChar, 50); SqlParameter paramStorageDay = new SqlParameter("@StorageDay", SqlDbType.Int, 4); SqlParameter paramIsCanPurchase = new SqlParameter("@IsCanPurchase", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.ProductID != AppConst.StringNull) paramProductID.Value = oParam.ProductID; else paramProductID.Value = System.DBNull.Value; if (oParam.ProductMode != AppConst.StringNull) paramProductMode.Value = oParam.ProductMode; else paramProductMode.Value = System.DBNull.Value; if (oParam.ProductName != AppConst.StringNull) paramProductName.Value = oParam.ProductName; else paramProductName.Value = System.DBNull.Value; if (oParam.ProductType != AppConst.IntNull) paramProductType.Value = oParam.ProductType; else paramProductType.Value = System.DBNull.Value; if (oParam.ProductDesc != AppConst.StringNull) paramProductDesc.Value = oParam.ProductDesc; else paramProductDesc.Value = System.DBNull.Value; if (oParam.ProductDescLong != AppConst.StringNull) paramProductDescLong.Value = oParam.ProductDescLong; else paramProductDescLong.Value = System.DBNull.Value; if (oParam.Performance != AppConst.StringNull) paramPerformance.Value = oParam.Performance; else paramPerformance.Value = System.DBNull.Value; if (oParam.Warranty != AppConst.StringNull) paramWarranty.Value = oParam.Warranty; else paramWarranty.Value = System.DBNull.Value; if (oParam.PackageList != AppConst.StringNull) paramPackageList.Value = oParam.PackageList; else paramPackageList.Value = System.DBNull.Value; if (oParam.Weight != AppConst.IntNull) paramWeight.Value = oParam.Weight; else paramWeight.Value = System.DBNull.Value; if (oParam.C1SysNo != AppConst.IntNull) { paramC1SysNo.Value = oParam.C1SysNo; } else { paramC1SysNo.Value = System.DBNull.Value; } if (oParam.C2SysNo != AppConst.IntNull) { paramC2SysNo.Value = oParam.C2SysNo; } else { paramC2SysNo.Value = System.DBNull.Value; } if (oParam.C3SysNo != AppConst.IntNull) paramC3SysNo.Value = oParam.C3SysNo; else paramC3SysNo.Value = System.DBNull.Value; if (oParam.ManufacturerSysNo != AppConst.IntNull) paramManufacturerSysNo.Value = oParam.ManufacturerSysNo; else paramManufacturerSysNo.Value = System.DBNull.Value; if (oParam.ProductLink != AppConst.StringNull) paramProductLink.Value = oParam.ProductLink; else paramProductLink.Value = System.DBNull.Value; if (oParam.MultiPicNum != AppConst.IntNull) paramMultiPicNum.Value = oParam.MultiPicNum; else paramMultiPicNum.Value = System.DBNull.Value; if (oParam.PMUserSysNo != AppConst.IntNull) paramPMUserSysNo.Value = oParam.PMUserSysNo; else paramPMUserSysNo.Value = System.DBNull.Value; if (oParam.PPMUserSysNo != AppConst.IntNull) paramPPMUserSysNo.Value = oParam.PPMUserSysNo; else paramPPMUserSysNo.Value = System.DBNull.Value; if (oParam.Attention != AppConst.StringNull) paramAttention.Value = oParam.Attention; else paramAttention.Value = System.DBNull.Value; if (oParam.Note != AppConst.StringNull) paramNote.Value = oParam.Note; else paramNote.Value = System.DBNull.Value; if (oParam.BarCode != AppConst.StringNull) paramBarCode.Value = oParam.BarCode; else paramBarCode.Value = System.DBNull.Value; if (oParam.IsLarge != AppConst.IntNull) paramIsLarge.Value = oParam.IsLarge; else paramIsLarge.Value = System.DBNull.Value; if (oParam.LastVendorSysNo != AppConst.IntNull) paramLastVendorSysNo.Value = oParam.LastVendorSysNo; else paramLastVendorSysNo.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; if (oParam.PromotionWord != AppConst.StringNull) paramPromotionWord.Value = oParam.PromotionWord; else paramPromotionWord.Value = System.DBNull.Value; if (oParam.BriefName != AppConst.StringNull) paramBriefName.Value = oParam.BriefName; else paramBriefName.Value = System.DBNull.Value; if (oParam.AssessmentTitle != AppConst.StringNull) paramAssessmentTitle.Value = oParam.AssessmentTitle; else paramAssessmentTitle.Value = System.DBNull.Value; if (oParam.AssessmentLink != AppConst.StringNull) paramAssessmentLink.Value = oParam.AssessmentLink; else paramAssessmentLink.Value = System.DBNull.Value; if (oParam.VirtualArriveTime != AppConst.IntNull) paramVirtualArriveTime.Value = oParam.VirtualArriveTime; else paramVirtualArriveTime.Value = System.DBNull.Value; if (oParam.InventoryCycleTime != AppConst.IntNull) paramInventoryCycleTime.Value = oParam.InventoryCycleTime; else paramInventoryCycleTime.Value = System.DBNull.Value; if (oParam.DMSWeight != AppConst.DecimalNull) paramDMSWeight.Value = oParam.DMSWeight; else paramDMSWeight.Value = System.DBNull.Value; if (oParam.DMS != AppConst.DecimalNull) paramDMS.Value = oParam.DMS; else paramDMS.Value = System.DBNull.Value; if (oParam.OPL != AppConst.IntNull) paramOPL.Value = oParam.OPL; else paramOPL.Value = System.DBNull.Value; if (oParam.OrderNum != AppConst.IntNull) paramOrderNum.Value = oParam.OrderNum; else paramOrderNum.Value = System.DBNull.Value; if (oParam.APMUserSysNo != AppConst.IntNull) paramAPMUserSysNo.Value = oParam.APMUserSysNo; else paramAPMUserSysNo.Value = System.DBNull.Value; if (oParam.DefaultVendorSysNo != AppConst.IntNull) paramDefaultVendorSysNo.Value = oParam.DefaultVendorSysNo; else paramDefaultVendorSysNo.Value = System.DBNull.Value; if (oParam.DefaultPurchasePrice != AppConst.DecimalNull) paramDefaultPurchasePrice.Value = oParam.DefaultPurchasePrice; else paramDefaultPurchasePrice.Value = System.DBNull.Value; if (oParam.Product2ndType != AppConst.IntNull) paramProduct2ndType.Value = oParam.Product2ndType; else paramProduct2ndType.Value = System.DBNull.Value; if (oParam.MasterProductSysNo != AppConst.IntNull) paramMasterProductSysNo.Value = oParam.MasterProductSysNo; else paramMasterProductSysNo.Value = System.DBNull.Value; if (oParam.ProductColor != AppConst.IntNull) paramProductColor.Value = oParam.ProductColor; else paramProductColor.Value = System.DBNull.Value; if (oParam.ProductSize != AppConst.IntNull) paramProductSize.Value = oParam.ProductSize; else paramProductSize.Value = System.DBNull.Value; if (oParam.ProducingArea != AppConst.StringNull) paramProducingArea.Value = oParam.ProducingArea; else paramProducingArea.Value = System.DBNull.Value; if (oParam.PackQuantity != AppConst.IntNull) paramPackQuantity.Value = oParam.PackQuantity; else paramPackQuantity.Value = System.DBNull.Value; if (oParam.MinOrderQuantity != AppConst.IntNull) paramMinOrderQuantity.Value = oParam.MinOrderQuantity; else paramMinOrderQuantity.Value = System.DBNull.Value; if (oParam.IsStoreFrontSale != AppConst.IntNull) paramIsStoreFrontSale.Value = oParam.IsStoreFrontSale; else paramIsStoreFrontSale.Value = System.DBNull.Value; if (oParam.SaleUnit != AppConst.StringNull) paramSaleUnit.Value = oParam.SaleUnit; else paramSaleUnit.Value = System.DBNull.Value; if (oParam.StorageDay != AppConst.IntNull) paramStorageDay.Value = oParam.StorageDay; else paramStorageDay.Value = System.DBNull.Value; if (oParam.IsCanPurchase !=AppConst.IntNull) { paramIsCanPurchase.Value=oParam.IsCanPurchase; } else { paramIsCanPurchase.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramProductID); cmd.Parameters.Add(paramProductMode); cmd.Parameters.Add(paramProductName); cmd.Parameters.Add(paramProductType); cmd.Parameters.Add(paramProductDesc); cmd.Parameters.Add(paramProductDescLong); cmd.Parameters.Add(paramPerformance); cmd.Parameters.Add(paramWarranty); cmd.Parameters.Add(paramPackageList); cmd.Parameters.Add(paramWeight); cmd.Parameters.Add(paramC1SysNo); cmd.Parameters.Add(paramC2SysNo); cmd.Parameters.Add(paramC3SysNo); cmd.Parameters.Add(paramManufacturerSysNo); cmd.Parameters.Add(paramProductLink); cmd.Parameters.Add(paramMultiPicNum); cmd.Parameters.Add(paramPMUserSysNo); cmd.Parameters.Add(paramPPMUserSysNo); cmd.Parameters.Add(paramAttention); cmd.Parameters.Add(paramNote); cmd.Parameters.Add(paramBarCode); cmd.Parameters.Add(paramIsLarge); cmd.Parameters.Add(paramLastVendorSysNo); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramPromotionWord); cmd.Parameters.Add(paramBriefName); cmd.Parameters.Add(paramAssessmentTitle); cmd.Parameters.Add(paramAssessmentLink); cmd.Parameters.Add(paramVirtualArriveTime); cmd.Parameters.Add(paramInventoryCycleTime); cmd.Parameters.Add(paramDMSWeight); cmd.Parameters.Add(paramDMS); cmd.Parameters.Add(paramOPL); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramAPMUserSysNo); cmd.Parameters.Add(paramDefaultVendorSysNo); cmd.Parameters.Add(paramDefaultPurchasePrice); cmd.Parameters.Add(paramProduct2ndType); cmd.Parameters.Add(paramMasterProductSysNo); cmd.Parameters.Add(paramProductColor); cmd.Parameters.Add(paramProductSize); cmd.Parameters.Add(paramProducingArea); cmd.Parameters.Add(paramPackQuantity); cmd.Parameters.Add(paramMinOrderQuantity); cmd.Parameters.Add(paramIsStoreFrontSale); cmd.Parameters.Add(paramSaleUnit); cmd.Parameters.Add(paramStorageDay); cmd.Parameters.Add(paramIsCanPurchase); return SqlHelper.ExecuteNonQuery(cmd); }
private void mapBasic(ProductBasicInfo oParam, DataRow tempdr, bool isFull) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ProductID = Util.TrimNull(tempdr["ProductID"]); oParam.ProductName = Util.TrimNull(tempdr["ProductName"]); oParam.PromotionWord = Util.TrimNull(tempdr["PromotionWord"]); oParam.BriefName = Util.TrimNull(tempdr["BriefName"]); oParam.MultiPicNum = Util.TrimIntNull(tempdr["MultiPicNum"]); oParam.ProductMode = Util.TrimNull(tempdr["ProductMode"]); oParam.DMS = Util.TrimDecimalNull(tempdr["DMS"]); oParam.OPL = Util.TrimIntNull(tempdr["OPL"]); oParam.BarCode = Util.TrimNull(tempdr["Barcode"]); oParam.DefaultVendorSysNo = Util.TrimIntNull(tempdr["DefaultVendorSysNo"]); if (isFull) { oParam.ProductType = Util.TrimIntNull(tempdr["ProductType"]); oParam.ProductDesc = Util.TrimNull(tempdr["ProductDesc"]); oParam.ProductDescLong = Util.TrimNull(tempdr["ProductDescLong"]); oParam.Performance = Util.TrimNull(tempdr["Performance"]); oParam.Warranty = Util.TrimNull(tempdr["Warranty"]); oParam.PackageList = Util.TrimNull(tempdr["PackageList"]); oParam.Weight = Util.TrimIntNull(tempdr["Weight"]); oParam.C1SysNo = Util.TrimIntNull(tempdr["C1SysNo"]); oParam.C2SysNo = Util.TrimIntNull(tempdr["C2SysNo"]); oParam.C3SysNo = Util.TrimIntNull(tempdr["C3SysNo"]); oParam.ManufacturerSysNo = Util.TrimIntNull(tempdr["ManufacturerSysNo"]); oParam.ProductLink = Util.TrimNull(tempdr["ProductLink"]); //oParam.MultiPicNum = Util.TrimIntNull(tempdr["MultiPicNum"]); oParam.PMUserSysNo = Util.TrimIntNull(tempdr["PMUserSysNo"]); oParam.PPMUserSysNo = Util.TrimIntNull(tempdr["PPMUserSysNo"]); oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]); oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]); oParam.Attention = Util.TrimNull(tempdr["Attention"]); oParam.Note = Util.TrimNull(tempdr["Note"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); oParam.IsLarge = Util.TrimIntNull(tempdr["IsLarge"]); oParam.LastVendorSysNo = Util.TrimIntNull(tempdr["LastVendorSysNo"]); oParam.PromotionWord = Util.TrimNull(tempdr["PromotionWord"]); oParam.BriefName = Util.TrimNull(tempdr["BriefName"]); oParam.AssessmentTitle = Util.TrimNull(tempdr["AssessmentTitle"]); oParam.AssessmentLink = Util.TrimNull(tempdr["AssessmentLink"]); oParam.VirtualArriveTime = Util.TrimIntNull(tempdr["VirtualArriveTime"]); oParam.InventoryCycleTime = Util.TrimIntNull(tempdr["InventoryCycleTime"]); oParam.DMSWeight = Util.TrimDecimalNull(tempdr["DMSWeight"]); oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]); oParam.APMUserSysNo = Util.TrimIntNull(tempdr["APMUserSysNo"]); oParam.DefaultPurchasePrice = Util.TrimDecimalNull(tempdr["DefaultPurchasePrice"]); oParam.Product2ndType = Util.TrimIntNull(tempdr["Product2ndType"]); oParam.MasterProductSysNo = Util.TrimIntNull(tempdr["MasterProductSysNo"]); oParam.ProductColor = Util.TrimIntNull(tempdr["ProductColor"]); oParam.ProductSize = Util.TrimIntNull(tempdr["ProductSize"]); oParam.ProducingArea = Util.TrimNull(tempdr["ProducingArea"]); oParam.PackQuantity = Util.TrimIntNull(tempdr["PackQuantity"]); oParam.MinOrderQuantity = Util.TrimIntNull(tempdr["MinOrderQuantity"]); oParam.IsStoreFrontSale = Util.TrimIntNull(tempdr["IsStoreFrontSale"]); oParam.SaleUnit = Util.TrimNull(tempdr["SaleUnit"]); oParam.StorageDay = Util.TrimIntNull(tempdr["StorageDay"]); oParam.IsCanPurchase = Util.TrimIntNull(tempdr["IsCanPurchase"]); } }