//Document public static string fncGenDocNo(string lvDocCode) { #region //Connect Database SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSConnection"].ToString()); SqlCommand cmd = new SqlCommand(); SqlDataReader dr; #endregion string lvReturn = ""; cmd.Connection = con; con.Open(); cmd.CommandText = "SELECT * FROM SysDocNo WHERE S_MCode = '" + lvDocCode + "' "; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { //GenDoc string lvShort = dr["S_ShortCode"].ToString(); int lvYearChk = DateTime.Now.Year; if (lvYearChk < 2500) { lvYearChk += 543; } string lvYear = (lvYearChk - 2500).ToString(); int lvMonth = DateTime.Now.Month; int lvDay = DateTime.Now.Day; string lvSection = "121"; int lvRunDoc = Gstr.fncToInt(dr["S_RunNo"].ToString()); string lvDocID = ""; if (dr["S_TypeGen"].ToString() == "YYMMDept") { lvDocID = lvShort + lvYear.ToString() + lvMonth.ToString("00") + lvSection + lvRunDoc.ToString(dr["S_Format"].ToString()); } else if (dr["S_TypeGen"].ToString() == "YYMMdd") { lvDocID = lvShort + lvYear.ToString() + lvMonth.ToString("00") + lvDay.ToString("00") + lvRunDoc.ToString(dr["S_Format"].ToString()); } else { lvDocID = lvShort + lvRunDoc.ToString(dr["S_Format"].ToString()); } lvReturn = lvDocID; } } else { lvReturn = ""; } dr.Close(); con.Close(); return(lvReturn); }
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 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(); } }