private void btlogin_Click(object sender, EventArgs e) { gen.ExcuteNonquery("delete from Center"); // update by Khoa Pham 2/18/2020 gen.ExcuteNonquery("insert into Center values(N'" + txtten.Text + "',N'" + textEdit1.Text + "',N'" + textEdit2.Text + "',N'" + textEdit3.Text + "',N'" + textEdit4.Text + "',N'" + textEdit5.Text + "',N'" + textEdit6.Text + "',N'" + textEdit7.Text + "',N'" + textEdit8.Text + "','" + textEdit9.Text + "',N'" + textEdit10.Text + "',N'" + textEdit11.Text + "','',0)"); XtraMessageBox.Show("Hệ thống đã lưu thông tin thay đổi.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public void checkdistrist(string ac, TextBox a, TextBox b, string sql, Frm_distrist F) { if (a.Text == "") { MessageBox.Show("Mã quận/huyện không được bỏ trống.", "HAMACO"); } else if (b.Text == "") { MessageBox.Show("Tên quận/huyện không được bỏ trống.", "HAMACO"); } else { if (ac == "1") { gen.ExcuteNonquery(sql); F.myac(); F.Close(); } else { try { string kq = gen.GetString("select * from Distrist where DistristCode='" + a.Text + "'"); MessageBox.Show("Mã quận/huyện này đã tồn tại.", "HAMACO"); } catch { gen.ExcuteNonquery(sql); F.myac(); F.Close(); } } } }
private void baadd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (semh.Text == "") { XtraMessageBox.Show("Bạn không được bỏ trống mặt hàng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (denad.Text == "") { XtraMessageBox.Show("Bạn không được bỏ trống ngày áp dụng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (degd.Text == "") { XtraMessageBox.Show("Bạn không được bỏ trống giá điều ngày.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (active == "0") { gen.ExcuteNonquery("insert into DDHCL(RefID,RefNo,RefDate,PostedDate,InStockID,AccountingObjectCode,AccountingObjectName,TotalAmount,TotalTransport,Contactname,IsExport) values(newid(),'" + txtsct.Text + "','" + denad.EditValue.ToString() + "','" + degd.EditValue.ToString() + "','" + gen.GetString("select StockID from Stock where StockCode='" + sedv.EditValue.ToString() + "'") + "','" + semh.EditValue.ToString() + "',N'" + txtth.Text + "'," + txttl.EditValue.ToString() + ",'" + txtdsd.EditValue.ToString() + "',N'" + lbduyet.Text + "','" + chenqv.Checked + "')"); XtraMessageBox.Show("Dữ liệu đã được cập nhật.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); myac(); this.Close(); } else { gen.ExcuteNonquery("update DDHCL set RefDate='" + denad.EditValue.ToString() + "',PostedDate='" + degd.EditValue.ToString() + "',AccountingObjectCode='" + semh.EditValue.ToString() + "',AccountingObjectName=N'" + txtth.Text + "',TotalAmount=" + txttl.EditValue.ToString() + ",TotalTransport='" + txtdsd.EditValue.ToString() + "',Contactname=N'" + lbduyet.Text + "',IsExport='" + chenqv.Checked + "' where RefID='" + role + "'"); XtraMessageBox.Show("Dữ liệu đã được cập nhật.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); myac(); this.Close(); } }
private void btnNew_Click(object sender, EventArgs e) { if (txtTransactionCode.Text == "") { XtraMessageBox.Show("Please enter the transaction", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { tname = gen.GetString2("Transactions", "FormName", "TransactionCode", txtTransactionCode.Text, clientid); if (tname != "") { // add to Fav SQLString = "INSERT INTO TransactionFav ([TransactionCode],[username]) VALUES (" + "'"; SQLString += txtTransactionCode.Text + "','" + username + "')"; try { gen.ExcuteNonquery(SQLString); XtraMessageBox.Show("This transaction is created to the favorite successfully!", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); // load lai menu Fav load_menuFav(); } catch { SQLString = "This transaction is existed already in the favorite"; XtraMessageBox.Show(SQLString, "btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); //txtSQL.Text = SQLString; } } else { XtraMessageBox.Show("Tên transaction không đúng.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void tsbtsave_Click(object sender, EventArgs e) { string pid = "NULL"; int gr = 1; if (cbloai.Text != "") { pid = gen.GetString("select InventoryCategoryID from InventoryItemCategory where InventoryCategoryCode='" + cbloai.SelectedValue.ToString() + "'"); string t = gen.GetString("select Grade from InventoryItemCategory where InventoryCategoryCode='" + cbloai.SelectedValue.ToString() + "'"); gr = int.Parse(t) + 1; } if (active == "1") { string sql; if (pid == "NULL") { sql = "update InventoryItemCategory set InventoryCategoryName=N'" + txtname.Text + "',Inactive='" + checkBox1.Checked.ToString() + "',Grade='" + gr + "' where InventoryCategoryID='" + role + "'"; } else { sql = "update InventoryItemCategory set InventoryCategoryName=N'" + txtname.Text + "',Inactive='" + checkBox1.Checked.ToString() + "',ParentID='" + pid + "',Grade='" + gr + "' where InventoryCategoryID='" + role + "'"; gen.ExcuteNonquery("update InventoryItemCategory set IsParent='True' where InventoryCategoryID='" + pid + "'"); } // iic.checkiic(active, txtcode, txtname, sql, this, pid, role); } else { string sql = "insert into InventoryItemCategory(InventoryCategoryID,InventoryCategoryCode,InventoryCategoryName,Inactive,ParentID,Grade) values(newid(),'" + txtcode.Text + "',N'" + txtname.Text + "','" + checkBox1.Checked.ToString() + "','" + pid + "','" + gr + "')"; if (pid != "NULL") { gen.ExcuteNonquery("update InventoryItemCategory set IsParent='True' where InventoryCategoryID='" + pid + "'"); } // iic.checkiic(active, txtcode, txtname, sql, this, pid, role); } }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { string sql = "Delete from TransactionFav Where username ='******' and TransactionCode ='" + contextMenuID + "';"; gen.ExcuteNonquery(sql); LoadDataTableMenu(); loadTreeMenu(); }
private void tsbtcat_Click(object sender, EventArgs e) { ledt.Focus(); if (pt == "pnk") { pnk.checkpnk(active, role, this, gridView1, ledt, ledv, cbldt, txtsct, txtname, txtdc, txtngh, txtctg, txtldn, denct, denht, tsbtboghi, tsbtghiso, tsbtxoa, tsbtcat, tsbtin, tsbtsua, tsbtnap, ngaychungtu, txtmst, txtptvc, userid, branchid, tsbttruoc, tsbtsau, chtc); } else if (pt == "pnkvtddh") { pnktddh.checkpnk(active, role, this, gridView1, ledt, ledv, cbldt, txtsct, txtname, txtdc, txtngh, txtctg, txtldn, denct, denht, tsbtboghi, tsbtghiso, tsbtxoa, tsbtcat, tsbtin, tsbtsua, tsbtnap, ngaychungtu, txtmst, txtptvc, userid, branchid, tsbttruoc, tsbtsau, chtc, txttaixe); } else { pxk.checkpxk(active, role, this, gridView1, ledt, ledv, cbldt, txtsct, txtname, txtdc, txtngh, txtctg, txtldn, denct, denht, tsbtboghi, tsbtghiso, tsbtxoa, tsbtcat, tsbtin, tsbtsua, tsbtnap, ngaychungtu, txtmst, txtptvc, userid, branchid, tsbttruoc, tsbtsau, chtc, txttaixe); } refreshrole(); click = "true"; change(); click = "false"; if (active == "1") { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Sửa','" + txtsct.Text + "')"); } else { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Thêm','" + txtsct.Text + "')"); } }
private void tsbtghiso_Click(object sender, EventArgs e) { tsbtboghi.Visible = true; tsbtghiso.Visible = false; tsbtsua.Enabled = false; if (pt == "pck") { gen.ExcuteNonquery("update INInward set Posted='True' where RefID='" + role + "'"); } else { gen.ExcuteNonquery("update INOutward set Posted='True' where RefID='" + role + "'"); } }
private void btnLock_Click(object sender, EventArgs e) { SQLString = "UPDATE [MSC_User] SET InActive=1 WHERE CompanyCode='" + Globals.companycode + "' AND username='******'"; try { gen.ExcuteNonquery(SQLString); XtraMessageBox.Show("This user is locked successfully!", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch { XtraMessageBox.Show(SQLString, "btnLock_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void basave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { txtname.Focus(); if (rbcpn.Checked == true) { check = "1"; } else if (rbltu.Checked == true) { check = "2"; } else if (rbtnn.Checked == true) { check = "3"; } else if (rbgvn.Checked == true) { check = "4"; } else { check = "0"; } if (active == "1") { gen.ExcuteNonquery("delete Descasc where DescascCode=(select DescascCode from Descasc where DescascID='" + role + "')"); } Double so = 0; try { so = Double.Parse(gen.GetString("select Max(DescascCode) from Descasc")) + 1; } catch { } for (int i = 0; i < gridView1.RowCount - 1; i++) { string makho = gridView1.GetRowCellValue(i, "Mã kho").ToString(); makho = gen.GetString("select StockID from Stock where StockCode='" + makho + "'"); string sotien = gridView1.GetRowCellValue(i, "Số tiền").ToString().Replace(".", ""); string diengiai = gridView1.GetRowCellValue(i, "Diễn giải").ToString(); string manganh = gridView1.GetRowCellValue(i, "Mã ngành").ToString(); gen.ExcuteNonquery("insert into Descasc values(newid(),'" + so + "',N'" + txtname.EditValue + "','" + ledv.EditValue + "','" + makho + "','" + sotien + "',N'" + diengiai + "','" + check + "','" + txtdvsd.EditValue + "','" + manganh + "')"); } XtraMessageBox.Show("Dữ liệu của bạn đã được lưu.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.None); this.myac(); this.Close(); }
private void luu_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("delete from MSC_RolePermissionMaping where RoleID='" + role + "'"); for (int i = 0; i <= start; i++) { if (mscstr[i, 2] == "1") { gen.ExcuteNonquery("insert into MSC_RolePermissionMaping values(newid(),'" + mscstr[i, 0] + "','" + role + "','" + mscstr[i, 1] + "')"); } } SplashScreenManager.CloseForm(); this.Close(); this.Dispose(); }
private void Frm_login_Load(object sender, EventArgs e) { //load_txtDatabase(); // combo try { gen.ExcuteNonquery("select * from Center"); try { gen.GetString("select * from Center where Version='" + ver + "'"); this.Text = gen.GetString("select Top 1 CompanyName from Center"); } catch { XtraMessageBox.Show("Phiên bản bạn đang dùng chưa đúng, vui lòng cập nhật phiên bản mới.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } } catch (Exception ex) { //XtraMessageBox.Show("Kết nối tới Server chưa được thiết lập, vui lòng kết nối và thử lại.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); XtraMessageBox.Show(ex.Message, "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } }
private void btlogin_Click(object sender, EventArgs e) { if (txtmk.Text != txtmk2.Text || txtmk.Text == "") { XtraMessageBox.Show("Mật khẩu mới chưa khớp hoặc bạn chưa nhập mật khẩu mới.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtmk2.Text = ""; txtmk.Text = ""; txtmk.Focus(); } else { SQLString = "update MSC_User set Password='******' where Username='******' AND CompanyCode='" + Globals.companycode + "'"; try { gen.ExcuteNonquery(SQLString); XtraMessageBox.Show("Mật khẩu của bạn đã được thay đổi.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); txtmk2.Text = ""; txtmk.Text = ""; txtmk.Text = ""; txtmk2.Focus(); } catch { XtraMessageBox.Show(SQLString, "btlogin_Click", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtmk2.Text = ""; txtmk2.Focus(); } } }
private void btlogin_Click(object sender, EventArgs e) { if (txtmk.Text != textEdit2.Text || txtmk.Text == "") { XtraMessageBox.Show("Mật khẩu mới chưa khớp hoặc bạn chưa nhập mật khẩu mới.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); textEdit2.Text = ""; txtmk.Text = ""; txtmk.Focus(); } else { try { SplashScreenManager.ShowForm(typeof(Frm_wait)); string userid = gen.GetString("select Userid from MSC_User where UserName='******' and Password='******'"); gen.ExcuteNonquery("update MSC_User set Password='******' where UserID='" + userid + "'"); XtraMessageBox.Show("Mật khẩu của bạn đã được thay đổi.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); textEdit1.Text = ""; textEdit2.Text = ""; txtmk.Text = ""; textEdit1.Focus(); SplashScreenManager.CloseForm(); } catch { XtraMessageBox.Show("Mật khẩu hiện tại không đúng.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); textEdit1.Text = ""; textEdit1.Focus(); SplashScreenManager.CloseForm(); } } }
private void basave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (chkhcd.Checked == true) { string makho = gen.GetString("select StockID from Stock where StockCode='" + ledv.EditValue + "'"); string nguyengia = txtng.EditValue.ToString().Replace(".", "").Replace(",", "."); string khauhao = txtkhbq.EditValue.ToString().Replace(".", "").Replace(",", "."); if (active == "1") { gen.ExcuteNonquery("update Depreciation set DepreciationName=N'" + txtname.EditValue + "', OriginalPrice='" + nguyengia + "', Price='" + khauhao + "', StockID='" + makho + "',Fixed=1 where DepreciationID='" + role + "' "); } else { Double so = Double.Parse(gen.GetString("select Max(DepreciationCode) from Depreciation")) + 1; gen.ExcuteNonquery("insert into Depreciation(DepreciationID,DepreciationCode,DepreciationName,OriginalPrice,Price,StockID,PostDate,Fixed) values(newid(),'" + so + "',N'" + txtname.EditValue + "','" + nguyengia + "','" + khauhao + "','" + makho + "','" + ngay + "',1) "); } } else { string makho = gen.GetString("select StockID from Stock where StockCode='" + ledv.EditValue + "'"); string nguyengia = txtng.EditValue.ToString().Replace(".", "").Replace(",", "."); string khauhao = txtkhbq.EditValue.ToString().Replace(".", "").Replace(",", "."); string thuesuat = txtts.EditValue.ToString().Replace(".", "").Replace(",", "."); string giatriconlai = txttontruoc.EditValue.ToString().Replace(".", "").Replace(",", "."); string laivay = txtlv.EditValue.ToString().Replace(".", "").Replace(",", "."); if (active == "1") { gen.ExcuteNonquery("update Depreciation set DepreciationName=N'" + txtname.EditValue + "',StartTime='" + txtdvsd.EditValue + "',DepreciationTime='" + txttgkh.EditValue + "',EndTime='" + txttghkh.EditValue + "', OriginalPrice='" + nguyengia + "', Price='" + khauhao + "',ExitsPrice='" + giatriconlai + "',ExitsTime='" + txttgcl.EditValue + "',Tax='" + thuesuat + "',TaxPrice='" + laivay + "', StockID='" + makho + "',PostDate='" + ngay + "',Fixed=0 where DepreciationID='" + role + "'"); } else { Double so = Double.Parse(gen.GetString("select Max(DepreciationCode) from Depreciation")); so = so + 1; gen.ExcuteNonquery("insert into Depreciation values(newid(),'" + so + "',N'" + txtname.EditValue + "','" + txtdvsd.EditValue + "','" + txttgkh.EditValue + "','" + txttghkh.EditValue + "','" + nguyengia + "','" + khauhao + "','" + giatriconlai + "','" + txttgcl.EditValue + "','" + thuesuat + "','" + laivay + "','" + makho + "','" + ngay + "',0,0) "); } } XtraMessageBox.Show("Dữ liệu của bạn đã được lưu.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.None); this.myac(); this.Close(); } catch { XtraMessageBox.Show("Vui lòng kiểm tra lại thông tin trước khi lưu.", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void view2_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) { if (e.KeyCode == Keys.S && e.Modifiers == Keys.Control) { if (XtraMessageBox.Show("Bạn có chắc muốn lưu thông tin đã thay đổi này?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string thang = DateTime.Parse(ngaychungtu).Month.ToString(); string nam = DateTime.Parse(ngaychungtu).Year.ToString(); string idkhach = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); string makhach = view.GetRowCellValue(view.FocusedRowHandle, "Mã khách hàng").ToString(); string tenkhach = view.GetRowCellValue(view.FocusedRowHandle, "Tên khách hàng").ToString(); gen.ExcuteNonquery("delete SalarySS where StockID='" + kho + "' and MonthS='" + thang + "' and YearS='" + nam + "' and AccountingObjectID='" + idkhach + "' and EmployeeID='" + idnhanvien + "' "); for (int i = 0; i < gridView2.RowCount; i++) { if (gridView2.GetRowCellValue(i, "Số lượng").ToString() != "" && gridView2.GetRowCellValue(i, "Số lượng quy đổi").ToString() != "") { string idhang = gridView2.GetRowCellValue(i, "ID").ToString(); string hoadon = gridView2.GetRowCellValue(i, "Số hóa đơn").ToString(); string RefID = gridView2.GetRowCellValue(i, "RefID").ToString(); string mahang = gridView2.GetRowCellValue(i, "Mã hàng hóa").ToString(); string soluong = gridView2.GetRowCellValue(i, "Số lượng").ToString().Replace(".", "").Replace(",", "."); string soluongqd = gridView2.GetRowCellValue(i, "Số lượng quy đổi").ToString().Replace(".", "").Replace(",", "."); if (Double.Parse(soluongqd) != 0) { gen.ExcuteNonquery("insert into SalarySS values(newid(),'" + kho + "','" + thang + "','" + nam + "','" + idkhach + "','" + makhach + "',N'" + tenkhach + "','" + idnhanvien + "','" + nhanvien + "',N'" + tennhanvien + "','" + userid + "','" + soluong + "','" + soluongqd + "',0,'" + RefID + "','" + idhang + "','" + mahang + "','" + hoadon + "')"); } } } gridControl1.Enabled = true; panelControl2.Visible = false; } } else if (e.KeyCode == Keys.H && e.Modifiers == Keys.Control) { if (XtraMessageBox.Show("Bạn có chắc không muốn lưu thông tin này?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gridControl1.Enabled = true; panelControl2.Visible = false; } } }
private void tsbtcat_Click(object sender, EventArgs e) { ledt.Focus(); if (active == "1" && thue != txttthue.Text) { DialogResult dr = XtraMessageBox.Show("Thuế được thay từ < " + thue + " đồng > sang < " + txttthue.Text + " đồng >, bạn có muốn tiếp tục?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); if (dr == DialogResult.Cancel) { return; } } hdmh.checkhdmh(active, role, this, gridView1, gridView2, gridView3, ledt, cbldt, txtsct, txtname, txtdc, txtldn, denct, denht, tsbtboghi, tsbtghiso, tsbtxoa, tsbtcat, tsbtin, tsbtsua, tsbtnap, ngaychungtu, cbthue, txtshd, txtkhhd, txtnhd, txthtt, txthttt, txtms, le1562, branchid, userid, txttthue, ledv.EditValue.ToString(), tsbttruoc, tsbtsau, txtmst); refreshrole(); click = "true"; change(); click = "false"; if (active == "1") { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Sửa','" + txtsct.Text + "')"); thue = txttthue.Text; } else { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Thêm','" + txtsct.Text + "')"); } }
private void btnAddTransaction_Click(object sender, EventArgs e) { // add table RolePermissionMapping SQLString = "INSERT INTO RolePermissionMapping ([ClientId],[TransactionCode], [RoleID], [PermissionID]) VALUES (" + clientid; SQLString += ",'" + txtTransactionCode.Text + "'"; SQLString += ",'" + roleid + "','" + txtPermission.Text + "')"; try { gen.ExcuteNonquery(SQLString); XtraMessageBox.Show("This transaction is added successfully!", "HAMACO", MessageBoxButtons.OK, MessageBoxIcon.Information); //update lai datagrid Datagrid_update(roleid); } catch { //XtraMessageBox.Show(SQLString, "btnAddTransaction_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSQL.Text = SQLString; } }
private void tsbtcat_Click(object sender, EventArgs e) { if (txtldn.Text == "") { DevExpress.XtraEditors.XtraMessageBox.Show("Bạn chưa nhập lý do lập ủy nhiệm chi.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); txtldn.Focus(); return; } ledt.Focus(); unc.checkunc(active, role, this, gridView1, ledt, ledv, letk, leth, txtsct, txtname, txtdc, txtnn, txtctg, txtldn, denct, denht, tsbtboghi, tsbtghiso, chvay, tsbtcat, tsbtin, tsbtsua, tsbtnap, ngaychungtu, cbthue, userid, txtthuhuong, tsbttruoc, tsbtsau, "0"); refreshrole(); change(); if (active == "1") { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Sửa','" + txtsct.Text + "')"); } else { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Thêm','" + txtsct.Text + "')"); } }
private void tsbtcat_Click(object sender, EventArgs e) { ledt.Focus(); hdmh.checkpck(active, role, this, gridView3, ledt, ledv, txtsct, txtname, txtdc, txtldn, denct, denht, ngaychungtu, cbthue, userid, branchid, txtms, txtkhhd, txtshd, txtnhd, txthtt, txthttt, txttthue, tsbttruoc, tsbtsau, txtquyen, ledvx); refreshrole(); click = "true"; change(); click = "false"; if (active == "1") { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Sửa','" + txtsct.Text + "')"); } else { gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Thêm','" + txtsct.Text + "')"); } }
private void tsbtboghi_Click(object sender, EventArgs e) { tsbtghiso.Visible = true; tsbtboghi.Visible = false; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][3].ToString() == "EDIT") { tsbtsua.Enabled = true; } } if (pt == "pttmvt") { gen.ExcuteNonquery("update SUCAReceipt set Posted='False' where RefID='" + role + "'"); } else if (pt == "ptnhvt") { gen.ExcuteNonquery("update SUBADeposit set Posted='False' where RefID='" + role + "'"); } else if (pt == "pctmvt") { gen.ExcuteNonquery("update SUCAPayment set Posted='False' where RefID='" + role + "'"); } else if (pt == "pcnhvt") { gen.ExcuteNonquery("update SUBATransfer set Posted='False' where RefID='" + role + "'"); } gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Bỏ ghi','" + txtsct.Text + "')"); }
private void sbok_Click(object sender, EventArgs e) { if (checkEdit2.EditValue.ToString() == "True") { if (tsbt == "tsbtthpnxtt" || tsbt == "tsbtthpnxdc") { pnht.loadtong(ngaychungtu, userid, tsbt, "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } else if (tsbt == "tsbtthuedaura" || tsbt == "tsbtthuedauvao") { bc.loadthuetong(ngaychungtu, tsbt, "intonghoptheokho", userid); } else if (tsbt == "tsbtthkqkd") { thtk.loadketquakinhdoanh(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), ngaychungtu, ngaycuoi, tsbt + "tct", userid); } else if (tsbt == "tsbtbkhhnd" || tsbt == "tsbtbkhhxd") { thtk.loadbangkehanghoatong(ngaychungtu, ngaycuoi, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "IDS").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho nhập").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho xuất").ToString(), "2"); } else if (tsbt == "tsbtpkt") { pkt.loadchitiet(ngaychungtu, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "2", view.GetRowCellValue(view.FocusedRowHandle, "Tên người dùng").ToString(), tsbt + "tong", "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } } else if (checkEdit1.EditValue.ToString() == "True") { if (tsbt == "tsbtbctcth") { if (tsbt == "tsbtbctcth") { thtk.loadbaocaothuchingay(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Tên kho").ToString()); } } else if (tsbt == "tsbtbkhhnd" || tsbt == "tsbtbkhhxd") { thtk.loadbangkehanghoatong(ngaychungtu, ngaycuoi, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "IDS").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho nhập").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho xuất").ToString(), "1"); } else if (tsbt == "tsbtthpnxtt" || tsbt == "tsbtthpnxdc") { pnht.loadchitiet(ngaychungtu, userid, tsbt, "1", "", "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } else if (tsbt == "tsbtpkt") { pkt.loadchitiet(ngaychungtu, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "0", view.GetRowCellValue(view.FocusedRowHandle, "Tên người dùng").ToString(), tsbt, "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } else if (tsbt == "tsbtthkqkd") { thtk.loadketquakinhdoanh(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), ngaychungtu, ngaycuoi, tsbt + "tdv", userid); } else if (tsbt == "tsbtghiso") { string thang = DateTime.Parse(ngaychungtu).Month.ToString(); string nam = DateTime.Parse(ngaychungtu).Year.ToString(); if (XtraMessageBox.Show("Bạn có chắc ghi sổ toàn bộ dữ liệu tháng " + thang + " năm " + nam + " ?", "HAMACO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("tonghopghiso '" + thang + "','" + nam + "','',1"); SplashScreenManager.CloseForm(); } } else if (tsbt == "tsbtboghi") { string thang = DateTime.Parse(ngaychungtu).Month.ToString(); string nam = DateTime.Parse(ngaychungtu).Year.ToString(); if (XtraMessageBox.Show("Bạn có chắc bỏ ghi toàn bộ dữ liệu tháng " + thang + " năm " + nam + " ?", "HAMACO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("tonghopghiso '" + thang + "','" + nam + "','',0"); SplashScreenManager.CloseForm(); } } else if (tsbt == "tsbtthuedaura" || tsbt == "tsbtthuedauvao") { bc.loadthue(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "Mã khu vực").ToString(), "khuvuc", "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG", userid); } else if (tsbt == "sktth" || tsbt == "sktthtomtat") { string name = gen.GetString("select AccountName from Account where AccountNumber='" + userid + "'"); thtk.loadchitietsktth(ngaychungtu, ngaycuoi, tsbt, userid, name, ""); } else { thtk.loadchitietskttong(ngaychungtu, tsbt, account, accountname, lkno, lkco, cuoino, cuoico); } } else if (checkEdit3.EditValue.ToString() == "True") { if (tsbt == "tsbtthuedaura" || tsbt == "tsbtthuedauvao") { bc.loadthue(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "intonghop", "", userid); } } else { if (tsbt == "tsbtbctcth") { thtk.loadbaocaothuchi(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Tên kho").ToString()); } else if (tsbt == "tsbtbkhhnd" || tsbt == "tsbtbkhhxd") { thtk.loadbangkehanghoa(ngaychungtu, ngaycuoi, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "IDS").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho nhập").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Kho xuất").ToString(), "0"); } else if (tsbt == "tsbtpkt") { pkt.loadchitiet(ngaychungtu, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "1", view.GetRowCellValue(view.FocusedRowHandle, "Tên người dùng").ToString(), tsbt, "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } else if (tsbt == "tsbtthpnxtt" || tsbt == "tsbtthpnxdc") { pnht.loadchitiet(ngaychungtu, userid, tsbt, "0", view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG"); } else if (tsbt == "tsbtthkqkd") { thtk.loadketquakinhdoanh(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), ngaychungtu, ngaycuoi, tsbt, userid); } else if (tsbt == "tsbtghiso") { string thang = DateTime.Parse(ngaychungtu).Month.ToString(); string nam = DateTime.Parse(ngaychungtu).Year.ToString(); if (XtraMessageBox.Show("Bạn có chắc ghi sổ dữ liệu kho " + view.GetRowCellValue(view.FocusedRowHandle, "Mã kho").ToString() + " tháng " + thang + " năm " + nam + " ?", "HAMACO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("tonghopghiso '" + thang + "','" + nam + "','" + view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString() + "',1"); SplashScreenManager.CloseForm(); } } else if (tsbt == "tsbtboghi") { string thang = DateTime.Parse(ngaychungtu).Month.ToString(); string nam = DateTime.Parse(ngaychungtu).Year.ToString(); if (XtraMessageBox.Show("Bạn có chắc bỏ ghi dữ liệu kho " + view.GetRowCellValue(view.FocusedRowHandle, "Mã kho").ToString() + " tháng " + thang + " năm " + nam + " ?", "HAMACO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("tonghopghiso '" + thang + "','" + nam + "','" + view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString() + "',0"); SplashScreenManager.CloseForm(); } } else if (tsbt == "tsbtthuedaura" || tsbt == "tsbtthuedauvao") { bc.loadthue(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), "kho", "CÔNG TY CỔ PHẦN VẬT TƯ HẬU GIANG", userid); } else if (tsbt == "sktth" || tsbt == "sktthtomtat") { string name = gen.GetString("select AccountName from Account where AccountNumber='" + userid + "'"); thtk.loadchitietsktth(ngaychungtu, ngaycuoi, tsbt, userid, name, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString()); } else if (tsbt == "tsbtctlv") { thtk.loadchitietlaivay(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Tên kho").ToString()); } else if (tsbt == "tsbtctlvtn") { thtk.loadchitietlaivaytheonganh(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Tên kho").ToString()); } else if (tsbt == "tsbtctkqkd" || tsbt == "tsbtctkqkdtt") { thtk.loadchitietkinhdoanh(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString()); } else if (tsbt == "bkthbhtnvkdlqh") { Frm_rpcongno rp = new Frm_rpcongno(); rp.getngaychungtu(ngaycuoi); rp.getkho(userid); rp.getuserid(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString()); rp.gettsbt(tsbt); rp.Show(); } else { thtk.loadchitietskt(ngaychungtu, tsbt, view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(), view.GetRowCellValue(view.FocusedRowHandle, "Mã kho").ToString() + " - " + view.GetRowCellValue(view.FocusedRowHandle, "Tên kho").ToString(), account, accountname); } } }
private void batai_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (tsbt == "") { if (XtraMessageBox.Show("Bạn có chắc muốn cập nhật vật tư hàng hóa theo kho ?", gen.GetString("select Top 1 CompanyName from Center"), MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); string kho = gen.GetString("select StockID from Stock where StockCode='" + ledv.EditValue.ToString() + "'"); for (int i = 0; i < view.RowCount; i++) { if (view.GetRowCellValue(i, "Chọn").ToString() == "True") { string ma = view.GetRowCellValue(i, "ID").ToString(); string mahang = view.GetRowCellValue(i, "Mã hàng hóa").ToString(); string ten = view.GetRowCellValue(i, "Tên hàng hóa").ToString().Replace("'", "''"); string tyle = view.GetRowCellValue(i, "Tỷ lệ").ToString().Replace(",", "."); string dongia = view.GetRowCellValue(i, "Đơn giá").ToString().Replace(",", "."); string dongiaban = view.GetRowCellValue(i, "Đơn giá bán").ToString().Replace(",", "."); string dvt = view.GetRowCellValue(i, "Đơn vị tính").ToString(); string dvqd = view.GetRowCellValue(i, "Đơn vị quy đổi").ToString().Replace("'", "''"); string sql; try { string id = gen.GetString("select * from StockII where InventoryItemID='" + ma + "' and StockID='" + kho + "'"); sql = "update StockII set InventoryItemName=N'" + ten + "',Unit=N'" + dvt + "',ConvertUnit=N'" + dvqd + "',ConvertRate='" + tyle + "',UnitPrice='" + dongia + "',SalePrice='" + dongiaban + "' where InventoryItemID='" + ma + "' and StockID='" + kho + "'"; } catch { sql = "insert into StockII values(newid(),'" + ma + "',N'" + ten + "',N'" + dvt + "',N'" + dvqd + "','" + tyle + "','" + dongia + "','" + dongiaban + "','" + kho + "','" + mahang + "')"; } gen.ExcuteNonquery(sql); } if (view.GetRowCellValue(i, "Kho").ToString() == "True" && view.GetRowCellValue(i, "Chọn").ToString() == "False") { string ma = view.GetRowCellValue(i, "ID").ToString(); gen.ExcuteNonquery("delete StockII where InventoryItemID='" + ma + "' and StockID='" + kho + "'"); } } loadii(lvpq, view, ledv.EditValue.ToString()); SplashScreenManager.CloseForm(); } } else if (tsbt == "barbgdh") { if (XtraMessageBox.Show("Dữ liệu ngày " + String.Format("{0:dd/MM/yyyy}", DateTime.Parse(ngaychungtu)) + " sẽ bị xóa, bạn có chắc muốn cập nhật?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); ngaychungtu = DateTime.Parse(ngaychungtu).ToShortDateString(); gen.ExcuteNonquery("delete StockIIGD where PostedDate='" + ngaychungtu + "'"); for (int i = 0; i < view.RowCount; i++) { if (view.GetRowCellValue(i, "Mã hàng").ToString() != "") { string mahang = view.GetRowCellValue(i, "Mã hàng").ToString(); string nhamaycantho, khotranoc, kho22lhp, khorachgia, nhamayhcm, thuduc, bienhoa, binhduong, nhabe, kcnphumy, ltsh, baivong = null; if (DateTime.Parse(ngaychungtu) < DateTime.Parse("10/01/2019")) { nhamaycantho = view.GetRowCellValue(i, "Nhà máy Cần Thơ").ToString(); if (nhamaycantho == "") { nhamaycantho = "0"; } else { nhamaycantho = nhamaycantho.Replace(".", "").Replace(",", "."); } khotranoc = view.GetRowCellValue(i, "Kho Trà Nóc").ToString(); if (khotranoc == "") { khotranoc = "0"; } else { khotranoc = khotranoc.Replace(".", "").Replace(",", "."); } kho22lhp = view.GetRowCellValue(i, "Kho C22 LHP").ToString(); if (kho22lhp == "") { kho22lhp = "0"; } else { kho22lhp = kho22lhp.Replace(".", "").Replace(",", "."); } khorachgia = view.GetRowCellValue(i, "Kho Rạch Giá").ToString(); if (khorachgia == "") { khorachgia = "0"; } else { khorachgia = khorachgia.Replace(".", "").Replace(",", "."); } nhamayhcm = view.GetRowCellValue(i, "Nhà máy HCM").ToString(); if (nhamayhcm == "") { nhamayhcm = "0"; } else { nhamayhcm = nhamayhcm.Replace(".", "").Replace(",", "."); } thuduc = view.GetRowCellValue(i, "Thủ Đức").ToString(); if (thuduc == "") { thuduc = "0"; } else { thuduc = thuduc.Replace(".", "").Replace(",", "."); } bienhoa = view.GetRowCellValue(i, "Biên Hòa").ToString(); if (bienhoa == "") { bienhoa = "0"; } else { bienhoa = bienhoa.Replace(".", "").Replace(",", "."); } binhduong = view.GetRowCellValue(i, "Bình Dương").ToString(); if (binhduong == "") { binhduong = "0"; } else { binhduong = binhduong.Replace(".", "").Replace(",", "."); } nhabe = view.GetRowCellValue(i, "Nhà Bè").ToString(); if (nhabe == "") { nhabe = "0"; } else { nhabe = nhabe.Replace(".", "").Replace(",", "."); } kcnphumy = view.GetRowCellValue(i, "KCN Phú Mỹ").ToString(); if (kcnphumy == "") { kcnphumy = "0"; } else { kcnphumy = kcnphumy.Replace(".", "").Replace(",", "."); } ltsh = view.GetRowCellValue(i, "LTSH-Xe XMTD-PT Thủy 200 tấn").ToString(); if (ltsh == "") { ltsh = "0"; } else { ltsh = ltsh.Replace(".", "").Replace(",", "."); } baivong = view.GetRowCellValue(i, "Kho Phú Quốc - Bãi Vòng").ToString(); if (baivong == "") { baivong = "0"; } else { baivong = baivong.Replace(".", "").Replace(",", "."); } } else { nhamaycantho = view.GetRowCellValue(i, "Nhà máy CT (TĐ, Pomina)").ToString(); if (nhamaycantho == "") { nhamaycantho = "0"; } else { nhamaycantho = nhamaycantho.Replace(".", "").Replace(",", "."); } khotranoc = view.GetRowCellValue(i, "Kho Trà Nóc").ToString(); if (khotranoc == "") { khotranoc = "0"; } else { khotranoc = khotranoc.Replace(".", "").Replace(",", "."); } kho22lhp = view.GetRowCellValue(i, "Kho C22 LHP").ToString(); if (kho22lhp == "") { kho22lhp = "0"; } else { kho22lhp = kho22lhp.Replace(".", "").Replace(",", "."); } khorachgia = view.GetRowCellValue(i, "Kho Rạch Giá").ToString(); if (khorachgia == "") { khorachgia = "0"; } else { khorachgia = khorachgia.Replace(".", "").Replace(",", "."); } nhamayhcm = view.GetRowCellValue(i, "Hòa Phát ( salan-PQ)").ToString(); if (nhamayhcm == "") { nhamayhcm = "0"; } else { nhamayhcm = nhamayhcm.Replace(".", "").Replace(",", "."); } thuduc = view.GetRowCellValue(i, "TĐ, BH, NB (Đường thủy)").ToString(); if (thuduc == "") { thuduc = "0"; } else { thuduc = thuduc.Replace(".", "").Replace(",", "."); } bienhoa = view.GetRowCellValue(i, "TĐ, BH (Đường bộ)").ToString(); if (bienhoa == "") { bienhoa = "0"; } else { bienhoa = bienhoa.Replace(".", "").Replace(",", "."); } binhduong = view.GetRowCellValue(i, "Bình Dương (Đường bộ)").ToString(); if (binhduong == "") { binhduong = "0"; } else { binhduong = binhduong.Replace(".", "").Replace(",", "."); } nhabe = view.GetRowCellValue(i, "Nhà Bè (Đường bộ)").ToString(); if (nhabe == "") { nhabe = "0"; } else { nhabe = nhabe.Replace(".", "").Replace(",", "."); } kcnphumy = view.GetRowCellValue(i, "KCN Phú Mỹ (Đường Bộ +Thủy)").ToString(); if (kcnphumy == "") { kcnphumy = "0"; } else { kcnphumy = kcnphumy.Replace(".", "").Replace(",", "."); } ltsh = view.GetRowCellValue(i, "LTSH-Xe XMTD-PT Thủy 200 tấn").ToString(); if (ltsh == "") { ltsh = "0"; } else { ltsh = ltsh.Replace(".", "").Replace(",", "."); } baivong = view.GetRowCellValue(i, "Kho Phú Quốc - Bãi Vòng").ToString(); if (baivong == "") { baivong = "0"; } else { baivong = baivong.Replace(".", "").Replace(",", "."); } } gen.ExcuteNonquery("insert into StockIIGD(ID,PostedDate,InventoryItemCode,NhamayCT,KhoTN,KhoC22,KhoRG,NhamayHCM,KhoTD,KhoBH,KhoBD,KhoNB,KhoPM,KhoLTSH,KhoBV) values(newid(),'" + ngaychungtu + "','" + mahang + "','" + nhamaycantho + "','" + khotranoc + "','" + kho22lhp + "','" + khorachgia + "','" + nhamayhcm + "','" + thuduc + "','" + bienhoa + "','" + binhduong + "','" + nhabe + "','" + kcnphumy + "','" + ltsh + "','" + baivong + "')"); } } SplashScreenManager.CloseForm(); XtraMessageBox.Show("Dữ liệu đã được xử lý xong", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else if (tsbt == "barbglpg") { if (XtraMessageBox.Show("Bạn có chắc muốn duyệt vật giá bán này?", gen.GetString("select Top 1 CompanyName from Center"), MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { SplashScreenManager.ShowForm(typeof(Frm_wait)); gen.ExcuteNonquery("delete InventoryItemAD where Month(PostedDate)='" + DateTime.Parse(ngaychungtu).Month + "' and Year(PostedDate)='" + DateTime.Parse(ngaychungtu).Year + "'"); for (int i = 0; i < view.RowCount; i++) { string mahang = view.GetRowCellValue(i, "ID").ToString(); string gia = view.GetRowCellValue(i, "Tăng giảm giá").ToString(); if (gia == "") { gia = "0"; } else { gia = gia.Replace(".", "").Replace(",", "."); } gen.ExcuteNonquery("insert InventoryItemAD values(newid(),'" + mahang + "'," + gia + ",'" + ngaychungtu + "','True')"); } gen.ExcuteNonquery("duyetgiabanlpg '" + ngaychungtu + "'"); SplashScreenManager.CloseForm(); XtraMessageBox.Show("Dữ liệu đã được xử lý xong", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } }
private void sbok_Click(object sender, EventArgs e) { DialogResult dr = XtraMessageBox.Show("Bạn có thực sự muốn thay đổi?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); if (dr == DialogResult.Yes) { if (tsbt == "tsbthdbhchange") { try { DataTable makhach = gen.GetTable("select AccountingObjectID,AccountingObjectName,Address,CompanyTaxCode from AccountingObject where AccountingObjectCode='" + searchLookUpEdit1.EditValue + "'"); /* * Double phantram = Double.Parse(gen.GetString("select Website from MSC_User where UserID='" + userid + "'")) / 100; * if (Double.Parse(txthm.EditValue.ToString()) + Double.Parse(txthm.EditValue.ToString()) * phantram < Double.Parse(txtcn.EditValue.ToString()) + congno) * { * XtraMessageBox.Show("Vui lòng kiểm tra lại Tổng công nợ vượt hạn mức hợp đồng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); * return; * } */ if (gen.GetString("select Top 1 CompanyTaxCode from Center") == "1801115004" || gen.GetString("select Top 1 CompanyTaxCode from Center") == "18001113092") { Double phantram = Double.Parse(gen.GetString("select Website from MSC_User where UserID='" + userid + "'")) / 100; Double dinhmuc = 0; if (phantram > 0 && phantram < 0.5) { dinhmuc = 50000000; } else if (phantram > 0.5 && phantram < 1) { dinhmuc = 150000000; } else if (phantram == 1) { dinhmuc = 300000000; } if (sehd.Text != "" && (Double.Parse(txthm.EditValue.ToString()) + Double.Parse(txthm.EditValue.ToString()) * phantram < Double.Parse(txtcn.EditValue.ToString()) + congno || Double.Parse(txthm.EditValue.ToString()) + dinhmuc < Double.Parse(txtcn.EditValue.ToString()) + congno)) { XtraMessageBox.Show("Vui lòng kiểm tra lại Tổng công nợ vượt hạn mức hợp đồng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (gen.GetString("select Top 1 CompanyTaxCode from Center") == "18001113092") { if (Double.Parse(txthm.EditValue.ToString()) < Double.Parse(txtcn.EditValue.ToString()) - congno) { XtraMessageBox.Show("Vui lòng thu tiền trước khi xuất lô hàng tiếp theo.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } } else { Double phantram = Double.Parse(gen.GetString("select Website from MSC_User where UserID='" + userid + "'")) / 100; Double dinhmuc = 0; if (phantram > 0 && phantram < 0.5) { dinhmuc = 100000000; } else if (phantram >= 0.5) { dinhmuc = 300000000; } if ((Double.Parse(txthm.EditValue.ToString()) + Double.Parse(txthm.EditValue.ToString()) * phantram < Double.Parse(txtcn.EditValue.ToString()) + congno || Double.Parse(txthm.EditValue.ToString()) + dinhmuc < Double.Parse(txtcn.EditValue.ToString()) + congno)) { XtraMessageBox.Show("Vui lòng kiểm tra lại Tổng công nợ vượt hạn mức hợp đồng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (txtsct.Text != searchLookUpEdit1.Text && gen.GetString("select AccountingObjectType from SSInvoice where RefID='" + ID + "'") == "1") { Double hanmuc = 20000000; Double tongxuat = Double.Parse(gen.GetString("select COALESCE(Sum(TotalAmount+TotalCost-TotalDiscountAmount-TotalFreightAmount+TotalVATAmount),0) from SSInvoice where Convert(varchar, CABARefDate,111)=(select Convert(varchar, CABARefDate,111) from SSInvoice where RefID='" + ID + "') and AccountingObjectID='" + makhach.Rows[0][0] + "' and AccountingObjectType='1' ")); Double tong = Double.Parse(gen.GetString("select COALESCE(TotalAmount+TotalCost-TotalDiscountAmount-TotalFreightAmount+TotalVATAmount,0) from SSInvoice where RefID='" + ID + "'")); if (tongxuat + tong > hanmuc) { XtraMessageBox.Show("Tổng số tiền mặt trong ngày vượt quá 20 triệu, vui lòng kiểm tra lại.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } gen.ExcuteNonquery("update INOutwardLPG set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "' where RefID in (select INOutwardRefID from (select Distinct INOutwardID from SSInvoiceINOutward where SSInvoiceID='" + ID + "') a, INOutward b where a.INOutwardID=b.RefID)"); gen.ExcuteNonquery("update DDH set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "' where RefIDInOutward in (select RefNo from (select Distinct INOutwardID from SSInvoiceINOutward where SSInvoiceID='" + ID + "') a, INOutward b where a.INOutwardID=b.RefID)"); gen.ExcuteNonquery("update INOutward set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "' where RefID in (select Distinct INOutwardID from SSInvoiceINOutward where SSInvoiceID='" + ID + "')"); gen.ExcuteNonquery("update SSInvoice set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "',CustomField5='" + makhach.Rows[0][3] + "' where RefID='" + ID + "'"); gen.ExcuteNonquery("update HACHTOAN set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectIDMain='" + makhach.Rows[0][0] + "' where RefID='" + ID + "'"); gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Đổi mã khách','" + chungtu + " " + txtsct.Text + "=" + searchLookUpEdit1.EditValue + "')"); XtraMessageBox.Show("Mã khách < " + txtsct.Text + " > đã được đổi thành < " + searchLookUpEdit1.EditValue + " > vui lòng kiểm tra lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch { XtraMessageBox.Show("Bạn phải chọn mã khách mới.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (tsbt == "tsbtddhlpgchange") { DataTable makhach = gen.GetTable("select AccountingObjectID,AccountingObjectName,Address,CompanyTaxCode from hamaco.dbo.AccountingObject where AccountingObjectCode='" + searchLookUpEdit1.EditValue + "'"); //DataTable makhach_ta = gen.GetTable("select AccountingObjectID,AccountingObjectName,Address,CompanyTaxCode from hamaco_ta.dbo.AccountingObject where AccountingObjectCode='" + searchLookUpEdit1.EditValue + "'"); //DataTable makhach_tn = gen.GetTable("select AccountingObjectID,AccountingObjectName,Address,CompanyTaxCode from hamaco_tn.dbo.AccountingObject where AccountingObjectCode='" + searchLookUpEdit1.EditValue + "'"); //gen.ExcuteNonquery("update hamaco.dbo.INOutward set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "' where INOutwardRefID='" + ID + "'"); //gen.ExcuteNonquery("update hamaco_ta.dbo.INOutward set AccountingObjectID='" + makhach_ta.Rows[0][0] + "',AccountingObjectName=N'" + makhach_ta.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach_ta.Rows[0][2] + "' where INOutwardRefID='" + ID + "'"); //gen.ExcuteNonquery("update hamaco_tn.dbo.INOutward set AccountingObjectID='" + makhach_tn.Rows[0][0] + "',AccountingObjectName=N'" + makhach_tn.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach_tn.Rows[0][2] + "' where INOutwardRefID='" + ID + "'"); gen.ExcuteNonquery("update INOutwardLPG set AccountingObjectID='" + makhach.Rows[0][0] + "',AccountingObjectName=N'" + makhach.Rows[0][1] + "',AccountingObjectAddress=N'" + makhach.Rows[0][2] + "' where RefID='" + ID + "'"); XtraMessageBox.Show("Mã khách < " + txtsct.Text + " > đã được đổi thành < " + searchLookUpEdit1.EditValue + " > vui lòng kiểm tra lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { try { string ton = null; if (tsbt == "tsbthdbh") { ton = gen.GetString("select * from SSInvoice where RefNo='" + textEdit1.Text + "'"); } else if (tsbt == "tsbthdmh") { ton = gen.GetString("select * from PUInvoice where RefNo='" + textEdit1.Text + "'"); } XtraMessageBox.Show("Số phiếu < " + textEdit1.Text + " > đã có trong hệ thống vui lòng xem lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { if (tsbt == "tsbthdbh") { gen.ExcuteNonquery("update SSInvoice set RefNo='" + textEdit1.Text + "' where RefID='" + ID + "'"); } else if (tsbt == "tsbthdmh") { gen.ExcuteNonquery("update PUInvoice set RefNo='" + textEdit1.Text + "' where RefID='" + ID + "'"); } gen.ExcuteNonquery("update HACHTOAN set RefNo='" + textEdit1.Text + "' where RefID='" + ID + "'"); this.myac(); gen.ExcuteNonquery("insert into MSC_Auditting_Log(EventID,LoginName,ComputerName,Time,PermissionTypeAlias,Reference) values(newid(),'" + gen.GetString("select UserName from MSC_User where UserID='" + userid + "'").ToString() + "','" + System.Environment.MachineName + "',GETDATE(),N'Đổi phiếu','" + txtsct.Text + "=" + textEdit1.Text + "')"); XtraMessageBox.Show("Số phiếu < " + txtsct.Text + " > đã được đổi thành < " + textEdit1.Text + " > vui lòng kiểm tra lại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } } }
private void tsbtsave_Click(object sender, EventArgs e) { string loai = gen.GetString("select * from InventoryItemCategory where InventoryCategoryCode='" + leloai.EditValue.ToString().Trim() + "'"); int tc = Convert.ToInt32(letc.EditValue.ToString()); string thue = "0"; string tlcd, dgtk; if (txttlcd.Text == "") { tlcd = "NULL"; } else { tlcd = txttlcd.Text.Replace(".", "").Replace(",", "."); } if (txtdgtk.Text == "") { dgtk = "NULL"; } else { dgtk = txtdgtk.Text.Replace(".", "").Replace(",", "."); } if (txtcode.Text == "") { MessageBox.Show("Mã vật tư, hàng hóa không được bỏ trống.", "HAMACO"); } else if (txtname.Text == "") { MessageBox.Show("Tên vật tư hàng hóa không được bỏ trống.", "HAMACO"); } { if (active == "1") { try { string mb = gen.GetString("select * from hamaco.dbo.InventoryItem where InventoryItemCode='" + lemb.Text + "'"); gen.ExcuteNonquery("update hamaco.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ", Parent='" + mb + "',SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_ta.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ", Parent='" + mb + "',SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_tn.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ", Parent='" + mb + "',SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_vithanh.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ", Parent='" + mb + "',SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_qlk.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ", Parent='" + mb + "',SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); } catch { gen.ExcuteNonquery("update hamaco.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ",SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_ta.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ",SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_tn.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ",SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_vithanh.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ",SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); gen.ExcuteNonquery("update hamaco_qlk.dbo.InventoryItem set InventoryItemName=N'" + txtname.Text + "',Unit=N'" + txtdvt.Text + "',ConvertUnit=N'" + txtdvcd.Text + "',ConvertRate=" + tlcd + ",GuarantyPeriod=N'" + txtthbh.Text + "',Inactive='" + chbntdoi.Checked.ToString() + "',InventoryCategoryID='" + loai + "',TaxRate='" + thue + "',InventoryItemType='" + tc + "',SalePrice=" + dgtk + ",SaleDescription=N'" + txtnganhhang.Text + "',PurchaseDescription=N'" + txtnhomhang.Text + "', IsSystem='" + chhkm.Checked + "' where InventoryItemCode='" + txtcode.Text + "'"); } this.myac(); this.Close(); } else { try { string mb = gen.GetString("select * from hamaco.dbo.InventoryItem where InventoryItemCode='" + lemb.Text + "'"); ii.checkii(active, txtcode, txtname, "insert into hamaco.dbo.InventoryItem(InventoryItemID,InventoryCategoryID,InventoryItemCode,InventoryItemName,GuarantyPeriod,Unit,ConvertUnit,ConvertRate,SalePrice,TaxRate,InventoryItemType,Inactive,Parent,SaleDescription,PurchaseDescription,IsSystem) values(newid(),'" + loai + "','" + txtcode.Text + "',N'" + txtname.Text + "',N'" + txtthbh.Text + "',N'" + txtdvt.Text + "',N'" + txtdvcd.Text + "'," + tlcd + "," + dgtk + ",'" + thue + "','" + tc + "','" + chbntdoi.Checked.ToString() + "','" + mb + "',N'" + txtnganhhang.Text + "',N'" + txtnhomhang.Text + "','" + chhkm.Checked + "')", this); } catch { ii.checkii(active, txtcode, txtname, "insert into hamaco.dbo.InventoryItem(InventoryItemID,InventoryCategoryID,InventoryItemCode,InventoryItemName,GuarantyPeriod,Unit,ConvertUnit,ConvertRate,SalePrice,TaxRate,InventoryItemType,Inactive,SaleDescription,PurchaseDescription,IsSystem) values(newid(),'" + loai + "','" + txtcode.Text + "',N'" + txtname.Text + "',N'" + txtthbh.Text + "',N'" + txtdvt.Text + "',N'" + txtdvcd.Text + "'," + tlcd + "," + dgtk + ",'" + thue + "','" + tc + "','" + chbntdoi.Checked.ToString() + "',N'" + txtnganhhang.Text + "',N'" + txtnhomhang.Text + "','" + chhkm.Checked + "')", this); } } } }
private void btok_Click(object sender, EventArgs e) { gen.ExcuteNonquery("delete from MSC_UserJoinRole where UserID='" + role + "'"); gen.ExcuteNonquery("insert into MSC_UserJoinRole values(newid(),'" + role + "','" + view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString() + "','4eb226e3-fb42-4ab4-b82e-7021d2322b40')"); this.Close(); }