private void setStatusRequisition(string active,string status)
{
bool rt = true;
ArrayList arr = new ArrayList();
ReturnSearchFlow csFlow = new ReturnSearchFlow();
RequisitionData dr = new RequisitionData();
dr.CODE = txtRqCode.Text.Trim();
dr.ACTIVE = active.ToString();
dr.STATUS = status.ToString();
arr.Add(dr);
rt = csFlow.UpdateRequisition_Choose(Appz.CurrentUserData.UserID.ToString(), arr);
}
private void btnBack_Click(object sender, EventArgs e)
{
int cnt = -1;
bool ret = true;
if (Appz.OpenQuestionDialog("µéͧ¡ÒáÅѺ˹éÒ¨ÍËÅÑ¡ãªèËÃ×ÍäÁè?") == DialogResult.OK)
{
cnt = ReturnSearchFlow.CheckStockInitemData(_LOID.ToString());
if (cnt == 0)
{
ReturnSearchFlow RtFlow = new ReturnSearchFlow();
ret = RtFlow.DeleteStockInData(_LOID.ToString());
if (txtSiiStatus.Text.Trim() != "")
setStatusRequisition("0", "VO");
else
setStatusRequisition("1", "AP");
}
this.Close();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
bool ret = true;
bool rt = true;
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃźÃÒ¡ÒÃãªèËÃ×ÍäÁè?") == DialogResult.OK)
{
ArrayList arrLOID = new ArrayList();
ArrayList arr = new ArrayList();
ReturnSearchFlow csFlow = new ReturnSearchFlow();
for (int i = 0; i < grvReturnSearch.Rows.Count; i++)
{
DataGridViewCheckBoxCell maCell = (DataGridViewCheckBoxCell)this.grvReturnSearch.Rows[i].Cells["CHKAPPROVE"];
if (maCell.FormattedValue.Equals(true))
{
RequisitionData dr = new RequisitionData();
arrLOID.Add(grvReturnSearch.Rows[i].Cells["SILOID"].Value.ToString());
// arr.Add(grvReturnSearch.Rows[i].Cells["RQCODE"].Value.ToString());
dr.CODE = grvReturnSearch.Rows[i].Cells["RQCODE"].Value.ToString();
dr.ACTIVE = "1";
dr.STATUS = "AP";
arr.Add(dr);
}
}
ret = csFlow.DeleteStockIn_StockInitemData(Appz.CurrentUserData.UserID, arrLOID);
if (ret == true)
{
rt = csFlow.UpdateRequisition_Choose(Appz.CurrentUserData.UserID.ToString(), arr);
Appz.OpenInformationDialog("źÃÒ¡ÒÃàÃÕºÃéÍÂ");
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
}
LoadData();
}
}
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;
}
}
}
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();
}