private void SetData2(StockoutFGData data)
{
this.txtSTCode.Text = data.CODE.ToString();
this.txtSTLoid.Text = data.LOID.ToString();
this.txtSupplier.Text = data.RECEIVER.ToString();
this.txtRemark.Text = data.REMARK;
this.txtReason.Text = data.REASON;
this.ctlSTDate.DateValue = data.CREATEON;
ABB.Data.Purchase.SupplierData sData = FlowObj.GetSupplierData(data.RECEIVER);
this.txtSupplierName.Text = sData.SUPPLIERNAME;
this.txtName.Text = (sData.CNAME + " " + sData.CLASTNAME).Trim();
this.txtAddress.Text = sData.CADDRESS;
this.txtTel.Text = sData.CTEL;
this.txtFax.Text = sData.CFAX;
this.grvPDReturn.DataSource = FlowObj.GetStockoutItemList(data.LOID);
this.grvPDReturn.DataBind();
}
private StockoutFGData GetData()
{
StockoutFGData data = new StockoutFGData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.REASON = this.txtReason.Text.Trim();
data.CODE = this.txtCode.Text.Trim();
data.RECEIVER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text);
data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text);
data.ITEM = ItemObj.GetItemList();
data.REMARK = this.txtRemark.Text.Trim();
data.STATUS = this.txtStatus.Text.Trim();
data.DOCTYPE = Constz.DocType.RetRaw.LOID;
return data;
}
private void SetData(StockoutFGData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.txtStatus.Text = data.STATUS;
this.txtCustomer.Text = data.RECEIVER.ToString();
this.txtSender.Text = data.SENDER.ToString();
this.ctlCreateDate.DateValue = data.CREATEON;
this.txtCustomerCode.Text = "";
this.txtCustomerName.Text = "";
this.txtCode.Text = data.CODE;
this.txtReason.Text = data.REASON;
this.txtRemark.Text = data.REMARK;
this.txtCreateBy.Text = data.CREATEBY;
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);
SetCustomerData(data.RECEIVER);
SetGrvItem(data.STATUS);
Calculation();
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.ctlToolbar.ClientClickPrint = Appz.ReportScript(Constz.Report.ProductReturn, data.LOID) + " return false;";
}
private StockoutFGData GetData()
{
StockoutFGData data = new StockoutFGData();
data.LOID = Convert.ToDouble(this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.CADDRESS = this.txtAddress.Text.Trim();
data.CFAX = this.txtFax.Text.Trim();
data.CLASTNAME = this.txtLastName.Text.Trim();
data.CNAME = this.txtName.Text.Trim();
data.CTEL = this.txtTel.Text.Trim();
data.CTITLE = Convert.ToDouble(this.cmbTitle.SelectedItem.Value);
data.DOCTYPE = Convert.ToDouble(this.txtDocType.Text == "" ? "0" : this.txtDocType.Text);
data.RECEIVER = Convert.ToDouble(this.txtReceiver.Text == "" ? "0" : this.txtReceiver.Text);
data.REFLOID = Convert.ToDouble(this.txtRefLoid.Text == "" ? "0" : this.txtRefLoid.Text);
data.REFTABLE = "REQUISITION";
data.REMARK = this.txtRemark.Text.Trim();
data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text);
data.STATUS = this.txtStatus.Text.Trim();
data.ITEM = ItemObj.GetItemList();
return data;
}
private void SetData(StockoutFGData data)
{
this.txtLOID.Text = data.LOID.ToString();
SetDocTypeName(data.DOCTYPE);
this.txtRefNo.Text = data.REQUISITIONCODE;
this.txtCustomerCode.Text = data.CUSTOMERCODE;
this.txtCustomerName.Text = data.CUSTOMERNAME;
this.cmbTitle.SelectedIndex = this.cmbTitle.Items.IndexOf(this.cmbTitle.Items.FindByValue(data.CTITLE.ToString()));
this.txtName.Text = data.CNAME;
this.txtLastName.Text = data.CLASTNAME;
this.txtAddress.Text = data.CADDRESS;
this.txtTel.Text = data.CTEL;
this.txtFax.Text = data.CFAX;
this.txtRefLoid.Text = data.REFLOID.ToString();
this.txtStatus.Text = data.STATUS;
this.txtStatusName.Text = Appz.GetStatusName(data.STATUS);
this.txtSender.Text = data.SENDER.ToString();
this.txtReceiver.Text = data.RECEIVER.ToString();
this.txtCode.Text = data.CODE;
this.ctlCreateOn.DateValue = data.CREATEON;
this.ctlReserveDate.DateValue = data.RESERVEDATE;
this.txtCreateBy.Text = data.CREATEBY;
this.txtRemark.Text = data.REMARK;
this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat);
this.btnSearch.Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code);
this.ctlToolbar.BtnSaveShow = (data.STATUS == Constz.Requisition.Status.Waiting.Code);
this.ctlToolbar.BtnSubmitShow = (data.STATUS == Constz.Requisition.Status.Waiting.Code);
SetPeriod();
SetGrvItem(data.STATUS);
//print
if (data.DOCTYPE == Constz.DocType.ReqSupport.LOID)
this.ctlToolbar.BtnPrintShow = false;
else if (data.DOCTYPE == Constz.DocType.ReqFair.LOID)
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOutBorrow, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else if (data.DOCTYPE == Constz.DocType.ReqDistribute.LOID || data.DOCTYPE == Constz.DocType.ReqProduct.LOID || data.DOCTYPE == Constz.DocType.Reserve.LOID)
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOut, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else if (data.DOCTYPE == Constz.DocType.ReqOrgSupport.LOID)
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockOutSupport, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else
this.ctlToolbar.ClientClickPrint = "return false; ";
if (data.DOCTYPE == Constz.DocType.ReqProduct.LOID)
{
this.txtCustomerCode.Text = data.WAREHOUSECODE;
this.txtCustomerName.Text = data.WAREHOUSENAME;
}
}
private bool VerifyData(StockoutFGData data)
{
bool ret = true;
if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкءÒÃÊÔ¹¤éÒ";
}
else if (data.RECEIVER == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÅÙ¡¤éÒ";
}
else if (data.REASON == "")
{
ret = false;
_error = "¡ÃسÒÃкØÊÒà˵ءÒÃÊ觤׹";
}
return ret;
}
public bool UpdateData(string userID, StockoutFGData 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 UpdateDataReturn(string userID, StockoutFGData data)
{
bool ret = true;
if (!VerifyData(data)) throw new ApplicationException(_error);
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CFAX = data.CFAX;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CNAME = data.CNAME;
DALObj.CTEL = data.CTEL;
DALObj.CTITLE = data.CTITLE;
DALObj.RECEIVER = data.RECEIVER;
DALObj.DELIVERYDATE = data.DELIVERYDATE;
DALObj.REMARK = data.REMARK;
DALObj.REASON = data.REASON;
DALObj.REQDATE = data.REQDATE;
DALObj.DOCTYPE = data.DOCTYPE;
DALObj.STATUS = data.STATUS;
DALObj.REFLOID = data.REFLOID;
DALObj.REFTABLE = data.REFTABLE;
DALObj.PRODUCTREF = data.PRODUCTREF;
DALObj.SENDER = data.SENDER;
DALObj.INVCODE = data.INVCODE;
// DALObj.REASON = data.REASON;
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);
}
StockOutItemDAL itemDAL = new StockOutItemDAL();
itemDAL.DeleteDataByStockOut(data.LOID, obj.zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.INVNO = item.INVNO;
itemDAL.STOCKOUT = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.LOTNO = item.LOTNO;
itemDAL.STATUS = data.STATUS;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}//for
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, StockoutFGData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
DALObj.GetDataByLOID(data.LOID, zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CFAX = data.CFAX;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CNAME = data.CNAME;
DALObj.CTEL = data.CTEL;
DALObj.CTITLE = data.CTITLE;
DALObj.RECEIVER = data.RECEIVER;
DALObj.DELIVERYDATE = data.DELIVERYDATE;
DALObj.REMARK = data.REMARK;
DALObj.REASON = data.REASON;
DALObj.REQDATE = data.REQDATE;
DALObj.DOCTYPE = data.DOCTYPE;
DALObj.STATUS = data.STATUS;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REFLOID = data.REFLOID;
//DALObj.REFPROD = data.REFPROD;
DALObj.PRODUCTREF = data.PRODUCTREF;
DALObj.INVCODE = data.INVCODE;
//DALObj.REASON = data.REASON;
DALObj.SENDER = data.SENDER;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, zTrans);
else
ret = DALObj.InsertCurrentData(userID, zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
DALItemObj.DeleteDataByStockOut(_LOID, zTrans);
for (int i = 0; i < data.ITEM.Count; i++)
{
StockOutItemData itemData = (StockOutItemData)data.ITEM[i];
_itemDAL = new StockOutItemDAL();
DALItemObj.ACTIVE = itemData.ACTIVE;
DALItemObj.LOTNO = itemData.LOTNO;
DALItemObj.PRICE = itemData.PRICE;
DALItemObj.PRODUCT = itemData.PRODUCT;
DALItemObj.QTY = itemData.QTY;
DALItemObj.REFLOID = itemData.REFLOID;
DALItemObj.REFTABLE = itemData.REFTABLE;
DALItemObj.STATUS = data.STATUS;
DALItemObj.STOCKOUT = _LOID;
DALItemObj.UNIT = itemData.UNIT;
DALItemObj.INVNO = itemData.INVNO;
ret = DALItemObj.InsertCurrentData(userID, zTrans);
if (!ret) throw new ApplicationException(DALItemObj.ErrorMessage);
}
}
public StockoutFGData GetData(double loid)
{
StockoutFGData data = new StockoutFGData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.ACTIVE = DALObj.ACTIVE;
//data.REQCODE = GetRequisitionCode(DALObj2.REFLOID);
data.REFLOID = 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.RECEIVER = DALObj.RECEIVER;
data.DELIVERYDATE = DALObj.DELIVERYDATE;
data.INVCODE = DALObj.INVCODE;
data.REMARK = DALObj.REMARK;
data.REQDATE = DALObj.REQDATE;
data.DOCTYPE = DALObj.DOCTYPE;
data.STATUS = DALObj.STATUS;
data.REASON = DALObj.REASON;
data.SENDER = DALObj.SENDER;
data.TOTAL = DALObj.SumPrice(DALObj.LOID, null);
StockOutFGReqData reqData = GetRequisitionData(data.REFLOID);
data.RESERVEDATE = reqData.RESERVEDATE;
data.REQUISITIONCODE = reqData.REQUISITIONCODE;
}
return data;
}
public bool UpdateData(string userID, StockoutFGData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
_LOID = data.LOID;
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code || DALObj.STATUS == "")
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, StockoutFGData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
_LOID = data.LOID;
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code)
{
if (Convert.ToDouble(OracleDB.ExecSingleCmd("SELECT COUNT(LOID) FROM STOCKOUTITEM WHERE LOTNO IS NULL AND STOCKOUT = " + data.LOID.ToString(), obj.zTrans)) > 0)
throw new ApplicationException("ÁÕºÒ§ÃÒ¡Ò÷ÕèäÁèä´éÃÐºØ lot No.");
data.STATUS = Constz.Requisition.Status.Approved.Code;
UpdateData(userID, data, obj.zTrans);
ret = DALItemObj.UpdateStatusByStockOut(_LOID, data.STATUS, userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALItemObj.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;
}
return ret;
}
private bool VerifyData(StockoutFGData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
if (data.REFLOID == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÃÒ¡ÒâÍàºÔ¡";
}
else if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкءÒÃÊÔ¹¤éÒ¢ÍàºÔ¡";
}
else if (DALObj.GetStockOutByReference(data.REFLOID, "REQUISITION", data.LOID, zTrans) > 0)
{
ret = false;
_error = "äÁèÊÒÁÒöÍÅ×͡㺤Ӣ͹Õéä´é à¹×èͧ¨Ò¡ÊÃéÒ§ãºàºÔ¡áÅéÇ";
}
return ret;
}
