private void SetData(ProductOrderData data)
{
if (data.LOID == 0)
{
data.STATUS = Constz.Requisition.Status.Waiting.Code;
this.txtCreateBy.Text = Authz.CurrentUserInfo.UserID;
this.ctlReqDate.DateValue = DateTime.Now.Date;
this.txtWarehouse.Text = Authz.CurrentUserInfo.Warehouse.ToString();
}
else
{
this.ctlReqDate.DateValue = data.REQDATE;
this.txtCreateBy.Text = data.CREATEBY;
this.txtWarehouse.Text = data.WAREHOUSE.ToString();
}
this.txtLOID.Text = data.LOID.ToString();
this.txtRequisitionCode.Text = data.CODE;
this.txtRemark.Text = data.REMARK;
this.txtStatus.Text = data.STATUS;
this.txtStatusName.Text = Appz.GetStatusName(data.STATUS);
SetGrvItem(data.STATUS);
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 = ABB.Global.Appz.ReportScript(Constz.Report.ProductOrder, data.LOID) + " return false;";
}
public ProductOrderData GetData(double loid)
{
ProductOrderData data = new ProductOrderData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.ACTIVE = DALObj.ACTIVE;
data.CODE = DALObj.CODE;
data.CREATEBY = DALObj.CREATEBY;
data.CUSTOMER = DALObj.CUSTOMER;
data.REMARK = DALObj.REMARK;
data.RESERVEDATE = DALObj.RESERVEDATE;
data.REQUISITIONTYPE = DALObj.REQUISITIONTYPE;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.REFWAREHOUSE = DALObj.REFWAREHOUSE;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.GRANDTOT = DALObj.GRANDTOT;
WarehouseDAL itemDAL = new WarehouseDAL();
itemDAL.GetDataByLOID(DALObj.WAREHOUSE, null);
data.WAREHOUSENAME = itemDAL.NAME;
}
return data;
}
public bool ValidateData(ProductOrderData data)
{
bool ret = true;
if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ";
}
return ret;
}
public ProductOrderData GetData(double loid)
{
ProductOrderData data = new ProductOrderData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.ACTIVE = DALObj.ACTIVE;
data.CODE = DALObj.CODE;
data.CREATEBY = DALObj.CREATEBY;
data.REMARK = DALObj.REMARK;
data.REQDATE = DALObj.REQDATE;
data.REQUISITIONTYPE = DALObj.REQUISITIONTYPE;
data.STATUS = DALObj.STATUS;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.CUSTOMER = DALObj.CUSTOMER;
}
return data;
}
private void SetData(ProductOrderData data)
{
if (data.LOID == 0)
{
data.STATUS = Constz.Requisition.Status.Waiting.Code;
data.CREATEBY = Authz.CurrentUserInfo.UserID;
data.WAREHOUSE = Authz.CurrentUserInfo.Warehouse;
data.RESERVEDATE = DateTime.Today;
data.REFWAREHOUSE = Constz.ReadyMadeDepartment.LOID;
WarehouseDAL itemDAL = new WarehouseDAL();
itemDAL.GetDataByLOID(Authz.CurrentUserInfo.Warehouse, null);
data.WAREHOUSENAME = itemDAL.NAME;
}
this.txtLOID.Text = data.LOID.ToString();
this.txtStatus.Text = data.STATUS;
this.txtRequisitionCode.Text = data.CODE;
this.ctlReqDate.DateValue = data.RESERVEDATE.Year == 1 ? DateTime.Now : data.RESERVEDATE;
this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat);
this.txtRemark.Text = data.REMARK;
this.txtCreateBy.Text = data.CREATEBY;
this.txtStatusName.Text = Appz.GetStatusName(data.STATUS);
this.txtWarehouse.Text = data.WAREHOUSE.ToString();
this.cmbRefWarehouse.SelectedIndex = this.cmbRefWarehouse.Items.IndexOf(this.cmbRefWarehouse.Items.FindByValue(data.REFWAREHOUSE.ToString()));
this.txtCustomer.Text = data.CUSTOMER.ToString();
this.txtWarehouseName.Text = data.WAREHOUSENAME;
this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat);
this.txtTotalDiscount.Text = data.TOTDIS.ToString(Constz.DblFormat);
this.txtVat.Text = data.VAT.ToString();
this.txtTotalVat.Text = data.TOTVAT.ToString(Constz.DblFormat);
this.txtGrandTotal.Text = data.GRANDTOT.ToString(Constz.DblFormat);
this.txtNet.Text = data.GRANDTOT.ToString(Constz.IntFormat);
//if (this.cmbRefWarehouse.SelectedItem.Value == "0")
//{
// data.REFWAREHOUSE = Constz.ReadyMadeDepartment.LOID;
// this.cmbRefWarehouse.SelectedIndex = this.cmbRefWarehouse.Items.IndexOf(this.cmbRefWarehouse.Items.FindByValue(data.REFWAREHOUSE.ToString()));
//}
SetGrvItem(data.STATUS);
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.grvItem.Columns[indexCHECk].Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code);
this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ProductRequestInShop, data.LOID) + " return false; ";
this.ctlToolbarItem.Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code);
}
private ProductOrderData GetData()
{
ProductOrderData data = new ProductOrderData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.CODE = this.txtRequisitionCode.Text.Trim();
// data.CUSTOMER = Constz.ReadyMadeDepartment.LOID;
data.CUSTOMER = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text);
data.ITEM = ItemObj.GetItemList();
data.REMARK = this.txtRemark.Text.Trim();
data.RESERVEDATE = this.ctlReqDate.DateValue;
data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ06;
data.STATUS = this.txtStatus.Text.Trim();
data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text);
data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text);
data.REFWAREHOUSE = Convert.ToDouble(this.cmbRefWarehouse.SelectedItem.Value);
data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text);
data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text);
data.TOTDIS = Convert.ToDouble(this.txtTotalDiscount.Text == "" ? "0" : this.txtTotalDiscount.Text);
data.TOTVAT = Convert.ToDouble(this.txtTotalVat.Text == "" ? "0" : this.txtTotalVat.Text);
data.VAT = Convert.ToDouble(this.txtVat.Text == "" ? "0" : this.txtVat.Text);
data.WAREHOUSENAME = this.txtWarehouseName.Text.Trim();
return data;
}
private void UpdateData(string userID, ProductOrderData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
DALObj.GetDataByLOID(data.LOID, zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CODE = data.CODE;
DALObj.REMARK = data.REMARK;
DALObj.REQDATE = data.REQDATE;
DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE;
DALObj.STATUS = data.STATUS;
DALObj.WAREHOUSE = data.WAREHOUSE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, zTrans);
else
ret = DALObj.InsertCurrentData(userID, zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
//itemDAL.DUEDATE = data.DUEDATE;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
public bool UpdateData(string userID, ProductOrderData data)
{
bool ret = true;
if (ValidateData(data))
{
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;
}
}
else
ret = false;
return ret;
}
public bool CommitData(string userID, ProductOrderData data)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
UpdateData(userID, data, obj.zTrans);
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;
}
private ProductOrderData GetData()
{
ProductOrderData data = new ProductOrderData();
data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ07;
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.CODE = this.txtRequisitionCode.Text.Trim();
data.ITEM = ItemObj.GetItemList();
data.REMARK = this.txtRemark.Text.Trim();
data.REQDATE = this.ctlReqDate.DateValue;
data.STATUS = this.txtStatus.Text.Trim();
data.CUSTOMER = Constz.ProductionDepartment.LOID;
data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text);
return data;
}
