private void SetData(PDReserveData data) { this.txtLotno.Text = data.LOTNO; //this.PDDateFrom.Text = data.MFGDATE; //this.PDDateTo.Text = data.MFGDATE; this.txtPDName.Text = data.PDNAME; SearchData(); }
private void SetData(PDReserveData data) { // Setdata from Old REQUISITION this.txtLOID.Text = data.LOID.ToString(); if (data.LOID == 0) { data.CREATEBY = Authz.CurrentUserInfo.UserID; data.ACTIVE = Constz.ActiveStatus.Active; data.REQDATE = DateTime.Now.Date; data.STATUS = Constz.Requisition.Status.Waiting.Code; data.WAREHOUSE = Authz.CurrentUserInfo.Warehouse; //data.VAT = Convert.ToDouble(SysConfigFlow.GetValue(Constz.ConfigName.VAT)); } if (data.REQDATE.Year == 1) data.REQDATE = DateTime.Now.Date; this.txtStatus.Text = (data.STATUS != "" ? data.STATUS : txtStatus.Text); //this.txtStatus1.Text = (data.STATUS != "" ? data.STATUS : txtStatus.Text); this.txtStatus1.Text = (data.STATUS == Constz.Requisition.Status.SendWareHouse.Code ? Constz.Requisition.Status.SendWareHouse.Name : (data.STATUS == Constz.Requisition.Status.Void.Code ? Constz.Requisition.Status.Void.Name : (data.STATUS == Constz.Requisition.Status.Finish.Code ? Constz.Requisition.Status.Finish.Name : Constz.Requisition.Status.DoWaiting.Name))); this.txtWareHouse.Text = (data.WAREHOUSE != 0 ? data.WAREHOUSE.ToString() : txtWareHouse.Text); this.txtRequisitionCode.Text = data.CODE; if (data.LOTNO == "0") { this.txtLotNo.Text = ""; } else { this.txtLotNo.Text = data.LOTNO; } this.txtDate.Text = data.REQDATE.ToString(Constz.DateFormat); this.txtDUEDate.Text = data.MFGDATE.ToString(Constz.DateFormat); this.txtRemark.Text = data.REMARK; this.txtCreateBy.Text = data.CREATEBY; this.txtPDCode.Text = data.PDBARCODE; this.txtPDName.Text = data.PDNAME; this.txtQty.Text = Convert.ToString(data.BATCHSIZE); this.txtQtyUnit.Text = data.BATCHSIZEUNITNAME; this.txtSTDQty.Text = Convert.ToString(data.STDQTY); this.txtPDQtyUnit.Text = data.PDUNITNAME; this.txtBatchsizeUnit.Text = Convert.ToString(data.BATCHSIZEUNIT); this.txtPacksize.Text = Convert.ToString(data.PACKSIZE); this.txtPacksizeunit.Text = Convert.ToString(data.PACKSIZEUNIT); SetStdQty(); //¤Ó¹Ç³¼Å¼ÅÔµµÒÁ·ÄÉ®Õ this.txtPdpStdqty.Text = Convert.ToString(data.BATCHSIZE * Convert.ToDouble(txtPdpStdqty.Text)); this.txtVPLOID.Text = data.VPLOID.ToString(); SetGrvItem(this.txtStatus.Text); if (data.STATUS != Constz.Requisition.Status.Waiting.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnCancelShow = false; this.ctlToolbar.BtnSubmitShow = false; } this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ProductMaterialReserve, data.LOID) + " return false;"; }
private bool VeridateData(PDReserveData data) { bool ret = true; if (data.LOTNO.Trim() == "") { ret = false; _error = "¡ÃسÒÃкØàÅ¢·Õè¡ÒüÅÔµ"; } else if (data.PDNAME.Trim() == "") { ret = false; _error = "¡ÃسÒÃкت×èͼÅÔµÀѳ±ì"; } return ret; }
public ArrayList GetSearchUnit(PDReserveData uSearch) { //string str = ""; ArrayList arrResult = new ArrayList(); //str = " SELECT * FROM UNIT "; //str += " WHERE NAME = '" + name + "'"; //str += " AND E = " + Ename; //if (Barcode != "") //{ // str += " AND BARCODE = '" + Barcode + "'"; //} //if (PName != "") //{ // str += " AND PNAME LIKE '%" + PName + "%'"; //} //try //{ // OracleDataReader zRd = OracleDB.ExecQueryCmd(str); // arrResult.Clear(); // int i = 1; // while (zRd.Read()) // { // V_Product_List_RequisitionData irData = new V_Product_List_RequisitionData(); // irData.ORDERNO = i; // irData.BARCODE = zRd["BARCODE"].ToString(); // irData.PNAME = zRd["PNAME"].ToString(); // arrResult.Add(irData); // i = i + 1; // } //} //catch (Exception ex) //{ // throw ex; //} return arrResult; }
public PDReserveData GetPDDataFromLOT(string LotNo) { // Get Master Data From BOM List.. PDReserveData data = new PDReserveData(); if (SearchDAL.GetDataByLOTNO(LotNo, null)) { data.VPLOID = SearchDAL.PDLOID; data.LOTNO = SearchDAL.LOTNO; data.PDBARCODE = SearchDAL.PDBARCODE; data.PDNAME = SearchDAL.PDNAME; data.BATCHSIZE = SearchDAL.BATCHSIZE; data.BATCHSIZEUNITNAME = SearchDAL.BATCHSIZEUNITNAME; } return data; }
public PDReserveData GetData1(double loid) { PDReserveData data = new PDReserveData(); if (SearchDAL.GetDataByLOID(loid, null)) { data.LOTNO = SearchDAL.LOTNO; data.PDBARCODE = SearchDAL.PDBARCODE; data.PDNAME = SearchDAL.PDNAME; data.BATCHSIZE = SearchDAL.BATCHSIZE; data.BATCHSIZEUNITNAME = SearchDAL.BATCHSIZEUNITNAME; } return data; }
//public OfficerData GetOfficerData(double loid) //{ // OfficerDAL dal = new OfficerDAL(); // OfficerData data = new OfficerData(); // dal.GetDataByLOID(loid, null); // data.TNAME = dal.TNAME; // data.LASTNAME = dal.LASTNAME; // data.DIVISION = dal.DIVISION; // data.USERID = dal.USERID; // data.PASSWORD = dal.PASSWORD; // data.EFDATE = dal.EFDATE; // data.EPDATE = dal.EPDATE; // return data; //} public PDReserveData GetData(double loid) { PDReserveData data = new PDReserveData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.CODE = DALObj.CODE; //data.LOTNO = DALObj.LOTNO; data.REQDATE = DALObj.REQDATE; //data.PURCHASETYPE = DALObj.PURCHASETYPE; //data.REQUESTBY = DALObj.REQUESTBY; //data.DIVISION = DALObj.DIVISION; data.STATUS = DALObj.STATUS; data.CREATEBY = DALObj.CREATEBY; data.REMARK = DALObj.REMARK; } return data; }
public PDReserveData GetDataLotNo(string code) { PDReserveData data = new PDReserveData(); if (DALObj.GetDataByLOTNO(code, null)) { data.REQDATE = DALObj.REQDATE; data.CODE = DALObj.CODE; data.CREATEBY = DALObj.CREATEBY; //data.STATUS = DALObj.STATUS; data.REMARK = DALObj.REMARK; data.LOTNO = DALObj.LOTNO; data.WAREHOUSE = DALObj.WAREHOUSE; } return data; }
private PDReserveData GetData() { PDReserveData data = new PDReserveData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ08; data.ACTIVE = Constz.ActiveStatus.Active; data.WAREHOUSE = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text); data.LOTNO = this.txtLotNo.Text.Trim(); data.PDNAME = this.txtPDName.Text ; data.REQDATE = Convert.ToDateTime(this.txtDate.Text); data.MFGDATE = Convert.ToDateTime(this.txtDUEDate.Text); data.CODE = this.txtRequisitionCode.Text.Trim(); data.PDBARCODE = this.txtPDCode.Text.Trim(); data.REMARK = this.txtRemark.Text.Trim(); data.STATUS = this.txtStatus.Text.Trim(); data.VPLOID = Convert.ToDouble(this.txtVPLOID.Text == "" ? "0" : this.txtVPLOID.Text); data.ITEM = GetItemData(); return data; }
public bool ValidateData(PDReserveData data) { bool ret = true; //if (Convert.ToDouble(data.LOTNO) == 0) //{ // ret = false; // _error = "¡ÃسÒÃкØàÅ¢·Õè¡ÒüÅÔµ"; //} //else if (data.REQDATE.Year == 1) //{ // ret = false; // _error = "¡ÃسÒÇѹ·ÕèºÑ¹·Ö¡ÃÒ¡ÒÃ"; //} //else if (data.REASON == "") //{ // ret = false; // _error = "¡ÃسÒÃкØà˵ؼÅ㹡Òâͫ×éÍ"; //} if (data.ITEM.Count == 0) { ret = false; _error = "ÂѧäÁèÁÕ¢éÍÁÙÅã¹ Bom ¢Í§ÊÔ¹¤éÒ»ÃÐàÀ·¹Õé"; } return ret; }
public bool UpdateData(string userID, PDReserveData data) { bool ret = true; if (VeridateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.PDLOID = data.LOID; //DALObj.MFGDATE = data.MFGDATE.Trim(); DALObj.LOTNO = data.LOTNO.Trim(); DALObj.PDNAME = data.PDNAME.Trim(); if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else ret = DALObj.InsertCurrentData(userID, obj.zTrans); if (ret) { obj.zTrans.Commit(); obj.CloseConnection(); } else { throw new ApplicationException(DALObj.ErrorMessage); } } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
//public InvoiceReturnData GetCustomerList(string code) //{ // InvoiceReturnData data = new InvoiceReturnData(); // if (DALObj.GetDataByCODE(code, null)) // { // //data.LOID = DALObj.LOID; // data.INVCODE = DALObj.INVCODE; // data.CUSTOMERCODE = DALObj.CUSTOMERCODE; // data.CUSTOMERNAME = DALObj.CUSTOMERNAME; // data.PRODUCTNAME = DALObj.PRODUCTNAME; // } // return data; //} public PDReserveData GetData(double loid) { PDReserveData data = new PDReserveData(); if (DALObj.GetDataByLOID(loid, null)) { data.PDNAME = DALObj.PDNAME; //data.ACTIVE = DALObj.ACTIVE; data.LOTNO = DALObj.LOTNO; data.LOID = DALObj.PDLOID; data.MFGDATE = DALObj.MFGDATE; } return data; }
public bool CommitData(string userID, PDReserveData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data); ret = DALObj.CutStockRequisition(_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 bool UpdateData(string userID, PDReserveData data) { // ####### UPDATE REQUISITION bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); if (data.LOID != 0) { // update old requisition DALObj.GetDataByLOID(data.LOID, obj.zTrans); } else { DALObj.STATUS = data.STATUS; DALObj.ACTIVE = data.ACTIVE; DALObj.REFTABLE = "PDPRODUCT"; DALObj.REFLOID = data.VPLOID; DALObj.LOTNO = data.LOTNO; DALObj.CODE = data.CODE; DALObj.WAREHOUSE = data.WAREHOUSE; DALObj.REQUISITIONTYPE =data.REQUISITIONTYPE ; } try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); //DALObj.CODE = data.CODE; DALObj.REQDATE = data.REQDATE; DALObj.DUEDATE = data.MFGDATE; DALObj.REMARK = data.REMARK; DALObj.STATUS = data.STATUS; DALObj.ACTIVE = data.ACTIVE; DALObj.LOTNO = data.LOTNO; DALObj.WAREHOUSE = data.WAREHOUSE; DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE; 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); } // ############ UPDATE ITEM ProductMaterial itemDAL = new ProductMaterial(); itemDAL.DeleteCurrentDataByREQ(DALObj.LOID, obj.zTrans); for (Int16 i = 0; i < data.ITEM.Count; ++i) { itemDAL = new ProductMaterial(); ProductMaterialData item = (ProductMaterialData)data.ITEM[i]; itemDAL.REQUISITION = DALObj.LOID; itemDAL.PRODUCT = item.PRODUCT; itemDAL.UNIT = item.UNIT; itemDAL.MASTER = item.MASTER; itemDAL.ACTIVE = item.ACTIVE; // itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.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 PDReserveData GetDataLotNo1(string code) { PDReserveData data = new PDReserveData(); if (SearchDAL.GetDataByLOTNO(code, null)) { data.LOTNO = SearchDAL.LOTNO; data.PDBARCODE = SearchDAL.PDBARCODE; data.PDNAME = SearchDAL.PDNAME; data.BATCHSIZE = SearchDAL.BATCHSIZE; data.BATCHSIZEUNITNAME = SearchDAL.BATCHSIZEUNITNAME; } return data; }
public PDReserveData GetAllData(double loid) { // Get Old Data From Requisition PDReserveData data = new PDReserveData(); if (DALObj.GetDataByLOID(loid, null)) { //data.REQDATE = DALObj.REQDATE; //data.CODE = DALObj.CODE; //data.CREATEBY = DALObj.CREATEBY; //data.STATUS = DALObj.STATUS; //data.REMARK = DALObj.REMARK; //data.LOTNO = DALObj.LOTNO; //data.WAREHOUSE = DALObj.WAREHOUSE; //data.LOTNO = DALObj.LOTNO; PDReserveData data2 = GetPDDataFromLOT(data.LOTNO); data.PDBARCODE = data2.PDBARCODE; data.PDNAME = data2.PDNAME; data.BATCHSIZE = data2.BATCHSIZE; data.BATCHSIZEUNITNAME = data2.BATCHSIZEUNITNAME; } return data; }
//public OfficerData GetOfficerData(double loid) //{ // OfficerDAL dal = new OfficerDAL(); // OfficerData data = new OfficerData(); // dal.GetDataByLOID(loid, null); // data.TNAME = dal.TNAME; // data.LASTNAME = dal.LASTNAME; // data.DIVISION = dal.DIVISION; // data.USERID = dal.USERID; // data.PASSWORD = dal.PASSWORD; // data.EFDATE = dal.EFDATE; // data.EPDATE = dal.EPDATE; // return data; //} public PDReserveData GetData(double loid) { PDReserveData data = new PDReserveData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.CODE = DALObj.CODE; data.REQDATE = DALObj.REQDATE; data.MFGDATE = DALObj.DUEDATE; data.REQUISITIONTYPE = DALObj.REQUISITIONTYPE; data.STATUS = DALObj.STATUS; data.CREATEBY = DALObj.CREATEBY; data.REMARK = DALObj.REMARK; } return data; }