public bool InsertData(string UserID, BasketData bkData, DataTable tempTable) { double _PMLOID = 0; _PMLOID = InsertProductMaster(UserID, bkData); if (_PMLOID == 0) return false; _PBLOID = InsertProductBarcode(UserID, bkData, _PMLOID); if (_PBLOID == 0) return false; if (InsertPackage(UserID, tempTable, _PBLOID, _PMLOID) == false) return false; else { return true; } }
private void UpdateData() { bool ret = true; BasketData bkData = new BasketData(); BasketFlow bkFlow = new BasketFlow(); bkData.LOID = Convert.ToDouble(txtLOID.Text.Trim() == "" ? "0" : txtLOID.Text.Trim()); bkData.CODE = txtCode.Text.Trim(); bkData.NAME = txtBasketName.Text.Trim(); bkData.ABBNAME = txtABBName.Text.Trim(); bkData.BARCODE = txtBarcode.Text.Trim(); bkData.UNITBASKET = Convert.ToDouble(cmbUnit.SelectedItem.Value); bkData.PRODUCTGROUP = Convert.ToDouble(cmbProductGroup.SelectedItem.Value); bkData.COST = Convert.ToDouble(txtCost.Text.Trim()); bkData.PRICE = Convert.ToDouble(txtPrice.Text.Trim()); bkData.STDPRICE = Convert.ToDouble(txtSTDPrice.Text.Trim()); bkData.PRODUCTMASTER = Convert.ToDouble(txtProductMaster.Text.Trim()); bkData.ENAME = txtEname.Text.Trim(); if (chkStatus.Checked == true) bkData.ACTIVE = "1"; else bkData.ACTIVE = "0"; if (radVAT.Checked == true) bkData.ISVAT = Constz.VAT.Included.Code; else if (radNoVAT.Checked == true) bkData.ISVAT = Constz.VAT.NotIncluded.Code; if (radDiscount.Checked == true) bkData.ISDISCOUNT = Constz.Discount.Calculated.Code; else if (radNoDiscount.Checked == true) bkData.ISDISCOUNT = Constz.Discount.NotCalculated.Code; if (radRefund.Checked == true) bkData.ISREFUND = Constz.Refund.Yes.Code; else if (radNoRefund.Checked == true) bkData.ISREFUND = Constz.Refund.No.Code; bkData.REMARK = txtRemark.Text.Trim(); if (Session["tempTab"] != null) tempTable = (DataTable)Session["tempTab"]; if (bkFlow.CheckCode(bkData.LOID, bkData.CODE.Trim()) == false) Appz.ClientAlert(Page, "ÃËÑÊ¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ"); if (bkFlow.CheckName(bkData.LOID, bkData.NAME.Trim()) == false) Appz.ClientAlert(Page, "ª×èÍ¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ"); if (bkFlow.CheckBarcode(bkData.LOID, bkData.BARCODE.Trim()) == false) Appz.ClientAlert(Page, "ºÒÃìâ¤é´¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ"); ret = bkFlow.UpdateData(Authz.CurrentUserInfo.UserID, bkData, tempTable); if (ret == false) Appz.ClientAlert(Page, bkFlow.ErrorMessage); else { //ClearControls(); //LoadData(bkData.BARCODE); Appz.ClientAlert(Page, "·Ó¡ÒÃá¡é䢢éÍÁÙÅ¡ÃÐàªéÒàÃÕºÃéÍÂ"); LoadData(bkFlow.PBLOID); } }
private double UpdateProductBarcode(string UserID, BasketData bkData ) { bool ret = true; ProductBarcodeDAL bDAL = new ProductBarcodeDAL(); bDAL.GetDataByLOID(bkData.LOID, null); bDAL.ABBNAME = bkData.ABBNAME; bDAL.BARCODE = bkData.BARCODE; bDAL.UNIT = bkData.UNITBASKET; bDAL.COST = bkData.COST; bDAL.PRICE = bkData.PRICE; bDAL.ISVAT = bkData.ISVAT; bDAL.ISDISCOUNT = bkData.ISDISCOUNT; bDAL.ISREFUND = bkData.ISREFUND; bDAL.ACTIVE = bkData.ACTIVE; bDAL.STDPRICE = bkData.PRICE; bDAL.MULTIPLY = 1; ret = bDAL.UpdateCurrentData(UserID, null); if (ret == false) { _error = bDAL.ErrorMessage; return 0; } else { return bDAL.LOID; } }
private bool UpdateProductMaster(string UserID, BasketData bkData) { bool ret = true; ProductMasterDAL oDAL = new ProductMasterDAL(); oDAL.GetDataByLOID(bkData.PRODUCTMASTER, null); oDAL.CODE = bkData.CODE; oDAL.NAME = bkData.NAME; oDAL.ENAME = bkData.ENAME; oDAL.UNIT = bkData.UNITBASKET; oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP; oDAL.ACTIVE = bkData.ACTIVE; ret = oDAL.UpdateCurrentData(UserID, null); if (ret == false) { _error = oDAL.ErrorMessage; return ret; } else return ret; }
public bool UpdateData(string UserID, BasketData bkData, DataTable tempTable) { bool ret = true; ret = UpdateProductMaster(UserID, bkData); if (ret == false ) return false; _PBLOID = UpdateProductBarcode(UserID, bkData); if (_PBLOID == 0) return false; if (UpdatePackage(UserID, tempTable, _PBLOID) == false) return false; else { return true; } //bool ret = true; //ProductDAL oDAL = new ProductDAL(); //OracleDBObj objDB = new OracleDBObj(); //objDB.CreateConnection(); //objDB.CreateTransaction(); //try //{ // oDAL.GetDataByLOID(bkData.LOID, null); // oDAL.CODE = bkData.CODE; // oDAL.NAME = bkData.NAME; // oDAL.ABBNAME = bkData.ABBNAME; // oDAL.BARCODE = bkData.BARCODE; // oDAL.UNIT = bkData.UNITBASKET; // oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP; // oDAL.COST = bkData.COST; // oDAL.PRICE = bkData.PRICE; // oDAL.STDPRICE = bkData.STDPRICE; // oDAL.ISVAT = bkData.ISVAT; // oDAL.ISDISCOUNT = bkData.ISDISCOUNT; // oDAL.ISEDIT = bkData.ISEDITPRICE; // oDAL.ISREFUND = bkData.ISREFUND; // oDAL.REMARK = bkData.REMARK; // oDAL.ACTIVE = "1"; // ret = oDAL.UpdateCurrentData(UserID, objDB.zTrans); // if (ret == true) // { // if (tempTable.Rows.Count > 0) // { // if (UpdatePackage(UserID, tempTable, objDB, oDAL.LOID) == true) // { // objDB.zTrans.Commit(); // ret = true; // } // else // { // objDB.zTrans.Rollback(); // ret = false; // } // } // else // { // objDB.zTrans.Commit(); // ret = true; // } // } // else // { // _error = oDAL.ErrorMessage; // objDB.zTrans.Rollback(); // ret = false; // } //} //catch (Exception ex) //{ // _error = ex.Message; ; // objDB.zTrans.Rollback(); // ret = false; //} //objDB.CloseConnection(); //return ret; }
private double InsertProductBarcode(string UserID, BasketData bkData, double ProductMaster) { bool ret = true; ProductBarcodeDAL bDAL = new ProductBarcodeDAL(); bDAL.PRODUCTMASTER = ProductMaster; bDAL.ABBNAME = bkData.ABBNAME; bDAL.BARCODE = bkData.BARCODE; bDAL.UNIT = bkData.UNITBASKET; bDAL.COST = bkData.COST; bDAL.PRICE = bkData.PRICE; bDAL.ISVAT = bkData.ISVAT; bDAL.ISDISCOUNT = bkData.ISDISCOUNT; bDAL.ISREFUND = bkData.ISREFUND; bDAL.ACTIVE = bkData.ACTIVE; bDAL.STDPRICE = bkData.PRICE; bDAL.MULTIPLY = 1; bDAL.ISEDIT = "Y"; bDAL.ISDEFAULT = "Y"; ret = bDAL.InsertCurrentData(UserID, null); if (ret == false) { string sqlDelete = "DELETE FROM PRODUCTMASTER WHERE LOID = " + ProductMaster; OracleDB.ExecNonQueryCmd(sqlDelete); _error = bDAL.ErrorMessage; return 0; } else { return bDAL.LOID; } }
private double InsertProductMaster(string UserID, BasketData bkData) { bool ret = true; ProductMasterDAL oDAL = new ProductMasterDAL(); oDAL.CODE = bkData.CODE; oDAL.NAME = bkData.NAME; oDAL.ENAME = bkData.ENAME; oDAL.UNIT = bkData.UNITBASKET; oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP; oDAL.ACTIVE = bkData.ACTIVE; ret = oDAL.InsertCurrentData(UserID, null); if (ret == false) { _error = oDAL.ErrorMessage; return 0; } else return oDAL.LOID; }