public StockoutWHData GetData(double loid) { StockoutWHData data = new StockoutWHData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.ACTIVE = DALObj.ACTIVE; data.REQUISITIONTYPE = DALObj.DOCTYPE; data.REQCODE = GetRequisitionCode(DALObj.REFLOID); data.REFLOID = DALObj.REFLOID; //data.TOTAL = GetRequisitionTotal(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.CUSTOMER = DALObj.RECEIVER; data.DUEDATE = DALObj.DELIVERYDATE; data.INVCODE = DALObj.INVCODE; data.REMARK = DALObj.REMARK; data.REQDATE = DALObj.REQDATE; data.STATUS = DALObj.STATUS; data.REFPROD = DALObj.PRODUCTLOID; data.REFTABLE = DALObj.PRODUCTREF; data.DIVISION = DALObj.DIVISION; data.SUPPORTCAUSE = DALObj.SUPPORTCAUSE; data.SUPPORTREFCODE = DALObj.SUPPORTREFCODE; if (data.REQUISITIONTYPE == Constz.Requisition.RequisitionType.REQ12) data.REQCODE = GetPDOrderCode(DALObj.REFLOID); else data.REQCODE = GetRequisitionCode(DALObj.REFLOID); } return data; }
public bool UpdateData(string userID, StockoutWHData 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 CommitData(string userID, StockoutWHData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data, obj.zTrans); DALObj.OnDB = false; 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; }
//public DataTable GetRequisitionItem(double requisition) //{ // StockOutItemDAL itemDAL = new StockOutItemDAL(); // return SearchDAL.GetPurchaseItemList(requisition); //} //public DataTable GetRequisitionItemBlank() //{ // StockOutItemDAL itemDAL = new StockOutItemDAL(); // return SearchDAL.GetPurchaseItemListBlank(); //} //public bool ValidateData(ProductReserveData data) //{ // bool ret = true; // if (data.CUSTOMER == 0) // { // ret = false; // _error = "¡ÃسÒÃкØÅÙ¡¤éÒ"; // } // else if (data.DUEDATE.Year == 1) // { // ret = false; // _error = "¡ÃسҡÓ˹´Çѹ·ÕèÊè§ÊÔ¹¤éÒ"; // } // else if (data.ITEM.Count == 0) // { // ret = false; // _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; // } // return ret; //} private void UpdateData(string userID, StockoutWHData data, System.Data.OracleClient.OracleTransaction zTrans) { bool ret = true; DALObj.GetDataByLOID(data.LOID, zTrans); DALObj.ACTIVE = data.ACTIVE; DALObj.CADDRESS = data.CADDRESS; DALObj.REFTABLE = data.REFTABLE; DALObj.CFAX = data.CFAX; DALObj.CLASTNAME = data.CLASTNAME; DALObj.CNAME = data.CNAME; DALObj.CTEL = data.CTEL; DALObj.CTITLE = data.CTITLE; DALObj.RECEIVER = data.CUSTOMER; DALObj.DELIVERYDATE = data.DUEDATE; DALObj.REMARK = data.REMARK; DALObj.REQDATE = data.REQDATE; DALObj.DOCTYPE = data.REQUISITIONTYPE; DALObj.STATUS = data.STATUS; DALObj.REFLOID = data.REFLOID; DALObj.PRODUCTLOID = data.REFPROD; DALObj.PRODUCTREF = data.PRODUCTREF; DALObj.INVCODE = data.INVCODE; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, zTrans); else ret = DALObj.InsertCurrentData(userID, zTrans); _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } StockOutItemDAL itemDAL = new StockOutItemDAL(); itemDAL.DeleteDataByStockOut(data.LOID, zTrans); for (int i = 0; i < data.STOCKOUTITEM.Rows.Count; i++) { itemDAL.PRODUCT = Convert.ToDouble(data.STOCKOUTITEM.Rows[i]["PRODUCT"]); itemDAL.LOTNO = data.STOCKOUTITEM.Rows[i]["LOTNO"].ToString(); itemDAL.QTY = Convert.ToDouble(data.STOCKOUTITEM.Rows[i]["QTY"]); itemDAL.REFLOID = Convert.ToDouble(data.STOCKOUTITEM.Rows[i]["LOID"]); itemDAL.PRICE = Convert.ToDouble(data.STOCKOUTITEM.Rows[i]["PRICE"]); itemDAL.ACTIVE = Constz.ActiveStatus.Active; itemDAL.STATUS = Constz.Requisition.Status.Waiting.Code; itemDAL.UNIT = Convert.ToDouble(data.STOCKOUTITEM.Rows[i]["UNIT"]); if (data.REQUISITIONTYPE == Constz.DocType.ReqRawPO.LOID) itemDAL.REFTABLE = "BOM"; else itemDAL.REFTABLE = "REQMATERIAL"; itemDAL.STOCKOUT = data.LOID; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } }
public StockoutWHData DoGetReqProduct(double loid) { string sql = "SELECT RQLOID AS LOID,POLOID, RQCODE AS CODE, REQDATE, DUEDATE, PDCODE AS PRODUCTCODE, PDLOID AS PRODUCT, PDNAME AS PRODUCTNAME, QTY AS STDQTY, UNAME AS UNIT, WAREHOUSE FROM V_REQUISITION_PROD WHERE RQLOID = '" + loid + "'"; DataTable dt = OracleDB.ExecListCmd(sql); StockoutWHData data = new StockoutWHData(); if (dt.Rows.Count > 0) { data.LOID = Convert.ToDouble(dt.Rows[0]["LOID"]); data.CODE = dt.Rows[0]["CODE"].ToString(); data.REQDATE = dt.Rows[0]["REQDATE"] == DBNull.Value ? new DateTime(1, 1, 1) : Convert.ToDateTime(dt.Rows[0]["REQDATE"]); data.DUEDATE = dt.Rows[0]["DUEDATE"] == DBNull.Value ? new DateTime(1, 1, 1) : Convert.ToDateTime(dt.Rows[0]["DUEDATE"]); data.PRODUCT = dt.Rows[0]["PRODUCT"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["PRODUCT"]); data.PRODUCTCODE = dt.Rows[0]["PRODUCTCODE"] == DBNull.Value ? "" : dt.Rows[0]["PRODUCTCODE"].ToString(); data.PRODUCTNAME = dt.Rows[0]["PRODUCTNAME"] == DBNull.Value ? "" : dt.Rows[0]["PRODUCTNAME"].ToString(); data.QTY = dt.Rows[0]["STDQTY"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["STDQTY"]); data.UNIT = dt.Rows[0]["UNIT"] == DBNull.Value ? "" : dt.Rows[0]["UNIT"].ToString(); data.CUSTOMER = dt.Rows[0]["WAREHOUSE"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["WAREHOUSE"].ToString()); data.REFPROD = dt.Rows[0]["POLOID"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["POLOID"]); } return data; }
public StockoutWHData DoGetProduct(double loid) { string sql = "SELECT PO_LOID AS LOID,POI_LOID, POCODE AS CODE, ORDERDATE AS REQDATE, DUEDATE, PD_LOID AS PRODUCT, PDCODE AS PRODUCTCODE, PDNAME AS PRODUCTNAME, QTY AS STDQTY, UNAME AS UNIT, S_LOID FROM V_PDORDER_LIST WHERE POI_LOID = '" + loid + "'"; DataTable dt = OracleDB.ExecListCmd(sql); StockoutWHData data = new StockoutWHData(); if (dt.Rows.Count > 0) { data.LOID = Convert.ToDouble(dt.Rows[0]["LOID"]); data.CODE = dt.Rows[0]["CODE"].ToString(); data.REQDATE = dt.Rows[0]["REQDATE"] == DBNull.Value ? new DateTime(1, 1, 1) : Convert.ToDateTime(dt.Rows[0]["REQDATE"]); data.DUEDATE = dt.Rows[0]["DUEDATE"] == DBNull.Value ? new DateTime(1, 1, 1) : Convert.ToDateTime(dt.Rows[0]["DUEDATE"]); data.PRODUCT = dt.Rows[0]["PRODUCT"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["PRODUCT"]); data.PRODUCTCODE = dt.Rows[0]["PRODUCTCODE"] == DBNull.Value ? "" : dt.Rows[0]["PRODUCTCODE"].ToString(); data.PRODUCTNAME = dt.Rows[0]["PRODUCTNAME"] == DBNull.Value ? "" : dt.Rows[0]["PRODUCTNAME"].ToString(); data.QTY = dt.Rows[0]["STDQTY"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["STDQTY"]); data.UNIT = dt.Rows[0]["UNIT"] == DBNull.Value ? "" : dt.Rows[0]["UNIT"].ToString(); data.CUSTOMER = dt.Rows[0]["S_LOID"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["S_LOID"].ToString()); data.REFPROD = dt.Rows[0]["POI_LOID"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[0]["POI_LOID"]); } return data; }
private StockoutWHData GetData() { StockoutWHData data = new StockoutWHData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.ACTIVE = Constz.ActiveStatus.Active; data.REMARK = this.txtRemark.Text.Trim(); data.DIVISION = Convert.ToDouble(this.cmbDivision.SelectedValue); data.DOCTYPE = Convert.ToDouble(this.cmbDocType.SelectedValue); data.SUPPORTCAUSE = this.txtSupportCause.Text ; data.SUPPORTREFCODE =this.txtSupportRefCode.Text ; data.REQUISITIONTYPE = Convert.ToDouble(this.cmbDocType.SelectedItem.Value); data.STATUS = this.txtStatus.Text.Trim(); data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text); data.STOCKOUTITEM = ItemObj.GetItemList(); //FlowObj.GetProductLot(Convert.ToDouble(this.txtRefLoid.Text)); data.DUEDATE = this.ctlDueDate.DateValue; data.REFLOID = Convert.ToDouble(this.txtRef1.Text.Trim()); data.REQDATE = this.ctlReqDate.DateValue; data.INVCODE = this.txtInvCode.Text.Trim(); data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text.Trim()); data.SENDER = Authz.CurrentUserInfo.Warehouse; data.REFPROD = Convert.ToDouble(this.txtRef2.Text.Trim()); if (data.REQUISITIONTYPE == Constz.DocType.ReqRawPO.LOID) { data.REFTABLE = "PDORDER"; data.PRODUCTREF = "POITEM"; } else { data.REFTABLE = "REQUISITION"; data.PRODUCTREF = "PDPRODUCT"; } return data; }
private void SetData2(StockoutWHData data) { this.txtLOID.Text = data.LOID.ToString(); this.txtRefLoid.Text = data.REFLOID.ToString(); this.txtStockCode.Text = data.CODE.ToString(); this.txtStatus.Text = data.STATUS; this.ctlCreateDate.DateValue = data.CREATEON; this.txtCreateBy.Text = data.CREATEBY; this.ctlDueDate.DateValue = data.DUEDATE; this.ctlReqDate.DateValue = data.REQDATE; this.cmbDocType.SelectedIndex = this.cmbDocType.Items.IndexOf(this.cmbDocType.Items.FindByValue(data.REQUISITIONTYPE.ToString())); this.cmbDivision.SelectedValue = data.DIVISION.ToString(); this.txtSupportCause.Text = data.SUPPORTCAUSE; this.txtSupportRefCode.Text = data.SUPPORTREFCODE; this.txtCustomer.Text = data.CUSTOMER.ToString(); this.txtRefNo.Text = data.REQCODE; this.txtWareHouse.Text = data.WAREHOUSE.ToString(); this.txtRef1.Text = data.REFLOID.ToString(); this.txtRef2.Text = data.REFPROD.ToString(); this.txtRemark.Text = data.REMARK; //this.txtCreateBy.Text = data.CREATEBY; // print if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPO.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockoutExportMaterial, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; else if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPD.LOID.ToString()) this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockoutMaterialWH, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; 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); if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPO.LOID.ToString()) { SetProduct(FlowObj.GetProductData(data.REFPROD)); } else { SetProduct(FlowObj.GetReqProductData(data.REFLOID)); } //DataTable dtStock = FlowObj.GetStockOutItem(data.LOID.ToString()); //ViewState["STOCKITEM"] = dtStock; //grvItem.DataSource = ViewState["STOCKITEM"]; // grvItem.DataBind(); SetGrvItem(this.txtStatus.Text); if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnSubmitShow = false; this.ctlToolbar.BtnCancelShow = false; } this.txtTotal.Text = GetNetPrice().ToString(); }
private void SetProduct(StockoutWHData data) { this.txtPD.Text = data.PRODUCT.ToString(); this.txtPDCode.Text = data.PRODUCTCODE; this.txtPDName.Text = data.PRODUCTNAME; this.txtAmount.Text = data.QTY.ToString(); this.txtUnit.Text = data.UNIT; }
private void SetPDorder(StockoutWHData data) { //this.txtWareHouse.Text = data.WAREHOUSE.ToString(); this.txtPD.Text = data.PRODUCT.ToString(); this.txtPDCode.Text = data.PRODUCTCODE; this.txtPDName.Text = data.PRODUCTNAME; this.txtAmount.Text = data.QTY.ToString(); this.cmbDivision.SelectedValue = data.DIVISION.ToString(); this.txtSupportCause.Text = data.SUPPORTCAUSE; this.txtSupportRefCode.Text = data.SUPPORTREFCODE; this.txtUnit.Text = data.UNIT; this.txtStatus.Text = Constz.Requisition.Status.Waiting.Code; this.txtRefNo.Text = data.CODE; this.ctlDueDate.DateValue = data.DUEDATE; this.ctlReqDate.DateValue = data.REQDATE; this.txtCustomer.Text = data.CUSTOMER.ToString(); this.txtStatusName.Text = Constz.Requisition.Status.Waiting.Name; this.ctlCreateDate.DateValue = DateTime.Today; this.txtRef1.Text = data.LOID.ToString(); this.txtRef2.Text = data.REFPROD.ToString(); if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPO.LOID.ToString()) { DataTable dtStock = FlowObj.GetProductLotWH(data.PRODUCT, Authz.CurrentUserInfo.Warehouse); ItemObj.CopyItem(dtStock); //ViewState["STOCKITEM"] = dtStock; } else { DataTable dtStock = FlowObj.GetReqProductLotWH(data.LOID, Authz.CurrentUserInfo.Warehouse); ItemObj.CopyItem(dtStock); //ViewState["STOCKITEM"] = dtStock; } SetGrvItem(this.txtStatus.Text); this.txtTotal.Text = GetNetPrice().ToString(); }
public bool CommitData(string userID, StockoutWHData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data, obj.zTrans); DALObj.OnDB = false; if (data.REQUISITIONTYPE == Constz.DocType.ReqRawPD.LOID) { ret = SearchDAL.UpdatePDProductStatus(Convert.ToDouble(data.REFPROD), Constz.Requisition.Status.RW.Code, userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); else { ret = SearchDAL.UpdatePDOrderStatus(Convert.ToDouble(data.REFPROD), Constz.Requisition.Status.RW.Code, userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.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; } } else ret = false; return ret; }
//public DataTable GetRequisitionItem(double requisition) //{ // StockOutItemDAL itemDAL = new StockOutItemDAL(); // return SearchDAL.GetPurchaseItemList(requisition); //} //public DataTable GetRequisitionItemBlank() //{ // StockOutItemDAL itemDAL = new StockOutItemDAL(); // return SearchDAL.GetPurchaseItemListBlank(); //} public bool ValidateData(StockoutWHData data) { bool ret = true; if (data.DOCTYPE == Constz.DocType.RetSMaterial.LOID && data.DIVISION == 0) { ret = false; _error = "¡ÃسÒàÅ×͡˹èǧҹ"; } else if (data.DOCTYPE == Constz.DocType.RetSMaterial.LOID && data.SUPPORTCAUSE == "") { ret = false; _error = "¡ÃسÒÃкØÊÒà˵ءÒÃʹѺʹع"; } else if (data.REFLOID == 0 && data.DOCTYPE != Constz.DocType.RetSMaterial.LOID) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } else if (data.STOCKOUTITEM.Rows.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÇѵ¶Ø´Ôº"; } return ret; }
private void SetData2(StockoutWHData data) { this.txtLOID.Text = data.LOID.ToString(); this.txtRefLoid.Text = data.REFLOID.ToString(); this.txtStockCode.Text = data.CODE.ToString(); this.txtStatus.Text = data.STATUS; this.ctlCreateDate.DateValue = data.CREATEON; if (data.CREATEON.Year != 1) { this.txtDate.Text = data.CREATEON.ToString().Substring(0, 10); } else { this.txtDate.Text = DateTime.Today.ToString().Substring(0, 10); //this.txtDate.Text = txtDate.Text.Replace("0:00:00", "#").Split('#').ToString(); } this.txtCreateBy.Text = data.CREATEBY; this.cmbDocType.SelectedIndex = this.cmbDocType.Items.IndexOf(this.cmbDocType.Items.FindByValue(data.REQUISITIONTYPE.ToString())); this.cmbDivision.SelectedValue = data.DIVISION.ToString(); this.txtSupportRefCode.Text = data.SUPPORTREFCODE; this.txtSupportCause.Text = data.SUPPORTCAUSE; this.txtCustomer.Text = data.CUSTOMER.ToString(); this.txtRefNo.Text = data.REQCODE; this.txtWareHouse.Text = data.WAREHOUSE.ToString(); this.txtRef1.Text = data.REFLOID.ToString(); this.txtRef2.Text = data.REFPROD.ToString(); this.txtRemark.Text = data.REMARK; //this.txtCreateBy.Text = data.CREATEBY; // print //if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPO.LOID.ToString()) // this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockoutExportMaterial, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; //else if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPD.LOID.ToString()) // this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockoutMaterialWH, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockoutOther, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;"; 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); if (this.cmbDocType.SelectedValue == Constz.DocType.ReqRawPO.LOID.ToString()) { SetProduct(FlowObj.GetProductData(data.REFPROD)); } else { SetProduct(FlowObj.GetReqProductData(data.REFLOID)); } SetGrvItem(this.txtStatus.Text); if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnSubmitShow = false; this.ctlToolbar.BtnCancelShow = false; this.cmbDivision.Enabled = false; this.txtSupportRefCode.Enabled = false; this.txtSupportCause.Enabled = false; } this.txtTotal.Text = GetNetPrice().ToString(); }
private void SetProduct(StockoutWHData data) { this.txtPD.Text = data.PRODUCT.ToString(); }