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