private void CheckStatus(string chaseno) { List <string> list = new List <string>(); string q1 = string.Format("select f_mpa from TB_FA_APPROVAL where f_chaseno = '{0}'", chaseno); using (IDataReader reader = DataService.GetInstance().ExecuteReader(q1)) { while (reader.Read()) { list.Add(reader.GetString(0)); } } if (list.Count == 1) { string st = IsTransfer(chaseno) ? "T" : "U"; string query = string.Format("update tb_betamould set tm_st_code = '{0}' where tm_chaseno = '{1}'", st, chaseno.Trim()); DataServiceMould.GetInstance().ExecuteNonQuery(query); } else { if (IsNormalInput(chaseno) && IsTempInput(chaseno)) { string query = string.Format("update tb_betamould set tm_st_code = 'U' where tm_chaseno = '{0}'", chaseno); DataServiceMould.GetInstance().ExecuteNonQuery(query); } } }
private bool IsTransfer(string chaseno) { string query = string.Format("select tm_status from tb_betamould where tm_chaseno = '{0}'", chaseno); string result = DataServiceMould.GetInstance().ExecuteScalar(query).ToString().Trim(); if (result == "TM") { return(true); } return(false); }
private void tsbtnSave_Click(object sender, EventArgs e) { dgvRingi.EndEdit(); int count = 0; foreach (DataGridViewRow row in dgvRingi.Rows) { string approval = row.Cells[0].Value.ToString(); string ringi = row.Cells[3].Value.ToString(); decimal amount = Convert.ToDecimal(row.Cells[7].Value); string type = row.Cells[8].Value.ToString(); string chaseno = row.Cells[9].Value.ToString(); string id = row.Cells[10].Value.ToString(); if (approval != "Approve") { continue; } string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string assetClass = type == "Mould" ? "Z1600" : type == "Jigs" ? "Z1710" : ""; string query = string.Format("update TB_FA_APPROVAL set f_ringi1stapp = 'Approve', f_ringi1st = N'{0}', f_ringi1stdate = '{1}', f_status = 'Asset Class Input', f_assetclass = '{2}' where f_id = '{3}'", GlobalService.Owner, now, assetClass, id); DataService.GetInstance().ExecuteNonQuery(query); //string text = string.Format("update TB_MASTER_RINGI set mr_balance = cast(mr_balance as decimal(10, 2)) - {0} where mr_no = '{1}'", amount, ringi); //DataService.GetInstance().ExecuteNonQuery(text); string text = string.Format("update tb_ringi set rg_balance = cast(rg_balance as decimal(10, 2)) - {0} where rg_no = '{1}'", amount, ringi); DataServiceMould.GetInstance().ExecuteNonQuery(text); count += 1; CheckMpa(id); } this.LoadData(""); }
public static void DeleteRecord(string chaseno) { string ringi = ""; string amount = ""; string text = string.Format("select tm_ringi_code, tm_amounthkd from tb_betamould where tm_chaseno = '{0}'", chaseno); using (IDataReader reader = DataServiceMould.GetInstance().ExecuteReader(text)) { while (reader.Read()) { ringi = reader.GetString(0); amount = reader.GetString(1); } } RestoreRingi(ringi, Convert.ToDecimal(amount)); string query = string.Format("delete from TB_FA_APPROVAL where f_chaseno = '{0}'", chaseno); DataService.GetInstance().ExecuteNonQuery(query); UpdateMainTable(chaseno); }
private void RejectStatus(string chaseno) { string backText = string.Format("update tb_betamould set tm_st_code = 'F' where tm_chaseno = '{0}'", chaseno); DataServiceMould.GetInstance().ExecuteNonQuery(backText); }
public static void UpdateMainTable(string chaseno) { string query = string.Format("update tb_betamould set tm_ringi_code = '', tm_st_code = 'F', tm_pdfid = '' where tm_chaseno = '{0}'", chaseno); DataServiceMould.GetInstance().ExecuteNonQuery(query); }
public static void RestoreRingi(string ringi, decimal amount) { string query = string.Format("update tb_ringi set rg_balance = cast(rg_balance as decimal(10, 2)) + {0} where rg_no = '{1}'", amount, ringi); DataServiceMould.GetInstance().ExecuteNonQuery(query); }
public static string CollectDate(string chaseno) { string query = string.Format("select tm_collectdate from tb_betamould where tm_chaseno = '{0}'", chaseno); return(DataServiceMould.GetInstance().ExecuteScalar(query).ToString()); }
private void tsbtnSave_Click(object sender, EventArgs e) { dgvApproval.EndEdit(); List <string> list = new List <string>(); foreach (DataGridViewRow row in dgvApproval.Rows) { string approval = row.Cells[0].Value.ToString(); string assetClass = row.Cells[1].Value.ToString(); string fixedAsset = row.Cells[2].Value.ToString(); string chaseno = row.Cells[9].Value.ToString(); string id = row.Cells[10].Value.ToString(); if (approval == "Reject") { list.Add(id); continue; } if (approval != "Approve") { continue; } if (assetClass == "") { continue; } if (fixedAsset == "") { continue; } string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string query = string.Format("update TB_FA_APPROVAL set f_status = 'Finished', f_fixedasset = '{0}'" + ", f_assetclass = '{1}', f_cm3rdapp = '{2}', f_cm3rddate = '{3}' where f_id = '{4}'", fixedAsset, assetClass, "Approve", now, id); DataService.GetInstance().ExecuteNonQuery(query); string mainQuery = ""; if (fixedAsset.StartsWith("4")) { mainQuery = string.Format("update tb_betamould set tm_tmpfixedassetcode = '{0}' where tm_chaseno = '{1}'", fixedAsset, chaseno); } else { mainQuery = string.Format("update tb_betamould set tm_fixedassetcode = '{0}' where tm_chaseno = '{1}'", fixedAsset, chaseno); } DataServiceMould.GetInstance().ExecuteNonQuery(mainQuery); CheckStatus(chaseno); } if (list.Count > 0) { RejectForm form = new RejectForm(list); form.ShowDialog(); } this.LoadData(""); }