示例#1
0
    private ProductSearchData GetData()
    {
        ProductSearchData data = new ProductSearchData();
        data.ACTIVE = (this.chkActive.Checked ? Constz.ActiveStatus.Active : Constz.ActiveStatus.InActive);
        data.CODE = this.txtCode.Text.Trim();
        data.BARCODE = this.txtBarCode.Text.Trim();
        data.COST = Convert.ToDouble(this.txtCost.Text == "" ? "0" : this.txtCost.Text);
        data.LEADTIME = Convert.ToDouble(this.txtLeadtime.Text == "" ? "0" : this.txtLeadtime.Text);
        data.LOTSIZE = Convert.ToDouble(this.txtLotSize.Text == "" ? "0" : this.txtLotSize.Text);
        data.LEADTIMEPD = Convert.ToDouble(this.txtLeadtimePD.Text == "" ? "0" : this.txtLeadtimePD.Text);
        data.LOTSIZEPD = Convert.ToDouble(this.txtLotSizePD.Text == "" ? "0" : this.txtLotSizePD.Text);
        data.ORDERTYPE = this.rbtOrderType.SelectedItem.Value.Trim();
        data.PRICE = Convert.ToDouble(this.txtPrice.Text == "" ? "0" : this.txtPrice.Text);
        data.STDPRICE = Convert.ToDouble(this.txtStdPrice.Text == "" ? "0" : this.txtStdPrice.Text);
        data.PRODUCTGROUP = Convert.ToDouble(this.cmbProductGroup.SelectedItem.Value);
        data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
        data.NAME = this.txtName.Text.Trim();
        data.ENAME = this.txtEName.Text.Trim();
        data.ABBNAME = this.txtAbbName.Text.Trim();
        data.PRODUCTTYPE = Convert.ToDouble(this.cmbProductType.SelectedItem.Value);
        data.UNIT = Convert.ToDouble(this.cmbUnit.SelectedItem.Value);
        data.PACKSIZEUNIT = Convert.ToDouble(this.cmbUnitPack.SelectedItem.Value);
        data.PACKSIZE = Convert.ToDouble(this.txtPacksize.Text == "" ? "0" : this.txtPacksize.Text);
        //data.AGE = Convert.ToDouble(this.txtAge.Text == "" ? "0" : this.txtAge.Text);
        data.PBLOID = Convert.ToDouble(this.txtPBLOID.Text == "" ? "0" : this.txtPBLOID.Text);

        return data;
    }
示例#2
0
    private void SetData(ProductSearchData data)
    {
        this.txtLOID.Text = data.LOID.ToString();
        this.txtMasterUnit.Text = data.UNIT.ToString();
        this.txtPackSizeUint.Text = data.PACKSIZEUNIT.ToString();

        this.txtName.Text = data.NAME;
        this.grvItem.DataBind();
    }
示例#3
0
 private void ValidateData(ProductSearchData data)
 {
     if (data.LOID == 0)
     {
         if (data.CODE.Trim() == "")
             throw new ApplicationException("¡ÃسÒÃкØÃËÑÊÇѵ¶Ø´Ôº");
         else if (data.PRODUCTTYPE == 0)
             throw new ApplicationException("¡ÃسÒàÅ×Í¡»ÃÐàÀ·Çѵ¶Ø´Ôº");
         else if (data.PRODUCTGROUP == 0)
             throw new ApplicationException("¡ÃسÒàÅ×Í¡¡ÅØèÁÇѵ¶Ø´Ôº");
         else if (data.NAME.Trim() == "")
             throw new ApplicationException("¡ÃسÒÃкت×èÍÇѵ¶Ø´Ôº");
         else if (data.ABBNAME.Trim() == "")
             throw new ApplicationException("¡ÃسÒÃкت×èÍÂèÍÇѵ¶Ø´Ôº");
         else if (data.BARCODE.Trim() == "")
             throw new ApplicationException("¡ÃسÒÃкغÒÃìâ¤é´");
         else if (data.UNIT == 0)
             throw new ApplicationException("¡ÃسÒàÅ×͡˹èÇÂÇѵ¶Ø´Ôº");
         else if (data.COST == 0)
             throw new ApplicationException("¡ÃسÒÃкØÃҤҷع");
         else if (data.ORDERTYPE.Trim() == "")
             throw new ApplicationException("¡ÃسÒàÅ×Í¡ÇÔ¸Õ¡ÒùÓà¢éÒ");
         else if ((data.ORDERTYPE.Trim() == "PO" || data.ORDERTYPE.Trim() == "AR") && data.LEADTIME == 0)
             throw new ApplicationException("¡ÃسÒÃкØÃÐÂÐàÇÅÒ¡ÒÃÊÑ觫×éÍ");
         else if ((data.ORDERTYPE.Trim() == "PD" || data.ORDERTYPE.Trim() == "AR") && data.LEADTIMEPD == 0)
             throw new ApplicationException("¡ÃسÒÃкØÃÐÂÐàÇÅÒ¡ÒüÅÔµ");
         else if ((data.ORDERTYPE.Trim() == "PO" || data.ORDERTYPE.Trim() == "AR") && data.LOTSIZE == 0)
             throw new ApplicationException("¡ÃسÒÃкبӹǹ¡ÒÃÊÑ觫×éÍ");
         else if ((data.ORDERTYPE.Trim() == "PD" || data.ORDERTYPE.Trim() == "AR") && data.LOTSIZEPD == 0)
             throw new ApplicationException("¡ÃسÒÃкبӹǹ¡ÒüÅÔµ");
         else if (data.PACKSIZE == 0)
             throw new ApplicationException("¡ÃسÒÃкآ¹Ò´ºÃèØ");
         else if (data.PACKSIZEUNIT == 0)
             throw new ApplicationException("¡ÃسÒàÅ×͡˹èÇ¢¹Ò´ºÃèØ");
         else if (MasterDALObj.CheckCode(data.LOID, data.CODE.Trim()) == false)
             throw new ApplicationException("ÃËÑÊÇѵ¶Ø´Ôº¹ÕéÁÕáÅéÇ");
         else if (MasterDALObj.CheckName(data.LOID, data.NAME.Trim()) == false)
             throw new ApplicationException("ª×èÍÇѵ¶Ø´Ôº¹ÕéÁÕáÅéÇ");
         if (data.ENAME != "")
         {
             if (MasterDALObj.CheckEName(data.LOID, data.ENAME.Trim()) == false)
                 throw new ApplicationException("ª×èÍÇѵ¶Ø´ÔºÀÒÉÒÍѧ¡ÄɹÕéÁÕáÅéÇ");
         }
         if (BarcodeDALObj.CheckBarcode(data.LOID, data.BARCODE.Trim(), data.PBLOID) == false)
             throw new ApplicationException("ºÒÃìâ¤é´ " + data.BARCODE + " ¹ÕéÁÕáÅéÇ");
         else if (BarcodeDALObj.CheckAbbname(data.LOID, data.ABBNAME.Trim(), data.PBLOID) == false)
             throw new ApplicationException("ª×èÍÂèÍ " + data.ABBNAME + " ¹ÕéÁÕáÅéÇ");
         else if (BarcodeDALObj.CheckUnit(data.LOID, data.UNIT.ToString(), data.PBLOID) == false)
             throw new ApplicationException("˹èǹѺ¹ÕéÁÕáÅéÇ");
     }
 }
示例#4
0
        private void ValidateData(ProductSearchData data)
        {
            if (data.LOID == 0)
            {
                if (data.PRODUCTTYPE == 0)
                    throw new ApplicationException("¡ÃسÒàÅ×Í¡»ÃÐàÀ·ÊÔ¹¤éÒ");
                else if (data.PRODUCTGROUP == 0)
                    throw new ApplicationException("¡ÃسÒàÅ×Í¡¡ÅØèÁÊÔ¹¤éÒ");
                else if (data.CODE.Trim() == "")
                    throw new ApplicationException("¡ÃسÒÃкØÃËÑÊÊÔ¹¤éÒ");
                else if (data.NAME.Trim() == "")
                    throw new ApplicationException("¡ÃسÒÃкت×èÍÊÔ¹¤éÒ");
                else if (data.ABBNAME.Trim() == "")
                    throw new ApplicationException("¡ÃسÒÃкت×èÍÂèÍÊÔ¹¤éÒ");
                else if (data.BARCODE.Trim() == "")
                    throw new ApplicationException("¡ÃسÒÃкغÒÃìâ¤é´");
                else if (data.UNIT == 0)
                    throw new ApplicationException("¡ÃسÒàÅ×͡˹èÇÂÊÔ¹¤éÒ");
                else if (data.COST == 0)
                    throw new ApplicationException("¡ÃسÒÃкØÃҤҷع");
                else if (data.PRICE == 0)
                    throw new ApplicationException("¡ÃسÒÃкØÃÒ¤Ò¢ÒÂ");
                else if (data.ORDERTYPE.Trim() == "")
                    throw new ApplicationException("¡ÃسÒàÅ×Í¡ÇÔ¸Õ¡ÒùÓà¢éÒ");
                else if ((data.ORDERTYPE.Trim() == "PO" || data.ORDERTYPE.Trim() == "AR") && data.LEADTIME == 0)
                    throw new ApplicationException("¡ÃسÒÃкØÃÐÂÐàÇÅÒ¡ÒÃÊÑ觫×éÍ");
                else if ((data.ORDERTYPE.Trim() == "PD" || data.ORDERTYPE.Trim() == "AR") && data.LEADTIMEPD == 0)
                    throw new ApplicationException("¡ÃسÒÃкØÃÐÂÐàÇÅÒ¡ÒüÅÔµ");
                else if ((data.ORDERTYPE.Trim() == "PO" || data.ORDERTYPE.Trim() == "AR") && data.LOTSIZE == 0)
                    throw new ApplicationException("¡ÃسÒÃкبӹǹ¡ÒÃÊÑ觫×éÍ");
                else if ((data.ORDERTYPE.Trim() == "PD" || data.ORDERTYPE.Trim() == "AR") && data.LOTSIZEPD == 0)
                    throw new ApplicationException("¡ÃسÒÃкبӹǹ¡ÒüÅÔµ");
                else if (data.PACKSIZE == 0)
                    throw new ApplicationException("¡ÃسÒÃкآ¹Ò´ºÃèØ");
                else if (data.PACKSIZEUNIT == 0)
                    throw new ApplicationException("¡ÃسÒàÅ×͡˹èÇ¢¹Ò´ºÃèØ");
            }

        }
示例#5
0
 public ProductSearchData GetData(double loid)
 {
     ProductSearchData data = new ProductSearchData();
     if (MasterDALObj.GetDataByLOID(loid, null))
     {
         string sqlstr = MasterDALObj.LOID.ToString() + " AND ISDEFAULT = 'Y'";
         BarcodeDALObj.GetDataByProductMaster(sqlstr, null);
         data.LOID = MasterDALObj.LOID;
         data.PBLOID = BarcodeDALObj.LOID;
         data.CODE = MasterDALObj.CODE;
         data.ACTIVE = MasterDALObj.ACTIVE;
         data.BARCODE = BarcodeDALObj.BARCODE;
         data.NAME = MasterDALObj.NAME;
         data.ENAME = MasterDALObj.ENAME;
         data.ABBNAME = BarcodeDALObj.ABBNAME;
         data.PRODUCTGROUP = MasterDALObj.PRODUCTGROUP;
         ABB.DAL.ProductGroupDAL groupDAL = new ABB.DAL.ProductGroupDAL();
         groupDAL.GetDataByLOID(MasterDALObj.PRODUCTGROUP, null);
         data.PRODUCTTYPE = groupDAL.PRODUCTTYPE;
         data.COST = BarcodeDALObj.COST;
         data.LEADTIME = MasterDALObj.LEADTIME;
         data.LOTSIZE = MasterDALObj.LOTSIZE;
         data.LEADTIMEPD = MasterDALObj.LEADTIMEPD;
         data.LOTSIZEPD = MasterDALObj.LOTSIZEPD;
         data.ORDERTYPE = MasterDALObj.ORDERTYPE;
         data.PRICE = BarcodeDALObj.PRICE;
         data.REGISNO = MasterDALObj.REGISNO;
         data.STDPRICE = BarcodeDALObj.STDPRICE;
         data.UNIT = MasterDALObj.UNIT;
         data.PACKSIZE = BarcodeDALObj.PACKSIZE;
         data.PACKSIZEUNIT = BarcodeDALObj.PACKSIZEUNIT;
         //data.AGE = MasterDALObj.AGE;
     }
     return data;
 }
示例#6
0
 private void SetData(ProductSearchData data)
 {
     this.txtLOID.Text = data.LOID.ToString();
     this.txtCode.Text = data.CODE.Trim();
     this.cmbProductType.SelectedIndex = this.cmbProductType.Items.IndexOf(this.cmbProductType.Items.FindByValue(data.PRODUCTTYPE.ToString()));
     this.chkActive.Checked = (data.ACTIVE == Constz.ActiveStatus.Active);
     this.txtName.Text = data.NAME.Trim();
     this.txtEName.Text = data.ENAME.Trim();
     this.txtAbbName.Text = data.ABBNAME.Trim();
     this.txtBarCode.Text = data.BARCODE.Trim();
     this.txtCost.Text = data.COST.ToString();
     this.txtLeadtime.Text = data.LEADTIME.ToString();
     this.txtLotSize.Text = data.LOTSIZE.ToString();
     this.txtLeadtimePD.Text = data.LEADTIMEPD.ToString();
     this.txtLotSizePD.Text = data.LOTSIZEPD.ToString();
     this.rbtOrderType.SelectedValue = data.ORDERTYPE;
     this.txtPrice.Text = data.PRICE.ToString();
     this.txtStdPrice.Text = data.STDPRICE.ToString();
     getDataToGroup();
     this.cmbProductGroup.SelectedIndex = this.cmbProductGroup.Items.IndexOf(this.cmbProductGroup.Items.FindByValue(data.PRODUCTGROUP.ToString()));
     this.cmbUnit.SelectedIndex = this.cmbUnit.Items.IndexOf(this.cmbUnit.Items.FindByValue(data.UNIT.ToString()));
     this.cmbUnitPack.SelectedIndex = this.cmbUnitPack.Items.IndexOf(this.cmbUnitPack.Items.FindByValue(data.PACKSIZEUNIT.ToString()));
     this.txtPacksize.Text = data.PACKSIZE.ToString();
     //this.txtAge.Text = data.AGE.ToString();
     this.txtPBLOID.Text = data.PBLOID.ToString();
 }
示例#7
0
 private void SetData(ProductSearchData data)
 {
     this.txtLOID.Text = data.LOID.ToString();
     this.cmbProductType.SelectedIndex = this.cmbProductType.Items.IndexOf(this.cmbProductType.Items.FindByValue(data.PRODUCTTYPE.ToString()));
     this.chkActive.Checked = (data.ACTIVE == Constz.ActiveStatus.Active);
     this.txtName.Text = data.NAME.Trim();
     this.txtEName.Text = data.ENAME.Trim();
     this.txtAbbName.Text = data.ABBNAME.Trim();
     this.txtBarCode.Text = data.BARCODE.Trim();
     this.txtCost.Text = data.COST.ToString(Constz.DblFormat);
     this.rbtIsDiscount.SelectedValue = data.ISDISCOUNT;
     this.rbtIsEdit.SelectedValue = data.ISEDIT;
     this.rbtIsVat.SelectedValue = data.ISVAT;
     this.txtLeadtime.Text = data.LEADTIME.ToString(Constz.IntFormat);
     this.txtLotSize.Text = data.LOTSIZE.ToString(Constz.IntFormat);
     this.txtLeadtimePD.Text = data.LEADTIMEPD.ToString(Constz.IntFormat);
     this.txtLotSizePD.Text = data.LOTSIZEPD.ToString(Constz.IntFormat);
     this.rbtOrderType.SelectedValue = data.ORDERTYPE;
     this.txtPrice.Text = data.PRICE.ToString(Constz.DblFormat);
     getDataToGroup();
     this.cmbProductGroup.SelectedIndex = this.cmbProductGroup.Items.IndexOf(this.cmbProductGroup.Items.FindByValue(data.PRODUCTGROUP.ToString()));
     this.txtRegisNo.Text = data.REGISNO.ToString();
     this.cmbUnit.SelectedIndex = this.cmbUnit.Items.IndexOf(this.cmbUnit.Items.FindByValue(data.UNIT.ToString()));
     this.cmbUnitPack.SelectedIndex = this.cmbUnitPack.Items.IndexOf(this.cmbUnitPack.Items.FindByValue(data.PACKSIZEUNIT.ToString()));
     this.rbtIsRefund.SelectedIndex = this.rbtIsRefund.Items.IndexOf(this.rbtIsRefund.Items.FindByValue(data.ISREFUND));
     this.txtPacksize.Text = data.PACKSIZE.ToString(Constz.IntFormat);
     this.txtAge.Text = data.AGE.ToString(Constz.IntFormat);
     this.txtPBLOID.Text = data.PBLOID.ToString();
     this.txtCode.Text = data.CODE.Trim();
     this.cmbProduceGroup.SelectedIndex = this.cmbProduceGroup.Items.IndexOf(this.cmbProduceGroup.Items.FindByValue(data.PRODUCEGROUP.ToString()));
     CheckOrderType();
 }
示例#8
0
 private void SetProductDetail(ProductSearchData data, GridViewRow gRow, TextBox txtBarcode, DropDownList cmbProduct, TextBox txtUnit, TextBox txtPrice, TextBox txtNetPrice, TextBox txtPDQty, TextBox txtQty)
 {
     txtBarcode.Text = data.BARCODE;
     txtPDQty.Text = Convert.ToString(data.PDQTY);
     cmbProduct.SelectedIndex = cmbProduct.Items.IndexOf(cmbProduct.Items.FindByValue(data.LOID.ToString()));
     txtUnit.Text = Convert.ToString(data.UNITNAME);
     txtPrice.Text = data.PRICE.ToString(Constz.DblFormat);
     txtNetPrice.Text = (Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text) * data.PRICE).ToString(Constz.DblFormat);
     gRow.Cells[16].Text = data.UNIT.ToString() ;
 }
示例#9
0
        public bool UpdateItemData(string userID, ProductSearchData data)
        {
            bool ret = true;
            
            OracleDBObj obj = new OracleDBObj();
            obj.CreateConnection();
            obj.CreateTransaction();
            try
            {
                ProductBarcodeDAL itemDAL = new ProductBarcodeDAL();
                ProductBarcodeDAL itemDAL2 = new ProductBarcodeDAL();
                ProductBarcodeDAL itemDAL3 = new ProductBarcodeDAL();
                //itemDAL.DeleteDataByProductMasterExceptDefault(data.LOID, obj.zTrans);
                itemDAL.UpdateActiveByProductMasterExceptDefault(data.LOID, "0", userID, obj.zTrans);
                for (Int16 i = 1; i < data.ITEM.Count; ++i)
                {
                    ProductBarcodeData item = (ProductBarcodeData)data.ITEM[i];
                    itemDAL.OnDB = false;
                    itemDAL.ACTIVE = "";
                    itemDAL.GetDataByBARCODE(item.BARCODE, obj.zTrans);
                    if (itemDAL.ACTIVE != Constz.ActiveStatus.Active)
                    {
                        itemDAL2.GetDataByABBNAME(item.ABBNAME.Trim(), obj.zTrans);
                        if (itemDAL2.ACTIVE == Constz.ActiveStatus.Active)
                        {
                            throw new ApplicationException("ª×èÍÂèÍ " + item.ABBNAME + " ¹ÕéÁÕáÅéÇ");
                        }
                        itemDAL3.GetDataByABBUNIT(item.LOID,item.UNIT, obj.zTrans);
                        if (itemDAL3.ACTIVE == Constz.ActiveStatus.Active)
                        {
                            throw new ApplicationException("ª×èÍ˹èÇ«éÓ");
                        }

                        itemDAL.BARCODE = item.BARCODE;
                        itemDAL.PRODUCTMASTER = data.LOID;
                        itemDAL.ABBNAME = item.ABBNAME;
                        itemDAL.UNIT = item.UNIT;
                        itemDAL.COST = item.COST;
                        itemDAL.PRICE = item.PRICE;
                        itemDAL.STDPRICE = item.STDPRICE;
                        itemDAL.ISDISCOUNT = "0";
                        itemDAL.ISVAT = "1";
                        itemDAL.PACKSIZE = item.PACKSIZE;
                        itemDAL.PACKSIZEUNIT = item.UNITPACK;
                        itemDAL.ISEDIT = "Y";
                        itemDAL.ISREFUND = "N";
                        itemDAL.ACTIVE = Convert.ToString(item.ACTIVE);
                        itemDAL.MULTIPLY = item.MULTIPLY;
                        itemDAL.ISDEFAULT = "N";

                        if (itemDAL.OnDB)
                            ret = itemDAL.UpdateCurrentData(userID, obj.zTrans);
                        else
                            ret = itemDAL.InsertCurrentData(userID, obj.zTrans);

                        if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
                    }
                    else
                    {
                        throw new ApplicationException("ºÒÃìâ¤é´ " + item.BARCODE + " ¹ÕéÁÕáÅéÇ");
                    }
                }
                _LOID = data.LOID;
                obj.zTrans.Commit();
                obj.CloseConnection();
            }
            catch (Exception ex)
            {
                obj.zTrans.Rollback();
                obj.CloseConnection();
                ret = false;
                _error = ex.Message;
            }

            return ret;
        }
示例#10
0
        public bool UpdateData(string userID, ProductSearchData data)
        {
            bool ret = true;
            ValidateData(data);

            OracleDBObj obj = new OracleDBObj();
            obj.CreateConnection();
            obj.CreateTransaction();
            try
            {
                MasterDALObj.OnDB = false;
                MasterDALObj.GetDataByLOID(data.LOID, obj.zTrans);
                BarcodeDALObj.GetDataByProductMaster(data.LOID.ToString(), obj.zTrans);
                MasterDALObj.NAME = data.NAME.Trim();
                MasterDALObj.ENAME = data.ENAME.Trim();
                MasterDALObj.CODE = data.CODE.Trim();
                BarcodeDALObj.ABBNAME = data.ABBNAME.Trim();
                MasterDALObj.PRODUCTGROUP = data.PRODUCTGROUP;
                MasterDALObj.ACTIVE = data.ACTIVE.Trim();
                BarcodeDALObj.ACTIVE = data.ACTIVE.Trim();
                BarcodeDALObj.BARCODE = data.BARCODE.Trim();
                BarcodeDALObj.COST = data.COST;
                BarcodeDALObj.ISDISCOUNT = "0";
                BarcodeDALObj.ISEDIT = "Y";
                BarcodeDALObj.ISVAT = "0";
                MasterDALObj.LEADTIME = data.LEADTIME;
                MasterDALObj.LOTSIZE = data.LOTSIZE;
                MasterDALObj.LEADTIMEPD = data.LEADTIMEPD;
                MasterDALObj.LOTSIZEPD = data.LOTSIZEPD;
                MasterDALObj.ORDERTYPE = data.ORDERTYPE.Trim();
                BarcodeDALObj.PRICE = data.PRICE;
                MasterDALObj.REGISNO = "";
                BarcodeDALObj.STDPRICE = data.STDPRICE;
                MasterDALObj.UNIT = data.UNIT;
                BarcodeDALObj.UNIT = data.UNIT;
                BarcodeDALObj.PACKSIZE = data.PACKSIZE;
                BarcodeDALObj.PACKSIZEUNIT = data.PACKSIZEUNIT;
                BarcodeDALObj.ISREFUND = "N";
                MasterDALObj.AGE = 0;
                BarcodeDALObj.ISDEFAULT = "Y";
                BarcodeDALObj.MULTIPLY = 1;
                BarcodeDALObj.ACTIVE = "1";

                if (MasterDALObj.OnDB)
                {
                    ret = MasterDALObj.UpdateCurrentData(userID, obj.zTrans);
                    if (!ret)
                    {
                        throw new ApplicationException(MasterDALObj.ErrorMessage);
                    }
                    BarcodeDALObj.PRODUCTMASTER = MasterDALObj.LOID;
                    ret = BarcodeDALObj.UpdateCurrentData(userID, obj.zTrans);
                    if (!ret)
                    {
                        throw new ApplicationException(BarcodeDALObj.ErrorMessage);
                    }
                }
                else
                {
                    ret = MasterDALObj.InsertCurrentData(userID, obj.zTrans);
                    if (!ret)
                    {
                        throw new ApplicationException(MasterDALObj.ErrorMessage);
                    }
                    BarcodeDALObj.PRODUCTMASTER = MasterDALObj.LOID;
                    ret = BarcodeDALObj.InsertCurrentData(userID, obj.zTrans);
                    if (!ret)
                    {
                        throw new ApplicationException(BarcodeDALObj.ErrorMessage);
                    }
                }

                _LOID = MasterDALObj.LOID;

                obj.zTrans.Commit();
                obj.CloseConnection();
            }
            catch (Exception ex)
            {
                obj.zTrans.Rollback();
                obj.CloseConnection();
                ret = false;
                throw new ApplicationException(ex.Message);
            }
            return ret;
        }
示例#11
0
 private void ValidateData2(ProductSearchData data)
 {
     if (MasterDALObj.CheckName(data.LOID, data.NAME.Trim()) == false)
         throw new ApplicationException("ª×èÍÊÔ¹¤éÒÀÒÉÒä·Â¹ÕéÁÕáÅéÇ");
     if (MasterDALObj.CheckCode(data.LOID, data.CODE.Trim()) == false)
         throw new ApplicationException("ÃËÑÊÊÔ¹¤éÒ¹ÕéÁÕáÅéÇ");
     if (data.ENAME != "")
     {
         if (MasterDALObj.CheckEName(data.LOID, data.ENAME.Trim()) == false)
             throw new ApplicationException("ª×èÍÊÔ¹¤éÒÀÒÉÒÍѧ¡ÄɹÕéÁÕáÅéÇ");
     }
     if (BarcodeDALObj.CheckBarcode(data.LOID, data.BARCODE.Trim(), data.PBLOID) == false)
         throw new ApplicationException("ºÒÃìâ¤é´¹ÕéÁÕáÅéÇ");
     if (BarcodeDALObj.CheckAbbname(data.LOID, data.ABBNAME.Trim(), data.PBLOID) == false)
         throw new ApplicationException("ª×èÍÂè͹ÕéÁÕáÅéÇ");
     if (BarcodeDALObj.CheckUnit(data.LOID, data.UNIT.ToString(), data.PBLOID) == false)
         throw new ApplicationException("˹èǹѺ¹ÕéÁÕáÅéÇ");
 }
示例#12
0
    private void SetProductDetail(ProductSearchData data, GridViewRow gRow, TextBox txtBarcode, DropDownList cmbProduct, DropDownList cmbUnit, Controls_DatePickerControl txtDate)
    {
        txtBarcode.Text = data.BARCODE;
        cmbProduct.SelectedIndex = cmbProduct.Items.IndexOf(cmbProduct.Items.FindByValue(data.LOID.ToString()));
        cmbUnit.SelectedIndex = cmbUnit.Items.IndexOf(cmbUnit.Items.FindByValue(data.UNIT.ToString()));
        txtDate.DateValue = DateTime.Now.Date.AddDays(data.LEADTIMEPD);

        //if (txtBarcode.ID == "txtNewBarCode" && txtBarcode.Text != "")
        //    InsertData(gRow);
    }
示例#13
0
    private void SetProductDetail(ProductSearchData data, GridViewRow gRow, TextBox txtBarcode, DropDownList cmbProduct, TextBox txtUnit, TextBox txtOldPrice, TextBox txtNewPrice)
    {
        txtBarcode.Text = data.BARCODE;
        txtUnit.Text = FlowObj.GetUnitName(data.UNIT);
        txtOldPrice.Text = data.PRICE.ToString(Constz.DblFormat);
        txtNewPrice.Text = CalNewPrice(data.PRICE).ToString(Constz.DblFormat);
        cmbProduct.SelectedIndex = cmbProduct.Items.IndexOf(cmbProduct.Items.FindByValue(data.LOID.ToString()));

        if (txtBarcode.ID == "txtNewBarCode" && txtBarcode.Text != "")
            InsertData(gRow);
    }
示例#14
0
 public ProductSearchData GetDataVProduct(string barCode)
  {
      ProductSearchData data = new ProductSearchData();
      if (VPDDALObj.GetDataByBarCode(barCode, null))
      {
          data.LOID = VPDDALObj.LOID;
          data.ACTIVE = VPDDALObj.ACTIVE;
          data.BARCODE = VPDDALObj.BARCODE;
          data.CODE = VPDDALObj.CODE;
          data.NAME = VPDDALObj.NAME;
          data.COST = VPDDALObj.COST;
          data.PDQTY = VPDDALObj.QTY;
          data.PRICE = VPDDALObj.PRICE;
          data.UNIT = VPDDALObj.UNIT;
          data.UNITNAME = VPDDALObj.UNAME;
      }
      return data;
  }
示例#15
0
 public ProductSearchData GetData(string barCode)
 {
     ProductSearchData data = new ProductSearchData();
     if (DALObj.GetDataByBarCode(barCode, null))
     {
         data.LOID = DALObj.LOID;
         data.ACTIVE = DALObj.ACTIVE;
         data.BARCODE = DALObj.BARCODE;
         data.CODE = DALObj.CODE;
         data.NAME = DALObj.NAME;
         data.ABBNAME = DALObj.ABBNAME;
         data.PRODUCTGROUP = DALObj.PRODUCTGROUP;
         ABB.DAL.ProductGroupDAL groupDAL = new ABB.DAL.ProductGroupDAL();
         groupDAL.GetDataByLOID(DALObj.PRODUCTGROUP, null);
         data.PRODUCTTYPE = groupDAL.PRODUCTTYPE;
         data.COST = DALObj.COST;
         data.ISDISCOUNT = DALObj.ISDISCOUNT;
         data.ISEDIT = DALObj.ISEDIT;
         data.ISVAT = DALObj.ISVAT;
         data.LEADTIME = DALObj.LEADTIME;
         data.LOTSIZE = DALObj.LOTSIZE;
         data.ORDERTYPE = DALObj.ORDERTYPE;
         data.PRICE = DALObj.PRICE;
         data.REGISNO = DALObj.REGISNO;
         data.STDPRICE = DALObj.STDPRICE;
         data.UNIT = DALObj.UNIT;
     }
     return data;
 }
示例#16
0
 public ProductSearchData GetDataVProduct(double loid)
 {
     ProductSearchData data = new ProductSearchData();
     if (VPDDALObj.GetDataByLOID(loid, null))
     {
         data.LOID = VPDDALObj.LOID;
         data.ACTIVE = VPDDALObj.ACTIVE;
         data.BARCODE = VPDDALObj.BARCODE;
         data.CODE = VPDDALObj.CODE;
         data.NAME = VPDDALObj.NAME;
         data.COST = VPDDALObj.COST;
         data.PDQTY = VPDDALObj.QTY;
         data.PRICE = VPDDALObj.PRICE;
         data.UNIT = VPDDALObj.UNIT;
         data.UNITNAME = VPDDALObj.UNAME;
     }
     return data;
 }
示例#17
0
 public ProductSearchData GetProductBarcode(double loid)
 {
     ProductSearchData data = new ProductSearchData();
     if (BarcodeDALObj.GetDataByLOID(loid, null))
     {
         data.LOID = BarcodeDALObj.LOID;
         //data.CODE = BarcodeDALObj.CODE;
         //data.ACTIVE = BarcodeDALObj.ACTIVE;
         data.BARCODE = BarcodeDALObj.BARCODE;
         //data.NAME = BarcodeDALObj.NAME;
         //data.ENAME = BarcodeDALObj.ENAME;
         //data.ABBNAME = BarcodeDALObj.ABBNAME;
         //data.PRODUCTGROUP = BarcodeDALObj.PRODUCTGROUP;
         //ABB.DAL.ProductGroupDAL groupDAL = new ABB.DAL.ProductGroupDAL();
         //groupDAL.GetDataByLOID(MasterDALObj.PRODUCTGROUP, null);
         //data.PRODUCTTYPE = groupDAL.PRODUCTTYPE;
         data.COST = BarcodeDALObj.COST;
         //data.ISDISCOUNT = BarcodeDALObj.ISDISCOUNT;
         //data.ISEDIT = BarcodeDALObj.ISEDIT;
         //data.ISVAT = BarcodeDALObj.ISVAT;
         //data.LEADTIME = BarcodeDALObj.LEADTIME;
         //data.LOTSIZE = BarcodeDALObj.LOTSIZE;
         //data.LEADTIMEPD = BarcodeDALObj.LEADTIMEPD;
         //data.LOTSIZEPD = BarcodeDALObj.LOTSIZEPD;
         //data.ORDERTYPE = BarcodeDALObj.ORDERTYPE;
         data.PRICE = BarcodeDALObj.PRICE;
         //data.REGISNO = BarcodeDALObj.REGISNO;
         //data.STDPRICE = BarcodeDALObj.STDPRICE;
         data.UNIT = BarcodeDALObj.UNIT;
         //data.ISREFUND = BarcodeDALObj.ISREFUND;
         //data.PACKSIZE = BarcodeDALObj.PACKSIZE;
         //data.PACKSIZEUNIT = BarcodeDALObj.PACKSIZEUNIT;
         //data.REMARK = BarcodeDALObj.REMARK;
         //data.AGE = BarcodeDALObj.AGE;
     }
     return data;
 }
示例#18
0
        public bool InsertData(string userID, ProductSearchData data)
        {
            bool ret = true;
            ValidateData(data);
            DALObj.NAME = data.NAME.Trim();
         //   DALObj.ABBNAME = data.ABBNAME.Trim();
            DALObj.PRODUCTGROUP = data.PRODUCTGROUP;
            DALObj.ACTIVE = data.ACTIVE.Trim();
            DALObj.BARCODE = data.BARCODE.Trim();
            DALObj.CODE = data.CODE.Trim();
            DALObj.COST = data.COST;
         //   DALObj.ISDISCOUNT = data.ISDISCOUNT.Trim();
         //   DALObj.ISEDIT = data.ISEDIT.Trim();
         //   DALObj.ISVAT = data.ISVAT.Trim();
            DALObj.LEADTIME = data.LEADTIME;
            DALObj.LOTSIZE = data.LOTSIZE;
            DALObj.LEADTIMEPD = data.LEADTIMEPD;
            DALObj.LOTSIZEPD = data.LOTSIZEPD;
            DALObj.ORDERTYPE = data.ORDERTYPE.Trim();
            DALObj.PRICE = data.PRICE;
            DALObj.REGISNO = data.REGISNO.Trim();
            DALObj.STDPRICE = data.STDPRICE;
            DALObj.UNIT = data.UNIT;
            DALObj.ABBNAME = data.ABBNAME;

            OracleDBObj obj = new OracleDBObj();
            obj.CreateConnection();
            obj.CreateTransaction();
            try
            {
                ret = DALObj.InsertCurrentData(userID, obj.zTrans);
                _LOID = DALObj.LOID;
                if (!ret)
                {
                    throw new ApplicationException(DALObj.ErrorMessage);
                }
                obj.zTrans.Commit();
                obj.CloseConnection();
            }
            catch (Exception ex)
            {
                obj.zTrans.Rollback();
                obj.CloseConnection();
                ret = false;
                throw new ApplicationException(ex.Message);
            }
            return ret;
        }
示例#19
0
 public ProductSearchData GetData(double loid)
 {
     ProductSearchData data = new ProductSearchData();
     if (DALObj.GetDataByLOID(loid, null))
     {
         data.LOID = DALObj.LOID;
         data.ACTIVE = DALObj.ACTIVE;
         data.BARCODE = DALObj.BARCODE;
         data.CODE = DALObj.CODE;
         data.NAME = DALObj.NAME;
         data.ABBNAME = DALObj.ABBNAME;
         data.PRODUCTGROUP = DALObj.PRODUCTGROUP;
         ABB.DAL.ProductGroupDAL groupDAL = new ABB.DAL.ProductGroupDAL();
         groupDAL.GetDataByLOID(DALObj.PRODUCTGROUP, null);
         data.PRODUCTTYPE = groupDAL.PRODUCTTYPE;
         data.COST = DALObj.COST;
         data.ISDISCOUNT = DALObj.ISDISCOUNT;
         data.ISEDIT = DALObj.ISEDIT;
         data.ISVAT = DALObj.ISVAT;
         data.LEADTIME = DALObj.LEADTIME;
         data.LOTSIZE = DALObj.LOTSIZE;
         data.LEADTIMEPD = DALObj.LEADTIMEPD;
         data.LOTSIZEPD = DALObj.LOTSIZEPD;
         data.ORDERTYPE = DALObj.ORDERTYPE;
         data.PRICE = DALObj.PRICE;
         data.REGISNO = DALObj.REGISNO;
         data.STDPRICE = DALObj.STDPRICE;
         data.UNIT = DALObj.UNIT;
         data.ISREFUND = DALObj.ISREFUND;
         data.PACKSIZE = DALObj.PACKSIZE;
         data.PACKSIZEUNIT = DALObj.PACKSIZEUNIT;
         data.REMARK = DALObj.REMARK;
     }
     return data;
 }