private void AddNewMH() { string ham = ""; if (LOAI == "X") { ham = "MAT_HANG_HDX_NHAP "; } else if (LOAI == "N") { ham = "MAT_HANG_HDN_NHAP "; } string sql = ham + " '" + UserInformation.PQ + "','" + UserInformation.MaDV + "','" + lblMaHD.Text + "','" + txtMaMH.Text.Trim() + "','" + txtDongiaMH.Text.Trim() + "','" + txtSoluongMH.Text.Trim() + "','" + txtTienChietkhauMH.Text.Trim() + "', 'C'"; int _ok = DatLoa.AddNew(sql); if (_ok > 0) { _pMode = "ADD_MH"; ViewMode(); loadData(); } }
private void AddNew() { string sql = "NHOM_HANG_NHAP N'" + UserInformation.PQ + "',N'" + TxtName.Text.Trim() + "'"; int _ok = DatLoa.AddNew(sql); if (_ok > 0) { loadData(); _pMode = ""; ViewMode(); DesFor.ColorChange(ref DesFor.BtnChange); DesFor.AlignCenterToScreen(); } }
/// <summary> /// Thực thi đăng nhập /// </summary> /// <param name="sSql"></param> private void btnCommit_Click(object sender, EventArgs e) { #region Kiểm tra thông tin đầu vào if (txtOLDpass.Text != UserInformation.Pass) { MessageBox.Show("Mật khẩu cũ sai", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtNEWpass.Text != txtNEWpasscheck.Text) { MessageBox.Show("Xác nhận mật khẩu sai", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtNEWpass.Text == txtOLDpass.Text) { MessageBox.Show("Mật khẩu mới không được giống mật khẩu cũ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtNEWpass.Text == "") { MessageBox.Show("Mật khẩu không được trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } #endregion string sql = "PASS_CHANGE '" + UserInformation.Code + "' , '" + txtNEWpass.Text + "'"; int _ok = DatLoa.AddNew(sql); if (_ok >= 0) { MyApp.MSSQLConnectionString = MyApp.GetLoginMSSQL(MyApp.gHostDB, MyApp.gServiceNameDB, MyApp.gUserDB, txtNEWpass.Text); UserInformation.Pass = txtNEWpass.Text; this.DialogResult = DialogResult.OK; this.Close(); } }
private void AddNew() { string sql = "KHACH_HANG_NHAP '" + UserInformation.PQ + "',N'" + TxtName.Text.Trim() + "',N'" + txtDiaChi.Text.Trim() + "','" + TxtSDT.Text.Trim() + "','" + txtEmail.Text.Trim() + "','" + cbbLoai.Text.Trim() + "'," + txtTThai.Text.Trim(); int _ok = DatLoa.AddNew(sql); if (_ok > 0) { loadData(); _pMode = ""; ViewMode(); DesFor.ColorChange(ref DesFor.BtnChange); DesFor.AlignCenterToScreen(); } }
private void AddNew() { string sql = "MAT_HANG_NHAP '" + UserInformation.PQ + "','" + UserInformation.MaDV + "',N'" + TxtID.Text.Trim() + "',N'" + TxtName.Text.Trim() + "','" + TxtNhomHang.Text + "','" + TxtNhaCC.Text + "','" + TxtGiaNhap.Text.Trim() + "','" + TxtGiaBan.Text.Trim() + "'"; int _ok = DatLoa.AddNew(sql); if (_ok > 0) { loadData(); _pMode = ""; ViewMode(); DesFor.ColorChange(ref DesFor.BtnChange); DesFor.AlignCenterToScreen(); } }
private void AddNew() { Char vchkUsingCheck = chkUsingCheck.Checked ? 'C' : 'K'; Char vchkChangePWDLogon = chkChangePWDLogon.Checked ? 'Y' : 'N'; string sql = "USER_NHAP '" + UserInformation.PQ + "','" + TxtUserId.Text.Trim() + "',N'" + TxtUserName.Text.Trim() + "','" + dExpiredDate.Text.Trim() + "','" + txtBranchID.Text.Trim() + "','" + vchkUsingCheck + "','" + vchkChangePWDLogon + "'"; int _ok = DatLoa.AddNew(sql); if (_ok > 0) { loadData(); _pMode = ""; ViewMode(); DesFor.ColorChange(ref DesFor.BtnChange); DesFor.AlignCenterToScreen(); } }