private void AddData()
{
bool ret = true;
StockInData data = new StockInData();
data.DOCTYPE = Constz.DocType.DelRaw.LOID;
data.APPROVEDATE = DateTime.Now;
data.SENDER = Authz.CurrentUserInfo.Warehouse;
data.RECEIVER = Authz.CurrentUserInfo.Warehouse;
data.STATUS = Constz.Requisition.Status.Waiting.Code;
ret = FlowObj.InsertStockIn(Authz.CurrentUserInfo.UserID, data);
if (ret)
{
this.pnlData.Visible = false;
this.btnSelect.Visible = true;
this.ctlToolbar.Visible = false;
this.pnlMessage.Visible = true;
this.btnCancel.Text = "¡àÅÔ¡";
data = FlowObj.GetData(FlowObj.LOID);
this.txtLOID.Text = FlowObj.LOID.ToString();
this.lblCode.Text = data.CODE;
this.lblDate.Text = data.APPROVEDATE.ToString(Constz.DateFormat);
}
else
{
Appz.ClientAlert(this, FlowObj.ErrorMessage);
}
}
private bool ValidateData(StockInData data)
{
bool ret = true;
if (data.INVNO.Trim() == "")
{
ret = false;
_error = "¡ÃسÒÃкØàÅ¢·ÕèãºÊ觢ͧ";
}
else if (data.SENDER == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡¼Ùé¨Ó˹èÒÂ";
}
return ret;
}
public bool InsertStockIn(string userID, StockInData data)
{
bool ret = true;
if (ValidateData(data))
{
DALObj.ACCCODE = data.ACCCODE;
DALObj.APPROVEDATE = data.APPROVEDATE;
DALObj.APPROVER = data.APPROVER;
DALObj.DOCTYPE = data.DOCTYPE;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.INVNO = data.INVNO;
DALObj.QCCODE = data.QCCODE;
DALObj.QCDATE = data.QCDATE;
DALObj.REASON = data.REASON;
DALObj.RECEIVEDATE = data.RECEIVEDATE;
DALObj.RECEIVER = data.RECEIVER;
DALObj.REMARK = data.REMARK;
DALObj.SENDER = data.SENDER;
DALObj.STATUS = data.STATUS;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
ret = DALObj.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
_LOID = DALObj.LOID;
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 SaveData()
{
StockInData data = new StockInData();
data.ACCCODE = "";
data.DOCTYPE = Constz.DocType.RecRaw.LOID;
data.INVNO = this.txtInvNo.Text.Trim();
data.RECEIVEDATE = DateTime.Now;
data.RECEIVER = Authz.CurrentUserInfo.Warehouse;
data.SENDER = Convert.ToDouble(this.cmbSupplier.SelectedItem.Value);
data.STATUS = Constz.Requisition.Status.Waiting.Code;
if (FlowObj.InsertStockIn(Authz.CurrentUserInfo.UserID, data))
{
Response.Redirect(Constz.HomeFolder + "WH/Transaction/StockInPO/SelectPO.aspx?loid=" + FlowObj.LOID.ToString());
}
else
{
this.pnlError.Visible = true;
this.pnlMain.Visible = false;
this.lblError.Text = FlowObj.ErrorMessage;
this.btnSave.Text = "µ¡Å§";
this.btnCancel.Visible = false;
}
}
private int InsertStockInItem()
{
grvProductStockInShop.EndEdit();
ArrayList arr = new ArrayList();
ArrayList SiArr = new ArrayList();
bool ret = true;
bool rr = true;
double cnt = 0;
cnt = grvProductStockInShop.Rows.Count;
StockInData sd = new StockInData();
sd.GRANDTOT = Convert.ToDouble(txtTotal.Text.Trim());
sd.LOID = Convert.ToDouble((txtSiLoid.Text.Trim()==""?"0":txtSiLoid.Text.Trim()));
SiArr.Add(sd);
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"];
DataGridViewTextBoxCell PRICE = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["PRICE"];
DataGridViewTextBoxCell ULOID = (DataGridViewTextBoxCell)grvProductStockInShop.Rows[i].Cells["ULOID"];
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());
dr.PRICE = Convert.ToDouble(PRICE.Value.ToString());
dr.UNIT = Convert.ToDouble(ULOID.Value.ToString());
arr.Add(dr);
}
ProductStockInShopFlow csFlow = new ProductStockInShopFlow();
ret = csFlow.InsertStockInitem(Appz.CurrentUserData.UserID, arr);
if (ret == true)
{
rr = csFlow.UpdateStockIn_GrandTot(Appz.CurrentUserData.UserID, SiArr);
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)
{
rr = csFlow.UpdateStockIn_GrandTot(Appz.CurrentUserData.UserID, SiArr);
return 2;
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
return 0;
}
}
}
}
public StockInData GetData(double loid)
{
StockInData data = new StockInData();
if (DALObj.GetDataByLOID(loid, null))
{
data.LOID = DALObj.LOID;
data.ACCCODE = DALObj.ACCCODE;
data.APPROVEDATE = DALObj.APPROVEDATE;
data.APPROVER = DALObj.APPROVER;
data.CODE = DALObj.CODE;
data.DOCTYPE = DALObj.DOCTYPE;
data.GRANDTOT = DALObj.GRANDTOT;
data.INVNO = DALObj.INVNO;
data.QCCODE = DALObj.QCCODE;
data.QCDATE = DALObj.QCDATE;
data.REASON = DALObj.REASON;
data.RECEIVEDATE = DALObj.RECEIVEDATE;
data.RECEIVER = DALObj.RECEIVER;
data.REMARK = DALObj.REMARK;
data.SENDER = DALObj.SENDER;
data.STATUS = DALObj.STATUS;
}
return data;
}
private StockInData GetData()
{
StockInData data = new StockInData();
data.LOID = Convert.ToDouble(this.txtLOID.Text);
data.CODE = this.txtCode.Text.Trim();
data.GRANDTOT = Convert.ToDouble(this.txtGrandTot.Text);
data.RECEIVEDATE = this.dtpReceiveDate.Value.Date;
data.RECEIVER = Convert.ToDouble(this.txtReceiver.Text);
data.REMARK = this.txtRemark.Text.Trim();
data.SENDER = Convert.ToDouble(this.txtSender.Text);
data.STATUS = this.txtStatus.Text;
data.REFCODE = this.txtRequisitionCode.Text.Trim();
data.GRANDTOT = Convert.ToDouble(this.txtGrandTot.Text == "" ? "0" : this.txtGrandTot.Text);
foreach (DataGridViewRow gRow in this.grvStockin.Rows)
{
StockInItemData itemData = new StockInItemData();
if (!gRow.IsNewRow)
{
itemData.PRICE = Convert.ToDouble(gRow.Cells[indexPRICE].Value);
itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value);
itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value);
itemData.UNIT = Convert.ToDouble(gRow.Cells[indexUNIT].Value);
data.STOCKINITEM.Add(itemData);
}
}
return data;
}
private int InsertStockInItem()
{
grvReturn.EndEdit();
ArrayList arr = new ArrayList();
ArrayList SiArr = new ArrayList();
bool ret = true;
bool rr = true;
double cnt = 0;
cnt = grvReturn.Rows.Count;
StockInData sd = new StockInData();
sd.GRANDTOT = Convert.ToDouble(txtGrandTot.Text.Trim());
sd.LOID = Convert.ToDouble(_LOID.ToString());
sd.REASON = txtReason.Text.Trim();
sd.REMARK = txtRemark.Text.Trim();
SiArr.Add(sd);
if (_FLAG == "ADD")
{
for (int i = 0; i < cnt; i++)
{
DataGridViewTextBoxCell QTY = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["QTY"];
DataGridViewTextBoxCell STOCKIN = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["SILOID"];
DataGridViewTextBoxCell PRODUCT = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["PDLOID"];
DataGridViewTextBoxCell REFLOID = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["RQILOID"];
DataGridViewTextBoxCell PRICE = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["PRICE"];
DataGridViewTextBoxCell ULOID = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["ULOID"];
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());
dr.PRICE = Convert.ToDouble(PRICE.Value.ToString());
dr.UNIT = Convert.ToDouble(ULOID.Value.ToString());
arr.Add(dr);
}
ReturnSearchFlow csFlow = new ReturnSearchFlow();
ret = csFlow.InsertStockInitem(Appz.CurrentUserData.UserID, arr);
if (ret == true)
{
rr = csFlow.UpdateStockIn_GrandTot(Appz.CurrentUserData.UserID, SiArr);
setStatusRequisition("0", "VO");
return 1;
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
return 0;
}
}
else
{
if (txtSiiStatus.Text.Trim() == "AP")
{
Appz.OpenWarningDialog("ÃÒ¡ÒùÕé¶Ù¡Â×¹ÂѹáÅéÇ");
return 0;
}
else
{
//¡Ã³Õ update ¨Ó¹Ç¹ÃѺ¤×¹
// for (int i = 0; i < cnt; i++)
// {
// DataGridViewTextBoxCell SIILOID = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["SIILOID"];
// DataGridViewTextBoxCell QTY = (DataGridViewTextBoxCell)grvReturn.Rows[i].Cells["QTY"];
// StockInItemData dr = new StockInItemData();
// dr.LOID = Convert.ToDouble(SIILOID.Value.ToString());
// dr.QTY = Convert.ToDouble(QTY.Value.ToString());
// arr.Add(dr);
// }
// ReturnSearchFlow csFlow = new ReturnSearchFlow();
// ret = csFlow.UpdateTemptable(Appz.CurrentUserData.UserID, arr);
// if (ret == true)
// {
// rr = csFlow.UpdateStockIn_GrandTot(Appz.CurrentUserData.UserID, SiArr);
// return 2;
// }
// else
// {
// Appz.OpenWarningDialog(csFlow.ErrorMessage);
return 0;
}
}
}
public bool UpdateData(StockInData data, string userID)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateTransaction();
try
{
ValidateData(data);
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
UpdateData(data, userID, obj.zTrans);
if (obj.zTrans != null) obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
ret = false;
_error = ex.Message;
if (obj.zTrans != null) obj.zTrans.Rollback();
obj.CloseConnection();
}
return ret;
}
private void ValidateData(StockInData data)
{
if (data.REFCODE.Trim() == "")
throw new ApplicationException("¡ÃسÒÃкØàÅ¢·ÕèãºàºÔ¡ÍÍ¡¨Ò¡¤Åѧ");
else if (data.STOCKINITEM.Count == 0)
throw new ApplicationException("¡ÃسÒàÅ×Í¡ÃÒ¡ÒÃÊÔ¹¤éÒ");
}
private void UpdateData(StockInData data, string userID, System.Data.OracleClient.OracleTransaction trans)
{
bool ret = true;
DALObj.CODE = data.CODE;
DALObj.DOCTYPE = Constz.DocType.RecShop.LOID;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.RECEIVEDATE = data.RECEIVEDATE;
DALObj.RECEIVER = data.RECEIVER;
DALObj.REMARK = data.REMARK;
DALObj.SENDER = data.SENDER;
DALObj.STATUS = data.STATUS;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REFLOID = data.REFLOID;
DALObj.REFCODE = data.REFCODE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
ret = DALObj.InsertCurrentData(userID, trans);
_LOID = DALObj.LOID;
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
DALItemObj.DeleteDataByStockIn(data.LOID, trans);
for (int i = 0; i < data.STOCKINITEM.Count; ++i)
{
StockInItemData itemData = (StockInItemData)data.STOCKINITEM[i];
DALItemObj.OnDB = false;
DALItemObj.PRICE = itemData.PRICE;
DALItemObj.PRODUCT = itemData.PRODUCT;
DALItemObj.QTY = itemData.QTY;
DALItemObj.STATUS = DALObj.STATUS;
DALItemObj.STOCKIN = DALObj.LOID;
DALItemObj.UNIT = itemData.UNIT;
if (!DALItemObj.InsertCurrentData(userID, trans)) throw new ApplicationException(DALItemObj.ErrorMessage);
}
}
private StockInData GetData()
{
StockInData data = new StockInData();
data.LOID = Convert.ToDouble(this.txtLOID.Text);
data.CODE = this.txtCode.Text.Trim();
data.GRANDTOT = Convert.ToDouble(this.txtTotal.Text);
data.RECEIVEDATE = this.dtpReceiveDate.Value.Date;
data.RECEIVER = Convert.ToDouble(this.txtReceiver.Text);
data.REMARK = this.txtRemark.Text.Trim();
data.SENDER = Convert.ToDouble(this.txtSender.Text);
data.STATUS = this.txtStatus.Text;
data.REFTABLE = "REQUISITION";
data.REFLOID = Convert.ToDouble(this.txtRefLOID.Text);
data.REASON = this.txtReason.Text.Trim();
foreach (DataGridViewRow gRow in this.grvStockIn.Rows)
{
StockInItemData itemData = new StockInItemData();
itemData.PRICE = Convert.ToDouble(gRow.Cells[indexPRICE].Value);
itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value);
itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value);
itemData.UNIT = Convert.ToDouble(gRow.Cells[indexUNIT].Value);
itemData.REFLOID = Convert.ToDouble(gRow.Cells[indexREFLOID].Value);
itemData.REFTABLE = "REQUISITIONITEM";
data.STOCKINITEM.Add(itemData);
}
return data;
}
public double InsertStockIn(string UserId, StockInData data)
{
Boolean ret = true;
StockInDAL oDAL = new StockInDAL();
oDAL.SENDER = Convert.ToDouble(data.SENDER);
oDAL.DOCTYPE = Constz.DocType.RetShop.LOID;
oDAL.RECEIVEDATE = DateTime.Now.Date;
oDAL.STATUS = Constz.Requisition.Status.Waiting.Code;
oDAL.GRANDTOT = 0.00;
oDAL.RECEIVER = data.RECEIVER;
ret = oDAL.InsertCurrentData(UserId, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return 0;
}
else
return oDAL.LOID;
}
private void btnNew_Click(object sender, EventArgs e)
{
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃÊÃéÒ§ÃÒ¡ÒÃãËÁèãªèËÃ×ÍäÁè") == DialogResult.OK )
{
ProductStockInShopFlow csFlow = new ProductStockInShopFlow();
StockInData csData = new StockInData();
csData.SENDER = Appz.CurrentUserData.Warehouse;
//csData.RECEIVER = Appz.CurrentUserData.Warehouse;
double loid ;
//insert STockin
loid = csFlow.InsertStockIn(Appz.CurrentUserData.UserID.ToString(),csData );
if (loid == 0)
MessageBox.Show(csFlow.ErrorMessage);
else
Openfrm(loid,"ADD");
LoadData();
}
}
private void btnNew_Click(object sender, EventArgs e)
{
ReturnSearchFlow csFlow = new ReturnSearchFlow();
StockInData csData = new StockInData();
csData.SENDER = Appz.CurrentUserData.Warehouse;
csData.RECEIVER = Appz.CurrentUserData.Warehouse;
double loid;
//insert STockin
loid = csFlow.InsertStockIn(Appz.CurrentUserData.UserID.ToString(), csData);
if (loid == 0)
MessageBox.Show(csFlow.ErrorMessage);
else
Openfrm(loid, "ADD");
LoadData();
}
private void grvReturnSearch_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
this.txtSiLoid.Text = grvReturnSearch.Rows[e.RowIndex].Cells["SILOID"].Value.ToString();
if (grvReturnSearch.Rows[e.RowIndex].Cells[e.ColumnIndex].GetType().ToString() == "System.Windows.Forms.DataGridViewLinkCell")
{
double SILOID = Convert.ToDouble(grvReturnSearch.Rows[e.RowIndex].Cells[6].Value);
Openfrm(SILOID, "EDIT");
StockInData data = new StockInData();
}
}
}
public bool CommitData(StockInData data, string userID)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateTransaction();
try
{
ValidateData(data);
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code || data.LOID == 0)
{
data.STATUS = Constz.Requisition.Status.Approved.Code;
UpdateData(data, userID, obj.zTrans);
//ret = DALObj.CutStock(DALObj.LOID, userID, obj.zTrans);
ret = DALObj.CutStock(DALObj.LOID, userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
if (obj.zTrans != null) obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
ret = false;
_error = ex.Message;
if (obj.zTrans != null) obj.zTrans.Rollback();
obj.CloseConnection();
}
return ret;
}
public bool InsertData(string userID, double warehouse)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateTransaction();
try
{
StockInData data = new StockInData();
data.RECEIVEDATE = DateTime.Today;
data.RECEIVER = warehouse;
data.SENDER = warehouse;
data.STATUS = Constz.Requisition.Status.Waiting.Code;
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
UpdateData(data, userID, obj.zTrans);
if (obj.zTrans != null) obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
ret = false;
_error = ex.Message;
if (obj.zTrans != null) obj.zTrans.Rollback();
obj.CloseConnection();
}
return ret;
}
private void ValidateData(StockInData data)
{
if (data.STOCKINITEM.Count == 0)
throw new ApplicationException("¡ÃسÒàÅ×Í¡ÃÒ¡ÒÃÊÔ¹¤éÒ");
}
