private void btnSave_Click(object sender, EventArgs e)
{
if (dgvAssignmentsStock.Rows.Count > 0)
{
var dgv = dgvAssignmentsStock;
var JOB_ID = dgv.SelectedCells[0].Value.ToString();
var FT = dgv.SelectedCells[2].Value.ToString();
string status_fix_id = "";
if ("ซ่อมเองโดยขออนุมัติซื้อพัสดุ" == FT)
{
status_fix_id = sf._ขออนุมัติพัสดุสั่งซื้อ;
}
else if ("ขออนุมัติซื้อทดแทน" == FT)
{
status_fix_id = sf._ขออนุมัติซื้อทดแทน;
}
var getDate = dc.GetDate();
var sql = "UPDATE COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID,SUPPLIES_DATE=@SUPPLIES_DATE"
+ " where JOBID = '" + JOB_ID + "'";
SqlParameterCollection param = new SqlCommand().Parameters;
param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = status_fix_id;
param.AddWithValue("@SUPPLIES_DATE", SqlDbType.VarChar).Value = getDate;
int i = new DBClass().SqlExecute(sql, param);
var sql_PO = "UPDATE COS_PART_ORDER SET SPL_ID=@SPL_ID"
+ " where JOB_ID = '" + JOB_ID + "'";
SqlParameterCollection param_PO = new SqlCommand().Parameters;
param_PO.AddWithValue("@SPL_ID", SqlDbType.Int).Value = 3;
int i2 = new DBClass().SqlExecute(sql_PO, param_PO);
ShowdgvAssignmentsStock();
}
//MessageBox.Show("ผิดพลาด " + ex.Message + "กรุณาปริ้น JOB " + JOB_ID + "ใหม่อีกที!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void btnSave_Click(object sender, EventArgs e)
{
DataGridView dgv = dgvAdminApproveBuyPart;
FIX_TYPE_ID = dgv.SelectedCells[16].Value.ToString();
var JOB_ID = dgv.CurrentRow.Cells[0].Value.ToString();
var Carucode = dgv.SelectedCells[4].Value.ToString();
var Caruno = dgv.SelectedCells[5].Value.ToString();
var Pritername = cbxPrinter.SelectedItem.ToString();
if (dgvAdminApproveBuyPart.SelectedRows.Count < 1)
{
MessageBox.Show("คุณยังไม่ได้เลือกงาน");
return;
}
if (MessageBox.Show("คุณต้องการอนุมัติสั่งซื้อพัสดุใช่หรือไม่", "ทำการยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (FIX_TYPE_ID == uf._ซ่อมเองโดยขออนุมัติซื้อพัสดุ || FIX_TYPE_ID == uf._ขออนุมัติซื้อทดแทน)
{
var status_fix = "";
//ลบข้อมูลเดิมใน Gridview ก่อน
var delete = "DELETE FROM COS_PART_ORDER WHERE JOB_ID=@JOB_ID";
SqlParameterCollection param_delete = new SqlCommand().Parameters;
param_delete.AddWithValue("@JOB_ID", SqlDbType.NVarChar).Value = JOB_ID;
var r = new DBClass().SqlExecute(delete, param_delete);
//บันทึกข้อมูลลงไปทั้งหมด
for (int k = 0; k < dgvStock.Rows.Count; k++)
{
var sql_order = "INSERT INTO COS_PART_ORDER (JOB_ID,PO_ID,PL_ID,PL_ID_C,SPL_ID,PO_QTY_REQUIRED,PO_ASSIGN_DATE)VALUES"
+ "(@JOB_ID,@PO_ID,@PL_ID,@PL_ID_C,@SPL_ID,@PO_QTY_REQUIRED,@PO_ASSIGN_DATE)";
SqlParameterCollection param_order = new SqlCommand().Parameters;
param_order.AddWithValue("@JOB_ID", SqlDbType.VarChar).Value = dgvStock.Rows[k].Cells[0].Value;
param_order.AddWithValue("@PO_ID", SqlDbType.Int).Value = dgvStock.Rows[k].Cells[1].Value;
param_order.AddWithValue("@PL_ID", SqlDbType.Int).Value = dgvStock.Rows[k].Cells[2].Value;
param_order.AddWithValue("@PL_ID_C", SqlDbType.Int).Value = dgvStock.Rows[k].Cells[3].Value;
param_order.AddWithValue("@SPL_ID", SqlDbType.Int).Value = 3;
param_order.AddWithValue("@PO_QTY_REQUIRED", SqlDbType.Int).Value = dgvStock.Rows[k].Cells[5].Value;
param_order.AddWithValue("@PO_ASSIGN_DATE", SqlDbType.VarChar).Value = DateTime.Now.ToString("yyyyMMddHHmm");
int i_ = new DBClass().SqlExecute(sql_order, param_order);
}
if (FIX_TYPE_ID == uf._ซ่อมเองโดยขออนุมัติซื้อพัสดุ)
{
status_fix = sf._รอพัสดุรับรายการสั่งซื้อ;
}
else if (FIX_TYPE_ID == uf._ขออนุมัติซื้อทดแทน)
{
status_fix = sf._รอหัวหน้าหน่วยงานอนุมัติสั่งซื้อทดแทน;
}
var sql_update = "UPDATE COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID,SUB_BOSS_DATE=@SUB_BOSS_DATE where JOBID='" + JOB_ID + "'";
SqlParameterCollection param = new SqlCommand().Parameters;
param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = status_fix;
param.AddWithValue("@SUB_BOSS_DATE", SqlDbType.NVarChar).Value = dc.GetDate();
int i = new DBClass().SqlExecute(sql_update, param);
}
else if (FIX_TYPE_ID == uf._ส่งซ่อมเอกชนในประกัน)
{
var sql_update = "update COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID,SUB_BOSS_DATE=@SUB_BOSS_DATE where JOBID='" + JOB_ID + "'";
SqlParameterCollection param = new SqlCommand().Parameters;
param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = sf._รอหัวหน้าหน่วยงานอนุมัติส่งซ่อมเอกชนในประกัน;
param.AddWithValue("@SUB_BOSS_DATE", SqlDbType.NVarChar).Value = dc.GetDate();
int i = new DBClass().SqlExecute(sql_update, param);
}
else if (FIX_TYPE_ID == uf._ส่งซ่อมเอกชนนอกประกัน)
{
var sql_update = "update COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID,SUB_BOSS_DATE=@SUB_BOSS_DATE where JOBID='" + JOB_ID + "'";
SqlParameterCollection param = new SqlCommand().Parameters;
param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = sf._รอหัวหน้าหน่วยงานอนุมัติส่งซ่อมเอกชนนอกประกัน;
param.AddWithValue("@SUB_BOSS_DATE", SqlDbType.NVarChar).Value = dc.GetDate();
int i = new DBClass().SqlExecute(sql_update, param);
}
MessageBox.Show("บันทึกข้อมูลเสร็จเรียบร้อยแล้ว", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information);
////ปริ้นใบแจ้งซ่อม
if (rdoPreview.Checked == true)
{
PrintPreview(sqlReport(JOB_ID), Carucode, Caruno, JOB_ID);
}
else
{
PrintNoPreview();
}
string sql = "";
if (chk1.Checked == true)
{
sql = "INSERT INTO COS_PRINT([JOB_ID],[Print_date],[Print_user],[Print_doc_type])" +
"VALUES('" + JOB_ID + "','" + dc.GetDate() + "','" + User._U_ID + "','1')";
int i2 = new DBClass().SqlExecute(sql);
}
if (chk2.Checked == true)
{
sql = "INSERT INTO COS_PRINT([JOB_ID],[Print_date],[Print_user],[Print_doc_type])" +
"VALUES('" + JOB_ID + "','" + dc.GetDate() + "','" + User._U_ID + "','2')";
int i2 = new DBClass().SqlExecute(sql);
}
if (chk3.Checked == true)
{
sql = "INSERT INTO COS_PRINT([JOB_ID],[Print_date],[Print_user],[Print_doc_type])" +
"VALUES('" + JOB_ID + "','" + dc.GetDate() + "','" + User._U_ID + "','3')";
int i2 = new DBClass().SqlExecute(sql);
}
ShowAdminApproveBuyPart();
ClearData();
}
}