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