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;
}
