private void SearchData()
{
ReturnRequestFlow flow = new ReturnRequestFlow();
ReturnRequestData data = new ReturnRequestData();
data.LOTNO = this.txtLotno.Text.Trim();
data.PRODUCT = this.cmbProduct.SelectedValue;
this.grvRequisition.DataSource = flow.GetPopUpList(data);
this.grvRequisition.DataBind();
// this.btnSelect.Visible = (this.grvReserve.Rows.Count > 0);
if (this.grvRequisition.SelectedValue == null)
this.txtRef.Text = "";
else
this.txtRef.Text = this.grvRequisition.SelectedValue.ToString();
}
public ReturnRequestData DoGetRefData(double loid)
{
string sql = "SELECT PDP.LOTNO,PD.NAME,PD.BARCODE FROM PDPRODUCT PDP ";
// sql += "INNER JOIN REQUISITION RQ ON RQ.REFTABLE = 'PDPRODUCT' AND PDP.LOID = RQ.REFLOID ";
sql += "INNER JOIN PRODUCT PD ON PDP.PRODUCT = PD.LOID ";
sql += "WHERE PDP.LOID = '" + loid + "'";
DataTable dt = OracleDB.ExecListCmd(sql);
ReturnRequestData data = new ReturnRequestData();
if (dt.Rows.Count > 0)
{
data.LOTNO = dt.Rows[0]["LOTNO"].ToString();
data.PDNAME = dt.Rows[0]["NAME"].ToString();
data.PDBARCODE = dt.Rows[0]["BARCODE"].ToString();
}
return data;
}
public DataTable GetPopUpList(ReturnRequestData data)
{
string whereString = "";
if (data.PRODUCT.Trim() != "0")
whereString += (whereString == "" ? "" : "AND ") + "PRODUCT = '" + OracleDB.QRText(data.PRODUCT.Trim()) + "' ";
if (data.LOTNO.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "LOTNO = '" + OracleDB.QRText(data.LOTNO.Trim()) + "' ";
string sql = "select * from (SELECT ROWNUM NO, PDP.LOID, PD.LOID PRODUCT, PD.BARCODE, PD.NAME PRODUCTNAME, PDP.LOTNO ";
sql += "FROM PDPRODUCT PDP ";
sql += "INNER JOIN PRODUCT PD ON PDP.PRODUCT = PD.LOID WHERE PDP.PRODSTATUS IN ('RD','RR','QB','QC','QS','AP')) ";
sql += (whereString == "" ? "" : "WHERE " + whereString);
sql += "ORDER BY NO ";
DataTable dt = OracleDB.ExecListCmd(sql);
//for (int i = 0; i < dt.Rows.Count; ++i)
//{
// dt.Rows[i]["NO"] = i + 1;
//}
return dt;
}
//public bool CopyPDRequest(string userID, double loidSource)
//{
// PDReserveData data = GetData(loidSource);
// DataTable itemList = GetPDItem(data.LOID);
// ArrayList arr = new ArrayList();
// foreach (DataRow dRow in itemList.Rows)
// {
// PDReserveItemData idata = new PDReserveItemData();
// idata.MASTER = Convert.ToDouble(dRow["MASTER"]);
// idata.ACTIVE = Constz.ActiveStatus.Active;
// arr.Add(idata);
// }
// data.ITEM = arr;
// DALObj.OnDB = false;
// data.LOID = 0;
// data.CODE = "";
// data.STATUS = Constz.Requisition.Status.Waiting.Code;
// //data.ACTIVE = Constz.ActiveStatus.Active;
// //data.ORDERTYPE = Constz.OrderType.PO.Code;
// return UpdateData(userID, data);
//}
public bool CommitData(string userID, ReturnRequestData 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, ReturnRequestData 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.WAREHOUSE = data.WAREHOUSE;
//}
try
{
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
DALObj.CODE = data.CODE;
DALObj.REQDATE = data.REQDATE;
DALObj.STATUS = data.STATUS;
DALObj.ACTIVE = data.ACTIVE;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REFLOID = data.REFLOID;
DALObj.LOTNO = data.LOTNO;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.REMARK = data.REMARK;
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();
ReturnItemData item = (ReturnItemData)data.ITEM[i];
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.PRODUCT = item.PDLOID;
itemDAL.MASTER = item.MASTER;
itemDAL.UNIT = item.UNIT;
itemDAL.USEQTY = item.USEQTY;
itemDAL.WASTEQTYMAT = item.WASTEQTYMAT;
itemDAL.RETURNQTY = item.RETURNQTY;
itemDAL.ACTIVE = Constz.ActiveStatus.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 bool ValidateData(ReturnRequestData data)
{
bool ret = true;
if (data.LOTNO.Trim() == "")
{
ret = false;
_error = "¡ÃسÒÃкØàÅ¢·Õè¡ÒüÅÔµ";
}
//else if (data.REQDATE.Year == 1)
//{
// ret = false;
// _error = "¡ÃسÒÇѹ·ÕèºÑ¹·Ö¡ÃÒ¡ÒÃ";
//}
//else if (data.REASON == "")
//{
// ret = false;
// _error = "¡ÃسÒÃкØà˵ؼÅ㹡Òâͫ×éÍ";
//}
else if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ";
}
return ret;
}
public ReturnRequestData GetAllData(double loid)
{
// Get Old Data From Requisition
ReturnRequestData data = new ReturnRequestData();
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;
data.REFLOID = DALObj.REFLOID;
data.LOID = DALObj.LOID;
//ReturnRequestData data2 = GetPDDataFromLOT(data.LOTNO);
//data.PDBARCODE = data2.PDBARCODE;
//data.PDNAME = data2.PDNAME;
//data.BATCHSIZE = data2.BATCHSIZE;
//data.BATCHSIZEUNITNAME = data2.BATCHSIZEUNITNAME;
}
return data;
}
private void SetData(ReturnRequestData data)
{
// Setdata from Old REQUISITION
if (data.REQDATE.Year == 1) data.REQDATE = 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.txtRequisitionCode.Text = data.CODE;
this.txtLotNo.Text = data.LOTNO;
this.ctlReqDate.DateValue = data.REQDATE;
this.txtRemark.Text = data.REMARK;
//this.txtCreateBy.Text = data.CREATEBY;
this.txtPDCode.Text = data.PDBARCODE;
this.txtPDName.Text = data.PDNAME;
if (this.txtLOID.Text != "0")
{
this.txtRefLoid.Text = data.REFLOID.ToString();
SetDataPD(FlowObj.GetRefData(data.REFLOID));
}
//this.txtQty.Text = Convert.ToString(data.BATCHSIZE);
//this.txtQtyUnit.Text = data.BATCHSIZEUNITNAME;
//this.txtVPLOID.Text = data.VPLOID.ToString();
SetGrvItem(this.txtStatus.Text);
if (data.STATUS == Constz.Requisition.Status.Approved.Code)
{
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnSubmitShow = false;
}
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ReturnRequestPD, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + "return false;";
}
private ReturnRequestData GetData()
{
ReturnRequestData data = new ReturnRequestData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ14;
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.PDBARCODE = this.txtPDCode.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();data.STATUS = this.txtStatus.Text.Trim();
data.REFTABLE = "PDPRODUCT";
data.REFLOID = Convert.ToDouble(this.txtRefLoid.Text == "" ? "0" : this.txtRefLoid.Text);
data.ITEM = ItemObj.GetItemList();
data.REQDATE = ctlReqDate.DateValue;
data.STATUS = txtStatus.Text.Trim();
data.CODE = txtRequisitionCode.Text.Trim();
return data;
}
private void SetDataPD(ReturnRequestData data)
{
this.txtPDCode.Text = data.PDBARCODE;
this.txtPDName.Text = data.PDNAME;
}