예제 #1
0
 public void Init()
 {
     BasicInfo     = new ProductBasicInfo();
     PriceInfo     = new ProductPriceInfo();
     AttributeInfo = new ProductAttributeInfo();
     StatusInfo    = new ProductStatusInfo();
     BarcodeInfo   = new ProductBarcodeInfo();
 }
예제 #2
0
파일: ProductInfo.cs 프로젝트: ue96/ue96
 public void Init()
 {
     BasicInfo = new ProductBasicInfo();
     PriceInfo = new ProductPriceInfo();
     AttributeInfo = new ProductAttributeInfo();
     StatusInfo = new ProductStatusInfo();
     BarcodeInfo = new ProductBarcodeInfo();
 }
예제 #3
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        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();
            }
        }
예제 #4
0
파일: ProductManager.cs 프로젝트: ue96/ue96
 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"]);
 }
예제 #5
0
파일: ProductManager.cs 프로젝트: ue96/ue96
 public int UpdateStatusInfo(ProductStatusInfo oParam)
 {
     return new ProductStatusDac().Update(oParam);
 }
예제 #6
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        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();
            }
        }
예제 #7
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        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();
            }
        }
예제 #8
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        /// <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();
            }
        }
예제 #9
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        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();
            }
        }
예제 #10
0
파일: ProductManager.cs 프로젝트: ue96/ue96
 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;
 }
예제 #11
0
파일: ProductManager.cs 프로젝트: ue96/ue96
 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);
 }
예제 #12
0
파일: ProductManager.cs 프로젝트: ue96/ue96
        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();
            }
        }
예제 #13
0
        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);
        }