public bool InsertData(string UserID, BasketData bkData, DataTable tempTable)
{
double _PMLOID = 0;
_PMLOID = InsertProductMaster(UserID, bkData);
if (_PMLOID == 0)
return false;
_PBLOID = InsertProductBarcode(UserID, bkData, _PMLOID);
if (_PBLOID == 0)
return false;
if (InsertPackage(UserID, tempTable, _PBLOID, _PMLOID) == false)
return false;
else
{
return true;
}
}
private void UpdateData()
{
bool ret = true;
BasketData bkData = new BasketData();
BasketFlow bkFlow = new BasketFlow();
bkData.LOID = Convert.ToDouble(txtLOID.Text.Trim() == "" ? "0" : txtLOID.Text.Trim());
bkData.CODE = txtCode.Text.Trim();
bkData.NAME = txtBasketName.Text.Trim();
bkData.ABBNAME = txtABBName.Text.Trim();
bkData.BARCODE = txtBarcode.Text.Trim();
bkData.UNITBASKET = Convert.ToDouble(cmbUnit.SelectedItem.Value);
bkData.PRODUCTGROUP = Convert.ToDouble(cmbProductGroup.SelectedItem.Value);
bkData.COST = Convert.ToDouble(txtCost.Text.Trim());
bkData.PRICE = Convert.ToDouble(txtPrice.Text.Trim());
bkData.STDPRICE = Convert.ToDouble(txtSTDPrice.Text.Trim());
bkData.PRODUCTMASTER = Convert.ToDouble(txtProductMaster.Text.Trim());
bkData.ENAME = txtEname.Text.Trim();
if (chkStatus.Checked == true)
bkData.ACTIVE = "1";
else
bkData.ACTIVE = "0";
if (radVAT.Checked == true)
bkData.ISVAT = Constz.VAT.Included.Code;
else if (radNoVAT.Checked == true)
bkData.ISVAT = Constz.VAT.NotIncluded.Code;
if (radDiscount.Checked == true)
bkData.ISDISCOUNT = Constz.Discount.Calculated.Code;
else if (radNoDiscount.Checked == true)
bkData.ISDISCOUNT = Constz.Discount.NotCalculated.Code;
if (radRefund.Checked == true)
bkData.ISREFUND = Constz.Refund.Yes.Code;
else if (radNoRefund.Checked == true)
bkData.ISREFUND = Constz.Refund.No.Code;
bkData.REMARK = txtRemark.Text.Trim();
if (Session["tempTab"] != null)
tempTable = (DataTable)Session["tempTab"];
if (bkFlow.CheckCode(bkData.LOID, bkData.CODE.Trim()) == false)
Appz.ClientAlert(Page, "ÃËÑÊ¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ");
if (bkFlow.CheckName(bkData.LOID, bkData.NAME.Trim()) == false)
Appz.ClientAlert(Page, "ª×èÍ¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ");
if (bkFlow.CheckBarcode(bkData.LOID, bkData.BARCODE.Trim()) == false)
Appz.ClientAlert(Page, "ºÒÃìâ¤é´¡ÃÐàªéÒ«éӡѺ·ÕèÁÕÍÂÙèáÅéÇ");
ret = bkFlow.UpdateData(Authz.CurrentUserInfo.UserID, bkData, tempTable);
if (ret == false)
Appz.ClientAlert(Page, bkFlow.ErrorMessage);
else
{
//ClearControls();
//LoadData(bkData.BARCODE);
Appz.ClientAlert(Page, "·Ó¡ÒÃá¡é䢢éÍÁÙÅ¡ÃÐàªéÒàÃÕºÃéÍÂ");
LoadData(bkFlow.PBLOID);
}
}
private double UpdateProductBarcode(string UserID, BasketData bkData )
{
bool ret = true;
ProductBarcodeDAL bDAL = new ProductBarcodeDAL();
bDAL.GetDataByLOID(bkData.LOID, null);
bDAL.ABBNAME = bkData.ABBNAME;
bDAL.BARCODE = bkData.BARCODE;
bDAL.UNIT = bkData.UNITBASKET;
bDAL.COST = bkData.COST;
bDAL.PRICE = bkData.PRICE;
bDAL.ISVAT = bkData.ISVAT;
bDAL.ISDISCOUNT = bkData.ISDISCOUNT;
bDAL.ISREFUND = bkData.ISREFUND;
bDAL.ACTIVE = bkData.ACTIVE;
bDAL.STDPRICE = bkData.PRICE;
bDAL.MULTIPLY = 1;
ret = bDAL.UpdateCurrentData(UserID, null);
if (ret == false)
{
_error = bDAL.ErrorMessage;
return 0;
}
else
{
return bDAL.LOID;
}
}
private bool UpdateProductMaster(string UserID, BasketData bkData)
{
bool ret = true;
ProductMasterDAL oDAL = new ProductMasterDAL();
oDAL.GetDataByLOID(bkData.PRODUCTMASTER, null);
oDAL.CODE = bkData.CODE;
oDAL.NAME = bkData.NAME;
oDAL.ENAME = bkData.ENAME;
oDAL.UNIT = bkData.UNITBASKET;
oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP;
oDAL.ACTIVE = bkData.ACTIVE;
ret = oDAL.UpdateCurrentData(UserID, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return ret;
}
else
return ret;
}
public bool UpdateData(string UserID, BasketData bkData, DataTable tempTable)
{
bool ret = true;
ret = UpdateProductMaster(UserID, bkData);
if (ret == false )
return false;
_PBLOID = UpdateProductBarcode(UserID, bkData);
if (_PBLOID == 0)
return false;
if (UpdatePackage(UserID, tempTable, _PBLOID) == false)
return false;
else
{
return true;
}
//bool ret = true;
//ProductDAL oDAL = new ProductDAL();
//OracleDBObj objDB = new OracleDBObj();
//objDB.CreateConnection();
//objDB.CreateTransaction();
//try
//{
// oDAL.GetDataByLOID(bkData.LOID, null);
// oDAL.CODE = bkData.CODE;
// oDAL.NAME = bkData.NAME;
// oDAL.ABBNAME = bkData.ABBNAME;
// oDAL.BARCODE = bkData.BARCODE;
// oDAL.UNIT = bkData.UNITBASKET;
// oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP;
// oDAL.COST = bkData.COST;
// oDAL.PRICE = bkData.PRICE;
// oDAL.STDPRICE = bkData.STDPRICE;
// oDAL.ISVAT = bkData.ISVAT;
// oDAL.ISDISCOUNT = bkData.ISDISCOUNT;
// oDAL.ISEDIT = bkData.ISEDITPRICE;
// oDAL.ISREFUND = bkData.ISREFUND;
// oDAL.REMARK = bkData.REMARK;
// oDAL.ACTIVE = "1";
// ret = oDAL.UpdateCurrentData(UserID, objDB.zTrans);
// if (ret == true)
// {
// if (tempTable.Rows.Count > 0)
// {
// if (UpdatePackage(UserID, tempTable, objDB, oDAL.LOID) == true)
// {
// objDB.zTrans.Commit();
// ret = true;
// }
// else
// {
// objDB.zTrans.Rollback();
// ret = false;
// }
// }
// else
// {
// objDB.zTrans.Commit();
// ret = true;
// }
// }
// else
// {
// _error = oDAL.ErrorMessage;
// objDB.zTrans.Rollback();
// ret = false;
// }
//}
//catch (Exception ex)
//{
// _error = ex.Message; ;
// objDB.zTrans.Rollback();
// ret = false;
//}
//objDB.CloseConnection();
//return ret;
}
private double InsertProductBarcode(string UserID, BasketData bkData, double ProductMaster)
{
bool ret = true;
ProductBarcodeDAL bDAL = new ProductBarcodeDAL();
bDAL.PRODUCTMASTER = ProductMaster;
bDAL.ABBNAME = bkData.ABBNAME;
bDAL.BARCODE = bkData.BARCODE;
bDAL.UNIT = bkData.UNITBASKET;
bDAL.COST = bkData.COST;
bDAL.PRICE = bkData.PRICE;
bDAL.ISVAT = bkData.ISVAT;
bDAL.ISDISCOUNT = bkData.ISDISCOUNT;
bDAL.ISREFUND = bkData.ISREFUND;
bDAL.ACTIVE = bkData.ACTIVE;
bDAL.STDPRICE = bkData.PRICE;
bDAL.MULTIPLY = 1;
bDAL.ISEDIT = "Y";
bDAL.ISDEFAULT = "Y";
ret = bDAL.InsertCurrentData(UserID, null);
if (ret == false)
{
string sqlDelete = "DELETE FROM PRODUCTMASTER WHERE LOID = " + ProductMaster;
OracleDB.ExecNonQueryCmd(sqlDelete);
_error = bDAL.ErrorMessage;
return 0;
}
else
{
return bDAL.LOID;
}
}
private double InsertProductMaster(string UserID, BasketData bkData)
{
bool ret = true;
ProductMasterDAL oDAL = new ProductMasterDAL();
oDAL.CODE = bkData.CODE;
oDAL.NAME = bkData.NAME;
oDAL.ENAME = bkData.ENAME;
oDAL.UNIT = bkData.UNITBASKET;
oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP;
oDAL.ACTIVE = bkData.ACTIVE;
ret = oDAL.InsertCurrentData(UserID, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return 0;
}
else
return oDAL.LOID;
}
