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 ShowStock() { string sql_PART_ORDER = "SELECT [JOB_ID],[PC_ID],[PC_NAME],[PC_QTY_REQUIRED],[PC_UNIT] FROM [UHDATA].[dbo].[COS_PART_COM] WHERE JOB_ID='" + JOB_Now + "'"; DataTable dt = new DBClass().SqlGetData(sql_PART_ORDER); var sql = "SELECT MAX(po.PC_ID) FROM COS_JOB as nj join COS_PART_COM as po on po.JOB_ID = nj.JOBID where nj.JOBID = '" + JOB_Now + "'"; PART_ID_MAX = new DBClass().AutoNunber(sql); dgvStock.DataSource = dt; dgvStock.Columns[0].HeaderText = "JOB_ID"; dgvStock.Columns[1].HeaderText = "PC_ID"; dgvStock.Columns[2].HeaderText = "ชื่ออะไหล่"; dgvStock.Columns[3].HeaderText = "จำนวนที่ต้องการ"; dgvStock.Columns[4].HeaderText = "หน่วย"; dgvStock.Columns[0].Width = 130; dgvStock.Columns[1].Width = 60; dgvStock.Columns[2].Width = 150; dgvStock.Columns[3].Width = 80; dgvStock.Columns[4].Width = 80; dgvStock.ClearSelection(); }
private void comboBox1_Click(object sender, EventArgs e) { //if (dgvMain.SelectedRows.Count < 1) //{ // MessageBox.Show("กรุณาเลือก JOB งานก่อนเลือกวิธีซ่อมด้วยครับ!", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error); //} //cbxPART_NAME.DataSource = null; //txtREF_PRICE.Text = ""; //txtTotal.Text = ""; //dgvStock.Rows.Clear(); try { string sql = "select * from COS_COMPANY WHERE HIDE='N' order by [COMPANY_NAME] desc"; var dt = new DBClass().SqlGetData(sql); cbxCOMPANY.DataSource = dt; cbxCOMPANY.DisplayMember = "COMPANY_NAME"; cbxCOMPANY.ValueMember = "ID"; cbxCOMPANY.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show("ผิดพลาดเนื่องจาก" + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnSave_Click(object sender, EventArgs e) { if (dgvAssignmentsWork.SelectedRows.Count == 0) { MessageBox.Show("กรุณาเลือกงาน !", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (cbxRESPONSE_JOB_NAME.Text.Trim() == "") { MessageBox.Show("กรุณาเลือกช่างที่ได้รับมอบหมาย !", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cbxRESPONSE_JOB_NAME.DroppedDown = true; return; } if (cbxJOB_LEVEL.Text.Trim() == "") { MessageBox.Show("กรุณาเลือกระดับความยากของงาน !", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cbxJOB_LEVEL.Focus(); return; } if (Convert.ToDateTime(dtpEXPECT_DATE.Value.ToString("yyyy-MM-dd")) < Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) { MessageBox.Show("วันกำหนดงานเสร็จต้องไม่ใช่อดีต !", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); dtpEXPECT_DATE.Show(); return; } if (cbxJOB_LEVEL.Text == "งานทั่วไป") { LEVEL_ID = 1; } else if (cbxJOB_LEVEL.Text == "งานระดับยาก") { LEVEL_ID = 2; } else { LEVEL_ID = 3; } if (cbxJOB_WANT_ID.Text == "รอได้") { JOB_WANT_ID = 1; } else if (cbxJOB_WANT_ID.Text == "ด่วน") { JOB_WANT_ID = 2; } else { JOB_WANT_ID = 3; } if (MessageBox.Show("คุณต้องการบันทึกวิธีการส่งซ่อมใช่หรือไม่", "ทำการยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var selectedRows = dgvAssignmentsWork.SelectedRows.OfType <DataGridViewRow>().Where(row => !row.IsNewRow).ToArray(); for (int i = 0; i < dgvAssignmentsWork.SelectedRows.Count; i++) { try { var sql_update = "update COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID,USER_ID=@USER_ID,LEVEL_ID=@LEVEL_ID,JOB_WANT_ID=@JOB_WANT_ID,REMARK=@REMARK,ASSIGN_DATE=@ASSIGN_DATE,EXPECT_DATE=@EXPECT_DATE, COMMENT=@COMMENT where JOBID='" + selectedRows[i].Cells[0].Value + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = sf._รอช่างรับงาน; param.AddWithValue("@USER_ID", SqlDbType.Int).Value = cbxRESPONSE_JOB_NAME.SelectedValue; param.AddWithValue("@LEVEL_ID", SqlDbType.Int).Value = LEVEL_ID; param.AddWithValue("@JOB_WANT_ID", SqlDbType.Int).Value = JOB_WANT_ID; param.AddWithValue("@REMARK", SqlDbType.VarChar).Value = txtREMARK.Text; param.AddWithValue("@ASSIGN_DATE", SqlDbType.VarChar).Value = User.GETymd_time(); param.AddWithValue("@EXPECT_DATE", SqlDbType.VarChar).Value = dtpEXPECT_DATE.Value.ToString("yyyyMMdd"); param.AddWithValue("@COMMENT", SqlDbType.VarChar).Value = txtCOMMENT.Text; int i2 = new DBClass().SqlExecute(sql_update, param); } catch (Exception ex) { MessageBox.Show("รับงานไม่ได้เนื่องจาก" + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } MessageBox.Show("บันทึกวิธีส่งซ่อมเสร็จเรียบร้อยแล้ว", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearData(); ShowdgvAssignmentsWork(); } }
private void ShowAdminApproveBuyPart() { //try //{ var sql = "SELECT DISTINCT NJ.JOBID,FT.FT_NAME,RTRIM(MUHDEP.DEPNAME)AS DEPRNAME,c2c.NAME,NJ.CARUCODE,NJ.CARUNO,SPEC," + "CT.CAUSE_NAME,NJ.DESC_, NJ.OWNER, NJ.TEL,dbo.dmy_hm(NJ.REQ_DATE)AS REQ_DATE, dbo.dmy_hm(NJ.ASSIGN_DATE)AS ASSIGN_DATE," + "dbo.dmy(NJ.EXPECT_DATE)AS EXPECT_DATE, COS_LEVEL_TYPE.LEVEL_NAME,NJ.STATUS_FIX_ID,FT_ID " + "FROM COS_JOB NJ " + "LEFT JOIN COS_CAUSE_TYPE CT ON NJ.CAUSE_ID = CT.CAUSE_ID " + "LEFT JOIN MUHDEP ON NJ.DEPT_ID = MUHDEP.DEPCODE " + "LEFT JOIN [CARU2CODE] c2c ON c2c.CARUCODE=NJ.CARUCODE " + "LEFT JOIN [CARU2CARU] c2 ON c2.CARUCODE=NJ.CARUCODE AND c2.CARUNO=NJ.CARUNO " + "LEFT JOIN COS_LEVEL_TYPE ON NJ.JOB_WANT_ID = COS_LEVEL_TYPE.LEVEL_ID " + "LEFT JOIN COS_FIXED_TYPE FT ON NJ.FIX_TYPE_ID = FT.FT_ID " + "LEFT JOIN COS_PART_ORDER PO ON NJ.JOBID = PO.JOB_ID " + "LEFT JOIN COS_STATUS_FIXED SF ON NJ.STATUS_FIX_ID = SF.SF_ID " + "WHERE NO='4' AND NJ.DEPT='" + User._U_DEPT + "'"; // AND NJ.FIXED_DATE IS NOT NULL"; DataTable dt = new DBClass().SqlGetData(sql); var dgv = dgvAdminApproveBuyPart; dgv.DataSource = dt; dgv.Columns[0].HeaderText = "JOB_ID"; dgv.Columns[1].HeaderText = "ประเภทซ่อม"; dgv.Columns[2].HeaderText = "หน่วยงาน"; dgv.Columns[3].HeaderText = "ประเภทครุภัณฑ์"; dgv.Columns[4].HeaderText = "เลขครุภัณฑ์"; dgv.Columns[5].HeaderText = "ตัวย่อ"; dgv.Columns[6].HeaderText = "สเปก"; dgv.Columns[7].HeaderText = "อาการเสีย"; dgv.Columns[8].HeaderText = "คำอธิบาย"; dgv.Columns[9].HeaderText = "ผู้แจ้ง"; dgv.Columns[10].HeaderText = "เบอร์โทร"; dgv.Columns[11].HeaderText = "วันที่แจ้ง"; dgv.Columns[12].HeaderText = "วันกำหนดเสร็จ"; dgv.Columns[13].HeaderText = "ผู้รับผิดชอบ"; dgv.Columns[14].HeaderText = "หมายเหตุประเภทการซ่อม"; dgv.Columns[15].HeaderText = "หมายเหตุประเภทการซ่อม"; dgv.Columns[16].HeaderText = "หมายเหตุประเภทการซ่อม"; dgv.Columns[0].Width = 110; dgv.Columns[1].Width = 170; dgv.Columns[2].Width = 130; dgv.Columns[3].Width = 200; dgv.Columns[4].Width = 95; dgv.Columns[5].Width = 55; dgv.Columns[6].Width = 230; dgv.Columns[7].Width = 230; dgv.Columns[8].Width = 230; dgv.Columns[9].Width = 65; dgv.Columns[10].Width = 108; dgv.Columns[11].Width = 108; dgv.Columns[12].Width = 119; dgv.Columns[13].Width = 114; dgv.Columns[14].Width = 114; dgv.Columns[15].Visible = false; dgv.Columns[16].Visible = false; //} //catch (Exception ex) //{ // MessageBox.Show("ผิดพลาดเนื่องจาก" + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); //} }
private void ShowPrintOld() { if (cbx1.SelectedItem != null && cbx1.SelectedIndex >= 0) { REQ_DATE = "AND dbo.dmy(REQ_DATE) BETWEEN '" + dtp1_1.Value + "' AND '" + dtp1_2.Value + "'"; } else { REQ_DATE = ""; //DEPT = ""; } var sql = "SELECT DISTINCT NJ.JOBID,FT.FT_NAME,RTRIM(MUHDEP.DEPNAME)AS DEPRNAME,c2c.NAME,NJ.CARUCODE,NJ.CARUNO,SPEC," + "CT.CAUSE_NAME,NJ.DESC_, NJ.OWNER, NJ.TEL,dbo.dmy_hm(NJ.REQ_DATE)AS REQ_DATE, dbo.dmy(NJ.EXPECT_DATE)AS EXPECT_DATE, " + " COS_LEVEL_TYPE.LEVEL_NAME, U.U_NAME, NJ.STATUS_FIX_ID, FT_ID " + " FROM COS_JOB NJ " + " LEFT JOIN COS_CAUSE_TYPE CT ON NJ.CAUSE_ID = CT.CAUSE_ID " + " LEFT JOIN MUHDEP ON NJ.DEPT_ID = MUHDEP.DEPCODE " + " LEFT JOIN [CARU2CODE] c2c ON c2c.CARUCODE=NJ.CARUCODE " + " LEFT JOIN [CARU2CARU] c2 ON c2.CARUCODE=NJ.CARUCODE AND c2.CARUNO=NJ.CARUNO " + " LEFT JOIN COS_LEVEL_TYPE ON NJ.JOB_WANT_ID = COS_LEVEL_TYPE.LEVEL_ID " + " LEFT JOIN COS_FIXED_TYPE FT ON NJ.FIX_TYPE_ID = FT.FT_ID " + " LEFT JOIN COS_PART_ORDER PO ON NJ.JOBID = PO.JOB_ID " + " LEFT JOIN COS_STATUS_FIXED SF ON NJ.STATUS_FIX_ID = SF.SF_ID " + " LEFT JOIN COS_USER U ON U.U_ID=NJ.[USER_ID] " + " WHERE NO='5' AND NJ.DEPT='" + User._U_DEPT + "'" + REQ_DATE; // AND NJ.FIXED_DATE IS NOT NULL"; DataTable dt = new DBClass().SqlGetData(sql); var dgv = dgvPrintOld; dgv.DataSource = dt; dgv.Columns[0].HeaderText = "JOB_ID"; dgv.Columns[1].HeaderText = "ประเภทซ่อม"; dgv.Columns[2].HeaderText = "หน่วยงาน"; dgv.Columns[3].HeaderText = "ประเภทครุภัณฑ์"; dgv.Columns[4].HeaderText = "เลขครุภัณฑ์"; dgv.Columns[5].HeaderText = "ตัวย่อ"; dgv.Columns[6].HeaderText = "สเปก"; dgv.Columns[7].HeaderText = "อาการเสีย"; dgv.Columns[8].HeaderText = "คำอธิบาย"; dgv.Columns[9].HeaderText = "ผู้แจ้ง"; dgv.Columns[10].HeaderText = "เบอร์โทร"; dgv.Columns[11].HeaderText = "วันที่แจ้ง"; dgv.Columns[12].HeaderText = "วันกำหนดเสร็จ"; dgv.Columns[13].HeaderText = "ความเร่งด่วน"; dgv.Columns[14].HeaderText = "ช่างผู้รับผิดชอบ"; dgv.Columns[15].HeaderText = ""; dgv.Columns[0].Width = 110; dgv.Columns[1].Width = 170; dgv.Columns[2].Width = 130; dgv.Columns[3].Width = 200; dgv.Columns[4].Width = 95; dgv.Columns[5].Width = 55; dgv.Columns[6].Width = 230; dgv.Columns[7].Width = 230; dgv.Columns[8].Width = 230; dgv.Columns[9].Width = 65; dgv.Columns[10].Width = 108; dgv.Columns[11].Width = 108; dgv.Columns[12].Width = 95; dgv.Columns[13].Width = 80; dgv.Columns[14].Width = 150; dgv.Columns[15].Width = 300; //dgv.Columns[15].Visible = false; //dgv.Columns[16].Visible = false; Dictionary <string, string> test = new Dictionary <string, string>(); var cbx = cbx1; test.Add(dgv.Columns[12].Name, dgv.Columns[12].HeaderText); test.Add(dgv.Columns[3].Name, dgv.Columns[3].HeaderText); test.Add(dgv.Columns[4].Name, dgv.Columns[4].HeaderText); test.Add(dgv.Columns[10].Name, dgv.Columns[10].HeaderText); cbx.DataSource = new BindingSource(test, null); cbx.DisplayMember = "Value"; cbx.ValueMember = "Key"; }
private void PrintNoPreview() { DataGridView dgv; if (tabControl1.SelectedIndex == 0) { dgv = dgvAdminApproveBuyPart; } else { dgv = dgvPrintOld; } var JOB_ID = dgv.SelectedCells[0].Value.ToString(); string carucode = dgv.SelectedCells[4].Value.ToString(); string caruno = dgv.SelectedCells[5].Value.ToString(); Pritername = cbxPrinter.SelectedItem.ToString(); if (tabControl1.SelectedIndex == 0) { var sql = "update COS_PART_ORDER set SPL_ID=@SPL_ID" + " where JOB_ID = '" + JOB_ID + "'"; //var sql = "update COS_PART_ORDER set SPL_ID=@SPL_ID,U_ID=@U_ID,EXPECT_DATE=@EXPECT_DATE,PO_ASSIGN_DATE_SOTCK=@PO_ASSIGN_DATE_SOTCK" // + " where JOB_ID = '" + JOB_ID + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@SPL_ID", SqlDbType.Int).Value = 3; //param.AddWithValue("@U_ID", SqlDbType.Int).Value = cbxU_ID.SelectedValue; //param.AddWithValue("@EXPECT_DATE", SqlDbType.VarChar).Value = dtpEXPECT_DATE.Value.ToString("yyyyMMdd"); //param.AddWithValue("@PO_ASSIGN_DATE_SOTCK", SqlDbType.VarChar).Value = DateTime.Now.ToString("yyyyMMddHHmm"); int i = new DBClass().SqlExecute(sql, param); } var pathReport = Environment.CurrentDirectory + "\\Report\\RpRepairDoc.rpt"; var File = new FileInfo(pathReport); var text = "ติดต่อโปรแกรมเมอร์ 1126"; if (!File.Exists) { MessageBox.Show("ไม่มีไฟล์ใบสั่งซ่อม " + text, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (File.Length == 0) { MessageBox.Show("ไฟล์ใบส่งซ่อมไม่สมบูรณ์ " + text, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var dt = new DBClass().SqlGetData(sqlReport(JOB_ID)); ReportDocument rpt = new ReportDocument(); rpt.Load(pathReport); rpt.SetDataSource(dt); //ประวัติการซ่อม var sqlHisFix = "SELECT HisFix,[DESC_],dbo.dmy([FIXED_DATE])AS [FIXED_DATE],[MOTIVE],[FIXED_DETAIL],U.U_NAME,(SELECT dbo.dmyCOS(GETDATE()))AS DATE" + " FROM COS_JOB NJ" + " INNER JOIN" + " (" + " SELECT COUNT(CARUCODE)AS HisFix, [CARUCODE], [CARUNO]" + " FROM[COS_JOB]" + " WHERE CARUCODE <> '' AND([USER_ID] <> '1' OR[USER_ID] <> '9')" + " AND SEND_DATE IS NOT NULL" + " GROUP BY CARUCODE, CARUNO, [CARUNO]" + " HAVING COUNT([CARUCODE]) > 0 AND COUNT([CARUNO]) > 0" + " )AS F ON NJ.[CARUCODE]= F.[CARUCODE] AND NJ.CARUNO= F.[CARUNO]" + " INNER JOIN COS_USER U WITH (NOLOCK) ON U.U_ID=NJ.[USER_ID]" + " WHERE (NJ.[USER_ID] <> '1' AND NJ.[USER_ID] <> '9')" + " AND NJ.CARUCODE='" + carucode + "' AND NJ.CARUNO= '" + caruno + "'" + " GROUP BY HisFix, [DESC_], [FIXED_DATE], [MOTIVE], [FIXED_DETAIL], U.U_NAME"; //รายละเอียดครุภัณฑ์ var sqlCaru = "SELECT dbo.dmySlash(DATEIN)AS DATEIN,PRICE,CT.BGNAME,CM.METHODNAME,BGYEAR,SPEC,COMPANY" + " FROM CARU2CARU C" + " LEFT JOIN CARU2BGTYPE CT ON CT.BGCODE = C.BGCODE" + " LEFT JOIN CARU2METHOD CM ON CM.METHODCODE = C.METHODCODE" + " WHERE CARUCODE = '" + carucode + "' AND CARUNO = '" + caruno + "'"; var dtHisFix = new DBClass().SqlGetData(sqlHisFix); var dtCaru = new DBClass().SqlGetData(sqlCaru); rpt.Subreports["HisFix"].Database.Tables[0].SetDataSource(dtHisFix); rpt.Subreports["Caru"].Database.Tables[0].SetDataSource(dtCaru); rpt.SetDatabaseLogon("homc", "homc", "192.168.0.5", "UHDATA"); rpt.PrintToPrinter(1, false, 0, 0); //} //catch (Exception ex) //{ // MessageBox.Show("Error " + ex.Message, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); // Error = true; //} }
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(); } }
private void button1_Click(object sender, EventArgs e) { if (JOB_Now == "") { MessageBox.Show("คุณยังไม่ได้เลือกงาน"); return; } for (int k = 0; k < dgvStock.Rows.Count; k++) { var sql = "SELECT [ST_IN] FROM [COS_STOCK] WHERE ST_NAME='" + dgvStock.Rows[k].Cells[2].Value.ToString() + "'"; DataTable dt1 = new DBClass().SqlGetData(sql); var qty = dt1.Rows[0]["ST_IN"].ToString(); if (Convert.ToInt32(dgvStock.Rows[k].Cells[3].Value) < Convert.ToInt32(qty)) { if (dgvStock.Rows.Count - 1 == k) { Console.WriteLine(""); if (MessageBox.Show("คุณต้องการอนุมัติสั่งซื้ออะไหล่ใช่หรือไม่", "ทำการยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //ลบข้อมูลเดิมใน Gridview ก่อน for (int i = 0; i < dgvStock.Rows.Count; i++) { var delete = "delete from COS_PART_COM where JOB_ID=@JOB_ID"; SqlParameterCollection param_delete = new SqlCommand().Parameters; param_delete.AddWithValue("@JOB_ID", SqlDbType.VarChar).Value = JOB_Now; var r = new DBClass().SqlExecute(delete, param_delete); } //บันทึกข้อมูลลงไปทั้งหมด for (int k2 = 0; k2 < dgvStock.Rows.Count; k2++) { var sql_order = "INSERT INTO COS_PART_COM (JOB_ID,PC_ID,SPL_ID,PC_NAME,PC_QTY_REQUIRED,PC_QTY_RECEIVED,PC_UNIT,PC_ASSIGN_DATE)VALUES" + "(@JOB_ID,@PC_ID,@SPL_ID,@PC_NAME,@PC_QTY_REQUIRED,@PC_QTY_RECEIVED,@PC_UNIT,@PC_ASSIGN_DATE)"; SqlParameterCollection param_order = new SqlCommand().Parameters; param_order.AddWithValue("@JOB_ID", SqlDbType.VarChar).Value = dgvStock.Rows[k2].Cells[0].Value; param_order.AddWithValue("@PC_ID", SqlDbType.Int).Value = dgvStock.Rows[k2].Cells[1].Value; param_order.AddWithValue("@SPL_ID", SqlDbType.Int).Value = 2; param_order.AddWithValue("@PC_NAME", SqlDbType.VarChar).Value = dgvStock.Rows[k2].Cells[2].Value; param_order.AddWithValue("@PC_QTY_REQUIRED", SqlDbType.Int).Value = dgvStock.Rows[k2].Cells[3].Value; param_order.AddWithValue("@PC_QTY_RECEIVED", SqlDbType.Int).Value = dgvStock.Rows[k2].Cells[3].Value; param_order.AddWithValue("@PC_UNIT", SqlDbType.VarChar).Value = dgvStock.Rows[k2].Cells[4].Value; param_order.AddWithValue("@PC_ASSIGN_DATE", SqlDbType.VarChar).Value = DateTime.Now.ToString("yyyyMMddHHmm"); int i_order = new DBClass().SqlExecute(sql_order, param_order); } //บันทึกข้อมูลลงไปทั้งหมด for (int k2 = 0; k2 < dgvStock.Rows.Count; k2++) { var sql2 = "SELECT [ST_IN] FROM [COS_STOCK] WHERE ST_NAME='" + dgvStock.Rows[k2].Cells[2].Value.ToString() + "'"; DataTable dt2 = new DBClass().SqlGetData(sql2); var qty2 = dt2.Rows[0]["ST_IN"].ToString(); string sql_update = "update COS_STOCK SET ST_IN=@ST_IN where ST_NAME='" + dgvStock.Rows[k2].Cells[2].Value.ToString() + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@ST_IN", SqlDbType.Int).Value = Convert.ToInt32(qty2) - Convert.ToInt32(dgvStock.Rows[k2].Cells[3].Value); //จำนวนที่ใช้ int i2 = new DBClass().SqlExecute(sql_update, param); } MessageBox.Show("รับงานเสร็จเรียบร้อยแล้ว", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); //ถ้า 6 ทุกตัว ให้อัพเดท STATUS_FIX_ID เป็น 2 อะไหล่ครบ var sql1 = "SELECT SPL_ID FROM COS_PART_COM WHERE(JOB_ID = '" + JOB_Now + "')"; var dt = new DBClass().SqlGetData(sql1); Console.WriteLine("start"); int count = 0; for (int ii = 0; ii < dt.Rows.Count; ii++) { Console.WriteLine(dt.Rows[ii][0]); if ((int)dt.Rows[ii][0] == 2) { count = count + 1; } } if (count == dt.Rows.Count) { Console.WriteLine("บันทึก"); string sql_update = "update COS_JOB SET STATUS_FIX_ID=@STATUS_FIX_ID where JOBID='" + JOB_Now + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = 5; int i2 = new DBClass().SqlExecute(sql_update, param); } } ShowAdminApproveUsePart(); dgvStock.DataSource = null; } } else { //อะไหล่ไม่พอ MessageBox.Show(dgvStock.Rows[k].Cells[2].Value.ToString() + " ยังคงเหลืออีก " + (Convert.ToInt32(dgvStock.Rows[k].Cells[3].Value) - Convert.ToInt32(qty)).ToString(), "จำนวนอะไหล่ในสต๊อกไม่พอ", MessageBoxButtons.OK, MessageBoxIcon.Error); if (dgvStock.Rows.Count - 1 == k) { return; } } } }
public static string GETymd_time() { var dt = new DBClass().SqlGetData("SELECT dbo.GETymd_time()"); return(dt.Rows[0][0].ToString());; }
private void ShowdgvAssignmentsStock() { //try //{ var sql = "SELECT DISTINCT" + " NJ.JOBID,DS.DEPT_NAME,FT.FT_NAME, RTRIM(D.DEPNAME) AS DEPTNAME, C2C.NAME, NJ.CARUCODE, NJ.CARUNO, " + " SPEC, COS_CAUSE_TYPE.CAUSE_NAME, NJ.DESC_, NJ.OWNER, NJ.TEL, " + " dbo.dmy_hm(NJ.REQ_DATE) AS REQ_DATE, dbo.dmy(NJ.BOSS_DATE) AS BOSS_DATE, JWT.JW_NAME, NJ.REMARK" + " FROM COS_JOB NJ LEFT JOIN" + " COS_CAUSE_TYPE ON NJ.CAUSE_ID = COS_CAUSE_TYPE.CAUSE_ID LEFT JOIN" + " MUHDEP D ON NJ.DEPT_ID = D.DEPCODE LEFT JOIN" + " [CARU2CODE] C2C ON NJ.CARUCODE = C2C.CARUCODE LEFT JOIN " + "CARU2CARU c2 on c2.CARUCODE=NJ.CARUCODE AND c2.CARUNO=NJ.CARUNO LEFT JOIN" + " COS_JOB_WENT_TYPE JWT ON NJ.JOB_WANT_ID = JWT.JW_ID LEFT JOIN" + " COS_PART_ORDER ON NJ.JOBID = COS_PART_ORDER.JOB_ID" + " LEFT JOIN COS_USER U ON U.U_ID=COS_PART_ORDER.U_ID" + " LEFT JOIN COS_DEPT_COS DS WITH (NOLOCK)ON DS.DEPT_ID=NJ.DEPT" + " LEFT JOIN COS_FIXED_TYPE FT WITH (NOLOCK) ON FT.FT_ID=NJ.FIX_TYPE_ID" + " WHERE (NJ.STATUS_FIX_ID = " + sf._รอพัสดุรับรายการสั่งซื้อ + " OR NJ.STATUS_FIX_ID = " + sf._ขออนุมัติซื้อทดแทน + ")"; var dt = new DBClass().SqlGetData(sql); var dgv = dgvAssignmentsStock; dgv.DataSource = dt; dgv.Columns[0].HeaderText = "JOB_ID"; dgv.Columns[1].HeaderText = "หน่วยงานซ่อม"; dgv.Columns[2].HeaderText = "ประเภทซ่อม"; dgv.Columns[3].HeaderText = "หน่วยงานส่งซ่อม"; dgv.Columns[4].HeaderText = "ประเภทครุภัณฑ์"; dgv.Columns[5].HeaderText = "เลขครุภัณฑ์"; dgv.Columns[6].HeaderText = "ตัวย่อ"; dgv.Columns[7].HeaderText = "สเปก"; dgv.Columns[8].HeaderText = "อาการเสีย"; dgv.Columns[9].HeaderText = "รายละเอียด"; dgv.Columns[10].HeaderText = "ผู้แจ้งซ่อม"; dgv.Columns[11].HeaderText = "เบอร์โทร"; dgv.Columns[12].HeaderText = "วันที่ส่งซ่อม"; dgv.Columns[13].HeaderText = "ขออนุมัตซื้อ"; dgv.Columns[14].HeaderText = "ความต้องการ"; dgv.Columns[15].HeaderText = "หมายเหตุ"; dgv.Columns[0].Width = 120; dgv.Columns[1].Width = 120; dgv.Columns[2].Width = 160; dgv.Columns[3].Width = 120; dgv.Columns[4].Width = 200; dgv.Columns[5].Width = 130; dgv.Columns[6].Width = 80; dgv.Columns[7].Width = 200; dgv.Columns[8].Width = 150; dgv.Columns[9].Width = 130; dgv.Columns[10].Width = 70; dgv.Columns[11].Width = 50; dgv.Columns[12].Width = 110; dgv.Columns[13].Width = 120; dgv.Columns[14].Width = 70; dgv.Columns[15].Width = 70; //} //catch (Exception ex) //{ // MessageBox.Show("ผิดพลาดเนื่องจาก" + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); //} }
private void ShowReport() { var sql1 = "SELECT DISTINCT NJ.JOBID, RTRIM(D.DEPNAME) AS DEPTNAME, C2C.NAME, U2.U_NAME,NJ.CARUCODE," + " NJ.CARUNO, SPEC, CT.CAUSE_NAME, NJ.DESC_, NJ.OWNER, NJ.TEL, " + " dbo.dmy_hm(NJ.REQ_DATE) AS REQ_DATE, dbo.dmy(NJ.EXPECT_DATE) AS EXPECT_DATE, NJ.PRINT_STATUS,NJ.PRINT_DATE,PO.U_ID,U.U_NAME" + " FROM COS_JOB NJ" + " LEFT JOIN COS_CAUSE_TYPE CT ON NJ.CAUSE_ID = CT.CAUSE_ID" + " LEFT JOIN MUHDEP D ON NJ.DEPT_ID = D.DEPCODE" + " LEFT JOIN [CARU2CODE] C2C ON NJ.CARUCODE = C2C.CARUCODE" + " LEFT JOIN CARU2CARU c2 ON c2.CARUCODE=NJ.CARUCODE AND c2.CARUNO=NJ.CARUNO" + " LEFT JOIN COS_LEVEL_TYPE ON NJ.JOB_WANT_ID = COS_LEVEL_TYPE.LEVEL_ID" + " LEFT JOIN COS_PART_ORDER PO ON NJ.JOBID = PO.JOB_ID" + " LEFT JOIN COS_USER U ON U.U_ID = PO.U_ID" + " LEFT JOIN COS_USER U2 ON U2.U_ID = NJ.USER_ID" + " WHERE(PO.SPL_ID = '2' OR PO.SPL_ID = '3' OR PO.SPL_ID = '4' OR PO.SPL_ID = '5' OR PO.SPL_ID = '6')" + " AND NJ.PRINT_HIDE IS NULL" + " AND(NJ.CARUCODE like '%" + txtCARUCODE.Text + "%' AND NJ.CARUNO like '%" + txtCARUNO.Text + "%')"; var dt = new DBClass().SqlGetData(sql1); dgvPrintReports.DataSource = dt; dgvPrintReports.Columns[0].HeaderText = "JOB_ID"; dgvPrintReports.Columns[1].HeaderText = "หน่วยงาน"; dgvPrintReports.Columns[2].HeaderText = "ประเภท"; dgvPrintReports.Columns[3].HeaderText = "ช่างผู้รับผิดชอบ"; dgvPrintReports.Columns[4].HeaderText = "ครุภัณฑ์"; dgvPrintReports.Columns[5].HeaderText = "ตัวย่อ"; dgvPrintReports.Columns[6].HeaderText = "สเปก"; dgvPrintReports.Columns[7].HeaderText = "อาการ"; dgvPrintReports.Columns[8].HeaderText = "สาเหตุ"; dgvPrintReports.Columns[9].HeaderText = "ผู้แจ้ง"; dgvPrintReports.Columns[10].HeaderText = "เบอร์โทรกลับ"; dgvPrintReports.Columns[11].HeaderText = "วันที่แจ้งซ่อม"; dgvPrintReports.Columns[12].HeaderText = "วันกำหนดเสร็จ"; dgvPrintReports.Columns[13].HeaderText = "ปริ้น"; dgvPrintReports.Columns[14].HeaderText = "วันที่ปริ้น"; dgvPrintReports.Columns[0].Width = 125; dgvPrintReports.Columns[1].Width = 85; dgvPrintReports.Columns[2].Width = 130; dgvPrintReports.Columns[3].Width = 130; dgvPrintReports.Columns[4].Width = 102; dgvPrintReports.Columns[5].Width = 70; dgvPrintReports.Columns[6].Width = 190; dgvPrintReports.Columns[7].Width = 95; dgvPrintReports.Columns[8].Width = 90; dgvPrintReports.Columns[9].Width = 90; dgvPrintReports.Columns[10].Width = 90; dgvPrintReports.Columns[11].Width = 110; dgvPrintReports.Columns[12].Width = 90; dgvPrintReports.Columns[13].Width = 60; dgvPrintReports.Columns[14].Width = 120; if (User._U_ID != "8") { dgvPrintReports.Columns[15].HeaderText = "U_ID"; dgvPrintReports.Columns[16].HeaderText = "พัสดุผู้รับผิดชอบ"; dgvPrintReports.Columns[15].Visible = true; dgvPrintReports.Columns[16].Visible = true; dgvPrintReports.Columns[15].Width = 120; dgvPrintReports.Columns[16].Width = 120; } else { dgvPrintReports.Columns[15].HeaderText = "U_ID"; dgvPrintReports.Columns[16].HeaderText = "พัสดุผู้รับผิดชอบ"; dgvPrintReports.Columns[15].Visible = false; dgvPrintReports.Columns[16].Visible = false; dgvPrintReports.Columns[15].Width = 120; dgvPrintReports.Columns[16].Width = 120; } dgvPrintReports.ClearSelection(); }
private void btnSave_Click(object sender, EventArgs e) { if (User._JOB_Now == null) { MessageBox.Show("คุณยังไม่ได้เลือกงาน"); return; } string sql = "select SUM(TOTAL_STANDARD_PRICE)" + " from COS_PART_USED" + " where JOB_ID = '" + User._JOB_Now + "'"; float TOTAL_STANDARD_PRICE = new DBClass().TOTAL_STANDARD_PRICE(sql); var value = (string)cbxCARU2_COS_FIXED_TYPE.SelectedValue; if (MessageBox.Show("คุณต้องการบันทึกวิธีการส่งซ่อมใช่หรือไม่", "ทำการยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { if (value == "ซ่อมเองโดยไม่ใช้วัสดุ") { if (User._JOB_Now != null && User._PART_ID != null) { AutoDeleteStock(); } FIXED_TYPE = "0"; PART_LIST = ""; COST_PART = TOTAL_STANDARD_PRICE; FIXED_NAME = "ซ่อมเองโดยไม่ใช้วัสดุ"; } else if (value == "ซ่อมเองโดยใช้วัสดุในสต๊อก") { if (dgvStock.DataSource == null) { MessageBox.Show("คุณยังไม่ได้เพิ่มอะไหล์ในการซ่อม"); return; } FIXED_TYPE = "5"; PART_LIST = "1"; COST_PART = TOTAL_STANDARD_PRICE; FIXED_NAME = "ซ่อมเองโดยใช้วัสดุในสต๊อก"; } else if (value == "ซ่อมเองโดยขออนุมัติซื้อวัสดุ") { FIXED_TYPE = "2"; PART_LIST = ""; COST_PART = TOTAL_STANDARD_PRICE; FIXED_NAME = ""; } else if (value == "ขออนุมัติจ้างเอกชน") { FIXED_TYPE = "3"; PART_LIST = ""; COST_PART = TOTAL_STANDARD_PRICE; FIXED_NAME = ""; } else if (value == "ขออนุมัติซื้อทดแทน") { FIXED_TYPE = "4"; PART_LIST = ""; COST_PART = TOTAL_STANDARD_PRICE; FIXED_NAME = ""; } if (value == "ซ่อมเองโดยไม่ใช้วัสดุ" || value == "ซ่อมเองโดยใช้วัสดุในสต๊อก" || value == "ขออนุมัติจ้างเอกชน" || value == "ขออนุมัติซื้อทดแทน") { string sql_update = "update COS_JOBLIST SET STATE=@STATE,PART_LIST=@PART_LIST,FIXED_TYPE=@FIXED_TYPE,FIXED_NAME=@FIXED_NAME,COST_PART=@COST_PART,MOTIVE=@MOTIVE,HOWTOFIXED=@HOWTOFIXED,PSD_SEND_REQ_BUY=@PSD_SEND_REQ_BUY" + " where JOB_ID='" + User._JOB_Now + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@STATE", SqlDbType.Int).Value = "1"; param.AddWithValue("@PART_LIST", SqlDbType.VarChar).Value = PART_LIST; param.AddWithValue("@FIXED_TYPE", SqlDbType.VarChar).Value = FIXED_TYPE; param.AddWithValue("@FIXED_NAME", SqlDbType.VarChar).Value = FIXED_NAME; param.AddWithValue("@COST_PART", SqlDbType.Float).Value = COST_PART; param.AddWithValue("@MOTIVE", SqlDbType.VarChar).Value = txtMOTIVE.Text; param.AddWithValue("@HOWTOFIXED", SqlDbType.VarChar).Value = txtHOWTOFIXED.Text; param.AddWithValue("@PSD_SEND_REQ_BUY", SqlDbType.DateTime).Value = DateTime.Now; int i2 = new DBClass().SqlExecute(sql_update, param); MessageBox.Show("เลือกวิธีส่งซ่อมเสร็จเรียบร้อยแล้ว", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (value == "ซ่อมเองโดยขออนุมัติซื้อวัสดุ") { string sql_PSD = "update COS_JOBLIST SET STATE=@STATE,PART_LIST=@PART_LIST,FIXED_TYPE=@FIXED_TYPE,FIXED_NAME=@FIXED_NAME,COST_PART=@COST_PART,MOTIVE=@MOTIVE,HOWTOFIXED=@HOWTOFIXED" + " where JOB_ID='" + User._JOB_Now + "'"; SqlParameterCollection paramsql_PSD = new SqlCommand().Parameters; paramsql_PSD.AddWithValue("@STATE", SqlDbType.Int).Value = "1"; paramsql_PSD.AddWithValue("@PART_LIST", SqlDbType.VarChar).Value = PART_LIST; paramsql_PSD.AddWithValue("@FIXED_TYPE", SqlDbType.VarChar).Value = FIXED_TYPE; paramsql_PSD.AddWithValue("@FIXED_NAME", SqlDbType.VarChar).Value = FIXED_NAME; paramsql_PSD.AddWithValue("@COST_PART", SqlDbType.Float).Value = COST_PART; paramsql_PSD.AddWithValue("@MOTIVE", SqlDbType.VarChar).Value = txtMOTIVE.Text; paramsql_PSD.AddWithValue("@HOWTOFIXED", SqlDbType.VarChar).Value = txtHOWTOFIXED.Text; int i = new DBClass().SqlExecute(sql_PSD, paramsql_PSD); MessageBox.Show("เลือกวิธีส่งซ่อมเสร็จเรียบร้อยแล้ว", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("รับงานไม่ได้เนื่องจาก" + ex.Message, "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); //DBClass.tr.Rollback(); } finally { User._JOB_Now = ""; ClearHisFix(); } } }
private void Form1_Load(object sender, EventArgs e) { try { var pathReport = dc.pathReport + "RpRepairDoc.rpt"; var File = new FileInfo(pathReport); var text = "ติดต่อโปรแกรมเมอร์ 1126"; if (!File.Exists) { MessageBox.Show("ไม่มีไฟล์ใบสั่งซ่อม " + text, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (File.Length == 0) { MessageBox.Show("ไฟล์ใบส่งซ่อมไม่สมบูรณ์ " + text, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var dt = new DBClass().SqlGetData(sql); ReportDocument rpt = new ReportDocument(); rpt.Load(pathReport); rpt.SetDataSource(dt); //ประวัติการซ่อม var sqlHisFix = "SELECT HisFix,[DESC_],dbo.dmy([FIXED_DATE])AS [FIXED_DATE],[MOTIVE],[FIXED_DETAIL],U.U_NAME,(SELECT dbo.dmyCOS(GETDATE()))AS DATE" + " FROM COS_JOB NJ" + " INNER JOIN" + " (" + " SELECT COUNT(CARUCODE)AS HisFix, [CARUCODE], [CARUNO]" + " FROM[COS_JOB]" + " WHERE CARUCODE <> '' AND([USER_ID] <> '1' OR[USER_ID] <> '9')" + " AND SEND_DATE IS NOT NULL" + " GROUP BY CARUCODE, CARUNO, [CARUNO]" + " HAVING COUNT([CARUCODE]) > 0 AND COUNT([CARUNO]) > 0" + " )AS F ON NJ.[CARUCODE]= F.[CARUCODE] AND NJ.CARUNO= F.[CARUNO]" + " INNER JOIN COS_USER U WITH (NOLOCK) ON U.U_ID=NJ.[USER_ID]" + " WHERE (NJ.[USER_ID] <> '1' AND NJ.[USER_ID] <> '9')" + " AND NJ.CARUCODE='" + carucode + "' AND NJ.CARUNO= '" + caruno + "'" + " GROUP BY HisFix, [DESC_], [FIXED_DATE], [MOTIVE], [FIXED_DETAIL], U.U_NAME"; //รายละเอียดครุภัณฑ์ var sqlCaru = "SELECT dbo.dmySlash(DATEIN)AS DATEIN,PRICE,CT.BGNAME,CM.METHODNAME,BGYEAR,SPEC,COMPANY" + " FROM CARU2CARU C" + " LEFT JOIN CARU2BGTYPE CT ON CT.BGCODE = C.BGCODE" + " LEFT JOIN CARU2METHOD CM ON CM.METHODCODE = C.METHODCODE" + " WHERE CARUCODE = '" + carucode + "' AND CARUNO = '" + caruno + "'"; var dtHisFix = new DBClass().SqlGetData(sqlHisFix); var dtCaru = new DBClass().SqlGetData(sqlCaru); rpt.Subreports["HisFix"].Database.Tables[0].SetDataSource(dtHisFix); rpt.Subreports["Caru"].Database.Tables[0].SetDataSource(dtCaru); rpt.SetDatabaseLogon("homc", "homc", "192.168.0.5", "UHDATA"); crystalReportViewer1.ReportSource = rpt; //crystalReportViewer1.PrintReport(); } catch (Exception ex) { MessageBox.Show("Error " + ex.Message, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }