public void lvLoadUser() { try { string lvSQL = "Select * from Employee "; if (txtSearch.Text != "") { lvSQL += "Where (Employee_ID like '%" + txtSearch.Text + "%' Or Employee_Name like '%" + txtSearch.Text + "%' Or Employee_LName like '%" + txtSearch.Text + "%') "; } DataTable DT = new DataTable(); DT = GsysSQL.fncGetQueryData(lvSQL, DT); int lvNumRow = DT.Rows.Count; sp1.ActiveSheet.RowCount = lvNumRow; for (int i = 0; i < lvNumRow; i++) { string lvID = DT.Rows[i]["Employee_ID"].ToString(); string lvName = DT.Rows[i]["Employee_Name"].ToString() + " " + DT.Rows[i]["Employee_LName"].ToString(); sp1.ActiveSheet.Cells[i, 0].Text = lvID; sp1.ActiveSheet.Cells[i, 1].Text = lvName; } DT.Dispose(); } catch { MessageBox.Show("ไม่สามารถติดต่อ ฐานข้อมูลได้ กรุณาเปิดโปรแกรมใหม่อีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Restart(); } }
private void btnNext5_Click(object sender, EventArgs e) { if (txtUserPay.Text != "") { string lvChk = GsysSQL.fncFindEmpName(txtUserPay.Text); if (lvChk == "") { MessageBox.Show("ไม่พบข้อมูลรหัสนี้ กรุณาตรวจสอบ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserPay.Text = ""; txtUserPay.Focus(); return; } if (txtID.Text == "00021" || txtID.Text == "00022" || txtID.Text == "00023") { tabControl1.SelectedIndex = 7; } else { tabControl1.SelectedIndex = 4; } //txtRemark.Text = ""; txtRemark.Focus(); } else { MessageBox.Show("กรุณาระบุผู้จ่าย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserPay.Text = ""; txtUserPay.Focus(); return; } }
private void btnNext6_Click(object sender, EventArgs e) { string lvUnit = GsysSQL.fncFindItemUnit(txtID.Text); lbDate.Text = txtDate.DateTime.ToString("dd/MM/yyyy"); lbItem.Text = GsysSQL.fncFindItemName(txtID.Text); lbAmount.Text = txtAmount.Text + " " + lvUnit; lbUserResive.Text = GsysSQL.fncFindFullEmpName(txtUserResive.Text); if (pvMode != "IN") { lbUserPay.Text = GsysSQL.fncFindFullEmpName(txtUserPay.Text); } else { lbUserPay.Text = " - "; } if (txtID.Text == "00021" || txtID.Text == "00022" || txtID.Text == "00023") { tabControl1.SelectedIndex = 7; } else { tabControl1.SelectedIndex = 6; } }
private void btnNext2_Click(object sender, EventArgs e) { if (txtID.Text == "") { MessageBox.Show("กรุณาระบุรหัส", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Text = ""; txtID.Focus(); return; } else if (txtName.Text == "") { MessageBox.Show("กรุณาระบุชื่อ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtName.Text = ""; txtName.Focus(); return; } else { string lvChk = GsysSQL.fncFindItemName(txtID.Text); if (lvChk == "") { MessageBox.Show("ไม่พบข้อมูลรหัสนี้ กรุณาตรวจสอบ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Text = ""; txtName.Text = ""; txtID.Focus(); return; } tabControl1.SelectedIndex = 2; txtAmount.Text = ""; txtAmount.Focus(); } }
private void sp2_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) { string lvItemID = sp2.ActiveSheet.Cells[e.Row, 1].Text; if (lvItemID == "00021" || lvItemID == "00022" || lvItemID == "00023") { tabControl1.SelectedIndex = 2; } else { DialogResult dialogResult = MessageBox.Show("ยืนยันการทำรายการ", "แจ้งเตือน", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { string lvPk = sp2.ActiveSheet.Cells[e.Row, 9].Text; //Update ยอด string lvSQL = "Update Inv_Moving set M_Type = 'T' Where M_Pk = '" + lvPk + "' "; string lvResault = GsysSQL.fncExecuteQueryData(lvSQL); string lvItemName = sp2.ActiveSheet.Cells[e.Row, 2].Text; string lvUserName = sp2.ActiveSheet.Cells[e.Row, 4].Text; MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); lvLoadItemBorrow(true); string lvMsg = lvUserName + " ได้นำ " + lvItemName + " มาคืนเรียบร้อยแล้ว "; lineNotify(lvMsg); } else if (dialogResult == DialogResult.No) { return; } } }
private void btnNext4_Click(object sender, EventArgs e) { if (pvMode == "IN") { if (txtUserResive.Text != "") { string lvChk = GsysSQL.fncFindEmpName(txtUserResive.Text); if (lvChk == "") { MessageBox.Show("ไม่พบข้อมูลรหัสนี้ กรุณาตรวจสอบ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Text = ""; txtUserResive.Focus(); return; } tabControl1.SelectedIndex = 4; //txtRemark.Text = ""; txtRemark.Focus(); } else { MessageBox.Show("กรุณาระบุผู้รับ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Text = ""; txtUserResive.Focus(); return; } } else { if (txtUserResive.Text != "") { string lvChk = GsysSQL.fncFindEmpName(txtUserResive.Text); if (lvChk == "") { MessageBox.Show("ไม่พบข้อมูลรหัสนี้ กรุณาตรวจสอบ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Text = ""; txtUserResive.Focus(); return; } tabControl1.SelectedIndex = 5; txtUserPay.Text = ""; txtUserPay.Focus(); btnSearchUser1.PerformClick(); } else { MessageBox.Show("กรุณาระบุผู้รับ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Text = ""; txtUserResive.Focus(); return; } } }
public void LoadAssetData(bool lvShow) { try { this.Cursor = Cursors.WaitCursor; btnIn.Enabled = false; btnOut.Enabled = false; btnBorrow.Enabled = false; btnNoteBook.Enabled = false; string lvSQL = "Select * from Asset Where Asset_ID2 >= '" + txtSearchS.Text + "' And Asset_ID2 <= '" + txtSearchE.Text + "' "; DataTable DT = new DataTable(); DT = GsysSQL.fncGetQueryData(lvSQL, DT); int lvNumRow = DT.Rows.Count; sp3.ActiveSheet.RowCount = lvNumRow; progressBar1.Maximum = lvNumRow; progressBar1.Value = 0; pnStatus.Visible = true; for (int i = 0; i < lvNumRow; i++) { sp3.ActiveSheet.Cells[i, 0].Text = DT.Rows[i]["Asset_ID2"].ToString(); sp3.ActiveSheet.Cells[i, 1].Text = DT.Rows[i]["Asset_Faction"].ToString(); sp3.ActiveSheet.Cells[i, 2].Text = Gstr.fncChangeSDate(DT.Rows[i]["Asset_ResiveDate"].ToString()); sp3.ActiveSheet.Cells[i, 3].Text = DT.Rows[i]["Asset_Name"].ToString(); progressBar1.Value += 1; Application.DoEvents(); } pnStatus.Visible = false; DT.Dispose(); btnIn.Enabled = true; btnOut.Enabled = true; btnBorrow.Enabled = true; btnNoteBook.Enabled = true; if (lvShow) { tabControl1.SelectedIndex = 3; } this.Cursor = Cursors.Default; } catch { Application.Restart(); } }
private void btnAccept_Click(object sender, EventArgs e) { if (this.textBox1.Text == "" || this.textBox2.Text == "" || this.textBox3.Text == "") { MessageBox.Show("โปรดกรอกข้อมูลให้ครบถ้วน"); if (this.textBox1.Text == "") { textBox1.Focus(); } else if (this.textBox2.Text == "") { textBox2.Focus(); } else { textBox3.Focus(); } } else { cmd = new SqlCommand("SELECT * FROM Employee WHERE Employee_ID= '" + this.textBox1.Text + "'", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); int i = ds.Tables[0].Rows.Count; if (i > 0) { MessageBox.Show("มีรหัสพนักงานคนนี้อยู่แล้ว"); ds.Clear(); } else { string lvSQL = "INSERT INTO Employee(Employee_ID, Employee_Name,Employee_LName)" + "VALUES" + "('" + this.textBox1.Text + "', '" + this.textBox2.Text + "', '" + this.textBox3.Text + "')"; string DR = GsysSQL.fncExecuteQueryData(lvSQL); if (DR == "Success") { MessageBox.Show("บันทึกเรียบร้อย"); this.Close(); } else { MessageBox.Show("ผิดพลาด"); } } } }
private void txtID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { string lvName = GsysSQL.fncFindItemName(txtID.Text); if (lvName != "") { txtName.Text = lvName; btnNext2.PerformClick(); } else { MessageBox.Show("ไม่พบข้อมูล กรุณาตรวจสอบ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Text = ""; txtName.Text = ""; txtID.Focus(); return; } } }
private void btnPrintQR_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; //ลบข้อมูล เก่า string lvSQL = "Delete From SysTemp "; //HD string lvResault = GsysSQL.fncExecuteQueryDataAccess(lvSQL); for (int i = 0; i < sp3.ActiveSheet.RowCount; i++) { string lvField1 = sp3.ActiveSheet.Cells[i, 0].Text; string lvField2 = sp3.ActiveSheet.Cells[i, 1].Text; string lvField3 = sp3.ActiveSheet.Cells[i, 2].Text; lvSQL = "Insert into SysTemp (Field1, Field2, Field3) ";// lvSQL += "Values ('" + lvField1 + "', '" + lvField2 + "', '" + lvField3 + "')"; lvResault = GsysSQL.fncExecuteQueryDataAccess(lvSQL); } frmPrint frm = new frmPrint(); this.Cursor = Cursors.Default; frm.ShowDialog(); }
private void btnSave_Click(object sender, EventArgs e) { if (pvMode == "IN") { #region รับเข้า //เช็คข้อมูล if (txtDate.EditValue == "") { MessageBox.Show("กรุณาระบุ วันที่", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtDate.Focus(); return; } else if (txtID.Text == "") { MessageBox.Show("กรุณาระบุ รหัส", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Focus(); return; } else if (Gstr.fncToInt(txtAmount.Text) <= 0) { MessageBox.Show("กรุณาระบุ จำนวน", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtAmount.Focus(); return; } else if (txtUserResive.Text == "") { MessageBox.Show("กรุณาระบุ ผู้รับ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Focus(); return; } string lvType = "R"; string lvDate = Gstr.fncChangeTDate(txtDate.EditValue.ToString()); string lvItemID = Gstr.fncGetDataCode(txtID.Text, ";"); string lvAmount = txtAmount.Text; string lvBal = GsysSQL.fncFindBal(lvItemID); string lvUserResive = txtUserResive.Text; string lvUserPay = ""; string lvRemark = txtRemark.Text; string lvSQL = ""; string lvResault = ""; int lvTotalBal = Gstr.fncToInt(lvBal) + Gstr.fncToInt(lvAmount); if (lvTotalBal < 0) { lvTotalBal = 0; } //Update ยอด lvSQL = "Update SysITEM_Stock set Item_Amount = '" + lvTotalBal + "' Where Item_ID = '" + lvItemID + "' "; lvResault = GsysSQL.fncExecuteQueryData(lvSQL); //Insert เคลื่อนไหว lvSQL = "Insert into Inv_Moving (M_Type, M_Date, M_ItemID, M_AmountR, M_AmountP, M_AmountBal, M_UserResive, M_UserPay, M_Remark) "; lvSQL += "values('" + lvType + "', '" + lvDate + "', '" + lvItemID + "', '" + lvAmount + "', '', '" + lvTotalBal + "', '" + lvUserResive + "', '" + lvUserPay + "', '" + lvRemark + "')"; lvResault = GsysSQL.fncExecuteQueryData(lvSQL); if (lvResault == "Success") { GVar.gvSave = true; MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } #endregion } else if (pvMode == "Borrow") { #region ยืมของ //เช็คข้อมูล if (txtDate.EditValue == "") { MessageBox.Show("กรุณาระบุ วันที่", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtDate.Focus(); return; } else if (txtID.Text == "") { MessageBox.Show("กรุณาระบุ รหัส", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Focus(); return; } else if (Gstr.fncToInt(txtAmount.Text) <= 0) { MessageBox.Show("กรุณาระบุ จำนวน", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtAmount.Focus(); return; } else if (txtUserResive.Text == "") { MessageBox.Show("กรุณาระบุ ผู้ขอเบิก", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Focus(); return; } else if (txtUserPay.Text == "") { MessageBox.Show("กรุณาระบุ ผู้จ่าย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Focus(); return; } string lvType = "B"; string lvDate = Gstr.fncChangeTDate(txtDate.EditValue.ToString()); string lvItemID = Gstr.fncGetDataCode(txtID.Text, ";"); string lvAmount = txtAmount.Text; string lvBal = GsysSQL.fncFindBal(lvItemID); string lvUserResive = Gstr.fncGetDataCode(txtUserResive.Text, ";"); string lvUserPay = Gstr.fncGetDataCode(txtUserPay.Text, ";"); string lvRemark = txtRemark.Text; string lvSQL = ""; string lvResault = ""; int lvTotalBal = Gstr.fncToInt(lvBal) - Gstr.fncToInt(lvAmount); int lvMinStock = Gstr.fncToInt(GsysSQL.fncFindMinStock(lvItemID)); string lvOption = ""; if (ChkMouse.Checked) { lvOption += "Mouse "; } if (ChkMousePad.Checked) { lvOption += "MousePad "; } if (ChkAdapter.Checked) { lvOption += "Adapter "; } if (ChkPointer.Checked) { lvOption += "Pointer "; } if (ChkFlashDrive.Checked) { lvOption += "FlashDrive "; } lvOption = lvOption.Replace(' ', ','); ////ห้ามจ่ายติดลบ //if (lvTotalBal < 0) //{ // MessageBox.Show("จำนวนคงเหลือไม่เพียงพอ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); // txtAmount.Focus(); // return; //} //if (lvTotalBal < 0) lvTotalBal = 0; ////Update ยอด //lvSQL = "Update SysITEM_Stock set Item_Amount = '" + lvTotalBal + "' Where Item_ID = '" + lvItemID + "' "; //lvResault = GsysSQL.fncExecuteQueryData(lvSQL); //Insert เคลื่อนไหว lvSQL = "Insert into Inv_Moving (M_Type, M_Date, M_ItemID, M_AmountR, M_AmountP, M_AmountBal, M_UserResive, M_UserPay, M_Remark, M_Option) "; lvSQL += "values('" + lvType + "', '" + lvDate + "', '" + lvItemID + "', '', '" + lvAmount + "', '" + lvTotalBal + "', '" + lvUserResive + "', '" + lvUserPay + "', '" + lvRemark + "', '" + lvOption + "')"; lvResault = GsysSQL.fncExecuteQueryData(lvSQL); if (lvResault == "Success") { GVar.gvSave = true; string lvUserName = GsysSQL.fncFindFullEmpName(lvUserResive); string lvItemName = GsysSQL.fncFindItemName(lvItemID); string lvItemUnit = GsysSQL.fncFindItemUnit(lvItemID); if (lvItemName == "อื่นๆ") { lvItemName = lvRemark; } string lvMessage = "แจ้งเตือน " + lvUserName + " ได้ยืม " + lvItemName + " จำนวน " + lvAmount + " " + lvItemUnit + " " + lvRemark; lineNotify(lvMessage); MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } #endregion } else { #region เบิกจ่าย //เช็คข้อมูล if (txtDate.EditValue == "") { MessageBox.Show("กรุณาระบุ วันที่", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtDate.Focus(); return; } else if (txtID.Text == "") { MessageBox.Show("กรุณาระบุ รหัส", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtID.Focus(); return; } else if (Gstr.fncToInt(txtAmount.Text) <= 0) { MessageBox.Show("กรุณาระบุ จำนวน", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtAmount.Focus(); return; } else if (txtUserResive.Text == "") { MessageBox.Show("กรุณาระบุ ผู้ขอเบิก", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Focus(); return; } else if (txtUserPay.Text == "") { MessageBox.Show("กรุณาระบุ ผู้จ่าย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserResive.Focus(); return; } string lvType = "P"; string lvDate = Gstr.fncChangeTDate(txtDate.EditValue.ToString()); string lvItemID = Gstr.fncGetDataCode(txtID.Text, ";"); string lvAmount = txtAmount.Text; string lvBal = GsysSQL.fncFindBal(lvItemID); string lvUserResive = Gstr.fncGetDataCode(txtUserResive.Text, ";"); string lvUserPay = Gstr.fncGetDataCode(txtUserPay.Text, ";"); string lvRemark = txtRemark.Text; string lvSQL = ""; string lvResault = ""; int lvTotalBal = Gstr.fncToInt(lvBal) - Gstr.fncToInt(lvAmount); int lvMinStock = Gstr.fncToInt(GsysSQL.fncFindMinStock(lvItemID)); //ห้ามจ่ายติดลบ if (lvTotalBal < 0) { MessageBox.Show("จำนวนคงเหลือไม่เพียงพอ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); txtAmount.Focus(); return; } if (lvTotalBal < 0) { lvTotalBal = 0; } //Update ยอด lvSQL = "Update SysITEM_Stock set Item_Amount = '" + lvTotalBal + "' Where Item_ID = '" + lvItemID + "' "; lvResault = GsysSQL.fncExecuteQueryData(lvSQL); //Insert เคลื่อนไหว lvSQL = "Insert into Inv_Moving (M_Type, M_Date, M_ItemID, M_AmountR, M_AmountP, M_AmountBal, M_UserResive, M_UserPay, M_Remark) "; lvSQL += "values('" + lvType + "', '" + lvDate + "', '" + lvItemID + "', '', '" + lvAmount + "', '" + lvTotalBal + "', '" + lvUserResive + "', '" + lvUserPay + "', '" + lvRemark + "')"; lvResault = GsysSQL.fncExecuteQueryData(lvSQL); if (lvResault == "Success") { if (lvTotalBal <= lvMinStock && lvMinStock != 0) { string lvMessage = "แจ้งเตือน " + txtName.Text + " ใกล้หมดแล้ว ยอดคงเหลือปัจุบัน คือ " + lvTotalBal; lineNotify(lvMessage); } else { string lvEmpName = GsysSQL.fncFindFullEmpName(lvUserResive); string lvItemName = GsysSQL.fncFindItemName(lvItemID); string lvItemUnit = GsysSQL.fncFindItemUnit(lvItemID); string lvMessage = "แจ้งเตือน " + lvEmpName + " ได้เบิก " + lvItemName + " จำนวน " + lvAmount + " " + lvItemUnit; lineNotify(lvMessage); } MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } #endregion } }
public void lvLoadItem(bool lvShow) { try { this.Cursor = Cursors.WaitCursor; btnreg.Enabled = false; btnIn.Enabled = false; btnOut.Enabled = false; btnBorrow.Enabled = false; btnNoteBook.Enabled = false; string lvSQL = "Select Top 50 * from Inv_Moving Where M_Type in ('R','P') Order by M_Pk Desc "; DataTable DT = new DataTable(); DT = GsysSQL.fncGetQueryData(lvSQL, DT); int lvNumRow = DT.Rows.Count; sp1.ActiveSheet.RowCount = lvNumRow; progressBar1.Maximum = lvNumRow; progressBar1.Value = 0; pnStatus.Visible = true; for (int i = 0; i < lvNumRow; i++) { sp1.ActiveSheet.Cells[i, 0].Text = Gstr.fncChangeSDate(DT.Rows[i]["M_Date"].ToString()); sp1.ActiveSheet.Cells[i, 1].Text = DT.Rows[i]["M_ItemID"].ToString(); sp1.ActiveSheet.Cells[i, 2].Text = GsysSQL.fncFindItemName(DT.Rows[i]["M_ItemID"].ToString()); sp1.ActiveSheet.Cells[i, 3].Text = DT.Rows[i]["M_AmountR"].ToString(); sp1.ActiveSheet.Cells[i, 4].Text = DT.Rows[i]["M_AmountP"].ToString(); sp1.ActiveSheet.Cells[i, 5].Text = DT.Rows[i]["M_AmountBal"].ToString(); sp1.ActiveSheet.Cells[i, 6].Text = GsysSQL.fncFindEmpName(DT.Rows[i]["M_UserResive"].ToString()); sp1.ActiveSheet.Cells[i, 7].Text = GsysSQL.fncFindEmpName(DT.Rows[i]["M_UserPay"].ToString()); sp1.ActiveSheet.Cells[i, 8].Text = GsysSQL.fncFindEmpName(DT.Rows[i]["M_Remark"].ToString()); progressBar1.Value += 1; Application.DoEvents(); } pnStatus.Visible = false; DT.Dispose(); btnreg.Enabled = true; btnIn.Enabled = true; btnOut.Enabled = true; btnBorrow.Enabled = true; btnNoteBook.Enabled = true; if (lvShow) { tabControl1.SelectedIndex = 0; } this.Cursor = Cursors.Default; } catch { Application.Restart(); } }
private void FncListViewDragDrop(object sender, DragEventArgs e, ListView lv, string lvAddress) { //คืนของ string lvItemCode = ""; if (lvAddress == "") { //หาสิ่งที่เลือก string lvItemSelect = ""; if (e.Data.GetDataPresent(typeof(List <ListViewItem>))) { var items = (List <ListViewItem>)e.Data.GetData(typeof(List <ListViewItem>)); // move to dest LV foreach (ListViewItem lvi in items) { lvItemSelect = lvi.Text; } } //ถ้าเป็นช่องเดิมไม่มีการย้ายให้ Return bool lvChk = false; foreach (ListViewItem item in lv.Items) { if (item.Text == lvItemSelect) { lvChk = true; break; } } if (lvChk) { return; } //ยืนยัน string lvTxtAlert = "ตรวจสอบอุปกรณ์ ว่าครบหรือไม่ "; //if (GVar.gvDateBill != Gstr.fncChangeTDate(txtDate.Text)) lvTxtAlert = " **วันที่ไม่ตรงกับใบเสร็จ**"+ Environment.NewLine + Environment.NewLine + "ยืนยันการทำรายการต่อหรือไม่?"; DialogResult dialogResult = MessageBox.Show(lvTxtAlert, "ยืนยันการคืน NoteBook ?", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } else { string lvMsg = ""; if (e.Data.GetDataPresent(typeof(List <ListViewItem>))) { var items = (List <ListViewItem>)e.Data.GetData(typeof(List <ListViewItem>)); // move to dest LV foreach (ListViewItem lvi in items) { if (lvi.Text == "Dell") { lvMsg = "แจ้งเตือน NoteBook Dell ได้ถูกนำมาคืนแล้ว"; lvItemCode = "00021"; } else if (lvi.Text == "ASUS") { lvMsg = "แจ้งเตือน NoteBook ASUS ได้ถูกนำมาคืนแล้ว"; lvItemCode = "00022"; } else if (lvi.Text == "ThinkPad") { lvMsg = "แจ้งเตือน NoteBook ThinkPad ได้ถูกนำมาคืนแล้ว"; lvItemCode = "00023"; } else if (lvi.Text == "Lenovo") { lvMsg = "แจ้งเตือน NoteBook Lenovo ได้ถูกนำมาคืนแล้ว"; lvItemCode = "00024"; } } } //Update ยอด string lvSQL = "Update Inv_Moving set M_Type = 'T' Where M_ItemID = '" + lvItemCode + "' "; string lvResault = GsysSQL.fncExecuteQueryData(lvSQL); lineNotify(lvMsg); } } if (e.Data.GetDataPresent(typeof(List <ListViewItem>))) { var items = (List <ListViewItem>)e.Data.GetData(typeof(List <ListViewItem>)); // move to dest LV foreach (ListViewItem lvi in items) { if (lvAddress != "") { GVar.gvSave = false; GVar.gvBorrow = true; frmIN frm = new frmIN(); frm.pvMode = "Borrow"; lvItemCode = ""; if (lvi.Text == "Dell") { lvItemCode = "00021"; } else if (lvi.Text == "ASUS") { lvItemCode = "00022"; } else if (lvi.Text == "ThinkPad") { lvItemCode = "00023"; } else if (lvi.Text == "Lenovo") { lvItemCode = "00024"; } frm.txtID.Text = lvItemCode; frm.txtName.Text = GsysSQL.fncFindItemName(lvItemCode); frm.txtRemark.Text = "ใช้งาน สำหรับ " + lvAddress; frm.ShowDialog(); } if (GVar.gvSave) { // LVI obj can only belong to one LVI, remove lvi.ListView.Items.Remove(lvi); lv.Items.Add(lvi); } } } lvLoadItemBorrow(true); }