private void SetData(StockoutBasketData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.txtStatus.Text = data.STATUS;
this.txtPDLOID.Text = data.PRODUCT.ToString();
this.txtWareHouse.Text = data.WAREHOUSE.ToString();
this.cmbBasketType.SelectedIndex = this.cmbBasketType.Items.IndexOf(this.cmbBasketType.Items.FindByValue(data.TYPE));
if (this.txtPDLOID.Text != "")
SetProductPackage(this.txtPDLOID.Text);
this.txtBasketQty.Text = data.QTY.ToString();
this.txtBasketCode.Text = data.CODE;
this.ctlCheckDate.DateValue = data.CHECKDATE;
this.txtStatusName.Text = (data.STATUS == Constz.Basket.Status.Approved.Code ? Constz.Basket.Status.Approved.Name : Constz.Basket.Status.Waiting.Name);
if (data.STATUS == Constz.Basket.Status.Approved.Code)
{
this.cmbBasketType.Enabled = false;
this.txtBasketQty.Enabled = false;
}
this.txtLotNo.Text = data.LOTNO;
this.txtRemark.Text = data.REMARK;
calPrice();
SetGrvItem(data.STATUS);
if (data.STATUS == Constz.Basket.Status.Approved.Code)
{
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnSubmitShow = false;
}
}
public StockoutBasketData GetData(double loid)
{
StockoutBasketData data = new StockoutBasketData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.CODE = DALObj.CODE;
data.CHECKDATE = DALObj.CHECKDATE;
data.PRODUCT = DALObj.PRODUCT;
data.QTY = DALObj.QTY;
data.STATUS = DALObj.STATUS;
data.STOCKINDATE = DALObj.STOCKINDATE;
data.REMARK = DALObj.REMARK;
data.TYPE = DALObj.TYPE;
data.UNIT = DALObj.UNIT;
data.LOTNO = DALObj.LOTNO;
data.WAREHOUSE = DALObj.WAREHOUSE;
}
return data;
}
public bool ValidateData(StockoutBasketData data)
{
bool ret = true;
if (data.PRODUCT == 0)
{
ret = false;
_error = "¡ÃسÒÃкءÃÐàªéÒ";
}
if (data.ITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ";
}
if (data.QTY == 0)
{
ret = false;
_error = "¡ÃسÒÃкبӹǹ¡ÃÐàªéÒ";
}
string sql = "SELECT PK.SUBPRODUCT, PK.QTY, PD.NAME PDNAME FROM PACKAGE PK INNER JOIN PRODUCT PD ON PD.LOID = PK.SUBPRODUCT WHERE PK.MAINPRODUCT = '" + data.PRODUCT.ToString() + "'";
DataTable tb = OracleDB.ExecListCmd(sql);
for (Int16 i = 0; i < tb.Rows.Count; ++i)
{
double Product = Convert.ToDouble(tb.Rows[i]["SUBPRODUCT"]);
double Qty = Convert.ToDouble(tb.Rows[i]["QTY"]) * data.QTY;
double AllQty = 0;
for (Int16 j = 0; j < data.ITEM.Count; ++j)
{
BasketItemData itemCompare = (BasketItemData)data.ITEM[j];
if (Product == itemCompare.PRODUCT)
{
AllQty += itemCompare.QTY;
}
}
if (AllQty != Qty)
{
_error = "¨Ó¹Ç¹¢Í§ " + tb.Rows[i]["PDNAME"].ToString() + " äÁè¶Ù¡µéͧ";
return false;
}
}
return ret;
}
public bool UpdateData(string userID, StockoutBasketData 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);
DALObj.CODE = data.CODE;
DALObj.CHECKDATE = data.CHECKDATE;
DALObj.PRODUCT = data.PRODUCT;
DALObj.QTY = data.QTY;
if (data.STOCKINDATE.Year != 1)
{
DALObj.STOCKINDATE = data.STOCKINDATE;
}
DALObj.REMARK = data.REMARK;
DALObj.TYPE = data.TYPE;
DALObj.UNIT = data.UNIT;
DALObj.STATUS = data.STATUS;
DALObj.LOTNO = data.LOTNO;
DALObj.WAREHOUSE = data.WAREHOUSE;
if (DALObj.OnDB)
{
ret = DALObj.UpdateCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
else
{
DALObj.STATUS = data.STATUS;
ret = DALObj.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
_LOID = DALObj.LOID;
BasketItemDAL itemDAL = new BasketItemDAL();
itemDAL.DeleteDataByBasket(data.LOID, obj.zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
BasketItemData item = (BasketItemData)data.ITEM[i];
itemDAL.BASKET = DALObj.LOID;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.UNIT = item.UNIT;
itemDAL.LOTNO = item.LOTNO;
itemDAL.PACKAGE = item.PACKAGE;
itemDAL.QTY = item.QTY;
itemDAL.PRODUCTSTOCK = item.PRODUCTSTOCK;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
if (data.STATUS == Constz.Requisition.Status.Approved.Code)
{
ret = DALObj.CutStockBasket(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;
}
}
else
ret = false;
return ret;
}
protected void SubmitClick(object sender, EventArgs e)
{
StockoutBasketData data = new StockoutBasketData();
data = GetData();
data.STATUS = Constz.Basket.Status.Approved.Code;
data.STOCKINDATE = DateTime.Now.Date;
if (FlowObj.UpdateData(Authz.CurrentUserInfo.UserID, data))
{
ResetState(FlowObj.LOID);
Appz.ClientAlert(this, "Â×¹Âѹ¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ");
}
else
Appz.ClientAlert(this, FlowObj.ErrorMessage);
}
private StockoutBasketData GetData()
{
StockoutBasketData data = new StockoutBasketData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.CODE = this.txtBasketCode.Text.Trim();
data.CHECKDATE = this.ctlCheckDate.DateValue;
data.PRODUCT = Convert.ToDouble(this.txtPDLOID.Text == "" ? "0" : this.txtPDLOID.Text);
data.QTY = Convert.ToDouble(this.txtBasketQty.Text == "" ? "0" : this.txtBasketQty.Text);
data.STATUS = this.txtStatus.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
data.TYPE = this.cmbBasketType.SelectedItem.Value;
data.UNIT = Convert.ToDouble(this.txtUnit.Text == "" ? "0" : this.txtUnit.Text);
data.LOTNO = this.txtLotNo.Text.Trim();
data.WAREHOUSE = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text);
data.ITEM = ItemObj.GetItemList();
return data;
}
