private void SetData(StockinReturnData data) { if (data.LOID != 0) this.cmbDocType.Enabled = false; else this.cmbDocType.Enabled = true; this.txtLOID.Text = data.LOID.ToString(); this.txtStatus.Text = data.STATUS; this.txtSender.Text = data.SENDER.ToString(); this.cmbDocType.SelectedIndex = this.cmbDocType.Items.IndexOf(this.cmbDocType.Items.FindByValue(data.DOCTYPE.ToString())); //print if (data.DOCTYPE.ToString() == Constz.DocType.RetInReduce.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnPDRequest, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (data.DOCTYPE.ToString() == Constz.DocType.RetDistribute.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.FGStockInReturnProduct, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (data.DOCTYPE.ToString() == Constz.DocType.RetFair.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockInReturn, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (data.DOCTYPE.ToString() == Constz.DocType.RetInSample.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnPDExam, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; DataTable dt = FlowObj.GetRefData(data.REFLOID.ToString()); if (dt.Rows.Count > 0) { this.txtRefCode.Text = dt.Rows[0]["DOCCODE"].ToString(); } this.txtCustomerCode.Text = ""; this.txtCustomerName.Text = ""; 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.txtCode.Text = data.CODE; this.ctlReceiveDate.DateValue = data.RECEIVEDATE; this.txtRemark.Text = data.REMARK; this.txtCreateBy.Text = data.CREATEBY; this.txtStatusName.Text = Appz.GetStatusName(data.STATUS); this.txtVat.Text = SysConfigFlow.GetValue(Constz.ConfigName.VAT); this.txtGrandTotal.Text = data.GRANDTOT.ToString(Constz.DblFormat); SetCustomerData(data.SENDER, false); SetGrvItem(data.STATUS); Calculation(); if (data.STATUS != Constz.Requisition.Status.Waiting.Code) { this.btnSearch.Visible = false; this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnSubmitShow = false; } }
public bool CommitData(string userID, StockinReturnData data) { bool ret = true; bool cutstock = true; bool custockinreturnlost = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); cutstock = (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code); custockinreturnlost = cutstock; UpdateData(userID, data, obj.zTrans); if (cutstock) { StockInDAL sDAL = new StockInDAL(); ret = sDAL.CutStock(DALObj.LOID, userID, obj.zTrans); if (!ret) _error = sDAL.ErrorMessage; } if (custockinreturnlost) { StockInDAL sDAL = new StockInDAL(); ret = sDAL.CutStockInReturnLost(DALObj.LOID, userID, obj.zTrans); if (!ret) _error = sDAL.ErrorMessage; } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
public bool UpdateData(string userID, StockinReturnData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); UpdateData(userID, data, obj.zTrans); obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
private void UpdateData(string userID, StockinReturnData data, System.Data.OracleClient.OracleTransaction trans) { bool ret = true; DALObj.CODE = data.CODE; DALObj.DOCTYPE = data.DOCTYPE; DALObj.SENDER = data.SENDER; DALObj.RECEIVEDATE = data.RECEIVEDATE; DALObj.STATUS = data.STATUS; DALObj.REMARK = data.REMARK; DALObj.GRANDTOT = data.GRANDTOT; DALObj.CADDRESS = data.CADDRESS; DALObj.REFLOID = data.REFLOID; DALObj.REFTABLE = data.REFTABLE; DALObj.CTITLE = data.CTITLE; DALObj.CNAME = data.CNAME; DALObj.CLASTNAME = data.CLASTNAME; DALObj.CTEL = data.CTEL; DALObj.CFAX = data.CFAX; DALObj.RECEIVER = data.RECEIVER; DALObj.APPROVEDATE = data.APPROVEDATE; DALObj.APPROVER = data.APPROVER; if (DALObj.OnDB) { ret = DALObj.UpdateCurrentData(userID, trans); } else { ret = DALObj.InsertCurrentData(userID, trans); } if (!ret) throw new ApplicationException(DALObj.ErrorMessage); _LOID = DALObj.LOID; StockInItemDAL itemDAL = new StockInItemDAL(); itemDAL.DeleteDataByStockIn(data.LOID, trans); for (Int16 i = 0; i < data.ITEM.Count; ++i) { StockinReturnItemData item = (StockinReturnItemData)data.ITEM[i]; itemDAL.STOCKIN = DALObj.LOID; itemDAL.PRODUCT = item.PRODUCT; itemDAL.UNIT = item.UNIT; itemDAL.LOTNO = item.LOTNO; itemDAL.PRICE = item.PRICE; itemDAL.QTY = item.QTY; itemDAL.QTYLOST = item.QTYLOST; itemDAL.REFLOID = item.REFLOID; itemDAL.REFTABLE = item.REFTABLE; itemDAL.STATUS = DALObj.STATUS; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, trans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } }
public bool ValidateData(StockinReturnData data) { bool ret = true; if (data.SENDER == 0) { ret = false; _error = "¡ÃسÒàÅ×Í¡ÅÙ¡¤éÒ"; } if (data.ITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } return ret; }
public StockinReturnData GetData(double loid) { StockinReturnData data = new StockinReturnData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.CREATEBY = DALObj.CREATEBY; data.CODE = DALObj.CODE; data.DOCTYPE = DALObj.DOCTYPE; data.SENDER = DALObj.SENDER; data.RECEIVEDATE = DALObj.RECEIVEDATE; data.STATUS = DALObj.STATUS; data.REMARK = DALObj.REMARK; data.GRANDTOT = DALObj.GRANDTOT; data.CADDRESS = DALObj.CADDRESS; data.REFLOID = DALObj.REFLOID; data.REFTABLE = DALObj.REFTABLE; data.CTITLE = DALObj.CTITLE; data.CNAME = DALObj.CNAME; data.CLASTNAME = DALObj.CLASTNAME; data.CTEL = DALObj.CTEL; data.CFAX = DALObj.CFAX; } return data; }
private StockinReturnData GetData() { StockinReturnData data = new StockinReturnData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.CODE = this.txtCode.Text.Trim(); data.RECEIVEDATE = this.ctlReceiveDate.DateValue; data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text); data.DOCTYPE = Convert.ToDouble(this.cmbDocType.SelectedItem.Value); data.RECEIVER = Authz.CurrentUserInfo.Warehouse; data.STATUS = this.txtStatus.Text.Trim(); data.REMARK = this.txtRemark.Text.Trim(); data.ITEM = ItemObj.GetItemList(); data.GRANDTOT = Convert.ToDouble(this.txtGrandTotal.Text == "" ? "0" : this.txtGrandTotal.Text); data.CADDRESS = this.txtAddress.Text.Trim(); data.CTITLE = Convert.ToDouble(this.cmbTitle.SelectedItem.Value); data.CNAME = this.txtName.Text.Trim(); data.CLASTNAME = this.txtLastName.Text.Trim(); data.CTEL = this.txtTel.Text.Trim(); data.CFAX = this.txtFax.Text.Trim(); data.REFLOID = Convert.ToDouble(this.txtRefLOID.Text == "" ? "0" : this.txtRefLOID.Text); data.REFTABLE = this.txtRefTable.Text.Trim(); return data; }
private void SetData(StockinReturnData data) { // Setdata from Old REQUISITION if (data.RECEIVEDATE.Year == 1) data.RECEIVEDATE = DateTime.Now.Date; this.txtLOID.Text = data.LOID.ToString(); //###### this.txtStatus.Text = (data.STATUS != "" ? data.STATUS : txtStatus.Text); 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 : (data.STATUS == Constz.Requisition.Status.QC.Code ? Constz.Requisition.Status.QC.Name : (data.STATUS == Constz.Requisition.Status.Finish.Code ? Constz.Requisition.Status.Finish.Name : Constz.Requisition.Status.Waiting.Name)))); this.txtWareHouse.Text = (data.WAREHOUSE != 0 ? data.WAREHOUSE.ToString() : txtWareHouse.Text); this.txtCode.Text = data.CODE; this.txtRemark.Text = data.REMARK; this.txtRefLoid.Text = data.REFLOID.ToString(); SetPDdata(data.REFLOID); SetGrvItem(this.txtStatus.Text); if (data.STATUS == Constz.Requisition.Status.Finish.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnSubmitShow = false; } this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnMaterial, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; }
private StockinReturnData GetData() { StockinReturnData data = new StockinReturnData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.DOCTYPE = Constz.DocType.RetMaterial.LOID; data.WAREHOUSE = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text); data.REMARK = this.txtRemark.Text.Trim(); data.STATUS = this.txtStatus.Text.Trim(); data.REFTABLE = "REQUISITION"; data.REFLOID = Convert.ToDouble(this.txtRefLoid.Text == "" ? "0" : this.txtRefLoid.Text); data.RECEIVEDATE = ctlReceiveDate.DateValue; data.ITEM = ItemObj.GetItemList(); data.STATUS = txtStatus.Text.Trim(); data.CODE = txtCode.Text.Trim(); data.RECEIVER = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text); data.SENDER = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text); return data; }
public StockinReturnData DoGetPDData(double loid) { string sql = "SELECT * FROM V_MATERIAL_RETURN_POPUP_LIST WHERE LOID = '" + loid + "' "; DataTable dt = OracleDB.ExecListCmd(sql); StockinReturnData data = new StockinReturnData(); if (dt.Rows.Count > 0) { data.PDBARCODE = dt.Rows[0]["BARCODE"].ToString(); data.PDNAME = dt.Rows[0]["PRODUCTNAME"].ToString(); data.QTY = Convert.ToDouble(dt.Rows[0]["PDQTY"]); data.UNAME = dt.Rows[0]["UNITNAME"].ToString(); data.CODE = dt.Rows[0]["REQCODE"].ToString(); data.REQDATE = Convert.ToDateTime(dt.Rows[0]["REQDATE"]); data.PPLOID = Convert.ToDouble(dt.Rows[0]["PPLOID"]); } return data; }