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("");
}
