public ReturnTesterData GetData() { ReturnTesterData data = new ReturnTesterData(); data.CREATEBY = this.txtCreateBy.Text; data.CREATEON = this.dtpCreateOn.Value; data.ACTIVE = Constz.ActiveStatus.Active; if (this.txtStatus.Text != Constz.Requisition.Status.Waiting.Code) { data.APPROVEDATE = dtpApproveDate.Value; data.APPROVER = Convert.ToDouble(this.txtApprover.Text == "" ? "0" : this.txtApprover.Text); } data.CODE = this.txtCode.Text; data.DOCTYPE = Constz.DocType.RetSample.LOID; data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.REASON = this.txtReason.Text.Trim(); if (this.cmbReceiver.SelectedValue != null) data.RECEIVER = Convert.ToDouble(this.cmbReceiver.SelectedValue); data.REMARK = this.txtRemark.Text.Trim(); data.SENDER = Convert.ToDouble(this.txtSender.Text); data.STATUS = this.txtStatus.Text.Trim(); data.STOCKITEM = new ArrayList(); foreach (DataGridViewRow gRow in this.grvStockIn.Rows) { if (!gRow.IsNewRow) { StockOutItemData itemData = new StockOutItemData(); itemData.ACTIVE = Constz.ActiveStatus.Active; itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value); itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value); itemData.STATUS = data.STATUS; itemData.UNIT = Convert.ToDouble(gRow.Cells["UNIT"].Value); data.STOCKITEM.Add(itemData); } } return data; }
public ReturnTesterData GetData(double loid) { ReturnTesterData data = new ReturnTesterData(); if (DALObj.GetDataByLOID(loid, null)) { data.APPROVEDATE = DALObj.APPROVEDATE; data.APPROVER = DALObj.APPROVER; data.CODE = DALObj.CODE; data.CREATEBY = DALObj.CREATEBY; data.CREATEON = DALObj.CREATEON; data.DOCTYPE = DALObj.DOCTYPE; data.LOID = DALObj.LOID; data.REASON = DALObj.REASON; data.RECEIVER = DALObj.RECEIVER; data.REMARK = DALObj.REMARK; data.SENDER = DALObj.SENDER; data.STATUS = DALObj.STATUS; data.STOCKITEM = new ArrayList(); DataTable dt = SearchDAL.GetStockOutItem(loid); int i = 1; foreach (DataRow dRow in dt.Rows) { ReturnTesterItemData itemData = new ReturnTesterItemData(); itemData.ORDERNO = i; itemData.BARCODE = dRow["BARCODE"].ToString(); itemData.NAME = dRow["NAME"].ToString(); itemData.QTY = Convert.ToDouble(dRow["QTY"]); itemData.PRICE = Convert.ToDouble(dRow["PRICE"]); itemData.UNITNAME = dRow["UNITNAME"].ToString(); itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]); itemData.UNIT = Convert.ToDouble(dRow["UNIT"]); data.STOCKITEM.Add(itemData); } } return data; }
public void SetData(ReturnTesterData data) { this.txtStatus.Text = data.STATUS; SetStatusName(data.STATUS); this.txtApprover.Text = data.APPROVER.ToString(); if (data.APPROVEDATE.Year != 1) this.dtpApproveDate.Value = data.APPROVEDATE; this.txtCode.Text = data.CODE; this.txtLOID.Text = data.LOID.ToString(); this.txtReason.Text = data.REASON; this.cmbReceiver.SelectedValue = data.RECEIVER; this.txtRemark.Text = data.REMARK; this.txtSender.Text = data.SENDER.ToString(); this.grvStockIn.Rows.Clear(); this.txtDate.Text = data.CREATEON.ToString("dd/MM/yyyy"); this.dtpCreateOn.Value = data.CREATEON; this.txtCreateBy.Text = data.CREATEBY; for (int i = 0; i < data.STOCKITEM.Count; ++i) { ReturnTesterItemData itemData = (ReturnTesterItemData)data.STOCKITEM[i]; DataGridViewRow gRow = (DataGridViewRow)this.grvStockIn.Rows[this.grvStockIn.NewRowIndex].Clone(); gRow.Cells[indexORDERNO].Value = i + 1; gRow.Cells[indexBARCODE].Value = itemData.BARCODE; gRow.Cells[indexNAME].Value = itemData.NAME; gRow.Cells[indexQTY].Value = itemData.QTY; gRow.Cells[indexUNITNAME].Value = itemData.UNITNAME; gRow.Cells[indexPRICE].Value = itemData.PRICE; gRow.Cells[indexNETPRICE].Value = itemData.PRICE * itemData.QTY; gRow.Cells[indexPRODUCT].Value = itemData.PRODUCT; gRow.Cells[indexUNIT].Value = itemData.UNIT; this.grvStockIn.Rows.Add(gRow); } if (data.STATUS != Constz.Requisition.Status.Waiting.Code) { this.grvStockIn.AllowUserToAddRows = false; this.grvStockIn.AllowUserToDeleteRows = false; this.grvStockIn.ReadOnly = true; this.btnSave.Enabled = false; this.btnSubmit.Enabled = false; this.grvStockIn.Columns[indexSEARCH].Visible = false; } else { this.grvStockIn.AllowUserToAddRows = true; this.grvStockIn.AllowUserToDeleteRows = true; this.grvStockIn.ReadOnly = false; this.btnSave.Enabled = true; this.btnSubmit.Enabled = true; this.grvStockIn.Columns[indexSEARCH].Visible = true; } CalculateGrandTotal(); }
private bool SaveData(ReturnTesterData data) { bool ret = true; ret = FlowObj.UpdateData(Appz.CurrentUserData.UserID, data); if (ret) SetData(FlowObj.GetData(FlowObj.LOID)); else Appz.OpenErrorDialog(FlowObj.ErrorMessage); return ret; }
public bool ValidateData(ReturnTesterData data) { bool ret = true; if (data.RECEIVER == 0) { ret = false; _error = "¡ÃسÒàÅ×Í¡¤ÅѧÊÔ¹¤éÒ"; } else if (data.REASON.Trim() == "") { ret = false; _error = "¡ÃسÒÃкØà˵ؼÅ㹡Òä׹ÊÔ¹¤éÒµÑÇÍÂèÒ§"; } else if (data.STOCKITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } return ret; }
public bool UpdateData(string userID, ReturnTesterData data) { bool ret = true; bool cutstock = 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 && data.STATUS == Constz.Requisition.Status.Approved.Code); DALObj.ACTIVE = data.ACTIVE; DALObj.APPROVEDATE = data.APPROVEDATE; DALObj.APPROVER = data.APPROVER; DALObj.DOCTYPE = data.DOCTYPE; DALObj.REASON = data.REASON; DALObj.RECEIVER = data.RECEIVER; DALObj.REMARK = data.REMARK; DALObj.SENDER = data.SENDER; DALObj.STATUS = data.STATUS; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else { DALObj.CODE = OracleDB.GetRunningCode("STOCKOUT", data.DOCTYPE.ToString(), obj.zTrans); ret = DALObj.InsertCurrentData(userID, obj.zTrans); cutstock = false; } _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } StockOutItemDAL itemDAL = new StockOutItemDAL(); itemDAL.DeleteDataByStockOut(DALObj.LOID, obj.zTrans); for (Int16 i = 0; i < data.STOCKITEM.Count; ++i) { StockOutItemData item = (StockOutItemData)data.STOCKITEM[i]; itemDAL.ACTIVE = item.ACTIVE; itemDAL.LOTNO = item.LOTNO; itemDAL.PRODUCT = item.PRODUCT; itemDAL.QTY = item.QTY; itemDAL.STATUS = item.STATUS; itemDAL.STOCKOUT = DALObj.LOID; itemDAL.UNIT = item.UNIT; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } if (cutstock) { ret = DALObj.CutStock(DALObj.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; } } else ret = false; return ret; }