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