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();
}
}
private void mapStatus(ProductStatusInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.InfoStatus = Util.TrimIntNull(tempdr["InfoStatus"]);
oParam.InfoUserSysNo = Util.TrimIntNull(tempdr["InfoUserSysNo"]);
oParam.InfoTime = Util.TrimDateNull(tempdr["InfoTime"]);
oParam.PriceStatus = Util.TrimIntNull(tempdr["PriceStatus"]);
oParam.PriceUserSysNo = Util.TrimIntNull(tempdr["PriceUserSysNo"]);
oParam.PriceTime = Util.TrimDateNull(tempdr["PriceTime"]);
oParam.PicStatus = Util.TrimIntNull(tempdr["PicStatus"]);
oParam.PicUserSysNo = Util.TrimIntNull(tempdr["PicUserSysNo"]);
oParam.PicTime = Util.TrimDateNull(tempdr["PicTime"]);
oParam.WarrantyStatus = Util.TrimIntNull(tempdr["WarrantyStatus"]);
oParam.WarrantyUserSysNo = Util.TrimIntNull(tempdr["WarrantyUserSysNo"]);
oParam.WarrantyTime = Util.TrimDateNull(tempdr["WarrantyTime"]);
oParam.WeightStatus = Util.TrimIntNull(tempdr["WeightStatus"]);
oParam.WeightUserSysNo = Util.TrimIntNull(tempdr["WeightUserSysNo"]);
oParam.WeightTime = Util.TrimDateNull(tempdr["WeightTime"]);
oParam.AllowStatus = Util.TrimIntNull(tempdr["AllowStatus"]);
oParam.AllowUserSysNo = Util.TrimIntNull(tempdr["AllowUserSysNo"]);
oParam.AllowTime = Util.TrimDateNull(tempdr["AllowTime"]);
oParam.PreviewStatus = Util.TrimIntNull(tempdr["PreviewStatus"]);
oParam.PreviewUserSysNo = Util.TrimIntNull(tempdr["PreviewUserSysNo"]);
oParam.PreviewTime = Util.TrimDateNull(tempdr["PreviewTime"]);
}
public int UpdateStatusInfo(ProductStatusInfo oParam)
{
return new ProductStatusDac().Update(oParam);
}
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 void EditPrice(ProductPriceInfo oPrice, ProductStatusInfo oStatus)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//���ԭ��û��priceInfo��Add
if (oPrice.SysNo == AppConst.IntNull)
ProductManager.GetInstance().InsertPrice(oPrice);
else
ProductManager.GetInstance().UpdatePriceInfo(oPrice);
ProductManager.GetInstance().RefreshStatus(oStatus, oPrice.ProductSysNo);
scope.Complete();
}
}
/// <summary>
/// ������Ʒ��״̬��������Ʒ����״̬
/// </summary>
/// <param name="oParam"></param>
/// <param name="productStatus"></param>
public void RefreshStatus(ProductStatusInfo oParam, int productSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (oParam.SysNo == AppConst.IntNull)
{
oParam.ProductSysNo = productSysNo;
if (oParam.AllowStatus == AppConst.IntNull)
oParam.AllowStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.InfoStatus == AppConst.IntNull)
oParam.InfoStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.PicStatus == AppConst.IntNull)
oParam.PicStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.PriceStatus == AppConst.IntNull)
oParam.PriceStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.WarrantyStatus == AppConst.IntNull)
oParam.WarrantyStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.WeightStatus == AppConst.IntNull)
oParam.WeightStatus = (int)AppEnum.ProductStatusInfo.Valid;
if (oParam.PreviewStatus == AppConst.IntNull)
oParam.PreviewStatus = (int)AppEnum.ProductStatusInfo.Valid;
this.InsertStatus(oParam);
}
else
{
this.UpdateStatusInfo(oParam);
}
ProductBasicInfo pb = ProductManager.GetInstance().LoadBasic(oParam.ProductSysNo);
//����ʱ�������ж�StatusInfo
if (pb.Status != (int)AppEnum.ProductStatus.Abandon)
{
if (oParam.AllowStatus == (int)AppEnum.ProductStatusInfo.Show && oParam.InfoStatus == (int)AppEnum.ProductStatusInfo.Show
&& oParam.PicStatus == (int)AppEnum.ProductStatusInfo.Show && oParam.PriceStatus == (int)AppEnum.ProductStatusInfo.Show
&& oParam.WarrantyStatus == (int)AppEnum.ProductStatusInfo.Show && oParam.WeightStatus == (int)AppEnum.ProductStatusInfo.Show
&& oParam.PreviewStatus == (int)AppEnum.ProductStatusInfo.Show) //����Ԥ��״̬
pb.Status = (int)AppEnum.ProductStatus.Show;
else
pb.Status = (int)AppEnum.ProductStatus.Valid;
}
new ProductBasicDac().UpdateStatus(oParam.ProductSysNo, pb.Status);
scope.Complete();
}
}
public void ProductClone(string SourceID, string TargetID, int createUserSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//������Ʒ������Ϣ
ProductBasicInfo TBasic = ProductManager.GetInstance().LoadBasic(SourceID);
if (TBasic.SysNo == AppConst.IntNull)
throw new BizException("Source Product does not exist");
int SourceSysno = TBasic.SysNo;
if (TargetID != string.Empty)
TBasic.ProductID = TargetID;
else
{
if (SourceID.Substring(SourceID.Length - 1, 1).ToUpper() != "R" && SourceID.Substring(SourceID.Length - 1, 1).ToUpper() != "B")//��ƷĬ�ϸ���Ϊ����
{
TBasic.ProductID = SourceID + "R";
}
else if (SourceID.Substring(SourceID.Length - 1, 1).ToUpper() == "R")//����Ĭ�ϸ���Ϊ��Ʒ
{
TBasic.ProductID = SourceID.Substring(0, SourceID.Length - 1) + "B";
}
else if (SourceID.Substring(SourceID.Length - 1, 1).ToUpper() == "B")//��Ʒ���ṩĬ�ϸ���
{
throw new BizException("Bad Product has no default target");
}
}
if (TBasic.ProductID.ToUpper().EndsWith("R") || TBasic.ProductID.ToUpper().Substring(0, TBasic.ProductID.Length - 1).EndsWith("R"))
{
TBasic.ProductName = "�����֣�" + TBasic.ProductName.Replace("�����֣�", string.Empty).Replace("����Ʒ��", string.Empty);
TBasic.ProductType = (int)AppEnum.ProductType.SecondHand;
}
else if (TBasic.ProductID.ToUpper().EndsWith("B"))
{
TBasic.ProductName = "����Ʒ��" + TBasic.ProductName.Replace("�����֣�", string.Empty).Replace("����Ʒ��", string.Empty);
TBasic.ProductType = (int)AppEnum.ProductType.Bad;
}
TBasic.CreateUserSysNo = createUserSysNo;
TBasic.Status = (int)AppEnum.ProductStatus.Valid;
TBasic.MultiPicNum = 0;
ProductManager.GetInstance().InsertBasic(TBasic);
//���Ƽ۸���Ϣ
ProductPriceInfo TPrice = ProductManager.GetInstance().LoadPrice(SourceSysno);
if (TPrice.ProductSysNo != AppConst.IntNull)
{
TPrice.ProductSysNo = TBasic.SysNo;
ProductManager.GetInstance().InsertPrice(TPrice);
}
//״̬�����ƣ������¼�¼
ProductStatusInfo TStatus = new ProductStatusInfo();
TStatus.ProductSysNo = TBasic.SysNo;
TStatus.AllowStatus = (int)AppEnum.ProductStatusInfo.Valid;
TStatus.InfoStatus = (int)AppEnum.ProductStatusInfo.Valid;
TStatus.PicStatus = (int)AppEnum.ProductStatusInfo.Valid;
TStatus.PriceStatus = (int)AppEnum.ProductStatusInfo.Valid;
TStatus.WarrantyStatus = (int)AppEnum.ProductStatusInfo.Valid;
TStatus.WeightStatus = (int)AppEnum.ProductStatusInfo.Valid;
ProductManager.GetInstance().InsertStatus(TStatus);
//������Ʒ���� add by judy
int TargetSysno = TBasic.SysNo;
ProductManager.GetInstance().CloneAttribute2(TargetSysno, SourceSysno);
//��ʼ��Ŀ����Ʒ���
InventoryManager.GetInstance().InitInventory(TBasic.SysNo);
//���ư�ȫ��� add by judy //��ȫ����ݲ�����
//InventoryStockInfo TStock = InventoryManager.GetInstance().LoadInventoryStock2(SourceSysno);
//InventoryManager.GetInstance().SetSafeQty(TargetSysno, TStock.SafeQty, TStock.StockSysNo);
scope.Complete();
}
}
public ProductStatusInfo LoadStatus(int productSysNo)
{
string sql = " select * from product_status where productsysno=" + productSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
ProductStatusInfo oStatus = new ProductStatusInfo();
if (Util.HasMoreRow(ds))
mapStatus(oStatus, ds.Tables[0].Rows[0]);
return oStatus;
}
public int InsertStatus(ProductStatusInfo oParam)
{
string sql = "select * from product_status where productsysno =" + oParam.ProductSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the same ProductSysNo exists already");
return new ProductStatusDac().Insert(oParam);
}
public void ImportStatus()
{
if (!AppConfig.IsImportable)
throw new BizException("IsImportable is false");
string sql = "select top 1 * from product_status";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the table Product_Status is not empty");
string sql_product_distinct = "select productsysno from ipp2003..product_status group by productsysno having count(productsysno)>=2";
DataSet ds_product_distinct = SqlHelper.ExecuteDataSet(sql_product_distinct);
if (Util.HasMoreRow(ds_product_distinct))
throw new BizException("the ipp2003..product_status has item of 2 rows status info");
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 pb.newsysno as productsysno,ps.a as AllowStatus,ps.A_usersysno as allowusersysno,
ps.a_time as allowtime,ps.w as warrantystatus,ps.w_usersysno as warrantyusersysno,ps.w_time as warrantytime,
ps.p as pricestatus,ps.p_usersysno as priceusersysno,ps.p_time as pricetime,
ps.i as infostatus,ps.i_usersysno as infousersysno,ps.i_time as infotime,
ps.g as picstatus,ps.g_usersysno as picusersysno,ps.g_time as pictime
from ipp2003..product_Status ps
left join ippConvert..productbasic pb on pb.oldsysno = ps.productsysno
where ps.productsysno>0 and ps.productsysno is not null and pb.newsysno is not null";
DataSet dsi = SqlHelper.ExecuteDataSet(sqli);
foreach (DataRow dr in dsi.Tables[0].Rows)
{
ProductStatusInfo oStatus = new ProductStatusInfo();
oStatus.ProductSysNo = Util.TrimIntNull(dr["ProductSysNo"]);
if ((bool)dr["AllowStatus"])
oStatus.AllowStatus = 1;
else
oStatus.AllowStatus = 0;
oStatus.AllowUserSysNo = Util.TrimIntNull(dr["AllowUserSysNo"]);
oStatus.AllowTime = Util.TrimDateNull(dr["AllowTime"]);
if ((bool)dr["InfoStatus"])
oStatus.InfoStatus = 1;
else
oStatus.InfoStatus = 0;
oStatus.InfoUserSysNo = Util.TrimIntNull(dr["InfoUserSysNo"]);
oStatus.InfoTime = Util.TrimDateNull(dr["InfoTime"]);
if ((bool)dr["PicStatus"])
oStatus.PicStatus = 1;
else
oStatus.PicStatus = 0;
oStatus.PicUserSysNo = Util.TrimIntNull(dr["PicUserSysNo"]);
oStatus.PicTime = Util.TrimDateNull(dr["PicTime"]);
if ((bool)dr["PriceStatus"])
oStatus.PriceStatus = 1;
else
oStatus.PriceStatus = 0;
oStatus.PriceUserSysNo = Util.TrimIntNull(dr["PriceUserSysNo"]);
oStatus.PriceTime = Util.TrimDateNull(dr["PriceTime"]);
if ((bool)dr["WarrantyStatus"])
oStatus.WarrantyStatus = 1;
else
oStatus.WarrantyStatus = 0;
oStatus.WarrantyUserSysNo = Util.TrimIntNull(dr["WarrantyUserSysNo"]);
oStatus.WarrantyTime = Util.TrimDateNull(dr["WarrantyTime"]);
oStatus.WeightStatus = 0;
//this.InsertStatus(oStatus);
new ProductStatusDac().Insert(oStatus);
}
scope.Complete();
}
}
public int Insert(ProductStatusInfo oParam)
{
string sql = @"INSERT INTO Product_Status
(
ProductSysNo, InfoStatus, InfoUserSysNo,
InfoTime, PicStatus, PicUserSysNo, PicTime,
WarrantyStatus, WarrantyUserSysNo, WarrantyTime, PriceStatus,
PriceUserSysNo, PriceTime, WeightStatus, WeightUserSysNo,
WeightTime, AllowStatus, AllowUserSysNo, AllowTime,
PreviewStatus,PreviewUserSysNo,PreviewTime
)
VALUES (
@ProductSysNo, @InfoStatus, @InfoUserSysNo,
@InfoTime, @PicStatus, @PicUserSysNo, @PicTime,
@WarrantyStatus, @WarrantyUserSysNo, @WarrantyTime, @PriceStatus,
@PriceUserSysNo, @PriceTime, @WeightStatus, @WeightUserSysNo,
@WeightTime, @AllowStatus, @AllowUserSysNo, @AllowTime,
@PreviewStatus,@PreviewUserSysNo,@PreviewTime
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int,4);
SqlParameter paramInfoStatus = new SqlParameter("@InfoStatus", SqlDbType.Int,4);
SqlParameter paramInfoUserSysNo = new SqlParameter("@InfoUserSysNo", SqlDbType.Int,4);
SqlParameter paramInfoTime = new SqlParameter("@InfoTime", SqlDbType.DateTime);
SqlParameter paramPicStatus = new SqlParameter("@PicStatus", SqlDbType.Int,4);
SqlParameter paramPicUserSysNo = new SqlParameter("@PicUserSysNo", SqlDbType.Int,4);
SqlParameter paramPicTime = new SqlParameter("@PicTime", SqlDbType.DateTime);
SqlParameter paramWarrantyStatus = new SqlParameter("@WarrantyStatus", SqlDbType.Int,4);
SqlParameter paramWarrantyUserSysNo = new SqlParameter("@WarrantyUserSysNo", SqlDbType.Int,4);
SqlParameter paramWarrantyTime = new SqlParameter("@WarrantyTime", SqlDbType.DateTime);
SqlParameter paramPriceStatus = new SqlParameter("@PriceStatus", SqlDbType.Int,4);
SqlParameter paramPriceUserSysNo = new SqlParameter("@PriceUserSysNo", SqlDbType.Int,4);
SqlParameter paramPriceTime = new SqlParameter("@PriceTime", SqlDbType.DateTime);
SqlParameter paramWeightStatus = new SqlParameter("@WeightStatus", SqlDbType.Int,4);
SqlParameter paramWeightUserSysNo = new SqlParameter("@WeightUserSysNo", SqlDbType.Int,4);
SqlParameter paramWeightTime = new SqlParameter("@WeightTime", SqlDbType.DateTime);
SqlParameter paramAllowStatus = new SqlParameter("@AllowStatus", SqlDbType.Int,4);
SqlParameter paramAllowUserSysNo = new SqlParameter("@AllowUserSysNo", SqlDbType.Int,4);
SqlParameter paramAllowTime = new SqlParameter("@AllowTime", SqlDbType.DateTime);
SqlParameter paramPreviewStatus = new SqlParameter("@PreviewStatus", SqlDbType.Int, 4);
SqlParameter paramPreviewUserSysNo = new SqlParameter("@PreviewUserSysNo", SqlDbType.Int, 4);
SqlParameter paramPreviewTime = new SqlParameter("@PreviewTime", SqlDbType.DateTime);
if ( oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if ( oParam.InfoStatus != AppConst.IntNull)
paramInfoStatus.Value = oParam.InfoStatus;
else
paramInfoStatus.Value = System.DBNull.Value;
if ( oParam.InfoUserSysNo != AppConst.IntNull)
paramInfoUserSysNo.Value = oParam.InfoUserSysNo;
else
paramInfoUserSysNo.Value = System.DBNull.Value;
if ( oParam.InfoTime != AppConst.DateTimeNull)
paramInfoTime.Value = oParam.InfoTime;
else
paramInfoTime.Value = System.DBNull.Value;
if ( oParam.PicStatus != AppConst.IntNull)
paramPicStatus.Value = oParam.PicStatus;
else
paramPicStatus.Value = System.DBNull.Value;
if ( oParam.PicUserSysNo != AppConst.IntNull)
paramPicUserSysNo.Value = oParam.PicUserSysNo;
else
paramPicUserSysNo.Value = System.DBNull.Value;
if ( oParam.PicTime != AppConst.DateTimeNull)
paramPicTime.Value = oParam.PicTime;
else
paramPicTime.Value = System.DBNull.Value;
if ( oParam.WarrantyStatus != AppConst.IntNull)
paramWarrantyStatus.Value = oParam.WarrantyStatus;
else
paramWarrantyStatus.Value = System.DBNull.Value;
if ( oParam.WarrantyUserSysNo != AppConst.IntNull)
paramWarrantyUserSysNo.Value = oParam.WarrantyUserSysNo;
else
paramWarrantyUserSysNo.Value = System.DBNull.Value;
if ( oParam.WarrantyTime != AppConst.DateTimeNull)
paramWarrantyTime.Value = oParam.WarrantyTime;
else
paramWarrantyTime.Value = System.DBNull.Value;
if ( oParam.PriceStatus != AppConst.IntNull)
paramPriceStatus.Value = oParam.PriceStatus;
else
paramPriceStatus.Value = System.DBNull.Value;
if ( oParam.PriceUserSysNo != AppConst.IntNull)
paramPriceUserSysNo.Value = oParam.PriceUserSysNo;
else
paramPriceUserSysNo.Value = System.DBNull.Value;
if ( oParam.PriceTime != AppConst.DateTimeNull)
paramPriceTime.Value = oParam.PriceTime;
else
paramPriceTime.Value = System.DBNull.Value;
if ( oParam.WeightStatus != AppConst.IntNull)
paramWeightStatus.Value = oParam.WeightStatus;
else
paramWeightStatus.Value = System.DBNull.Value;
if ( oParam.WeightUserSysNo != AppConst.IntNull)
paramWeightUserSysNo.Value = oParam.WeightUserSysNo;
else
paramWeightUserSysNo.Value = System.DBNull.Value;
if ( oParam.WeightTime != AppConst.DateTimeNull)
paramWeightTime.Value = oParam.WeightTime;
else
paramWeightTime.Value = System.DBNull.Value;
if ( oParam.AllowStatus != AppConst.IntNull)
paramAllowStatus.Value = oParam.AllowStatus;
else
paramAllowStatus.Value = System.DBNull.Value;
if ( oParam.AllowUserSysNo != AppConst.IntNull)
paramAllowUserSysNo.Value = oParam.AllowUserSysNo;
else
paramAllowUserSysNo.Value = System.DBNull.Value;
if ( oParam.AllowTime != AppConst.DateTimeNull)
paramAllowTime.Value = oParam.AllowTime;
else
paramAllowTime.Value = System.DBNull.Value;
if (oParam.PreviewStatus != AppConst.IntNull)
paramPreviewStatus.Value = oParam.PreviewStatus;
else
paramPreviewStatus.Value = System.DBNull.Value;
if (oParam.PreviewUserSysNo != AppConst.IntNull)
paramPreviewUserSysNo.Value = oParam.PreviewUserSysNo;
else
paramPreviewUserSysNo.Value = System.DBNull.Value;
if (oParam.PreviewTime != AppConst.DateTimeNull)
paramPreviewTime.Value = oParam.PreviewTime;
else
paramPreviewTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramInfoStatus);
cmd.Parameters.Add(paramInfoUserSysNo);
cmd.Parameters.Add(paramInfoTime);
cmd.Parameters.Add(paramPicStatus);
cmd.Parameters.Add(paramPicUserSysNo);
cmd.Parameters.Add(paramPicTime);
cmd.Parameters.Add(paramWarrantyStatus);
cmd.Parameters.Add(paramWarrantyUserSysNo);
cmd.Parameters.Add(paramWarrantyTime);
cmd.Parameters.Add(paramPriceStatus);
cmd.Parameters.Add(paramPriceUserSysNo);
cmd.Parameters.Add(paramPriceTime);
cmd.Parameters.Add(paramWeightStatus);
cmd.Parameters.Add(paramWeightUserSysNo);
cmd.Parameters.Add(paramWeightTime);
cmd.Parameters.Add(paramAllowStatus);
cmd.Parameters.Add(paramAllowUserSysNo);
cmd.Parameters.Add(paramAllowTime);
cmd.Parameters.Add(paramPreviewStatus);
cmd.Parameters.Add(paramPreviewUserSysNo);
cmd.Parameters.Add(paramPreviewTime);
return SqlHelper.ExecuteNonQuery(cmd);
}