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