private void worker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
foreach (DataRow row in uploadTable.Rows)
{
string chaseno = row.ItemArray[0].ToString();
string ulInStock = row.ItemArray[16].ToString();
string ulInStock50 = row.ItemArray[15].ToString();
if (ulInStock50 != "" && !ulInStock50.Contains("---") && ulInStock50 != "Received" && ulInStock50 != "一回合格入庫" && ulInStock50 != "已拆單、以合格同時入庫")
{
string vendorcode = DataChecking.getVendorCodeByChaseNo(chaseno);
string payterm = DataChecking.getPayTerm(vendorcode);
ulInStock50 = ImportXlsUtil.ParseDateTime(ulInStock50).ToString("yyyy/MM/dd");
string paymonth = "";
if (payterm == "HK01")
{
paymonth = ImportXlsUtil.ParseDateTime(ulInStock50).AddMonths(1).ToString("yyyy/MM/dd");
}
else if (payterm == "HK02")
{
paymonth = ImportXlsUtil.ParseDateTime(ulInStock50).AddMonths(2).ToString("yyyy/MM/dd");
}
string query = string.Format("update tb_betamould set tm_st_code = 'HS', tm_instockdate50 = '{0}', tm_moulditemviewer = 'Yes', tm_paydate = '{1}' where tm_chaseno = '{2}'", ulInStock50, paymonth, chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
}
if (ulInStock != "" && ulInStock != "Received" && ulInStock != "#N/A")
{
string vendorcode = DataChecking.getVendorCodeByChaseNo(chaseno);
string payterm = DataChecking.getPayTerm(vendorcode);
string paymonth = "";
if (payterm == "HK01")
{
paymonth = ImportXlsUtil.ParseDateTime(ulInStock).AddMonths(1).ToString("yyyy/MM/dd");
}
else if (payterm == "HK02")
{
paymonth = ImportXlsUtil.ParseDateTime(ulInStock).AddMonths(2).ToString("yyyy/MM/dd");
}
ulInStock = ImportXlsUtil.ParseDateTime(ulInStock).ToString("yyyy/MM/dd");
if (ulInStock == "0001/03/02")
{
ulInStock = "";
}
string query = string.Format("update tb_betamould set tm_st_code = 'S', tm_instockdate = '{0}', tm_paydate = '{1}', tm_nofac = 'False', tm_moulditemviewer = 'Yes' where tm_chaseno = '{2}'", ulInStock, paymonth, chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
string expenseText = string.Format("update tb_expensetransfer set et_poinstock = '{0}' where et_chaseno = '{1}'", ulInStock, chaseno);
DataService.GetInstance().ExecuteNonQuery(expenseText);
string query2 = string.Format("update TB_FA_APPROVAL set f_remarks = N'已入庫' where f_mould = '{0}'", chaseno);
DataServiceNew.GetInstance().ExecuteNonQuery(query2);
}
}
MessageBox.Show("Data uploaded");
}
catch
{
MessageBox.Show("Invalid Data Format");
}
}
private void search()
{
this.txtCheckdate.Clear();
this.txtCav.Clear();
this.txtWeight.Clear();
this.txtEquipment.Clear();
this.txtShot.Clear();
this.txtLength.Clear();
this.txtWidth.Clear();
this.txtHeight.Clear();
this.txtInstockRemarks.Clear();
this.dgvResult.Rows.Clear();
this.dgvPreview.Rows.Clear();
string po = txtPo.Text;
if (!DataChecking.isValidPo(po))
{
if (po.StartsWith("12") && po.EndsWith("10"))
{
string tmpo = po.Substring(0, po.Length - 2);
tmpo = tmpo + "20";
if (DataChecking.isValidPo(tmpo))
{
switch (MessageBox.Show("Temporary receive PO: " + po + " ?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
string poText = string.Format("insert into tb_temppo (tp_po) values ('{0}')", po);
DataService.GetInstance().ExecuteNonQuery(poText);
MessageBox.Show("Record has been saved.");
break;
case DialogResult.No:
break;
}
return;
}
else
{
MessageBox.Show("Invalid PO No.");
return;
}
}
else
{
MessageBox.Show("Invalid PO No.");
return;
}
}
if (DataChecking.IsPoRmb(po))
{
foreach (CheckBox checkbox in tbCheckbox.Controls)
{
checkbox.Enabled = false;
checkbox.Checked = false;
}
this.getDataByPo(po);
tmpPo = po;
if (checkPoIsMpa(po))
{
pictureBox1.BackgroundImage = Properties.Resources.tick;
ckbNormal.Enabled = false;
ckbTransfer.Enabled = false;
string is50 = DataChecking.getInstock50ByPo(po);
if (is50 == "Yes")
{
ckbFirst50.Enabled = true;
ckbSecond50.Enabled = false;
ckbPo1.Enabled = true;
ckbPo2.Enabled = true;
}
else
{
ckbFirst50.Enabled = false;
ckbSecond50.Enabled = true;
ckbPo1.Enabled = false;
ckbPo2.Enabled = false;
}
}
else
{
pictureBox1.BackgroundImage = Properties.Resources.cross;
string type = DataChecking.getTypeByPo(po);
if (type == "New" || type == "Modify")
{
ckbNormal.Enabled = true;
ckbTransfer.Enabled = false;
}
else
{
ckbNormal.Enabled = false;
ckbTransfer.Enabled = true;
}
ckbFirst50.Enabled = false;
ckbSecond50.Enabled = false;
ckbPo1.Enabled = false;
ckbPo2.Enabled = false;
}
btnPreview.Enabled = true;
}
else
{
string currentInStockdate = DataChecking.getInStockDateByPo(po);
if (currentInStockdate == "Received")
{
switch (MessageBox.Show("PO: " + po + " data already received. Do you want to modify it?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
break;
case DialogResult.No:
foreach (CheckBox checkbox in tbCheckbox.Controls)
{
checkbox.Enabled = true;
checkbox.Checked = false;
}
pictureBox1.BackgroundImage = null;
return;
}
}
this.getDataByPo(po);
tmpPo = po;
if (checkPoIsMpa(po))
{
pictureBox1.BackgroundImage = Properties.Resources.tick;
ckbNormal.Enabled = false;
ckbTransfer.Enabled = false;
string is50 = DataChecking.getInstock50ByPo(po);
if (is50 == "Yes")
{
ckbFirst50.Enabled = true;
ckbSecond50.Enabled = false;
ckbPo1.Enabled = true;
ckbPo2.Enabled = true;
}
else
{
ckbFirst50.Enabled = false;
ckbSecond50.Enabled = true;
ckbPo1.Enabled = false;
ckbPo2.Enabled = false;
}
}
else
{
pictureBox1.BackgroundImage = Properties.Resources.cross;
string type = DataChecking.getTypeByPo(po);
if (type == "New" || type == "Modify")
{
ckbNormal.Enabled = true;
ckbTransfer.Enabled = false;
}
else
{
ckbNormal.Enabled = false;
ckbTransfer.Enabled = true;
}
ckbFirst50.Enabled = false;
ckbSecond50.Enabled = false;
ckbPo1.Enabled = false;
ckbPo2.Enabled = false;
}
btnPreview.Enabled = true;
}
}
private void loadPreviewData(string chaseno, string po, string itemcode, string rev, string mouldno, string mouldcode, string vendor, string vendorname,
string tmpfac, string fac, string currency, string amount, string issued)
{
dgvPreview.Rows.Clear();
if (fac == "")
{
fac = "-";
}
if (ckbNormal.Checked)
{
instockdate50 = "-----";
instockdate = "Received";
inputRequired = true;
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, fac, currency, amount, issued, "-----", "Received" });
}
else if (ckbFirst50.Checked)
{
instockdate50 = "Received";
instockdate = "#N/A";
inputRequired = false;
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, fac, currency, amount, issued, "Received", "#N/A" });
}
else if (ckbSecond50.Checked)
{
instockdate = "Received";
inputRequired = true;
string tmpinstock50 = DataChecking.getInstock50ByPo(po);
instockdate50 = tmpinstock50;
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, fac, currency, amount, issued, tmpinstock50, "Received" });
}
else if (ckbPo1.Checked)
{
instockdate50 = "一回合格入庫";
instockdate = "Received";
inputRequired = true;
if (tmpfac != "")
{
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, "-", currency, amount, issued, "一回合格入庫", "Received" });
}
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, "-", fac, currency, amount, issued, "一回合格入庫", "Received" });
}
else if (ckbPo2.Checked)
{
instockdate50 = "已拆單、以合格同時入庫";
instockdate = "Received";
inputRequired = true;
if (tmpfac != "")
{
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, "-", currency, amount, issued, "已拆單、以合格同時入庫", "Received" });
}
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, "-", fac, currency, amount, issued, "已拆單、以合格同時入庫", "Received" });
}
else
{
instockdate50 = "-----";
instockdate = DateTime.Today.ToString("yyyy/MM/dd");
inputRequired = false;
if (tmpfac == "")
{
tmpfac = "-";
}
dgvPreview.Rows.Add(new object[] { chaseno, po, itemcode, rev, mouldno, mouldcode, vendor, vendorname, tmpfac, fac, currency, amount, issued, "-----", DateTime.Today.ToString("yyyy/MM/dd") });
}
}
private void btnReceive_Click(object sender, EventArgs e)
{
List <int> count = new List <int>();
foreach (Control control in tbCheckbox.Controls)
{
CheckBox ckb = (CheckBox)control;
if (ckb.Checked == true)
{
count.Add(1);
}
}
bool isRmb = DataChecking.IsPoRmb(txtPo.Text.Trim());
if (count.Count == 0 && !isRmb)
{
MessageBox.Show("Nothing selected. Please click Modify Spec if you want to update Mould Spec only");
return;
}
string checkdate = "", cav = "", weight = "", accessory = "", camera = "", length = "", width = "", height = "", instockremarks = "";
checkdate = txtCheckdate.Text;
if (!string.IsNullOrEmpty(txtCav.Text))
{
cav = txtCav.Text;
}
if (!string.IsNullOrEmpty(txtWeight.Text))
{
weight = txtWeight.Text;
}
if (!string.IsNullOrEmpty(txtEquipment.Text))
{
accessory = txtEquipment.Text;
}
if (!string.IsNullOrEmpty(txtShot.Text))
{
camera = txtShot.Text;
}
if (!string.IsNullOrEmpty(txtLength.Text))
{
length = txtLength.Text;
}
if (!string.IsNullOrEmpty(txtWidth.Text))
{
width = txtWidth.Text;
}
if (!string.IsNullOrEmpty(txtHeight.Text))
{
height = txtHeight.Text;
}
if (!string.IsNullOrEmpty(txtInstockRemarks.Text))
{
instockremarks = txtInstockRemarks.Text;
}
string calpo = txtPo.Text;
int thismonth = DateTime.Today.Month;
int selectedmonth = dpCheckDate.Value.Month;
/*checkdate = dpCheckDate.Value.ToString("yyyy/MM/dd");
*
* int result = thismonth - selectedmonth;
*
* if (result > 3 || result < -3)
* {
* switch (MessageBox.Show("Checkdate selection out of range (+ / - 3 months). Keep modifying?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
* {
* case DialogResult.Yes:
*
* break;
*
* case DialogResult.No:
* return;
* }
* }*/
if (isRmb)
{
string query = string.Format("update tb_betamould set tm_instockdate50 = '{0}', tm_instockdate = '{1}', tm_checkdate = '{2}', tm_cav = '{3}'" +
", tm_weight = '{4}', tm_accessory = '{5}', tm_camera = '{6}', tm_vertical = '{7}', tm_horizontal = '{8}', tm_height = '{9}', tm_moulditemviewer = 'Yes', tm_st_code = 'PR', tm_instockremarks = '{10}'" +
" where tm_po = '{11}'", instockdate50, instockdate, checkdate, cav, weight, accessory, camera, length, width, height, instockremarks, tmpPo);
//Debug.WriteLine(query);
DataService.GetInstance().ExecuteNonQuery(query);
}
else
{
if (inputRequired)
{
if (string.IsNullOrEmpty(checkdate))
{
MessageBox.Show("檢查合格日 cannot be null");
return;
}
string query = string.Format("update tb_betamould set tm_instockdate50 = '{0}', tm_instockdate = '{1}', tm_checkdate = '{2}', tm_cav = '{3}'" +
", tm_weight = '{4}', tm_accessory = '{5}', tm_camera = '{6}', tm_vertical = '{7}', tm_horizontal = '{8}', tm_height = '{9}', tm_moulditemviewer = 'Yes', tm_st_code = 'PR', tm_instockremarks = '{10}'" +
" where tm_po = '{11}'", instockdate50, instockdate, checkdate, cav, weight, accessory, camera, length, width, height, instockremarks, tmpPo);
DataService.GetInstance().ExecuteNonQuery(query);
//MessageBox.Show("Record has been saved");
}
else
{
string type = DataChecking.getTypeByPo(calpo);
if (type == "New" || type == "Modify")
{
string query = string.Format("update tb_betamould set tm_instockdate50 = '{0}', tm_instockdate = '{1}', tm_checkdate = '{2}', tm_cav = '{3}'" +
", tm_weight = '{4}', tm_accessory = '{5}', tm_camera = '{6}', tm_vertical = '{7}', tm_horizontal = '{8}', tm_height = '{9}', tm_moulditemviewer = 'Yes', tm_st_code = 'PR', tm_instockremarks = '{10}'" +
" where tm_po = '{11}'", instockdate50, instockdate, checkdate, cav, weight, accessory, camera, length, width, height, instockremarks, tmpPo);
DataService.GetInstance().ExecuteNonQuery(query);
}
else
{
List <string> polist = new List <string>();
string text = string.Format("select tm_po from tb_betamould where tm_po like '{0}%'", calpo);
GlobalService.reader = DataService.GetInstance().ExecuteReader(text);
while (GlobalService.reader.Read())
{
string po = GlobalService.reader.GetString(0);
polist.Add(po);
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
for (int i = 0; i < polist.Count; i++)
{
string targetpo = polist[i];
string query = string.Format("update tb_betamould set tm_instockdate50 = '{0}', tm_instockdate = '{1}', tm_checkdate = '{2}', tm_cav = '{3}'" +
", tm_weight = '{4}', tm_accessory = '{5}', tm_camera = '{6}', tm_vertical = '{7}', tm_horizontal = '{8}', tm_height = '{9}', tm_instockremarks = '{10}', tm_moulditemviewer = 'Yes', tm_st_code = 'S'" +
" where tm_po = '{11}'", instockdate50, instockdate, checkdate, cav, weight, accessory, camera, length, width, height, instockremarks, targetpo);
DataService.GetInstance().ExecuteNonQuery(query);
}
}
}
}
MessageBox.Show("Record has been saved");
//dpCheckDate.Value = DateTime.Today;
this.cancel();
}
private void bgworker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
DataTable tmptable = new DataTable();
tmptable = ImportXlsUtil.TranslateToTable(filename);
int errorcount = 1;
List <int> indexlist = new List <int>();
foreach (DataRow row in tmptable.Rows)
{
errorcount += 1;
string chaseno = row.ItemArray[2].ToString();
Debug.WriteLine("CHASE NO" + chaseno + "ROW: " + errorcount);
string status = DataChecking.getStatusByChaseno(chaseno);
Debug.WriteLine("STATUS: " + status);
string p2003no = row.ItemArray[12].ToString();
string p2003ans = row.ItemArray[13].ToString();
string p2003result = row.ItemArray[14].ToString();
string p2003updated = row.ItemArray[15].ToString();
string p2004no = row.ItemArray[16].ToString();
string p2004ans = row.ItemArray[17].ToString();
string p2004result = row.ItemArray[18].ToString();
string p2004updated = row.ItemArray[19].ToString();
string kdcno = row.ItemArray[20].ToString();
string kdcissued = row.ItemArray[21].ToString();
string kdcrps = row.ItemArray[22].ToString();
string kdcseisan = row.ItemArray[23].ToString();
string kdcresult = row.ItemArray[24].ToString();
string kdcupdated = row.ItemArray[25].ToString();
string assetdesc = row.ItemArray[26].ToString();
string capdate = row.ItemArray[27].ToString();
string acquishkd = row.ItemArray[28].ToString();
string accumhkd = row.ItemArray[29].ToString();
string closingmonth = row.ItemArray[30].ToString();
string bookhkd1 = row.ItemArray[31].ToString();
string fy = row.ItemArray[32].ToString();
string bookhkd2 = row.ItemArray[33].ToString();
//string nav = row.ItemArray[33].ToString();
string disposalringi = row.ItemArray[34].ToString();
string disposalreportno = row.ItemArray[35].ToString();
string disposalreportissued = row.ItemArray[36].ToString();
string disposalreportrecieved = row.ItemArray[37].ToString();
string vendorresult = row.ItemArray[38].ToString();
string fadisposal = row.ItemArray[39].ToString();
string disposalremarks = row.ItemArray[40].ToString();
string query = "";
string disposalText = "";
if (status == "D1")//待廃棄 - 調整依賴中
{
if ((p2003result == "OK" || p2003result == "可") && (p2004result == "OK" || p2004result == "可"))
{
if (check2003IsValid(p2003no, p2003ans, p2003updated) && check2004IsValid(p2004no, p2004ans, p2004updated))
{
p2003updated = ImportXlsUtil.ParseDateTime(p2003updated).ToString("yyyy/MM/dd");
p2004updated = ImportXlsUtil.ParseDateTime(p2004updated).ToString("yyyy/MM/dd");
query = string.Format("update tb_betamould set tm_st_code = 'D2' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_2003no = '{0}', dd_2003answer = '{1}', dd_2003result = '{2}'" +
", dd_2003updated = '{3}', dd_2004no = '{4}', dd_2004answer = '{5}', dd_2004result = '{6}', dd_2004updated = '{7}', dd_disposalremarks = '{8}' where" +
" dd_chaseno = '{9}'", p2003no, p2003ans, p2003result, p2003updated, p2004no, p2004ans, p2004result, p2004updated, disposalremarks,
chaseno);
}
else
{
indexlist.Add(errorcount);
}
}
if (p2003result == "不可" || p2004result == "不可")
{
query = RollBackQuery(chaseno);
disposalText = DeleteQuery(chaseno);
}
}
else if (status == "D2")//待廃棄 - 日本生産本部確認中
{
if (kdcresult == "OK" || kdcresult == "可")
{
if (checkKdcIsValid(kdcno, kdcrps, kdcseisan, kdcupdated))
{
kdcupdated = ImportXlsUtil.ParseDateTime(kdcupdated).ToString("yyyy/MM/dd");
string fac = DataChecking.isFixedAssetExists(chaseno) ? DataChecking.getFixedAssetCode(chaseno) : "";
if (fac != "")
{
query = string.Format("update tb_betamould set tm_st_code = 'D4' where tm_chaseno = '{0}'", chaseno);
}
else
{
query = string.Format("update tb_betamould set tm_st_code = 'D3' where tm_chaseno = '{0}'", chaseno);
}
/*disposalText = string.Format("update tb_disposaldetail set dd_kdcno = '{0}', dd_kdcrps = '{1}', dd_kdcseisan = '{2}'" +
* ", dd_kdcupdated = '{3}', dd_kdcresult = '{4}', dd_kdcissued = '{6}', dd_disposalremarks = '{7}' where dd_chaseno = '{5}'", kdcno, kdcrps, kdcseisan, kdcupdated, kdcresult, chaseno, kdcissued, disposalremarks);*/
disposalText = string.Format("update tb_disposaldetail set dd_kdcrps = '{0}', dd_kdcseisan = '{1}'" +
", dd_kdcupdated = '{2}', dd_kdcresult = '{3}', dd_kdcissued = '{5}', dd_disposalremarks = '{6}' where dd_chaseno = '{4}'", kdcrps, kdcseisan, kdcupdated, kdcresult, chaseno, kdcissued, disposalremarks);
}
else
{
indexlist.Add(errorcount);
}
}
if (kdcresult == "不可")
{
query = RollBackQuery(chaseno);
disposalText = DeleteQuery(chaseno);
}
}
else if (status == "D3")//待廃棄 - 日本生産本部確認完了
{
disposalreportissued = ImportXlsUtil.ParseDateTime(disposalreportissued).ToString("yyyy/MM/dd");
//disposalreportrecieved = ImportXlsUtil.ParseDateTime(disposalreportrecieved).ToString("yyyy/MM/dd");
if (checkDisposalReportValid(disposalreportno, disposalreportissued))
{
query = string.Format("update tb_betamould set tm_st_code = 'D6' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_reportno = '{0}', dd_reportissued = '{1}', dd_disposalremarks = '{3}'" +
" where dd_chaseno = '{2}'", disposalreportno, disposalreportissued, chaseno, disposalremarks);
}
else
{
indexlist.Add(errorcount);
}
}
else if (status == "D4")//待廃棄 - 固定資産確認
{
if (checkFaValid(assetdesc, capdate, acquishkd, accumhkd, closingmonth, bookhkd1, fy, bookhkd2))
{
capdate = ImportXlsUtil.ParseDateTime(capdate).ToString("yyyy/MM/dd");
closingmonth = ImportXlsUtil.ParseDateTime(closingmonth).ToString("yyyy/MM/dd");
fy = ImportXlsUtil.ParseDateTime(fy).ToString("yyyy/MM/dd");
if (bookhkd1 != "0" && bookhkd1 != "")
{
query = string.Format("update tb_betamould set tm_st_code = 'D5' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_assetdesc = '{0}', dd_capdate = '{1}', dd_acquishkd = '{2}'" +
", dd_accumhkd = '{3}', dd_closing = '{4}', dd_bookhkd = '{5}', dd_fy = '{6}', dd_bookhkd2 = '{7}', dd_disposalremarks = '{9}' where dd_chaseno = '{8}'",
assetdesc, capdate, acquishkd, accumhkd, closingmonth, bookhkd1, fy, bookhkd2, chaseno, disposalremarks);
}
else
{
if (checkDisposalReportValid(disposalreportno, disposalreportissued))
{
disposalreportissued = ImportXlsUtil.ParseDateTime(disposalreportissued).ToString("yyyy/MM/dd");
//disposalreportrecieved = ImportXlsUtil.ParseDateTime(disposalreportrecieved).ToString("yyyy/MM/dd");
query = string.Format("update tb_betamould set tm_st_code = 'D6' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_reportno = '{0}', dd_reportissued = '{1}', dd_disposalremarks = '{3}'" +
" where dd_chaseno = '{2}'", disposalreportno, disposalreportissued,
chaseno, disposalremarks);
}
else
{
indexlist.Add(errorcount);
}
}
}
else
{
indexlist.Add(errorcount);
}
}
else if (status == "D5")//待廃棄 - 廃棄稟議書申請
{
if (disposalringi != "")
{
if (checkRingiValid(disposalringi))
{
//disposalreportrecieved = ImportXlsUtil.ParseDateTime(disposalreportrecieved).ToString("yyyy/MM/dd");
//query = string.Format("update tb_betamould set tm_st_code = 'D6' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_disposalringi = '{0}' where dd_chaseno = '{1}'", disposalringi, chaseno);
Debug.WriteLine("Disposal Text: " + disposalText);
if (checkDisposalReportValid(disposalreportno, disposalreportissued))
{
query = string.Format("update tb_betamould set tm_st_code = 'D6' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_reportno = '{0}', dd_reportissued = '{1}'" +
", dd_disposalringi = '{2}', dd_disposalremarks = '{4}' where dd_chaseno = '{3}'", disposalreportno, disposalreportissued,
disposalringi, chaseno, disposalremarks);
}
}
else
{
indexlist.Add(errorcount);
}
}
else
{
query = RollBackQuery(chaseno);
disposalText = DeleteQuery(chaseno);
}
}
else if (status == "D6")//待廃棄 - 廃棄報告書発行済
{
if (vendorresult == "OK" || vendorresult == "可")
{
disposalreportissued = ImportXlsUtil.ParseDateTime(disposalreportissued).ToString("yyyy/MM/dd");
disposalreportrecieved = ImportXlsUtil.ParseDateTime(disposalreportrecieved).ToString("yyyy/MM/dd");
query = string.Format("update tb_betamould set tm_st_code = 'D7' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_reportreceived = '{0}', dd_vendorresult = '{1}', dd_disposalremarks = '{3}' where dd_chaseno = '{2}'", disposalreportrecieved, vendorresult, chaseno, disposalremarks);
}
else
{
query = RollBackQuery(chaseno);
disposalText = DeleteQuery(chaseno);
}
}
else if (status == "D7")//待廃棄 - 廃棄報告書回収済
{
string fac = DataChecking.isFixedAssetExists(chaseno) ? DataChecking.getFixedAssetCode(chaseno) : "";
if (fac != "")
{
if (checkFaDisposalValid(fadisposal))
{
fadisposal = ImportXlsUtil.ParseDateTime(fadisposal).ToString("yyyy/MM/dd");
query = string.Format("update tb_betamould set tm_st_code = 'D8' where tm_chaseno = '{0}'", chaseno);
disposalText = string.Format("update tb_disposaldetail set dd_fadisposaldate = '{0}', dd_disposalremarks = '{1}'" +
" where dd_chaseno = '{2}'", fadisposal, disposalremarks, chaseno);
}
else
{
indexlist.Add(errorcount);
}
}
}
else if (status == "D8")//待廃棄 - 固定資産廃棄申請済
{
}
else
{
indexlist.Add(errorcount);
}
if (query != "")
{
DataService.GetInstance().ExecuteNonQuery(query);
}
if (disposalText != "")
{
DataService.GetInstance().ExecuteNonQuery(disposalText);
}
}
if (indexlist.Count != 0)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("Following rows contain invalid data");
for (int i = 0; i < indexlist.Count; i++)
{
int rowindex = indexlist[i];
builder.Append("Row: " + rowindex).AppendLine();
}
MessageBox.Show(builder + "");
}
else
{
MessageBox.Show("Record has been saved");
}
//this.loadData();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
MessageBox.Show("Invalid data format in upload file");
}
}
private void btnGo_Click(object sender, EventArgs e)
{
if (!DataChecking.isValidVendor(txtVendorAfter.Text))
{
MessageBox.Show("Invalid vendor code");
return;
}
string itemcode = txtItemcode.Text;
string rev = txtRev.Text;
string mouldno = cbMouldno.SelectedItem.ToString();
string chaseno = DataChecking.getChaseNoByItem(itemcode, rev, mouldno);
string fee = txtFee.Text;
string vendorbefore = DataChecking.getVendorByItem(itemcode, rev, mouldno);
string vendorafter = txtVendorAfter.Text;
string ringi = "", fa = "";
try
{
ringi = DataChecking.getRingiByItem(itemcode, rev, mouldno);
fa = DataChecking.getFixedAssetCode(chaseno);
}
catch
{
ringi = "";
fa = "";
}
if (string.IsNullOrEmpty(txtFee.Text) || txtFee.Text == "0")
{
dgvTransferPreview.Rows.Add(new object[] { chaseno, mouldno, itemcode, rev, "0", vendorbefore, vendorafter, ringi, fa });
}
else
{
if (ringiList.Count != 0)
{
for (int i = 0; i < ringiList.Count; i++)
{
string ringiInList = ringiList[i].Ringi;
decimal balance = Convert.ToDecimal(ringiList[i].Balance);
decimal dFee = Convert.ToDecimal(fee);
if (dFee > balance)
{
availableRingi = false;
}
dgvTransferPreview.Rows.Add(new object[] { chaseno, mouldno, itemcode, rev, fee, vendorbefore, vendorafter, ringi, fa });
}
}
else
{
dgvTransferPreview.Rows.Add(new object[] { chaseno, mouldno, itemcode, rev, fee, vendorbefore, vendorafter, ringi, fa });
}
}
dgvTransferPreview.Sort(dgvTransferPreview.Columns[0], ListSortDirection.Ascending);
}
private void loadData(string chaseno)
{
string query = string.Format("select tm_mouldno, tm_itemcode, tm_rev" +
", tm_oemasset, tm_remarks, tm_vendor_code, tm_mouldcode_code, tm_status, tm_type, tm_owner, tm_model from tb_betamould where tm_chaseno = '{0}'", chaseno);
Debug.WriteLine(query);
string mouldno = "", itemcode = "", rev = "", oemasset = "", remarks = "", vendor = "", mouldcode = "", status = "", type = "", owner = "";
GlobalService.reader = DataService.GetInstance().ExecuteReader(query);
while (GlobalService.reader.Read())
{
mouldno = GlobalService.reader.GetString(0);
itemcode = GlobalService.reader.GetString(1);
rev = GlobalService.reader.GetString(2);
oemasset = GlobalService.reader.GetString(3);
remarks = GlobalService.reader.GetString(4);
vendor = GlobalService.reader.GetString(5);
mouldcode = GlobalService.reader.GetString(6);
status = GlobalService.reader.GetString(7);
type = GlobalService.reader.GetString(8);
owner = GlobalService.reader.GetString(9);
gModel = GlobalService.reader.GetString(10);
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
//if (status == "New" || status == "Modify")
// txtDiv.Text = "Modify";
txtDiv.Text = "Modify";
txtType.Text = type;
lblChaseno.Text = chaseno.StartsWith("CM") ? DataChecking.GetLastCnChaseNo() : DataChecking.getLastChaseNo();
txtMouldno.Text = mouldno;
txtItemcode.Text = itemcode;
txtOemasset.Text = oemasset;
txtRemarks.Text = remarks;
txtVendor.Text = vendor;
lblVendorname.Text = DataChecking.getVendorName(vendor);
lblGroup.Text = DataChecking.getVendorGroup(vendor);
lblPurchaser.Text = DataChecking.getVendorPerson(vendor);
lblCurrency.Text = DataChecking.getCurrency(vendor);
cbOwner.SelectedItem = owner;
try
{
cbGroup.Items.Clear();
string singleGroup = DataChecking.getVendorGroup(vendor);
string text = string.Format("select v_remarks from tb_vendor where v_code = '{0}'", vendor);
GlobalService.reader = DataService.GetInstance().ExecuteReader(text);
if (GlobalService.reader.HasRows)
{
while (GlobalService.reader.Read())
{
remarks = GlobalService.reader.GetString(0);
}
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
if (remarks != "")
{
string[] remark = Split(remarks);
foreach (string item in remark)
{
cbGroup.Items.Add(item);
}
}
else
{
cbGroup.Items.Add(singleGroup);
}
cbGroup.SelectedIndex = 0;
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
}
txtMouldCode.Text = mouldcode;
this.loadMouldCode(mouldcode);
}
sendToFile()
{
DataTable pdfTable = new DataTable();
pdfTable.Columns.Add("Chase No.");
pdfTable.Columns.Add("Item Text");
pdfTable.Columns.Add("Item Code");
pdfTable.Columns.Add("Ringi");
pdfTable.Columns.Add("Vendor");
List <int> indexList = new List <int>();
foreach (DataGridViewRow row in dgvRingiItemList.Rows)
{
string isSelected = row.Cells[13].FormattedValue.ToString();
if (isSelected == "True")
{
string chaseno = row.Cells[0].Value.ToString().Trim();
string mouldno = row.Cells[1].Value.ToString();
string rev = row.Cells[3].Value.ToString();
string currency = row.Cells[4].Value.ToString();
string amount = row.Cells[5].Value.ToString();
string amounthkd = row.Cells[6].Value.ToString();
string itemtext = row.Cells[7].Value.ToString();
string itemcode = row.Cells[2].Value.ToString();
string ringi = row.Cells[9].Value.ToString();
string vendor = row.Cells[8].Value.ToString();
string vendorname = DataChecking.getVendorName(vendor);
string resultVendor = vendor + " " + vendorname;
string remarks = row.Cells[12].Value.ToString();
string ringitext = string.Format("update tb_betamould set tm_ringi_code = '{0}', tm_modify = 'Yes', tm_ringiRemarks = '{1}' where tm_chaseno = '{2}'", ringi.Trim(), remarks, chaseno);
DataService.GetInstance().ExecuteNonQuery(ringitext);
string inserttext = string.Format("insert into tb_ringirelations (rr_chaseno, rr_mouldno, rr_itemcode, rr_rev, rr_ringi) values ('{0}', '{1}', '{2}', '{3}', '{4}')", chaseno, mouldno, itemcode, rev, ringi.Trim());
DataService.GetInstance().ExecuteNonQuery(inserttext);
string updatetext = string.Format("update tb_ringi set rg_balance = convert(decimal,rg_balance) - convert(decimal,'{0}') where rg_no = '{1}'", amounthkd, ringi.Trim());
DataService.GetInstance().ExecuteNonQuery(updatetext);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", "Quotation", "-", ringi, AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), chaseno, "Assign Ringi");
DataService.GetInstance().ExecuteNonQuery(logText);
string delText = string.Format("delete from tb_tempringi where tmp_chaseno = '{0}'", chaseno);
DataService.GetInstance().ExecuteNonQuery(delText);
string expenseText = string.Format("update tb_expensetransfer set et_ringino = '{0}' where et_chaseno = '{1}'", ringi.Trim(), chaseno);
DataService.GetInstance().ExecuteNonQuery(expenseText);
pdfTable.Rows.Add(new object[] { chaseno, itemtext, itemcode, ringi, resultVendor });
}
else
{
continue;
}
}
foreach (DataColumn col in pdfTable.Columns)
{
Debug.WriteLine("Column: " + col);
}
foreach (DataRow row in pdfTable.Rows)
{
Debug.WriteLine(row.ItemArray[0].ToString() + row.ItemArray[1].ToString() + row.ItemArray[2].ToString() + row.ItemArray[3].ToString() + row.ItemArray[4].ToString());
}
ExportPdfUtil.ExportFixedAssetCode(pdfTable);
Process.Start("http://km-square.km.local/kmhk-portal/General/BizSys/Lists/Fixed%20Assets%20Acquisition/NewForm.aspx?RootFolder=%2Fkmhk%2Dportal%2FGeneral%2FBizSys%2FLists%2FFixed%20Assets%20Acquisition&ContentTypeId=0x0100779070611ECD5E4AB0AE8AF49C2BA323&Source=http%3A%2F%2Fkm%2Dsquare%2Ekm%2Elocal%2Fkmhk%2Dportal%2FGeneral%2FBizSys%2FLists%2FFixed%2520Assets%2520Acquisition%2FApplication%2Easpx");
this.loadData();
}
private void btnSave_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dgvQuotationDetail.Rows)
{
string mouldno = row.Cells[0].Value.ToString();
string itemcode = row.Cells[1].Value.ToString();
string rev = row.Cells[2].Value.ToString();
string model = row.Cells[3].Value.ToString();
string status = row.Cells[4].Value.ToString();
string currency = row.Cells[6].Value.ToString();
string amount = row.Cells[7].Value.ToString();
string mpa = row.Cells[8].FormattedValue.ToString();
string vendor = row.Cells[9].Value.ToString();
string mouldcode = row.Cells[5].Value.ToString();
string oemasset = row.Cells[10].Value.ToString();
string remarks = row.Cells[11].Value.ToString();
//string setmould = row.Cells[11].Value.ToString();
string accountcode = row.Cells[12].Value.ToString();
string costcentre = row.Cells[13].Value.ToString();
string pcs = row.Cells[14].Value.ToString();
string pgroup = cbGroup.SelectedItem.ToString();
string modify = row.Cells[15].FormattedValue.ToString();
string setitemcode = row.Cells[16].Value.ToString();
string vnonly = row.Cells[17].Value.ToString();
string cnvnonly = row.Cells[18].Value.ToString();
string owner = row.Cells[19].Value.ToString().Trim();
string is50 = row.Cells[20].Value.ToString().Trim();
string projecttext = itemcode + "-" + rev;
string request = itemcode + rev;
string chaseno = owner == "KDTCN" ? DataChecking.GetLastCnChaseNo() : DataChecking.getLastChaseNo();
string itemtext = "";
string type = "Single";
if (!string.IsNullOrEmpty(setitemcode) && setitemcode != "" && setitemcode != "N/A")
{
type = "Set";
}
string instockdate50 = "";
if (mpa == "False")
{
itemtext = mouldno + "MP+" + mouldcode + "+" + status;
instockdate50 = "#N/A";
}
else
{
itemtext = mouldno + "MP+" + mouldcode + "+" + status + "*";
instockdate50 = "Yes";
}
string quantity = "";
string qstatus = "";
string category = "A";
decimal calAmount = 0;
string year = DateTime.Today.ToString("yyyy");
string month = DateTime.Today.ToString("MM");
string jpyrate = DataChecking.getJpyRate(year, month);
if (transferMode == "From KDC")
{
calAmount = Convert.ToDecimal(amount) * Convert.ToDecimal(jpyrate);
}
else
{
calAmount = DataChecking.amountWithRate(currency, amount);
}
string amounthkd = calAmount.ToString("#.##");
quantity = Convert.ToDecimal(amounthkd) >= 10000 && mpa == "True" ? "2" : "1";
int piece = Convert.ToInt32(pcs);
calAmount = calAmount / piece;
string po = "";
decimal tax = 0;
if (owner == "KDTCN")
{
qstatus = "U";
amounthkd = "-";
double ta = Convert.ToDouble(amount);
category = ta >= 5000 ? "A" : "K";
tax = Convert.ToDecimal(ta * 0.17);
}
else
{
if (calAmount < 10000)
{
if (calAmount == 0)
{
qstatus = "K";
}
else
{
qstatus = "U";
}
category = "K";
}
else
{
if (mouldcode.StartsWith("8") && mouldcode != "8")
{
qstatus = "U";
category = "K";
}
else if (oemasset != "")
{
qstatus = "U";
category = "K";
}
else
{
qstatus = "F";
}
}
if (status == "TM")
{
qstatus = "T";
if (calAmount < 10000)
{
category = "K";
}
else
{
category = "A";
qstatus = "F";
}
po = chaseno.Replace("MS", "TM");
}
}
string common = "Non-Common";
string insertText = "";
if (accountcode == "N/A")
{
accountcode = "";
}
if (costcentre == "N/A")
{
costcentre = "";
}
if ((mpa == "True" || is50 == "Yes") && owner == "KDTCN")
{
//double tmAmount = Convert.ToDouble(amount) / 2;
//double tmTax = Convert.ToDouble(tax) / 2;
if (!itemtext.EndsWith("*"))
{
itemtext = itemtext + "*";
}
insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre, tm_ismodify, tm_instockdate50, tm_pcs, tm_po, tm_vnonly, tm_cnvnonly, tm_is50, tm_tax, tm_checkdate2) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', N'{22}', N'{23}', '{24}', '{25}', '{26}', '{27}', '{28}', '{29}', '{30}', '{31}', '{32}', '{33}', '{34}', '{35}', '{36}')", chaseno, mouldno, itemcode, rev, status, type,
currency, amount, amounthkd, mpa, mouldcode, vendor, qstatus, "1", itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre, modify, instockdate50, pcs, po, vnonly, cnvnonly, is50, tax, pgroup);
DataService.GetInstance().ExecuteNonQuery(insertText);
/*string is50ChaseNo = DataChecking.GetLastCnChaseNo();
*
* string insertText2 = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
* ", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre, tm_ismodify, tm_instockdate50, tm_pcs, tm_po, tm_vnonly, tm_cnvnonly, tm_is50, tm_tax, tm_checkdate2) values" +
* " ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', N'{22}', N'{23}', '{24}', '{25}', '{26}', '{27}', '{28}', '{29}', '{30}', '{31}', '{32}', '{33}', '{34}', '{35}', '{36}')", is50ChaseNo, mouldno, itemcode, rev, status, type,
* currency, tmAmount, amounthkd, mpa, mouldcode, vendor, qstatus, "1", itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre, modify, instockdate50, pcs, po, vnonly, cnvnonly, is50, tmTax, pgroup);
* DataService.GetInstance().ExecuteNonQuery(insertText2);*/
}
else
{
insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre, tm_ismodify, tm_instockdate50, tm_pcs, tm_po, tm_vnonly, tm_cnvnonly, tm_is50, tm_tax, tm_checkdate2) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', N'{22}', N'{23}', '{24}', '{25}', '{26}', '{27}', '{28}', '{29}', '{30}', '{31}', '{32}', '{33}', '{34}', '{35}', '{36}')", chaseno, mouldno, itemcode, rev, status, type,
currency, amount, amounthkd, mpa, mouldcode, vendor, qstatus, quantity, itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre, modify, instockdate50, pcs, po, vnonly, cnvnonly, is50, tax, pgroup);
DataService.GetInstance().ExecuteNonQuery(insertText);
}
if (!string.IsNullOrEmpty(setitemcode) && setitemcode != "" && setitemcode != "N/A")
{
string setText = string.Format("if not exists (select * from tb_setcommon where sc_itemcode = '{0}' and sc_mouldno = '{1}') begin" +
" insert into tb_setcommon (sc_itemcode, sc_mouldno, sc_oldmouldno, sc_type) values ('{0}', '{1}', '{1}', 'Set') end", setitemcode, mouldno, mouldno);
DataService.GetInstance().ExecuteNonQuery(setText);
}
if (oemasset != "")
{
string oemcontent = DataChecking.getOemContent(oemasset);
string vendorname = DataChecking.getVendorName(vendor);
string query = String.Format("insert into tb_expensetransfer(et_date, et_asset, et_partno, et_rev, et_mouldno, et_type, et_mouldcode, et_cur, et_amount" +
", et_vendorcode, et_vendor, et_chaseno, et_remarks) values ('{0}', '{1}', '{2}', '{3}'" +
", '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')", DateTime.Today.ToString("yyyy/MM/dd"), oemcontent, itemcode,
rev, mouldno, status, mouldcode, currency, amount, vendor, vendorname, chaseno, remarks);
DataService.GetInstance().ExecuteNonQuery(query);
}
/*if (setmould == "False")
* {
* insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
* ", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre) values" +
* " ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}', '{25}', '{26}', '{27}')", chaseno, mouldno, itemcode, rev, status, type,
* currency, amount, amounthkd, mpa, mouldcode, vendor, qstatus, quantity, itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre);
* DataService.GetInstance().ExecuteNonQuery(insertText);
* }
* else
* {
* insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
* ", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre) values" +
* " ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}', '{25}')", chaseno, mouldno, itemcode, rev, status, "Set",
* currency, amount, amounthkd, mpa, mouldcode, vendor, qstatus, quantity, itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre);
* DataService.GetInstance().ExecuteNonQuery(insertText);
*
* string updateText = string.Format("update tb_betamould set tm_status = 'Set' where tm_mouldno = '{0}'", mouldno);
* DataService.GetInstance().ExecuteNonQuery(updateText);
*
* }*/
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', N'{3}', '{4}', '{5}', '{6}')", "Quotation", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd"), chaseno, "New Item");
DataService.GetInstance().ExecuteNonQuery(logText);
if (transferMode != "From Vendor")
{
string tmchaseno = chaseno.Replace("MS", "TM");
string ownerbefore = cbFromOwner.SelectedItem.ToString();
this.saveTransferHistory(mouldno, itemcode, rev, status, ownerbefore, "KDTHK", vendor, vendor, amount, tmchaseno);
}
}
MessageBox.Show("Record has been saved");
if (formClose != null)
{
formClose(this, new EventArgs());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string sourceChaseNo = lblChaseno.Text;
string mouldno = txtMouldno.Text;
string itemcode = txtItemcode.Text;
string rev = txtRev.Text;
decimal amount = Convert.ToDecimal(txtAmount.Text);
string oemasset = txtOemasset.Text;
string remarks = txtRemarks.Text;
string pcs = txtPcs.Text;
string type = txtType.Text;
//string owner = txtOwner.Text;
string owner = cbOwner.SelectedItem.ToString();
string pgroup = cbGroup.SelectedItem.ToString();
string vendor = txtVendor.Text;
string mouldcode = txtMouldCode.Text;
string model = gModel;
if (rev.Length == 1)
{
rev = "0" + rev;
}
string modify = "";
if (ckbModify.Checked)
{
modify = "True";
}
else
{
modify = "False";
}
bool mpa;
if (ckbMpa.Checked)
{
mpa = true;
}
else
{
mpa = false;
}
if (!DataChecking.isValidVendor(vendor))
{
MessageBox.Show("Invalid vendor code");
return;
}
if (!DataChecking.isValidMouldCode(mouldcode))
{
MessageBox.Show("Invalid mould code");
return;
}
string curr = "";
string year = DateTime.Today.ToString("yyyy");
string month = DateTime.Today.ToString("MM");
string jpyrate = DataChecking.getJpyRate(year, month);
if (lblCurrency.Text.Contains("JPY"))
{
curr = "JPY";
}
else
{
curr = DataChecking.getCurrency(vendor);
}
decimal calAmount = 0;
if (lblCurrency.Text.Contains("JPY"))
{
calAmount = Convert.ToDecimal(amount) * Convert.ToDecimal(jpyrate);
}
else
{
calAmount = DataChecking.amountWithRate(curr, amount.ToString());
}
string itemtext = "";
if (!mpa)
{
itemtext = mouldno + "MP+" + mouldcode + "+Modify";
}
else
{
itemtext = mouldno + "MP+" + mouldcode + "+Modify*";
}
string projecttext = itemcode + "-" + rev;
string request = itemcode + rev;
decimal tmpAmount = amount / Convert.ToInt32(pcs);
//string currency = DataChecking.getCurrency(vendor);
//string common = DataChecking.getCommon(mouldno, itemcode);
string common = DataChecking.getCommonByMouldNo(mouldno);
string quantity = "";
calAmount = calAmount / Convert.ToInt32(pcs);
string amounthkd = calAmount.ToString("#.##");
quantity = Convert.ToDecimal(amounthkd) >= 10000 && mpa ? "2" : "1";
string qstatus = "";
string category = "A";
decimal tax = 0;
string chaseno = sourceChaseNo.StartsWith("CM") ? DataChecking.GetLastCnChaseNo() : DataChecking.getLastChaseNo();
string accountcode = sourceChaseNo.StartsWith("CM") ? "" : "5005020002";
string costcentre = sourceChaseNo.StartsWith("CM") ? "" : "1404000029";
if (sourceChaseNo.StartsWith("CM"))
{
qstatus = "U";
amounthkd = "-";
double ta = Convert.ToDouble(amount);
category = ta >= 5000 ? "A" : "K";
tax = Convert.ToDecimal(ta * 0.17);
}
else
{
if (calAmount < 10000)
{
if (calAmount == 0)
{
qstatus = "K";
}
else
{
qstatus = "U";
}
category = "K";
}
else
{
if (mouldcode.StartsWith("8") && mouldcode != "8")
{
qstatus = "U";
category = "K";
}
else if (oemasset != "")
{
qstatus = "U";
category = "K";
}
else
{
qstatus = "F";
accountcode = "";
costcentre = "";
category = "A";
}
}
}
if (oemasset != "")
{
if (oemasset.Length == 1)
{
oemasset = "0" + oemasset;
}
if (!DataChecking.validOem(oemasset))
{
MessageBox.Show("Invalid OEM");
return;
}
accountcode = DataChecking.getAccountCode(oemasset);
costcentre = DataChecking.getCostCentre(oemasset);
}
//string model = itemcode.Substring(2, 3);
string insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model, tm_group, tm_accountcode, tm_costcentre, tm_ismodify, tm_pcs) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', N'{22}', N'{23}', '{24}', '{25}', '{26}', '{27}', '{28}', '{29}')", chaseno, mouldno, itemcode, rev, "Modify", type,
curr, amount, amounthkd, mpa, mouldcode, vendor, qstatus, quantity, itemtext, projecttext, request, owner, category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model, pgroup, accountcode, costcentre, modify, pcs);
DataService.GetInstance().ExecuteNonQuery(insertText);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', N'{3}', '{4}', '{5}', '{6}')", "Quotation", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), chaseno, "Modify Item");
DataService.GetInstance().ExecuteNonQuery(logText);
MessageBox.Show("Record has been saved");
if (formClose != null)
{
formClose(this, new EventArgs());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
errInput.Clear();
if (string.IsNullOrEmpty(txtNew.Text))
{
errInput.SetError(txtNew, "Please enter the number of items");
return;
}
if (string.IsNullOrEmpty(txtModify.Text))
{
errInput.SetError(txtModify, "Please enter the number of items");
return;
}
int number = Convert.ToInt32(txtNew.Text);
int modifynumber = Convert.ToInt32(txtModify.Text);
string itemcode = txtPartno.Text;
string rev = txtRev.Text;
string vendor = txtVendor.Text;
string mouldno = "";
string oemasset = txtOemAsset.Text;
string remarks = txtRemarks.Text;
string pcs = txtPcs.Text;
string model = "";
string accountcode = "";
string costcentre = "";
if (itemcode.Length == 12 || itemcode.Length == 15)
{
if (string.IsNullOrEmpty(txtModel.Text))
{
MessageBox.Show("Please input Model");
return;
}
model = txtModel.Text;
}
else if (itemcode.Length == 8)
{
model = itemcode.Substring(0, 3);
}
else
{
if (itemcode.StartsWith("1"))
{
model = itemcode.Substring(3, 3);
}
else
{
model = itemcode.Substring(2, 3);
}
}
if (!DataChecking.isValidVendor(vendor))
{
errInput.SetError(txtVendor, "Invalid Vendor Code");
return;
}
if (cbGroup.SelectedItem == null)
{
errInput.SetError(cbGroup, "Please select a group first");
return;
}
if (itemcode.Length != 8 && itemcode.Length != 10 && itemcode.Length != 12 && itemcode.Length != 15)
{
errInput.SetError(txtPartno, "Item Code length must be 8 / 10 / 12 / 15 digits");
return;
}
string owner = rbtnKDTHK.Checked ? "KDTHK" : "KDTCN";
if (oemasset != "")
{
if (oemasset.Length == 1)
{
oemasset = "0" + oemasset;
}
if (!DataChecking.validOem(oemasset))
{
errInput.SetError(txtOemAsset, "Invalid OEM");
return;
}
accountcode = DataChecking.getAccountCode(oemasset);
costcentre = DataChecking.getCostCentre(oemasset);
}
string setitemcode = "N/A";
if (!string.IsNullOrEmpty(txtItemcodeSet.Text))
{
setitemcode = txtItemcodeSet.Text;
}
if (rev.Length == 1)
{
rev = "0" + rev;
}
string fromOwner = "";
if (cbFromOwner.SelectedIndex == 0)
{
fromOwner = "From Vendor";
}
else if (cbFromOwner.SelectedIndex == 1)
{
fromOwner = "From KDC";
}
else if (cbFromOwner.SelectedIndex == 2)
{
fromOwner = "From KDTCN";
}
else if (cbFromOwner.SelectedIndex == 3)
{
fromOwner = "From KDTVN";
}
transferMode = fromOwner;
string currency = "";
string tmpMould = "";
if (fromOwner == "From KDC")
{
currency = "JPY";
}
else
{
currency = DataChecking.getCurrency(vendor);
}
string ismodify = "False";
if (ckbIsModify.Checked)
{
ismodify = "True";
}
string vnonly = cbProductionBase.SelectedIndex == 2 ? "True" : "False";
string cnvnonly = cbProductionBase.SelectedIndex == 1 ? "True" : "False";
if (number != 0)
{
if (!DataChecking.isItemCodeExists2(itemcode))
{
tmpMould = "K" + itemcode + "01";
}
else
{
tmpMould = "K" + itemcode + DataChecking.getLastThree2(itemcode);
}
if (transferMode == "From Vendor")
{
dgvQuotationDetail.Rows.Add(new object[] { tmpMould, itemcode, rev, model, "New", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
else
{
dgvQuotationDetail.Rows.Add(new object[] { tmpMould, itemcode, rev, model, "TM", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
if (number > 1)
{
for (int i = 1; i < number; i++)
{
int rowindex = dgvQuotationDetail.Rows.Count - 1;
string rowMould = dgvQuotationDetail.Rows[rowindex].Cells[0].Value.ToString();
int mId = Convert.ToInt32(rowMould.Substring(rowMould.Length - 2));
int cMid = mId + 1;
string result = cMid.ToString("00");
mouldno = "K" + itemcode + result;
if (transferMode == "From Vendor")
{
dgvQuotationDetail.Rows.Add(new object[] { mouldno, itemcode, rev, model, "New", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
else
{
dgvQuotationDetail.Rows.Add(new object[] { mouldno, itemcode, rev, model, "TM", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
}
}
if (modifynumber != 0)
{
if (!DataChecking.isItemCodeExists(txtPartno.Text))
{
MessageBox.Show("Item Code: " + txtPartno.Text + " does not exist");
return;
}
if (modifynumber == 1)
{
dgvQuotationDetail.Rows.Add(new object[] { "", itemcode, rev, model, "Modify", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
else
{
for (int i = 0; i < modifynumber; i++)
{
dgvQuotationDetail.Rows.Add(new object[] { "", itemcode, rev, model, "Modify", "", currency, "0", "False", vendor, oemasset, remarks, accountcode, costcentre, pcs, ismodify, setitemcode, vnonly, cnvnonly, owner, "No" });
}
}
}
dgvQuotationDetail.CurrentCell = dgvQuotationDetail.Rows[0].Cells[5];
dgvQuotationDetail.BeginEdit(true);
lblMsg.Text = dgvQuotationDetail.Rows.Count.ToString();
this.btnCheckTotal.Enabled = true;
this.btnValidate.Enabled = true;
}
}
private void btnValidate_Click(object sender, EventArgs e)
{
bool validInput = true;
bool validAmount = true;
bool validMouldCode = true;
bool isSetMould = false;
List <int> indexList = new List <int>();
List <int> setList = new List <int>();
Regex amountEx = new Regex(@"^[0-9]*(\.[0-9]{1,2})?$");
foreach (DataGridViewRow row in dgvQuotationDetail.Rows)
{
row.DefaultCellStyle.BackColor = SystemColors.ControlLightLight;
row.DefaultCellStyle.ForeColor = Color.Black;
string mouldno = row.Cells[0].Value.ToString();
string itemcode = row.Cells[1].Value.ToString();
string rev = row.Cells[2].Value.ToString();
string currency = row.Cells[6].Value.ToString();
string amount = row.Cells[7].Value.ToString();
string mpa = row.Cells[8].FormattedValue.ToString();
string vendor = row.Cells[9].Value.ToString();
string mouldcode = "";
//string setmould = row.Cells[11].FormattedValue.ToString();
string accountcode = row.Cells[12].Value.ToString();
string costcentre = row.Cells[13].Value.ToString();
if (!validPrice(amount))
{
validAmount = false;
indexList.Add(row.Index);
}
if (row.Cells[5].Value == null)
{
mouldcode = "";
}
else
{
mouldcode = row.Cells[5].Value.ToString();
}
if (!DataChecking.isValidMouldCode(mouldcode))
{
validMouldCode = false;
indexList.Add(row.Index);
}
/*if (setmould == "True")
* {
* setList.Add(row.Index);
* isSetMould = true;
* }*/
}
indexList = indexList.Distinct().ToList();
if (!validAmount)
{
MessageBox.Show("Invalid Amount Format found. Please check.");
}
if (!validMouldCode)
{
MessageBox.Show("Invalid Mould Code found. Please check.");
}
for (int i = 0; i < indexList.Count; i++)
{
int rowIndex = indexList[i];
dgvQuotationDetail.Rows[rowIndex].DefaultCellStyle.BackColor = Color.Red;
dgvQuotationDetail.Rows[rowIndex].DefaultCellStyle.ForeColor = Color.White;
}
for (int k = 0; k < setList.Count; k++)
{
int rowIndex = setList[k];
dgvQuotationDetail.Rows[rowIndex].Cells[0].Style.BackColor = Color.Yellow;
dgvQuotationDetail.Rows[rowIndex].Cells[0].Style.ForeColor = Color.Black;
}
if (isSetMould)
{
MessageBox.Show("Please check and make sure the Set Mould No. is correct.");
}
if (validAmount && validMouldCode)
{
validInput = true;
}
else
{
validInput = false;
}
lblMsg.Visible = true;
if (validInput)
{
lblMsg.Text = "PASSED";
lblMsg.ForeColor = Color.Green;
btnSave.Enabled = true;
}
else
{
lblMsg.Text = "WARNING";
lblMsg.ForeColor = Color.Red;
btnSave.Enabled = false;
}
canSave = validInput;
}
private void btnCheck_Click(object sender, EventArgs e)
{
decimal amount = 0;
decimal totalAmount = 0;
decimal usdAmount = 0;
decimal usdTotal = 0;
decimal jpyAmount = 0;
decimal jpyTotal = 0;
decimal rmbAmount = 0;
decimal rmbTotal = 0;
string year = DateTime.Today.ToString("yyyy");
string month = DateTime.Today.ToString("MM");
string jpyrate = DataChecking.getJpyRate(year, month);
bool isAmountOver = false;
List <OverCostData> overList = new List <OverCostData>();
List <QuotationData> quoList = new List <QuotationData>();
foreach (DataGridViewRow row in dgvQuotationDetail.Rows)
{
string partno = row.Cells[1].Value.ToString();
string rev = row.Cells[2].Value.ToString();
string currency = row.Cells[6].Value.ToString();
string camount = row.Cells[7].Value.ToString();
if (currency == "USD")
{
usdAmount = Convert.ToDecimal(row.Cells[7].Value);
usdTotal = usdTotal + usdAmount;
amount = DataChecking.amountWithRate(row.Cells[6].Value.ToString(), row.Cells[7].Value.ToString());
totalAmount = totalAmount + amount;
}
else if (currency == "JPY")
{
jpyAmount = Convert.ToDecimal(row.Cells[7].Value);
jpyTotal = jpyTotal + jpyAmount;
amount = Convert.ToDecimal(row.Cells[7].Value) * Convert.ToDecimal(jpyrate);
totalAmount = totalAmount + amount;
}
else if (currency == "HKD")
{
amount = DataChecking.amountWithRate(row.Cells[6].Value.ToString(), row.Cells[7].Value.ToString());
totalAmount = totalAmount + amount;
}
else if (currency == "RMB")
{
rmbAmount = Convert.ToDecimal(row.Cells[7].Value);
rmbTotal = rmbTotal + rmbAmount;
}
string mouldcode = row.Cells[5].Value.ToString();
string oem = row.Cells[10].Value.ToString();
string pcs = row.Cells[14].Value.ToString();
amount = amount / Convert.ToInt32(pcs);
if (oem != "")
{
row.Cells[12].Value = DataChecking.getAccountCode(oem);
row.Cells[13].Value = DataChecking.getCostCentre(oem);
}
else
{
if (currency != "RMB")
{
if (amount < 10000 || mouldcode.StartsWith("8") && mouldcode != "8")
{
row.Cells[12].Value = "5005020002";
row.Cells[13].Value = "1404000029";
}
}
}
quoList.Add(new QuotationData {
PartNo = partno, Rev = rev, Currency = currency, Amount = Convert.ToDouble(camount)
});
}
var sumList = from l in quoList
group l by new
{
l.PartNo,
l.Rev,
l.Currency,
} into g
select new QuotationData()
{
PartNo = g.Key.PartNo,
Rev = g.Key.Rev,
Currency = g.Key.Currency,
Amount = g.Sum(x => Convert.ToDouble(x.Amount))
};
foreach (var item in sumList)
{
if (IsPriceOverCost(item.PartNo, item.Rev, item.Currency, item.Amount.ToString()))
{
overList.Add(new OverCostData {
PartNo = item.PartNo, Amount = item.Amount.ToString()
});
isAmountOver = true;
}
}
if (isAmountOver)
{
string items = "";
foreach (OverCostData item in overList)
{
items = items + item.PartNo + " Amount: " + item.Amount + "\n";
foreach (DataGridViewRow row in dgvQuotationDetail.Rows)
{
if (row.Cells[1].Value.ToString() == item.PartNo)
{
row.DefaultCellStyle.BackColor = Color.Red;
row.DefaultCellStyle.ForeColor = Color.White;
}
}
}
MessageBox.Show("Below items over cost.\n\n" + items);
}
lblJpy.Text = jpyTotal.ToString("#.##");
lblHkd.Text = totalAmount.ToString("#.##");
lblUsd.Text = usdTotal.ToString("#.##");
lblRmb.Text = rmbTotal.ToString("#.##") + " (" + ((double)rmbTotal * 0.17).ToString("#.##") + ")";
}
private void loadData(int id)
{
try
{
string currentStatus = "";
string mouldcurr = "";
string calFa = "";
string query = string.Format("select tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_amount, tm_itemtext, tm_mpa" +
", tm_oemasset, tm_rm, tm_fixedassetcode, tm_ringi_code, tm_vendor_code, tm_mouldcode_code, tm_st_code, tm_pcs, tm_model, tm_ismodify, tm_currency, tm_category, tm_vnonly, tm_cnvnonly from tb_betamould where tm_id = '{0}'", id);
GlobalService.reader = DataService.GetInstance().ExecuteReader(query);
while (GlobalService.reader.Read())
{
lblChaseno.Text = GlobalService.reader.GetString(0);
txtMouldno.Text = GlobalService.reader.GetString(1);
oMouldno = txtMouldno.Text;
txtItemcode.Text = GlobalService.reader.GetString(2);
oItemCode = txtItemcode.Text;
txtRev.Text = GlobalService.reader.GetString(3);
oRev = txtRev.Text;
cbDiv.SelectedItem = GlobalService.reader.GetString(4);
oStatus = cbDiv.SelectedItem.ToString();
txtAmount.Text = GlobalService.reader.GetString(5);
oAmount = txtAmount.Text;
txtItemText.Text = GlobalService.reader.GetString(6);
oItemText = txtItemText.Text;
string mpa = GlobalService.reader.GetString(7);
if (mpa == "True")
{
ckbMpa.Checked = true;
}
else
{
ckbMpa.Checked = false;
}
oMpa = mpa;
txtOemasset.Text = GlobalService.reader.GetString(8);
oOemAsset = txtOemasset.Text;
txtRemarks.Text = GlobalService.reader.GetString(9);
oRemarks = txtRemarks.Text;
string fa = GlobalService.reader.GetString(10);
calFa = fa;
if (fa == "")
{
lblFa.Text = "N/A";
}
else
{
lblFa.Text = fa;
}
string rin = GlobalService.reader.GetString(11);
if (rin == "")
{
lblRingi.Text = "N/A";
}
else
{
lblRingi.Text = rin;
}
txtVendor.Text = GlobalService.reader.GetString(12);
oVendor = txtVendor.Text;
txtMouldCode.Text = GlobalService.reader.GetString(13);
oMouldCode = txtMouldCode.Text;
currentStatus = GlobalService.reader.GetString(14);
txtPcs.Text = GlobalService.reader.GetString(15);
txtModel.Text = GlobalService.reader.GetString(16);
string ismodify = GlobalService.reader.GetString(17);
mouldcurr = GlobalService.reader.GetString(18);
globalCategory = GlobalService.reader.GetString(19);
string vnonly = GlobalService.reader.GetString(20);
string cnvnonly = GlobalService.reader.GetString(21);
if (vnonly == "True")
{
cbProductionBase.SelectedIndex = 2;
}
else if (cnvnonly == "True")
{
cbProductionBase.SelectedIndex = 1;
}
else
{
cbProductionBase.SelectedIndex = 0;
}
if (ismodify == "True")
{
ckbModify.Checked = true;
}
else
{
ckbModify.Checked = false;
}
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
Debug.WriteLine(currentStatus);
modifyInStock = false;
globalStatus = currentStatus;
if (currentStatus == "Q" || currentStatus == "U" || currentStatus == "F" || currentStatus == "T")
{
this.btnSave.Enabled = true;
pbEdit.Image = Properties.Resources.tick_icon;
}
else if (currentStatus == "P" || currentStatus == "D")
{
if (calFa == "")
{
this.btnSave.Enabled = true;
pbEdit.Image = Properties.Resources.tick_icon;
}
else
{
this.btnSave.Enabled = false;
pbEdit.Image = Properties.Resources.cross_icon;
}
}
else if (currentStatus == "K")
{
foreach (Control control in groupBox1.Controls)
{
control.Enabled = false;
}
modifyInStock = true;
txtRemarks.Enabled = true;
txtModel.Enabled = true;
ckbModify.Enabled = true;
cbGroup.Enabled = true;
lblOem.Enabled = true;
txtOemasset.Enabled = true;
lblIsModify.Enabled = true;
lblModel.Enabled = true;
lblVendorGroup.Enabled = true;
lblRemarks.Enabled = true;
lblVnOnly.Enabled = true;
ckbVn.Enabled = true;
cbProductionBase.Enabled = true;
this.btnSave.Enabled = true;
pbEdit.Image = Properties.Resources.tick_icon;
}
else if (currentStatus == "S")
{
foreach (Control control in groupBox1.Controls)
{
control.Enabled = false;
}
modifyInStock = true;
txtRemarks.Enabled = true;
ckbModify.Enabled = true;
txtModel.Enabled = true;
cbGroup.Enabled = true;
lblOem.Enabled = true;
txtOemasset.Enabled = true;
lblIsModify.Enabled = true;
lblModel.Enabled = true;
lblVendorGroup.Enabled = true;
lblRemarks.Enabled = true;
lblVnOnly.Enabled = true;
ckbVn.Enabled = true;
cbProductionBase.Enabled = true;
this.btnSave.Enabled = true;
pbEdit.Image = Properties.Resources.tick_icon;
}
else
{
this.btnSave.Enabled = false;
pbEdit.Image = Properties.Resources.cross_icon;
}
lblStatus.Text = DataChecking.getCurrentStatus(currentStatus);
lblVendorname.Text = DataChecking.getVendorName(txtVendor.Text);
lblGroup.Text = DataChecking.getVendorGroup(txtVendor.Text);
lblPurchaser.Text = DataChecking.getVendorPerson(txtVendor.Text);
lblCurrency.Text = DataChecking.getCurrency(txtVendor.Text);
if (mouldcurr == "JPY")
{
lblCurrency.Text = lblCurrency.Text + "(Transfer Curr: JPY)";
}
this.loadMouldCode(txtMouldCode.Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
}
try
{
cbGroup.Items.Clear();
string singleGroup = DataChecking.getVendorGroup(txtVendor.Text);
string text = string.Format("select v_remarks from tb_vendor where v_code = '{0}'", txtVendor.Text);
GlobalService.reader = DataService.GetInstance().ExecuteReader(text);
string remarks = "";
if (GlobalService.reader.HasRows)
{
while (GlobalService.reader.Read())
{
remarks = GlobalService.reader.GetString(0);
}
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
if (remarks != "")
{
string[] remark = Split(remarks);
foreach (string item in remark)
{
cbGroup.Items.Add(item);
}
}
else
{
cbGroup.Items.Add(singleGroup);
}
cbGroup.SelectedIndex = 0;
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
}
}
private void RollBack2()
{
string po = txtPO.Text;
if (!IsPOExist(po))
{
MessageBox.Show("PO does not exist.");
return;
}
if (!IsPOInStock(po))
{
MessageBox.Show("PO : " + po + " does not in In-Stock status.");
return;
}
string query = "";
if (rbtnK.Checked)
{
query = string.Format("update tb_betamould set tm_st_code = 'K', tm_instockdate = '#N/A', tm_instockdate50 = case when tm_mpa = 'True' then 'Yes' else '#N/A' end where tm_po = '{0}'", po);
DataService.GetInstance().ExecuteNonQuery(query);
string chaseno = DataChecking.GetChaseNoByPO(po);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", "In Stock", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd"), chaseno, "Roll Back");
DataService.GetInstance().ExecuteNonQuery(logText);
MessageBox.Show("Record has been saved");
}
else if (rbtnPRpass.Checked)
{
query = string.Format("update tb_betamould set tm_st_code = 'PR', tm_instockdate = 'Received', tm_instockdate50 = N'一回合格入庫' where tm_po = '{0}'", po);
DataService.GetInstance().ExecuteNonQuery(query);
string chaseno = DataChecking.GetChaseNoByPO(po);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", "In Stock", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd"), chaseno, "Roll Back");
DataService.GetInstance().ExecuteNonQuery(logText);
MessageBox.Show("Record has been saved");
}
else if (rbtnPRfail.Checked)
{
query = string.Format("update tb_betamould set tm_st_code = 'PR', tm_instockdate = '#N/A', tm_instockdate50 = 'Received' where tm_po = '{0}'", po);
DataService.GetInstance().ExecuteNonQuery(query);
string chaseno = DataChecking.GetChaseNoByPO(po);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", "In Stock", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd"), chaseno, "Roll Back");
DataService.GetInstance().ExecuteNonQuery(logText);
MessageBox.Show("Record has been saved");
}
else if (rbtnHS.Checked)
{
query = string.Format("update tb_betamould set tm_st_code = 'HS', tm_instockdate = '#N/A' where tm_po = '{0}'", po);
DataService.GetInstance().ExecuteNonQuery(query);
string chaseno = DataChecking.GetChaseNoByPO(po);
string logText = string.Format("insert into tb_log (log_module, log_fromvalue, log_tovalue, log_user, log_datetime, log_chaseno, log_message)" +
" values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", "In Stock", "-", "-", AdUtil.getUsername("kmhk.local"), DateTime.Now.ToString("yyyy/MM/dd"), chaseno, "Roll Back");
DataService.GetInstance().ExecuteNonQuery(logText);
MessageBox.Show("Record has been saved");
}
else
{
MessageBox.Show("Please select one of the option");
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string _chaseno = lblChaseno.Text.Trim();
if (_chaseno.StartsWith("CM"))
{
string mouldno = txtMouldno.Text.Trim();
string partno = txtItemcode.Text.Trim();
string rev = txtRev.Text.Trim();
string div = cbDiv.SelectedItem.ToString();
string model = txtModel.Text.Trim();
string amount = txtAmount.Text.Trim();
string itemtext = txtItemText.Text.Trim();
string mpa = ckbMpa.Checked ? "True" : "False";
string remarks = txtRemarks.Text.Trim();
string pcs = txtPcs.Text.Trim();
string vendor = txtVendor.Text.Trim();
string group = cbGroup.SelectedItem.ToString();
string mouldcode = txtMouldCode.Text.Trim();
string quantity = mpa == "True"?"2":"1";
double camount = Convert.ToDouble(amount);
string category = camount >= 5000 ? "A" : "K";
string query = string.Format("update tb_betamould set tm_mouldno = '{0}', tm_itemcode = '{1}', tm_rev = '{2}', tm_status = '{3}', tm_model = '{4}', tm_amount = '{5}'" +
", tm_itemtext = '{6}', tm_mpa = '{7}', tm_rm = N'{8}', tm_pcs = '{9}', tm_vendor_code = '{10}', tm_group = '{11}', tm_mouldcode_code = '{12}', tm_qty = '{13}', tm_category = '{14}'" +
" where tm_chaseno = '{15}'", mouldno, partno, rev, div, model, amount, itemtext, mpa, remarks, pcs, vendor, group, mouldcode, quantity, category, _chaseno);
DataService.GetInstance().ExecuteNonQuery(query);
}
else
{
if (!modifyInStock)
{
string currentStatus = "";
string chaseno = lblChaseno.Text;
string mouldno = txtMouldno.Text;
string itemcode = txtItemcode.Text;
string rev = txtRev.Text;
string status = cbDiv.SelectedItem.ToString();
string amount = txtAmount.Text;
string mpa = "False";
if (ckbMpa.Checked)
{
mpa = "True";
}
string itemtext = "";
string projecttext = itemcode + "-" + rev;
string request = itemcode + rev;
string vendor = txtVendor.Text;
string mouldcode = txtMouldCode.Text;
string category = "";
string quantity = "1";
string currency = "";
string pcs = txtPcs.Text;
string oemasset = txtOemasset.Text;
string remarks = txtRemarks.Text;
string group = cbGroup.SelectedItem.ToString();
string instockdate50 = "";
string ismodify = "";
if (ckbModify.Checked)
{
ismodify = "True";
}
else
{
ismodify = "False";
}
string vnonly = cbProductionBase.SelectedIndex == 2 ? "True" : "False";
string cnvnonly = cbProductionBase.SelectedIndex == 1 ? "True" : "False";
string model = txtModel.Text;
bool validMouldCode = true;
if (mouldcode != "")
{
if (!DataChecking.isValidMouldCode(mouldcode))
{
validMouldCode = false;
}
else
{
if (mpa == "False")
{
itemtext = mouldno + "MP+" + mouldcode + "+" + status;
instockdate50 = "#N/A";
}
else
{
itemtext = mouldno + "MP+" + mouldcode + "+" + status + "*";
instockdate50 = "Yes";
}
}
}
bool validVendor = true;
if (vendor != "")
{
if (!DataChecking.isValidVendor(vendor))
{
validVendor = false;
}
else
{
if (lblCurrency.Text.Contains("JPY"))
{
currency = "JPY";
}
else
{
currency = DataChecking.getCurrency(vendor);
}
}
}
string accountcode = currency == "RMB" ? "" : "5005020002";
string costcentre = currency == "RMB" ? "" : "1404000029";
decimal calAmount = 0;
string year = DateTime.Today.ToString("yyyy");
string month = DateTime.Today.ToString("MM");
string jpyrate = DataChecking.getJpyRate(year, month);
if (lblCurrency.Text.Contains("JPY"))
{
calAmount = Convert.ToDecimal(amount) * Convert.ToDecimal(jpyrate);
}
else
{
calAmount = DataChecking.amountWithRate(currency, amount);
}
string amounthkd = currency == "RMB" ? "-" : calAmount.ToString("#.##");
if (calAmount >= 10000 & mpa == "True")
{
quantity = "2";
}
else
{
quantity = "1";
}
int piece = Convert.ToInt32(pcs);
calAmount = calAmount / piece;
if (!validMouldCode)
{
MessageBox.Show("Invalid Mould Code Found. Please check your data");
return;
}
if (!validVendor)
{
MessageBox.Show("Invalid Vendor Code Found. Please check your data");
return;
}
if (globalStatus != "T")
{
if (calAmount < 10000)
{
if (globalStatus == "K")
{
currentStatus = "K";
}
else if (globalStatus == "S")
{
currentStatus = "S";
}
else
{
if (calAmount == 0)
{
currentStatus = "K";
}
else
{
currentStatus = "U";
}
}
category = "K";
}
else
{
if (globalStatus == "K")
{
currentStatus = "K";
category = globalCategory;
}
else if (globalStatus == "S")
{
currentStatus = "S";
category = globalCategory;
}
else
{
if (mouldcode.StartsWith("8") && mouldcode != "8")
{
currentStatus = "U";
category = "K";
}
else if (oemasset != "")
{
currentStatus = "U";
category = "K";
}
else
{
currentStatus = "F";
accountcode = "";
costcentre = "";
category = "A";
}
}
}
}
else
{
currentStatus = "T";
category = "K";
}
if (oemasset != "")
{
//Debug.WriteLine("OEM: " + oemasset);
if (oemasset.Length == 1)
{
oemasset = "0" + oemasset;
}
if (!DataChecking.validOem(oemasset))
{
MessageBox.Show("Invalid OEM");
return;
}
accountcode = DataChecking.getAccountCode(oemasset);
costcentre = DataChecking.getCostCentre(oemasset);
}
//string amounthkd = DataChecking.amountWithRate(currency, amount).ToString();
string updateText = string.Format("update tb_betamould set tm_mouldno = '{0}', tm_itemcode = '{1}', tm_rev = '{2}'" +
", tm_status = '{3}', tm_currency = '{4}', tm_amount = '{5}', tm_mpa = '{6}', tm_mouldcode_code = '{7}'" +
", tm_vendor_code = '{8}', tm_qty = '{9}', tm_itemtext = '{10}', tm_projecttext = '{11}', tm_request = '{12}'" +
", tm_st_code = '{13}', tm_oemasset = '{14}', tm_rm = N'{15}', tm_modify = 'Yes', tm_amounthkd = '{16}', tm_group = '{17}', tm_accountcode = '{18}', tm_costcentre = '{19}', tm_category = '{20}', tm_ismodify = '{21}', tm_model = '{22}', tm_instockdate50 = '{23}', tm_vnonly = '{24}', tm_cnvnonly = '{25}' where tm_chaseno = '{26}'", mouldno, itemcode, rev, status, currency, amount, mpa, mouldcode,
vendor, quantity, itemtext, projecttext, request, currentStatus, oemasset, remarks, amounthkd, group, accountcode, costcentre, category, ismodify, model, instockdate50, vnonly, cnvnonly, chaseno);
DataService.GetInstance().ExecuteNonQuery(updateText);
this.saveLogRecord();
}
else
{
string ismodify = "";
if (ckbModify.Checked)
{
ismodify = "True";
}
else
{
ismodify = "False";
}
string vnonly = cbProductionBase.SelectedIndex == 2 ? "True" : "False";
string cnvnonly = cbProductionBase.SelectedIndex == 1 ? "True" : "False";
string model = txtModel.Text;
string remarks = txtRemarks.Text;
string chaseno = lblChaseno.Text;
string oemasset = txtOemasset.Text;
string accountcode = "";
string costcentre = "";
if (oemasset != "")
{
//Debug.WriteLine("OEM: " + oemasset);
if (oemasset.Length == 1)
{
oemasset = "0" + oemasset;
}
if (!DataChecking.validOem(oemasset))
{
MessageBox.Show("Invalid OEM");
return;
}
accountcode = DataChecking.getAccountCode(oemasset);
costcentre = DataChecking.getCostCentre(oemasset);
}
string text = string.Format("update tb_betamould set tm_model = '{0}', tm_ismodify = '{1}', tm_rm = '{2}', tm_group = '{3}'" +
", tm_moulditemviewer = 'Yes', tm_vnonly = '{4}', tm_cnvnonly = '{5}', tm_oemasset = '{6}', tm_accountcode = '{7}'" +
", tm_costcentre = '{8}' where tm_chaseno = '{9}'", model, ismodify, remarks, cbGroup.SelectedItem.ToString(), vnonly, cnvnonly, oemasset, accountcode, costcentre, chaseno);
DataService.GetInstance().ExecuteNonQuery(text);
}
MessageBox.Show("Record has been saved");
if (formClose != null)
{
formClose(this, new EventArgs());
}
}
}
private void addToListToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgvDisposal.SelectedRows == null)
{
return;
}
bool isValid = true;
List <string> mouldlist = new List <string>();
List <string> errlist = new List <string>();
foreach (DataGridViewRow row in dgvDisposal.SelectedRows)
{
string mouldno = row.Cells[1].Value.ToString();
if (DataChecking.isMouldInStock(mouldno))
{
mouldlist.Add(mouldno);
}
else
{
errlist.Add(mouldno);
isValid = false;
}
}
/*if (!isValid)
* {
* MessageBox.Show("Some data are not in IN-STOCK status yet. Please check the data before doing the disposal operation");
* return;
* }*/
for (int i = 0; i < mouldlist.Count; i++)
{
string mould = mouldlist[i];
Debug.WriteLine("SEARCH MOULD: " + mould);
string query = string.Format("select t.tm_chaseno from tb_betamould as t, tb_setcommon as sc where t.tm_mouldno = sc.sc_oldmouldno" +
" and sc.sc_mouldno = '{0}'", mould);
GlobalService.reader = DataService.GetInstance().ExecuteReader(query);
if (GlobalService.reader.HasRows)
{
while (GlobalService.reader.Read())
{
string strChaseno = GlobalService.reader.GetString(0);
GlobalService.ChaseNoList.Add(strChaseno);
}
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
string query1 = string.Format("select tm_chaseno from tb_betamould where tm_mouldno = '{0}'", mould);
GlobalService.reader = DataService.GetInstance().ExecuteReader(query1);
while (GlobalService.reader.Read())
{
string chase = GlobalService.reader.GetString(0);
GlobalService.ChaseNoList.Add(chase);
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
}
GlobalService.ChaseNoList = GlobalService.ChaseNoList.Distinct().ToList();
MessageBox.Show("Data added to list");
}
private void btnCheck_Click(object sender, EventArgs e)
{
try
{
updateList = new List <CdReportList>();
this.Cursor = Cursors.WaitCursor;
foreach (DataGridViewRow row in dgvCdReport.Rows)
{
List <string> instockList = new List <string>();
string reportno = row.Cells[1].Value.ToString();
string vendor = row.Cells[3].Value.ToString();
string itemcode = row.Cells[6].Value.ToString();
string rev = row.Cells[7].Value.ToString();
decimal tmpAmountAfter = Convert.ToDecimal(row.Cells[10].Value);
decimal tmpCdTotal = Convert.ToDecimal(row.Cells[12].Value);
decimal total = Convert.ToDecimal(DataChecking.getAmountHkdByItemcodeRev(itemcode, rev));
row.Cells[11].Value = total;
decimal originalTotal = Convert.ToDecimal(DataChecking.getAmountByItemcodeRev(itemcode, rev));
string instockdate = "";
string query = string.Format("select tm_instockdate from tb_betamould where tm_itemcode = '{0}' and tm_rev = '{1}'" +
" and tm_vendor_code = '{2}' and tm_st_code = 'S' group by tm_instockdate", itemcode, rev, vendor);
GlobalService.reader = DataService.GetInstance().ExecuteReader(query);
//DataGridViewComboBoxColumn col = (DataGridViewComboBoxColumn)dgvCdReport.Columns[12];
DataGridViewComboBoxCell comCell = new DataGridViewComboBoxCell();
//comCell = this.dgvCdReport[12, row.Index] as DataGridViewComboBoxCell;
dgvCdReport[13, row.Index] = comCell;
if (GlobalService.reader.HasRows)
{
while (GlobalService.reader.Read())
{
instockdate = GlobalService.reader.GetString(0);
instockList.Add(instockdate);
}
}
else
{
instockList.Add("沒有入庫紀錄");
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
comCell.DataSource = instockList;
comCell.Value = comCell.Items[0];
/*if (col.Items.Count > 0)
* row.Cells[12].Value = instockdate;
* else
* row.Cells[12].Value = "未有入庫紀錄";*/
string cdmonth = "";
if (instockdate != "" && instockdate != "沒有入庫紀錄")
{
cdmonth = Convert.ToDateTime(row.Cells[13].Value).ToString("yyyy.MM");
}
else
{
cdmonth = "#N/A";
}
if (cdmonth != "#N/A")
{
row.Cells[16].ReadOnly = false;
}
row.Cells[14].Value = cdmonth;
//row.Cells[0].Value = total;
row.Cells[12].Value = Convert.ToDecimal(row.Cells[9].Value) - Convert.ToDecimal(total);
Debug.WriteLine("Total: " + total + " Temp Amount: " + tmpAmountAfter);
if (total != tmpAmountAfter)
{
row.DefaultCellStyle.BackColor = Color.LightYellow;
row.Cells[15].Value = tmpAmountAfter + " \u2192 " + total;
}
else
{
row.DefaultCellStyle.BackColor = SystemColors.ControlLightLight;
}
string amountsystem = row.Cells[0].Value.ToString();
updateList.Add(new CdReportList {
ReportNo = reportno, AmountAfter = originalTotal.ToString(), AmountHkdAfter = total.ToString(), Remarks = row.Cells[15].Value.ToString(), InStockDate = instockdate, CdMonth = cdmonth, AmountSystem = amountsystem
});
}
this.Cursor = Cursors.Default;
MessageBox.Show("Checking completed");
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message + ex.StackTrace);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string mainMouldNo = lblMouldNo.Text;
string mainItemCode = lblItemcode.Text;
string mainText = string.Format("if not exists (select * from tb_relationcommon where rc_itemcode = '{1}') begin" +
" insert into tb_relationcommon (rc_oldmouldno, rc_itemcode, rc_newmouldno) values" +
" ('{0}', '{1}', '{2}') end", mainMouldNo, mainItemCode, mainMouldNo);
DataService.GetInstance().ExecuteNonQuery(mainText);
foreach (DataGridViewRow row in dgvResult.Rows)
{
string mouldnocommon = row.Cells[1].Value.ToString();
string itemcode = row.Cells[2].Value.ToString();
string vendor = row.Cells[3].Value.ToString();
string mouldcode = row.Cells[4].Value.ToString();
string newOld = row.Cells[6].Value.ToString();
string oemasset = row.Cells[7].Value.ToString();
string remarks = row.Cells[8].Value.ToString();
string mouldnoold = row.Cells[9].Value.ToString();
string query = string.Format("insert into tb_relationcommon (rc_oldmouldno, rc_itemcode, rc_newmouldno) values " +
" ('{0}', '{1}', '{2}')", mouldnoold, itemcode, mouldnocommon);
DataService.GetInstance().ExecuteNonQuery(query);
string commandText = string.Format("update tb_betamould set tm_common = 'Common', tm_type = 'Common', tm_modify = 'Yes', tm_moulditemviewer = 'Yes' where tm_mouldno = '{0}'", lblMouldNo.Text);
DataService.GetInstance().ExecuteNonQuery(commandText);
if (newOld == "New")
{
string projectText = itemcode + "-01";
string request = itemcode + "01";
string itemText = mouldnoold + "MP+" + mouldcode + "+New";
string currency = DataChecking.getCurrency(vendor);
string group = DataChecking.getVendorGroup(vendor);
string chaseno = DataChecking.getLastChaseNo();
string inserttext = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_currency, tm_amount, tm_amounthkd" +
", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_group) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}')", chaseno, mouldnocommon, itemcode, "01", "New",
currency, "0", "0", "False", mouldcode, vendor, "S", "1", itemText, projectText, request, "KDTHK", "K", DateTime.Today.ToString("yyyy/MM/dd"), "Common", oemasset, remarks, AdUtil.getUsername("kmhk.local"), group);
DataService.GetInstance().ExecuteNonQuery(inserttext);
}
else
{
string updateText = string.Format("update tb_betamould set tm_common = 'Common', tm_modify = 'Yes', tm_moulditemviewer = 'Yes' where tm_mouldno = '{0}' and tm_itemcode = '{1}'", mouldnoold, itemcode);
DataService.GetInstance().ExecuteNonQuery(updateText);
}
}
MessageBox.Show("Record has been saved");
if (formClose != null)
{
formClose(this, new EventArgs());
}
}
private void modify()
{
//table.Rows.Add();
int lastId = 0;
string text = "select top 1 tm_id from tb_betamould order by tm_id desc";
GlobalService.reader = DataService.GetInstance().ExecuteReader(text);
while (GlobalService.reader.Read())
{
lastId = GlobalService.reader.GetInt32(0);
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
lastId = lastId + 1;
string strChaseNo = DataChecking.getLastChaseNo();
string itemcode = dgvQuotation.SelectedRows[0].Cells[6].Value.ToString();
string rev = (Convert.ToInt32(DataChecking.getLastRev(itemcode)) + 1).ToString();
if (Convert.ToInt32(rev) < 10)
{
rev = "0" + rev;
}
string mouldno = dgvQuotation.SelectedRows[0].Cells[8].Value.ToString();
string status = "Modify";
string type = dgvQuotation.SelectedRows[0].Cells[10].Value.ToString();
string currency = DataChecking.getCurrency(dgvQuotation.SelectedRows[0].Cells[3].Value.ToString());
string amount = dgvQuotation.SelectedRows[0].Cells[13].Value.ToString();
string mpa = dgvQuotation.SelectedRows[0].Cells[15].FormattedValue.ToString();
string vendor = dgvQuotation.SelectedRows[0].Cells[3].Value.ToString();
string vendorname = dgvQuotation.SelectedRows[0].Cells[4].Value.ToString();
string mouldcode = dgvQuotation.SelectedRows[0].Cells[11].Value.ToString();
string qstatus = "";
//string owner = dgvQuotation.SelectedRows[0].Cells[13].Value.ToString();
string oemasset = dgvQuotation.SelectedRows[0].Cells[18].Value.ToString();
string remarks = dgvQuotation.SelectedRows[0].Cells[19].Value.ToString();
string category = "";
string commonstatus = dgvQuotation.SelectedRows[0].Cells[20].Value.ToString();
string purchasegroup = dgvQuotation.SelectedRows[0].Cells[5].Value.ToString();
if (DataChecking.amountWithRate(currency, amount) < 10000)
{
category = "K";
if (vendor != "" && mouldcode != "" && mouldno != "" && itemcode != "" && rev != "" && amount != "")
{
qstatus = "U";
}
else
{
qstatus = "Q";
}
}
else
{
category = "A";
if (vendor != "" && mouldcode != "" && mouldno != "" && itemcode != "" && rev != "" && amount != "" && oemasset == "")
{
qstatus = "F";
}
else if (vendor != "" && mouldcode != "" && mouldno != "" && itemcode != "" && rev != "" && amount != "" && oemasset != "")
{
qstatus = "U";
category = "K";
}
else
{
qstatus = "Q";
}
}
string amounthkd = DataChecking.amountWithRate(currency, amount).ToString("#.##");
string kdcstatus = DataChecking.getKdcStatus(qstatus);
string currentstatus = DataChecking.getCurrentStatus(qstatus);
string createdperson = AdUtil.getUsername("kmhk.local");
string createddatetime = DateTime.Today.ToString("yyyy/MM/dd");
string accountcode = "";
string costcentre = "";
if (oemasset != "")
{
accountcode = DataChecking.getAccountCode(oemasset);
costcentre = DataChecking.getCostCentre(oemasset);
}
else
{
}
table.Rows.Add(new object[] { lastId, currentstatus, strChaseNo, vendor, vendorname, purchasegroup, itemcode, rev, mouldno,
status, type, mouldcode, currency, amount, amounthkd, mpa, qstatus, kdcstatus, oemasset, remarks, commonstatus, createdperson, createddatetime });
string itemtext = mouldno + "MP+" + mouldcode + "+" + status;
string projecttext = itemcode + "-" + rev;
string request = itemcode + rev;
string quantity = "";
if (mpa == "True")
{
quantity = "2";
}
else
{
quantity = "1";
}
string model = itemcode.Substring(2, 3);
string common = DataChecking.getCommon(mouldno, itemcode);
string insertText = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency, tm_amount, tm_amounthkd" +
", tm_mpa, tm_mouldcode_code, tm_vendor_code, tm_st_code, tm_qty, tm_itemtext, tm_projecttext, tm_request, tm_owner, tm_category, tm_indate, tm_common, tm_oemasset, tm_rm, tm_createdby, tm_model) values" +
" ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}')", strChaseNo, mouldno, itemcode, rev, status, type,
currency, amount, amounthkd, mpa, mouldcode, vendor, qstatus, quantity, itemtext, projecttext, request, "KDTHK", category, DateTime.Today.ToString("yyyy/MM/dd"), common, oemasset, remarks, AdUtil.getUsername("kmhk.local"), model);
DataService.GetInstance().ExecuteNonQuery(insertText);
lblTotal.Text = "ROWS COUNT: " + dgvQuotation.Rows.Count;
}
private void transferWithoutFee(List <TransferNoFeeList> list)
{
if (list.Count != 0)
{
for (int i = 0; i < list.Count; i++)
{
string listChaseno = list[i].ChaseNo;
string listMouldno = list[i].MouldNo;
string listItemcode = list[i].ItemCode;
string query = string.Format("select tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_mpa, tm_fixedassetcode, tm_tmpfixedassetcode" +
", tm_qty, tm_common, tm_request, tm_projecttext, tm_category, tm_mouldcode_code, tm_owner, tm_vendor_code, tm_pcs" +
" from tb_betamould where tm_chaseno = '{0}'", listChaseno);
string mouldno = "", itemcode = "", rev = "", status = "", type = "", currency = "", mpa = "";
string fac = "", tmpfac = "", qty = "", common = "", request = "", indate = DateTime.Today.ToString("yyyy/MM/dd");
string projecttext = "", category = "", vendor = "", mouldcode = "", owner = "", fromVendor = "", pcs = "";
GlobalService.reader = DataService.GetInstance().ExecuteReader(query);
while (GlobalService.reader.Read())
{
mouldno = GlobalService.reader.GetString(0);
itemcode = GlobalService.reader.GetString(1);
rev = GlobalService.reader.GetString(2);
status = GlobalService.reader.GetString(3);
type = GlobalService.reader.GetString(4);
mpa = GlobalService.reader.GetString(5);
fac = GlobalService.reader.GetString(6);
tmpfac = GlobalService.reader.GetString(7);
qty = GlobalService.reader.GetString(8);
common = GlobalService.reader.GetString(9);
request = GlobalService.reader.GetString(10);
projecttext = GlobalService.reader.GetString(11);
category = GlobalService.reader.GetString(12);
mouldcode = GlobalService.reader.GetString(13);
owner = GlobalService.reader.GetString(14);
fromVendor = GlobalService.reader.GetString(15);
pcs = GlobalService.reader.GetString(16);
}
GlobalService.reader.Close();
GlobalService.reader.Dispose();
string tStatus = "";
if (status == "New")
{
tStatus = "TM";
}
else
{
tStatus = "TM+Modify";
}
string itemtext = mouldno + "MP+" + mouldcode + "+" + tStatus;
string chaseno = DataChecking.getLastChaseNo();
string tmpPo = chaseno.Replace("MS", "TM");
string transferChaseNo = DataChecking.getLastTransferNo();
vendor = txtVendorAfter.Text;
currency = DataChecking.getCurrency(vendor);
string text = string.Format("insert into tb_betamould (tm_chaseno, tm_mouldno, tm_itemcode, tm_rev, tm_status, tm_type, tm_currency" +
", tm_amount, tm_amounthkd, tm_mpa, tm_fixedassetcode, tm_tmpfixedassetcode, tm_common, tm_itemtext, tm_request, tm_indate" +
", tm_projecttext, tm_po, tm_category, tm_vendor_code, tm_mouldcode_code, tm_st_code, tm_transfer, tm_owner, tm_qty" +
", tm_createdby) values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}', '{25}'",
chaseno, mouldno, itemcode, rev, tStatus, type, currency, "0", "0", mpa, fac, tmpfac, common, itemtext, request, indate, projecttext, tmpPo,
category, vendor, mouldcode, "P", transferChaseNo, owner, qty, AdUtil.getUsername("kmhk.local"));
DataService.GetInstance().ExecuteNonQuery(text);
}
}
}
