private void SetData(StockinReturnData data)
{
if (data.LOID != 0)
this.cmbDocType.Enabled = false;
else
this.cmbDocType.Enabled = true;
this.txtLOID.Text = data.LOID.ToString();
this.txtStatus.Text = data.STATUS;
this.txtSender.Text = data.SENDER.ToString();
this.cmbDocType.SelectedIndex = this.cmbDocType.Items.IndexOf(this.cmbDocType.Items.FindByValue(data.DOCTYPE.ToString()));
//print
if (data.DOCTYPE.ToString() == Constz.DocType.RetInReduce.LOID.ToString())
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnPDRequest, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else if (data.DOCTYPE.ToString() == Constz.DocType.RetDistribute.LOID.ToString())
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.FGStockInReturnProduct, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else if (data.DOCTYPE.ToString() == Constz.DocType.RetFair.LOID.ToString())
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockInReturn, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
else if (data.DOCTYPE.ToString() == Constz.DocType.RetInSample.LOID.ToString())
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnPDExam, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
DataTable dt = FlowObj.GetRefData(data.REFLOID.ToString());
if (dt.Rows.Count > 0)
{
this.txtRefCode.Text = dt.Rows[0]["DOCCODE"].ToString();
}
this.txtCustomerCode.Text = "";
this.txtCustomerName.Text = "";
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.txtCode.Text = data.CODE;
this.ctlReceiveDate.DateValue = data.RECEIVEDATE;
this.txtRemark.Text = data.REMARK;
this.txtCreateBy.Text = data.CREATEBY;
this.txtStatusName.Text = Appz.GetStatusName(data.STATUS);
this.txtVat.Text = SysConfigFlow.GetValue(Constz.ConfigName.VAT);
this.txtGrandTotal.Text = data.GRANDTOT.ToString(Constz.DblFormat);
SetCustomerData(data.SENDER, false);
SetGrvItem(data.STATUS);
Calculation();
if (data.STATUS != Constz.Requisition.Status.Waiting.Code)
{
this.btnSearch.Visible = false;
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnSubmitShow = false;
}
}
public bool CommitData(string userID, StockinReturnData data)
{
bool ret = true;
bool cutstock = true;
bool custockinreturnlost = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
cutstock = (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code);
custockinreturnlost = cutstock;
UpdateData(userID, data, obj.zTrans);
if (cutstock)
{
StockInDAL sDAL = new StockInDAL();
ret = sDAL.CutStock(DALObj.LOID, userID, obj.zTrans);
if (!ret) _error = sDAL.ErrorMessage;
}
if (custockinreturnlost)
{
StockInDAL sDAL = new StockInDAL();
ret = sDAL.CutStockInReturnLost(DALObj.LOID, userID, obj.zTrans);
if (!ret) _error = sDAL.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, StockinReturnData data)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.OnDB = false;
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;
}
}
else
ret = false;
return ret;
}
private void UpdateData(string userID, StockinReturnData data, System.Data.OracleClient.OracleTransaction trans)
{
bool ret = true;
DALObj.CODE = data.CODE;
DALObj.DOCTYPE = data.DOCTYPE;
DALObj.SENDER = data.SENDER;
DALObj.RECEIVEDATE = data.RECEIVEDATE;
DALObj.STATUS = data.STATUS;
DALObj.REMARK = data.REMARK;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.CADDRESS = data.CADDRESS;
DALObj.REFLOID = data.REFLOID;
DALObj.REFTABLE = data.REFTABLE;
DALObj.CTITLE = data.CTITLE;
DALObj.CNAME = data.CNAME;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CTEL = data.CTEL;
DALObj.CFAX = data.CFAX;
DALObj.RECEIVER = data.RECEIVER;
DALObj.APPROVEDATE = data.APPROVEDATE;
DALObj.APPROVER = data.APPROVER;
if (DALObj.OnDB)
{
ret = DALObj.UpdateCurrentData(userID, trans);
}
else
{
ret = DALObj.InsertCurrentData(userID, trans);
}
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
_LOID = DALObj.LOID;
StockInItemDAL itemDAL = new StockInItemDAL();
itemDAL.DeleteDataByStockIn(data.LOID, trans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
StockinReturnItemData item = (StockinReturnItemData)data.ITEM[i];
itemDAL.STOCKIN = DALObj.LOID;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.UNIT = item.UNIT;
itemDAL.LOTNO = item.LOTNO;
itemDAL.PRICE = item.PRICE;
itemDAL.QTY = item.QTY;
itemDAL.QTYLOST = item.QTYLOST;
itemDAL.REFLOID = item.REFLOID;
itemDAL.REFTABLE = item.REFTABLE;
itemDAL.STATUS = DALObj.STATUS;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
public bool ValidateData(StockinReturnData data)
{
bool ret = true;
if (data.SENDER == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÅÙ¡¤éÒ";
}
if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ";
}
return ret;
}
public StockinReturnData GetData(double loid)
{
StockinReturnData data = new StockinReturnData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.CREATEBY = DALObj.CREATEBY;
data.CODE = DALObj.CODE;
data.DOCTYPE = DALObj.DOCTYPE;
data.SENDER = DALObj.SENDER;
data.RECEIVEDATE = DALObj.RECEIVEDATE;
data.STATUS = DALObj.STATUS;
data.REMARK = DALObj.REMARK;
data.GRANDTOT = DALObj.GRANDTOT;
data.CADDRESS = DALObj.CADDRESS;
data.REFLOID = DALObj.REFLOID;
data.REFTABLE = DALObj.REFTABLE;
data.CTITLE = DALObj.CTITLE;
data.CNAME = DALObj.CNAME;
data.CLASTNAME = DALObj.CLASTNAME;
data.CTEL = DALObj.CTEL;
data.CFAX = DALObj.CFAX;
}
return data;
}
private StockinReturnData GetData()
{
StockinReturnData data = new StockinReturnData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.CODE = this.txtCode.Text.Trim();
data.RECEIVEDATE = this.ctlReceiveDate.DateValue;
data.SENDER = Convert.ToDouble(this.txtSender.Text == "" ? "0" : this.txtSender.Text);
data.DOCTYPE = Convert.ToDouble(this.cmbDocType.SelectedItem.Value);
data.RECEIVER = Authz.CurrentUserInfo.Warehouse;
data.STATUS = this.txtStatus.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
data.ITEM = ItemObj.GetItemList();
data.GRANDTOT = Convert.ToDouble(this.txtGrandTotal.Text == "" ? "0" : this.txtGrandTotal.Text);
data.CADDRESS = this.txtAddress.Text.Trim();
data.CTITLE = Convert.ToDouble(this.cmbTitle.SelectedItem.Value);
data.CNAME = this.txtName.Text.Trim();
data.CLASTNAME = this.txtLastName.Text.Trim();
data.CTEL = this.txtTel.Text.Trim();
data.CFAX = this.txtFax.Text.Trim();
data.REFLOID = Convert.ToDouble(this.txtRefLOID.Text == "" ? "0" : this.txtRefLOID.Text);
data.REFTABLE = this.txtRefTable.Text.Trim();
return data;
}
private void SetData(StockinReturnData data)
{
// Setdata from Old REQUISITION
if (data.RECEIVEDATE.Year == 1) data.RECEIVEDATE = 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.txtCode.Text = data.CODE;
this.txtRemark.Text = data.REMARK;
this.txtRefLoid.Text = data.REFLOID.ToString();
SetPDdata(data.REFLOID);
SetGrvItem(this.txtStatus.Text);
if (data.STATUS == Constz.Requisition.Status.Finish.Code)
{
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnSubmitShow = false;
}
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.StockinReturnMaterial, Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text)) + " return false;";
}
private StockinReturnData GetData()
{
StockinReturnData data = new StockinReturnData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.DOCTYPE = Constz.DocType.RetMaterial.LOID;
data.WAREHOUSE = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text);
data.REMARK = this.txtRemark.Text.Trim(); data.STATUS = this.txtStatus.Text.Trim();
data.REFTABLE = "REQUISITION";
data.REFLOID = Convert.ToDouble(this.txtRefLoid.Text == "" ? "0" : this.txtRefLoid.Text);
data.RECEIVEDATE = ctlReceiveDate.DateValue;
data.ITEM = ItemObj.GetItemList();
data.STATUS = txtStatus.Text.Trim();
data.CODE = txtCode.Text.Trim();
data.RECEIVER = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text);
data.SENDER = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text);
return data;
}
public StockinReturnData DoGetPDData(double loid)
{
string sql = "SELECT * FROM V_MATERIAL_RETURN_POPUP_LIST WHERE LOID = '" + loid + "' ";
DataTable dt = OracleDB.ExecListCmd(sql);
StockinReturnData data = new StockinReturnData();
if (dt.Rows.Count > 0)
{
data.PDBARCODE = dt.Rows[0]["BARCODE"].ToString();
data.PDNAME = dt.Rows[0]["PRODUCTNAME"].ToString();
data.QTY = Convert.ToDouble(dt.Rows[0]["PDQTY"]);
data.UNAME = dt.Rows[0]["UNITNAME"].ToString();
data.CODE = dt.Rows[0]["REQCODE"].ToString();
data.REQDATE = Convert.ToDateTime(dt.Rows[0]["REQDATE"]);
data.PPLOID = Convert.ToDouble(dt.Rows[0]["PPLOID"]);
}
return data;
}
