private int InsertStockInItem()
{
grvProductStockInShop.EndEdit();
ArrayList arr = new ArrayList();
bool ret = true;
double cnt = 0;
cnt = grvProductStockInShop.Rows.Count;
if (_FLAG == "ADD")
{
for (int i = 0; i < cnt; i++)
{
DataGridViewTextBoxCell QTY = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["RECEIVE_QTY"];
DataGridViewTextBoxCell STOCKIN = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["SILOID"];
DataGridViewTextBoxCell PRODUCT = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["PDLOID"];
DataGridViewTextBoxCell REFLOID = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["RQILOID"];
StockInItemData dr = new StockInItemData();
dr.QTY = Convert.ToDouble(QTY.Value.ToString());
dr.STOCKIN = Convert.ToDouble(STOCKIN.Value.ToString());
dr.PRODUCT = Convert.ToDouble(PRODUCT.Value.ToString());
dr.REFLOID = Convert.ToDouble(REFLOID.Value.ToString());
arr.Add(dr);
}
ProductStockInShopFlow csFlow = new ProductStockInShopFlow();
ret = csFlow.InsertStockInitem(Appz.CurrentUserData.UserID, arr);
if (ret == true)
{
//Appz.OpenInformationDialog("ºÑ¹·Ö¡ÃÒ¡ÒÃàÃÕºÃéÍÂ");
return 1;
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
return 0;
}
}
else
{
if (txtSiiStatus.Text.Trim() == "AP")
{
Appz.OpenWarningDialog("ÃÒ¡ÒùÕé¶Ù¡Â×¹ÂѹáÅéÇ");
return 0;
}
else
{
for (int i = 0; i < cnt; i++)
{
DataGridViewTextBoxCell SIILOID = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["SIILOID"];
DataGridViewTextBoxCell RECEIVE_QTY = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["RECEIVE_QTY"];
StockInItemData dr = new StockInItemData();
dr.LOID = Convert.ToDouble(SIILOID.Value.ToString());
dr.QTY = Convert.ToDouble(RECEIVE_QTY.Value.ToString());
arr.Add(dr);
}
ProductStockInShopFlow csFlow = new ProductStockInShopFlow();
ret = csFlow.UpdateTemptable(Appz.CurrentUserData.UserID, arr);
if (ret == true)
return 2;
else
Appz.OpenWarningDialog(csFlow.ErrorMessage);
return 0;
}
}
}
protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList cmbProduct = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[3].FindControl("cmbProduct");
TextBox txtSQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[7].FindControl("txtSQty");
TextBox txtPQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[6].FindControl("txtPQty");
DropDownList cmbUnit = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[8].FindControl("cmbUnit");
StockInItemData data = new StockInItemData();
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtSQty.Text == "" ? "0" : txtSQty.Text);
data.PQTY = Convert.ToDouble(txtPQty.Text == "" ? "0" : txtPQty.Text);
e.NewValues["LOID"] = this.grvItem.Rows[e.RowIndex].Cells[1].Text;
e.NewValues["PRODUCT"] = data.PRODUCT.ToString();
e.NewValues["SQTY"] = data.QTY.ToString();
e.NewValues["PQTY"] = data.QTY.ToString();
}
protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtProduct = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[4].FindControl("txtProduct");
TextBox txtQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[6].FindControl("txtQty");
TextBox txtUnit = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[7].FindControl("txtUnit");
StockInItemData data = new StockInItemData();
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
e.NewValues["LOID"] = this.grvItem.Rows[e.RowIndex].Cells[10].Text;
//e.NewValues["PRODUCT"] = data.PRODUCT.ToString();
e.NewValues["QTY"] = data.QTY.ToString();
}
protected void grvItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
DropDownList cmbProduct = (DropDownList)this.grvItem.FooterRow.Cells[3].FindControl("cmbNewProduct");
TextBox txtSQty = (TextBox)this.grvItem.FooterRow.Cells[7].FindControl("txtNewSQty");
TextBox txtPQty = (TextBox)this.grvItem.FooterRow.Cells[6].FindControl("txtNewPQty");
TextBox txtLotNo = (TextBox)this.grvItem.FooterRow.Cells[4].FindControl("txtNewLotNo");
TextBox txtRemark = (TextBox)this.grvItem.FooterRow.Cells[9].FindControl("txtNewRemark");
DropDownList cmbUnit = (DropDownList)this.grvItem.FooterRow.Cells[8].FindControl("cmbNewUnit");
// TextBox txtNewQCQty = (TextBox)this.grvItem.FooterRow.Cells[8].FindControl("txtNewQCQty");
TextBox txtRefLoid = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtRefLoid");
TextBox txtPrice = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtPrice");
StockInItemData data = new StockInItemData();
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtSQty.Text == "" ? "0" : txtSQty.Text);
data.LOTNO = txtLotNo.Text.Trim();
data.REMARK = txtRemark.Text.Trim();
// data.QCQTY = Convert.ToDouble(txtNewQCQty.Text == "" ? "0" : txtNewQCQty.Text);
data.REFLOID = Convert.ToDouble(txtRefLoid.Text == "" ? "0" : txtRefLoid.Text);
data.PRICE = Convert.ToDouble(txtPrice.Text == "" ? "0" : txtPrice.Text);
data.PQTY = Convert.ToDouble(txtPQty.Text == "" ? "0" : txtPQty.Text);
if (ItemObj.InsertStokInItem(data))
{
SetGrvItem(this.txtStatus.Text);
}
else
Appz.ClientAlert(this, ItemObj.ErrorMessage);
}
}
public bool UpdateStockInItem(decimal LOID, decimal PRODUCT, string LOTNO, decimal REFLOID, string CODE, decimal QCQTY, decimal PQTY, decimal UNIT, string BARCODE, string QCREMARK, string QCRESULT, decimal RANK, decimal SQTY, string REMARK)
{
StockInItemData data = new StockInItemData();
data.LOID = Convert.ToDouble(LOID);
data.LOTNO = LOTNO;
data.REFLOID = Convert.ToDouble(REFLOID);
data.PRODUCT = Convert.ToDouble(PRODUCT);
data.QCQTY = Convert.ToDouble(QCQTY);
data.QTY = Convert.ToDouble(SQTY);
data.PQTY = Convert.ToDouble(PQTY);
data.REMARK = REMARK;
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
DataRow[] dRows = dt.Select("LOID = " + data.LOID.ToString());
DataRow dRow = dRows[0];
dRow["LOID"] = data.LOID;
dRow["PRODUCT"] = data.PRODUCT;
dRow["LOTNO"] = data.LOTNO;
dRow["QCQTY"] = data.QCQTY;
dRow["SQTY"] = data.QTY;
dRow["REFLOID"] = data.REFLOID;
dRow["PRICE"] = data.PRICE;
dRow["REMARK"] = data.REMARK;
POItemData product = FlowObj.GetPOItemData(data.REFLOID);
dRow["UNIT"] = product.UNIT;
dRow["BARCODE"] = product.BARCODE;
//dRow["UNITNAME"] = FlowObj.GetUnitData(product.UNIT).NAME;
dRow["CODE"] = product.CODE;
dRow["PQTY"] = product.QTY;
ReOrder(dt);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
else throw new ApplicationException(_error);
return ret;
}
public ArrayList GetItemList()
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
ArrayList arr = new ArrayList();
if (dt != null)
{
foreach (DataRow dRow in dt.Rows)
{
StockInItemData data = new StockInItemData();
//data.ACTIVE = Constz.ActiveStatus.Active;
data.LOID = Convert.ToDouble(dRow["LOID"]);
data.REFLOID = Convert.ToDouble(dRow["REFLOID"]);
data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
data.LOTNO = dRow["LOTNO"].ToString();
data.QCQTY = Convert.ToDouble(dRow["QCQTY"]);
data.QTY = dRow["SQTY"] == DBNull.Value ? 0 : Convert.ToDouble(dRow["SQTY"]);
data.UNIT = Convert.ToDouble(dRow["UNIT"]);
data.PRICE = Convert.ToDouble(dRow["PRICE"]);
data.REMARK = dRow["REMARK"].ToString();
data.QCREMARK = dRow["QCREMARK"].ToString();
data.QCRESULT = dRow["QCRESULT"].ToString();
arr.Add(data);
}
}
return arr;
}
//0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 PRICE, 0 DISCOUNT, 0 NETPRICE, '" + Constz.ActiveStatus.Active + "' ACTIVE, '' BARCODE, '' UNITNAME, '' ISVAT ";
public bool InsertStokInItem(StockInItemData data)
{
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
ReOrder(dt);
DataRow dRow = dt.NewRow();
dRow["LOID"] = Convert.ToDouble(dt.Rows.Count) + 1;
dRow["RANK"] = Convert.ToDouble(dRow["LOID"]);
dRow["PRODUCT"] = Convert.ToDouble(data.PRODUCT);
dRow["LOTNO"] = data.LOTNO;
dRow["REFLOID"] = Convert.ToDouble(data.REFLOID);
dRow["PRICE"] = Convert.ToDouble(data.PRICE);
dRow["REMARK"] = data.REMARK;
POItemData product = FlowObj.GetPOItemData(data.REFLOID);
dRow["QCQTY"] = Convert.ToDouble(data.QCQTY);
dRow["SQTY"] = Convert.ToDouble(data.QTY);
dRow["UNIT"] = Convert.ToDouble(product.UNIT);
// dRow["ACTIVE"] = Constz.ActiveStatus.Active;
dRow["BARCODE"] = product.BARCODE;
//dRow["UNITNAME"] = FlowObj.GetUnitData(product.UNIT).NAME;
dRow["CODE"] = product.CODE;
dRow["PQTY"] = product.QTY;
dt.Rows.Add(dRow);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
return ret;
}
private bool VerifyData(StockInItemData data)
{
bool ret = true;
if (data.PRODUCT == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
}
if (data.LOTNO == "")
{
ret = false;
_error = "¡ÃسÒÃÐºØ Lot No";
}
//else if (data.QCQTY == 0)
//{
// ret = false;
// _error = "¡ÃسÒÃкبӹǹÊ觵ÃǨ QC";
//}
else if (data.QCQTY>data.QTY)
{
ret = false;
_error = "¨Ó¹Ç¹Ê觵ÃǨ QC µéͧ¹éÍ¡ÇèÒà·èҡѺ¨Ó¹Ç¹·ÕèÃѺ";
}
else
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
foreach (DataRow dRow in dt.Rows)
{
if (dRow["LOTNO"].ToString() == data.LOTNO && Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT && Convert.ToDouble(dRow["LOID"]) != data.LOID)
{
_error = "ÃÒ¡ÒÃÊÔ¹¤éÒã¹àÅ¢·ÕèãºÊÑ觫×é͹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
ret = false;
goto ex;
}
}
ex: ;
}
return ret;
}
