private void button1_Click(object sender, EventArgs e) { if (txtContractor.Text == "") { MessageBox.Show("กรุณาเลือกผู้รับงาน"); return; } String strDate = "วันที่ดำเนินงาน " + dtpBegin.Text + " ถึง " + dtpEnd.Text + ""; GetReport rpt = new GetReport(DataSent(), 3,strDate); rpt.ShowDialog(); }
private void toolStripButton3_Click(object sender, EventArgs e) { if (dgvHead.Rows.Count > 0) { GetReport rpt = new GetReport(DataSent(), 1); rpt.ShowDialog(); } //GetReport rpt = new GetReport(DataSentTest(), 2); //rpt.ShowDialog(); }
/*บันทึกข้อมูลของใบโอนสินค้าส่งไปฝากขายลงในฐานข้อมูล*/ private void InsertValue() { String sql = ""; List<String> ListSql = new List<String>(); sql = "USE KTC select count(ReqId) from REQUIREMENT_HEAD where ReqId = '" + txtReqId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "USE KTC DELETE REQUIREMENT_DETAIL WHERE ReqId = '" + txtReqId.Text + "' "; ListSql.Add(sql); sql = "USE KTC DELETE REQUIREMENT_HEAD WHERE ReqId = '" + txtReqId.Text + "' "; ListSql.Add(sql); } String DateBegin = Class.Function.GetDate(dtpBegin.Value); String DateEnd = Class.Function.GetDate(dtpEnd.Value); String Manager = Class.Function.GetTextId(txtManager.Text); //String Contractor = Class.Function.GetTextId(txtContractor.Text); sql = "USE KTC INSERT INTO REQUIREMENT_HEAD(ReqId,DurationDay,DurationMonth,DateBegin,DateEnd,Manager,Title," + "ApproveId,DateSave,ReqHeadStatusId)" + "VALUES('" + txtReqId.Text + "','" + txtDurationDay.Text + "','" + txtDurationMonth.Text + "','" + DateBegin + "'," + "'" + DateEnd + "','" + Manager + "','" + txtTitle.Text + "','1',GETDATE(),'1')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvPart.Rows) { try { String strPartialId = row.Cells[0].Value.ToString(); String PartDesc = row.Cells[1].Value.ToString(); String PartialDurationDay = row.Cells["durationday"].Value.ToString(); String PartialDurationMonth = row.Cells["durationmonth"].Value.ToString(); String Contractor = Class.Function.GetTextId(row.Cells["ผู้รับงาน"].Value.ToString()); String Note = row.Cells["หมายเหตุ"].Value.ToString(); String PartDateEnd = Class.Function.GetDate(Convert.ToDateTime(row.Cells["กำหนดส่งงาน"].Value)); String PartDateBegin = Class.Function.GetDate(Convert.ToDateTime(row.Cells["วันที่เริ่มงานระบบย่อย"].Value)); String ApproveId = row.Cells["ApprovedId"].Value.ToString(); String RequestStatusId = row.Cells["RequestStatusId"].Value.ToString(); sql = "USE KTC INSERT INTO REQUIREMENT_DETAIL(PartialId,ReqId,PartialDesc,PartialDurationDay,PartialDurationMonth,Note,Contractor,PartDateEnd,ApproveId,PartDateBegin,RequestStatusId)" + "VALUES ('" + strPartialId + "','" + txtReqId.Text + "','" + PartDesc + "','" + PartialDurationDay + "','" + PartialDurationMonth + "','" + Note + "'," + "'" + Contractor + "','" + PartDateEnd + "','" + ApproveId + "','" + PartDateBegin + "','" + RequestStatusId + "')"; ListSql.Add(sql); } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลใบสั่งงานใหม่เลขที่ " + txtReqId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtReqId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { GetReport rpt = new GetReport(DataSent(txtReqId.Text), 1); rpt.ShowDialog(); } } ClearFrom(); } }