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