private void SetData(ProductReturnData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.txtCode.Text = data.CODE.ToString();
this.txtSTCode.Text = FlowObj.GetSTCode(data.REFLOID);
this.txtStatus.Text = data.STATUS;
this.txtSTLoid.Text = data.REFLOID.ToString();
this.txtSupplier.Text = data.SUPPLIER.ToString();
this.txtRemark.Text = data.REMARK;
this.txtReason.Text = data.REASON;
this.txtName.Text = data.CNAME;
this.txtAddress.Text = data.CADDRESS;
this.txtTel.Text = data.CTEL;
this.txtFax.Text = data.CFAX;
this.ctlPDReturnDate.DateValue = data.PDRETURNDATE;
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.ctlSTDate.DateValue = FlowObj.GetSTDate(data.REFLOID);
ABB.Data.Purchase.SupplierData sData = FlowObj.GetSupplierData(data.SUPPLIER);
this.txtSupplierName.Text = sData.SUPPLIERNAME;
this.grvPDReturn.DataSource = FlowObj.GetPDReturnItemList(data.LOID);
this.grvPDReturn.DataBind();
if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code)
{
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnCancelShow = false;
this.ctlToolbar.BtnSubmitShow = false;
this.btnSearch.Visible = false;
}
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ProductReturn, data.LOID) + " return false;";
}
private ProductReturnData GetData()
{
ProductReturnData data = new ProductReturnData();
data.CODEFROM = this.txtCodeFrom.Text.Trim();
data.CODETO = this.txtCodeTo.Text.Trim();
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
data.PRODUCT = Convert.ToDouble(this.cmbProduct.SelectedItem.Value);
data.SUPPLIER = Convert.ToDouble(this.cmbSupplier.SelectedItem.Value);
data.STATUSFROM = this.cmbStatusFrom.SelectedItem.Value;
data.STATUSTO = this.cmbStatusTo.SelectedItem.Value;
return data;
}
public ProductReturnData GetData(double loid)
{
ProductReturnData data = new ProductReturnData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.CODE = DALObj.CODE;
data.CREATEBY = DALObj.CREATEBY;
data.CADDRESS = DALObj.CADDRESS;
data.CFAX = DALObj.CFAX;
data.CNAME = DALObj.CNAME;
data.CTEL = DALObj.CTEL;
data.PDRETURNDATE = DALObj.PDRETURNDATE;
data.REASON = DALObj.REASON;
data.REFLOID = DALObj.REFLOID;
data.REMARK = DALObj.REMARK;
data.STATUS = DALObj.STATUS;
data.SUPPLIER = DALObj.SUPPLIER;
}
return data;
}
public bool ValidateData(ProductReturnData data)
{
bool ret = true;
if (data.REFLOID == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ãºá¨é§¤×¹ÊÔ¹¤éÒ/Çѵ¶Ø´Ôº";
}
if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡Ò÷Õèµéͧ¡ÒÃÊ觤׹";
}
return ret;
}
//public TransportDAL SearchDAL
//{
// get { if (search == null) search = new TransportDAL(); return search; }
//}
public DataTable GetPDReturnList(ProductReturnData data)
{
return DALObj.GetPDReturnList(data);
}
public bool CommitData(string userID, ProductReturnData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code)
{
UpdateData(userID, data, obj.zTrans);
ret = DALObj.CutStockPDReturn(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;
}
return ret;
}
public bool UpdateData(string userID, ProductReturnData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
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;
}
private void UpdateData(string userID, ProductReturnData data, System.Data.OracleClient.OracleTransaction trans)
{
bool ret = true;
if (ValidateData(data))
{
DALObj.ACTIVE = data.ACTIVE;
DALObj.STATUS = data.STATUS;
DALObj.SUPPLIER = data.SUPPLIER;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CFAX = data.CFAX;
DALObj.CNAME = data.CNAME;
DALObj.CTEL = data.CTEL;
DALObj.PDRETURNDATE = data.PDRETURNDATE;
DALObj.REASON = data.REASON;
DALObj.REFLOID = data.REFLOID;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REMARK = data.REMARK;
DALObj.TYPE = data.TYPE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
ret = DALObj.InsertCurrentData(userID, trans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
PDReturnItemDAL itemDAL = new PDReturnItemDAL();
itemDAL.DeleteDataByPDReturn(data.LOID, trans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
ProductReturnItemData item = (ProductReturnItemData)data.ITEM[i];
itemDAL.ACTIVE = Constz.ActiveStatus.Active;
itemDAL.PDRETURN = DALObj.LOID;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.PRICE = item.PRICE;
itemDAL.QTY = item.QTY;
itemDAL.REFLOID = item.LOID;
itemDAL.REFTABLE = "STOCKOUTITEM";
itemDAL.UNIT = item.UNIT;
itemDAL.STATUS = Constz.Requisition.Status.Waiting.Code;
itemDAL.LOTNO = item.LOTNO;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
else
throw new ApplicationException(_error);
}
private ProductReturnData GetData()
{
ProductReturnData data = new ProductReturnData();
data.LOID = Convert.ToDouble(txtLOID.Text.Trim());
data.REFLOID = Convert.ToDouble(this.txtSTLoid.Text.Trim());
data.CODE = this.txtCode.Text.Trim();
data.STATUS = this.txtStatus.Text.Trim();
data.ACTIVE = Constz.ActiveStatus.Active;
data.REFLOID = Convert.ToDouble(this.txtSTLoid.Text.Trim());
data.REFTABLE = "STOCKOUT";
data.CNAME = this.txtName.Text.Trim();
data.CADDRESS = this.txtAddress.Text.Trim();
data.CTEL = this.txtTel.Text.Trim();
data.CFAX = this.txtFax.Text.Trim();
data.SUPPLIER = Convert.ToDouble(this.txtSupplier.Text.Trim());
data.REMARK = this.txtRemark.Text.Trim();
data.REASON = this.txtReason.Text.Trim();
data.PDRETURNDATE = this.ctlPDReturnDate.DateValue;
data.ITEM = FlowObj.GetItemList(data.REFLOID);
data.TYPE = "1";
return data;
}
public DataTable GetPDReturnList(ProductReturnData whereData)
{
string whereString = "";
if (whereData.CODEFROM.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "CODE >= '" + OracleDB.QRText(whereData.CODEFROM.Trim()) + "' ";
if (whereData.CODETO.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "CODE <= '" + OracleDB.QRText(whereData.CODETO.Trim()) + "' ";
if (whereData.DATEFROM.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "PDRETURNDATE >= " + OracleDB.QRDate(whereData.DATEFROM) + " ";
if (whereData.DATETO.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "PDRETURNDATE <= " + OracleDB.QRDate(whereData.DATETO) + " ";
if (whereData.PRODUCT != 0)
whereString += (whereString == "" ? "" : "AND ") + "PRODUCT = " + whereData.PRODUCT.ToString() + " ";
if (whereData.SUPPLIER != 0)
whereString += (whereString == "" ? "" : "AND ") + "SUPPLIER = " + whereData.SUPPLIER.ToString() + " ";
if (whereData.STATUSFROM.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "RANK >= '" + OracleDB.QRText(whereData.STATUSFROM.Trim()) + "' ";
if (whereData.STATUSTO.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "RANK <= '" + OracleDB.QRText(whereData.STATUSTO.Trim()) + "' ";
string sql = "SELECT ROWNUM NO, B.* FROM (SELECT PT.LOID,PT.CODE,PT.PDRETURNDATE,PTI.LOID PTILOID,PTI.PRODUCT,PD.NAME PRODUCTNAME,PTI.QTY,PTI.UNIT, ";
sql += "CASE PT.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Name + "' ";
sql += "ELSE '' END AS STATUSNAME, ";
sql += "CASE PT.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Rank + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Rank + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Rank + "' ";
sql += "ELSE '' END AS RANK,U.NAME UNITNAME,PT.SUPPLIER,S.SUPPLIERNAME,ST.CODE STCODE FROM PDRETURN PT ";
sql += "INNER JOIN (SELECT MIN(LOID) LOID,PDRETURN FROM PDRETURNITEM GROUP BY PDRETURN)A ON PT.LOID = A.PDRETURN ";
sql += "INNER JOIN PDRETURNITEM PTI ON A.LOID = PTI.LOID ";
sql += "INNER JOIN STOCKOUT ST ON PT.REFTABLE = 'STOCKOUT' AND PT.REFLOID = ST.LOID INNER JOIN SUPPLIER S ON PT.SUPPLIER = S.LOID ";
sql += "INNER JOIN PRODUCT PD ON PTI.PRODUCT = PD.LOID INNER JOIN UNIT U ON PTI.UNIT = U.LOID)B ";
sql += (whereString == "" ? "" : "WHERE " + whereString);
sql += "ORDER BY NO ";
return OracleDB.ExecListCmd(sql);
}