private void SetData2(StockoutFGData data) { this.txtSTCode.Text = data.CODE.ToString(); this.txtSTLoid.Text = data.LOID.ToString(); this.txtSupplier.Text = data.RECEIVER.ToString(); this.txtRemark.Text = data.REMARK; this.txtReason.Text = data.REASON; this.ctlSTDate.DateValue = data.CREATEON; ABB.Data.Purchase.SupplierData sData = FlowObj.GetSupplierData(data.RECEIVER); this.txtSupplierName.Text = sData.SUPPLIERNAME; this.txtName.Text = (sData.CNAME + " " + sData.CLASTNAME).Trim(); this.txtAddress.Text = sData.CADDRESS; this.txtTel.Text = sData.CTEL; this.txtFax.Text = sData.CFAX; this.grvPDReturn.DataSource = FlowObj.GetStockoutItemList(data.LOID); this.grvPDReturn.DataBind(); }
private StockoutFGData GetData() { StockoutFGData data = new StockoutFGData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.ACTIVE = Constz.ActiveStatus.Active; data.REASON = this.txtReason.Text.Trim(); data.CODE = this.txtCode.Text.Trim(); data.RECEIVER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text); data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text); data.ITEM = ItemObj.GetItemList(); data.REMARK = this.txtRemark.Text.Trim(); data.STATUS = this.txtStatus.Text.Trim(); data.DOCTYPE = Constz.DocType.RetRaw.LOID; return data; }
private void SetData(StockoutFGData data) { this.txtLOID.Text = data.LOID.ToString(); this.txtStatus.Text = data.STATUS; this.txtCustomer.Text = data.RECEIVER.ToString(); this.txtSender.Text = data.SENDER.ToString(); this.ctlCreateDate.DateValue = data.CREATEON; this.txtCustomerCode.Text = ""; this.txtCustomerName.Text = ""; this.txtCode.Text = data.CODE; this.txtReason.Text = data.REASON; this.txtRemark.Text = data.REMARK; this.txtCreateBy.Text = data.CREATEBY; this.txtStatusName.Text = (data.STATUS == Constz.Requisition.Status.Approved.Code ? Constz.Requisition.Status.Approved.Name : (data.STATUS == Constz.Requisition.Status.Void.Code ? Constz.Requisition.Status.Void.Name : Constz.Requisition.Status.Waiting.Name)); this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat); SetCustomerData(data.RECEIVER); SetGrvItem(data.STATUS); Calculation(); if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnCancelShow = false; this.ctlToolbar.BtnSubmitShow = false; } this.ctlToolbar.ClientClickPrint = Appz.ReportScript(Constz.Report.ProductReturn, data.LOID) + " return false;"; }
private StockoutFGData GetData() { StockoutFGData data = new StockoutFGData(); data.LOID = Convert.ToDouble(this.txtLOID.Text); data.ACTIVE = Constz.ActiveStatus.Active; data.CADDRESS = this.txtAddress.Text.Trim(); data.CFAX = this.txtFax.Text.Trim(); data.CLASTNAME = this.txtLastName.Text.Trim(); data.CNAME = this.txtName.Text.Trim(); data.CTEL = this.txtTel.Text.Trim(); data.CTITLE = Convert.ToDouble(this.cmbTitle.SelectedItem.Value); data.DOCTYPE = Convert.ToDouble(this.txtDocType.Text == "" ? "0" : this.txtDocType.Text); data.RECEIVER = Convert.ToDouble(this.txtReceiver.Text == "" ? "0" : this.txtReceiver.Text); data.REFLOID = Convert.ToDouble(this.txtRefLoid.Text == "" ? "0" : this.txtRefLoid.Text); data.REFTABLE = "REQUISITION"; data.REMARK = this.txtRemark.Text.Trim(); data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text); data.STATUS = this.txtStatus.Text.Trim(); data.ITEM = ItemObj.GetItemList(); return data; }
private void SetData(StockoutFGData data) { this.txtLOID.Text = data.LOID.ToString(); SetDocTypeName(data.DOCTYPE); this.txtRefNo.Text = data.REQUISITIONCODE; this.txtCustomerCode.Text = data.CUSTOMERCODE; this.txtCustomerName.Text = data.CUSTOMERNAME; this.cmbTitle.SelectedIndex = this.cmbTitle.Items.IndexOf(this.cmbTitle.Items.FindByValue(data.CTITLE.ToString())); this.txtName.Text = data.CNAME; this.txtLastName.Text = data.CLASTNAME; this.txtAddress.Text = data.CADDRESS; this.txtTel.Text = data.CTEL; this.txtFax.Text = data.CFAX; this.txtRefLoid.Text = data.REFLOID.ToString(); this.txtStatus.Text = data.STATUS; this.txtStatusName.Text = Appz.GetStatusName(data.STATUS); this.txtSender.Text = data.SENDER.ToString(); this.txtReceiver.Text = data.RECEIVER.ToString(); this.txtCode.Text = data.CODE; this.ctlCreateOn.DateValue = data.CREATEON; this.ctlReserveDate.DateValue = data.RESERVEDATE; this.txtCreateBy.Text = data.CREATEBY; this.txtRemark.Text = data.REMARK; this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat); this.btnSearch.Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code); this.ctlToolbar.BtnSaveShow = (data.STATUS == Constz.Requisition.Status.Waiting.Code); this.ctlToolbar.BtnSubmitShow = (data.STATUS == Constz.Requisition.Status.Waiting.Code); SetPeriod(); SetGrvItem(data.STATUS); //print if (data.DOCTYPE == Constz.DocType.ReqSupport.LOID) this.ctlToolbar.BtnPrintShow = false; else if (data.DOCTYPE == Constz.DocType.ReqFair.LOID) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOutBorrow, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (data.DOCTYPE == Constz.DocType.ReqDistribute.LOID || data.DOCTYPE == Constz.DocType.ReqProduct.LOID || data.DOCTYPE == Constz.DocType.Reserve.LOID) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOut, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (data.DOCTYPE == Constz.DocType.ReqOrgSupport.LOID) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOutSupport, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else this.ctlToolbar.ClientClickPrint = "return false; "; if (data.DOCTYPE == Constz.DocType.ReqProduct.LOID) { this.txtCustomerCode.Text = data.WAREHOUSECODE; this.txtCustomerName.Text = data.WAREHOUSENAME; } }
private bool VerifyData(StockoutFGData data) { bool ret = true; if (data.ITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкءÒÃÊÔ¹¤éÒ"; } else if (data.RECEIVER == 0) { ret = false; _error = "¡ÃسÒÃкØÅÙ¡¤éÒ"; } else if (data.REASON == "") { ret = false; _error = "¡ÃسÒÃкØÊÒà˵ءÒÃÊ觤׹"; } return ret; }
public bool UpdateData(string userID, StockoutFGData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data, obj.zTrans); obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public bool UpdateDataReturn(string userID, StockoutFGData data) { bool ret = true; if (!VerifyData(data)) throw new ApplicationException(_error); OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.ACTIVE = data.ACTIVE; DALObj.CADDRESS = data.CADDRESS; DALObj.CFAX = data.CFAX; DALObj.CLASTNAME = data.CLASTNAME; DALObj.CNAME = data.CNAME; DALObj.CTEL = data.CTEL; DALObj.CTITLE = data.CTITLE; DALObj.RECEIVER = data.RECEIVER; DALObj.DELIVERYDATE = data.DELIVERYDATE; DALObj.REMARK = data.REMARK; DALObj.REASON = data.REASON; DALObj.REQDATE = data.REQDATE; DALObj.DOCTYPE = data.DOCTYPE; DALObj.STATUS = data.STATUS; DALObj.REFLOID = data.REFLOID; DALObj.REFTABLE = data.REFTABLE; DALObj.PRODUCTREF = data.PRODUCTREF; DALObj.SENDER = data.SENDER; DALObj.INVCODE = data.INVCODE; // DALObj.REASON = data.REASON; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else ret = DALObj.InsertCurrentData(userID, obj.zTrans); _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } StockOutItemDAL itemDAL = new StockOutItemDAL(); itemDAL.DeleteDataByStockOut(data.LOID, obj.zTrans); for (Int16 i = 0; i < data.ITEM.Count; ++i) { RequisitionItemData item = (RequisitionItemData)data.ITEM[i]; itemDAL.ACTIVE = item.ACTIVE; itemDAL.PRODUCT = item.PRODUCT; itemDAL.QTY = item.QTY; itemDAL.PRICE = item.PRICE; itemDAL.INVNO = item.INVNO; itemDAL.STOCKOUT = DALObj.LOID; itemDAL.UNIT = item.UNIT; itemDAL.LOTNO = item.LOTNO; itemDAL.STATUS = data.STATUS; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); }//for obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
private void UpdateData(string userID, StockoutFGData data, System.Data.OracleClient.OracleTransaction zTrans) { bool ret = true; DALObj.GetDataByLOID(data.LOID, zTrans); DALObj.ACTIVE = data.ACTIVE; DALObj.CADDRESS = data.CADDRESS; DALObj.CFAX = data.CFAX; DALObj.CLASTNAME = data.CLASTNAME; DALObj.CNAME = data.CNAME; DALObj.CTEL = data.CTEL; DALObj.CTITLE = data.CTITLE; DALObj.RECEIVER = data.RECEIVER; DALObj.DELIVERYDATE = data.DELIVERYDATE; DALObj.REMARK = data.REMARK; DALObj.REASON = data.REASON; DALObj.REQDATE = data.REQDATE; DALObj.DOCTYPE = data.DOCTYPE; DALObj.STATUS = data.STATUS; DALObj.REFTABLE = data.REFTABLE; DALObj.REFLOID = data.REFLOID; //DALObj.REFPROD = data.REFPROD; DALObj.PRODUCTREF = data.PRODUCTREF; DALObj.INVCODE = data.INVCODE; //DALObj.REASON = data.REASON; DALObj.SENDER = data.SENDER; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, zTrans); else ret = DALObj.InsertCurrentData(userID, zTrans); _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } DALItemObj.DeleteDataByStockOut(_LOID, zTrans); for (int i = 0; i < data.ITEM.Count; i++) { StockOutItemData itemData = (StockOutItemData)data.ITEM[i]; _itemDAL = new StockOutItemDAL(); DALItemObj.ACTIVE = itemData.ACTIVE; DALItemObj.LOTNO = itemData.LOTNO; DALItemObj.PRICE = itemData.PRICE; DALItemObj.PRODUCT = itemData.PRODUCT; DALItemObj.QTY = itemData.QTY; DALItemObj.REFLOID = itemData.REFLOID; DALItemObj.REFTABLE = itemData.REFTABLE; DALItemObj.STATUS = data.STATUS; DALItemObj.STOCKOUT = _LOID; DALItemObj.UNIT = itemData.UNIT; DALItemObj.INVNO = itemData.INVNO; ret = DALItemObj.InsertCurrentData(userID, zTrans); if (!ret) throw new ApplicationException(DALItemObj.ErrorMessage); } }
public StockoutFGData GetData(double loid) { StockoutFGData data = new StockoutFGData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.ACTIVE = DALObj.ACTIVE; //data.REQCODE = GetRequisitionCode(DALObj2.REFLOID); data.REFLOID = DALObj.REFLOID; data.CADDRESS = DALObj.CADDRESS; data.CFAX = DALObj.CFAX; data.CLASTNAME = DALObj.CLASTNAME; data.CNAME = DALObj.CNAME; data.CODE = DALObj.CODE; data.CREATEON = DALObj.CREATEON; data.CREATEBY = DALObj.CREATEBY; data.CTEL = DALObj.CTEL; data.CTITLE = DALObj.CTITLE; data.RECEIVER = DALObj.RECEIVER; data.DELIVERYDATE = DALObj.DELIVERYDATE; data.INVCODE = DALObj.INVCODE; data.REMARK = DALObj.REMARK; data.REQDATE = DALObj.REQDATE; data.DOCTYPE = DALObj.DOCTYPE; data.STATUS = DALObj.STATUS; data.REASON = DALObj.REASON; data.SENDER = DALObj.SENDER; data.TOTAL = DALObj.SumPrice(DALObj.LOID, null); StockOutFGReqData reqData = GetRequisitionData(data.REFLOID); data.RESERVEDATE = reqData.RESERVEDATE; data.REQUISITIONCODE = reqData.REQUISITIONCODE; } return data; }
public bool UpdateData(string userID, StockoutFGData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { _LOID = data.LOID; DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code || DALObj.STATUS == "") UpdateData(userID, data, obj.zTrans); obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public bool CommitData(string userID, StockoutFGData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { _LOID = data.LOID; DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code) { if (Convert.ToDouble(OracleDB.ExecSingleCmd("SELECT COUNT(LOID) FROM STOCKOUTITEM WHERE LOTNO IS NULL AND STOCKOUT = " + data.LOID.ToString(), obj.zTrans)) > 0) throw new ApplicationException("ÁÕºÒ§ÃÒ¡Ò÷ÕèäÁèä´éÃÐºØ lot No."); data.STATUS = Constz.Requisition.Status.Approved.Code; UpdateData(userID, data, obj.zTrans); ret = DALItemObj.UpdateStatusByStockOut(_LOID, data.STATUS, userID, obj.zTrans); if (!ret) throw new ApplicationException(DALItemObj.ErrorMessage); ret = DALObj.CutStock(_LOID, userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
private bool VerifyData(StockoutFGData data, System.Data.OracleClient.OracleTransaction zTrans) { bool ret = true; if (data.REFLOID == 0) { ret = false; _error = "¡ÃسÒàÅ×Í¡ÃÒ¡ÒâÍàºÔ¡"; } else if (data.ITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкءÒÃÊÔ¹¤éÒ¢ÍàºÔ¡"; } else if (DALObj.GetStockOutByReference(data.REFLOID, "REQUISITION", data.LOID, zTrans) > 0) { ret = false; _error = "äÁèÊÒÁÒöÍÅ×͡㺤Ӣ͹Õéä´é à¹×èͧ¨Ò¡ÊÃéÒ§ãºàºÔ¡áÅéÇ"; } return ret; }