private void PrintPreview() { DataGridView dgv = dataGridView1; var JOB_ID = dgv.SelectedCells[0].Value.ToString(); //ปริ้นใบแจ้งซ่อม Report1 = "SELECT DISTINCT NJ.JOBID," + " (select U_NAME from COS_USER WHERE U_ID = PO.U_ID)AS NAME, RTRIM(D.DEPNAME)AS DEPTNAME, " + " NJ.TEL, NJ.OWNER, dbo.dmyCOS_hm(NJ.REQ_DATE) AS REQ_DATE, c2c.NAME AS CT_NAME, CT.CAUSE_NAME, NJ.CARUCODE, " + " NJ.CARUNO, dbo.dmyCOS(NJ.EXPECT_DATE) AS EXPECT_DATE, PLC.PL_ID, PLC.PL_ID_C, (ISNULL(PL_NAME, '')) + '' + ISNULL(PL_BRAND, '') + '' + ISNULL(PL_GEN, '') + '' + ISNULL(PL_DESC_C, '') AS PO_NAME, PO.PO_QTY_REQUIRED, UN.ST_NAME AS ST_NAME, U.U_NAME, FT.FT_NAME, " + " C.[Boss_Technician], C.[Boss_Stock], C.[DeputyDirector], C.[Director], dbo.dmyCOS(SUBSTRING(FIXED_DATE, 1, 8))AS FIXED_DATE, " + " dbo.dmyCOS(SUBSTRING(PO_ASSIGN_DATE, 1, 8))AS PO_ASSIGN_DATE, dbo.dmyCOS(SUBSTRING(PO_ASSIGN_DATE_SOTCK, 1, 8))AS PO_ASSIGN_DATE_SOTCK,NJ.MOTIVE,NJ.FIXED_DETAIL,FIXED_DETAIL,(SELECT dbo.dmyCOS(GETDATE()))AS DATE" + " 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 COS_LEVEL_TYPE ON NJ.JOB_WANT_ID = COS_LEVEL_TYPE.LEVEL_ID" + " LEFT JOIN COS_FIXED_TYPE ON NJ.FIX_TYPE_ID = COS_FIXED_TYPE.FT_ID" + " LEFT JOIN COS_USER U ON NJ.USER_ID = U.U_ID" + " LEFT JOIN COS_PART_ORDER PO ON PO.JOB_ID = NJ.JOBID" + " LEFT JOIN COS_FIXED_TYPE FT ON FT.FT_ID = NJ.FIX_TYPE_ID" + " LEFT JOIN COS_PART_LIST_C PLC ON PLC.PL_ID = PO.PL_ID AND PLC.PL_ID_C = PO.PL_ID_C" + " LEFT JOIN COS_PART_LIST PL ON PL.PL_ID = PO.PL_ID " + " LEFT JOIN COS_UNIT UN ON UN.ST_UNIT = PL.PL_UNIT" + " CROSS JOIN COS_COS C" + " where NJ.JOBID = '" + JOB_ID + "'"; CARUCODE = dgv.SelectedCells[3].Value.ToString(); CARUNO = dgv.SelectedCells[4].Value.ToString(); fmReport1 f = new fmReport1(Report1, CARUCODE, CARUNO); f.Dock = DockStyle.Fill; f.ShowDialog(); }
private void PrintPreview(string _Report, string _Carucode, string _caruno) { try { if (dgvAssignmentsBoss.SelectedRows.Count > 1) { } if (tabControl1.SelectedIndex == 0) { var sql = "update COS_JOB set STATUS_FIX_ID=@STATUS_FIX_ID,BOSS_DATE=@BOSS_DATE" + " where JOB_ID = '" + JOB_ID + "'"; SqlParameterCollection param = new SqlCommand().Parameters; param.AddWithValue("@STATUS_FIX_ID", SqlDbType.Int).Value = sf._รอพัสดุรับรายการสั่งซื้อ; param.AddWithValue("@BOSS_DATE", SqlDbType.VarChar).Value = User.GETymd_time(); //int i = new DBClass().SqlExecute(sql, param); } fmReport1 f = new fmReport1(_Report, _Carucode, _caruno); f.Dock = DockStyle.Fill; f.ShowDialog(); } catch (Exception ex) { //ถ้างานผิดพลาดให้สั่งปริ้นใหม่ //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 = 2; //param.AddWithValue("@U_ID", SqlDbType.Int).Value = null; //param.AddWithValue("@EXPECT_DATE", SqlDbType.VarChar).Value = null; //param.AddWithValue("@PO_ASSIGN_DATE_SOTCK", SqlDbType.VarChar).Value = null; //int i = new DBClass().SqlExecute(sql, param); MessageBox.Show("ผิดพลาด " + ex.Message + "กรุณาปริ้น JOB " + JOB_ID + "ใหม่อีกที!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }