private void btnLuu_Click(object sender, EventArgs e)
{
try
{
TiepQuyDAL.DV_INSERT_TIEPQUY(
DateTime.Now,
Thong_tin_dang_nhap.ma_cn,
Thong_tin_dang_nhap.maNV,
cbATMID.SelectedItem.ToString(),
soTo50,
soTo100,
soTo200,
soTo500
);
}
catch
{
ErrorMessageDAL.DataAccessError();
return;
}
KhoiTaoTiepQuy();
Thread th = new Thread(TaoFileTiepQuy);
th.Start();
}
private void btnLuu_Click(object sender, EventArgs e)
{
//Luu CSDL
KhoiTaoKiemQuy();
try
{
KiemQuyDAL.DV_INSERT_KIEMQUY(
tuNgay,
denNgay,
cbATMID.SelectedItem.ToString(),
tpKiemQuy,
qtTienTHT,
qtMonCHT,
qtTienCHT,
timeTCO,
timeCO,
timeCI,
soDuTCO,
soDuCO,
soDuCI,
txtGhiChuIPCAS1.Text,
txtGhiChuIPCAS2.Text,
txtGhiChuIPCAS3.Text,
timeSC,
timeCE,
fimiSC50,
fimiSC100,
fimiSC200,
fimiSC500,
fimiCE50,
fimiCE100,
fimiCE200,
fimiCE500,
demB50,
demB100,
demB200,
demB500,
demCC50,
demCC100,
demCC200,
demCC500,
demCL50,
demCL100,
demCL200,
demCL500,
thuaThieu,
txtNguyenNhan.Text,
txtKhacPhuc.Text
);
}
catch
{
ErrorMessageDAL.DataAccessError();
return;
}
//Tao file
TaoFileKiemQuy();
//Thread th = new Thread(TaoFileKiemQuy);
//th.Start();
}
void DSTheTheoCMND()
{
try
{
DataTable dt = TheDAL.TheTheoCMND(txtThongTin.Text);
FillData(dt);
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
void TatCaThe()
{
try
{
DataTable dt = TheDAL.TatCaThe(dtpTuNgay.Text, dtpDenNgay.Text);
FillData(dt);
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
void DSTheDaGiao()
{
try
{
DataTable dt = TheDAL.TheDaGiao(dtpTuNgay.Text, dtpDenNgay.Text);
FillData(dt);
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
private void btnDeleteThe_Click(object sender, EventArgs e)
{
string soThe = dgvThongTinThe.SelectedRows[0].Cells[3].Value.ToString();
string soTK = dgvThongTinThe.SelectedRows[0].Cells[2].Value.ToString();
string loaiThe = dgvThongTinThe.SelectedRows[0].Cells[4].Value.ToString();
try
{
The the = new The(ThongTinTheDAL.LayThongTinThe(soTK, loaiThe));
if (Thong_tin_dang_nhap.ma_pb != the.maPB)
{
MessageBox.Show("Không có quyền xóa thẻ này!\nLiên hệ chi nhánh phát hành thẻ để được hỗ trợ!", "Thông báo", MessageBoxButtons.OK);
return;
}
}
catch
{
ErrorMessageDAL.DataAccessError();
return;
}
DialogResult result = MessageBox.Show("Có chắc chắn xóa thẻ này?", "Thông báo", MessageBoxButtons.YesNo);
if (result == System.Windows.Forms.DialogResult.Yes)
{
try
{
if (string.IsNullOrEmpty(soThe))
{
TheDAL.XoaThe_TheoSoTK_LoaiThe(soTK, loaiThe);
}
else
{
TheDAL.XoaThe_TheoSoThe(soThe);
}
MessageBox.Show("Xóa thẻ " + soThe + " thành công!", "Thông báo", MessageBoxButtons.OK);
if (tcrlQuanLyThe.SelectedIndex == 1)
{
TimKiem_TheoThongTin();
}
else
{
TimKiem_TheoNgay();
}
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
}
void LayTTCanBo()
{
users = new List <User>();
usersKiemQuy = new List <User>();
try
{
DataTable dt = KiemQuyDAL.DV_DSNhanVien_MaCN(Thong_tin_dang_nhap.ma_cn);
for (int i = 0; i < dt.Rows.Count; i++)
{
var u = new User(dt.Rows[i]);
users.Add(u);
cbCanBo.Items.Add(u.tennv);
}
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
public frmThanhLapToVanChuyen()
{
InitializeComponent();
listDich = new List <string>();
listNguon = new List <string>();
users = new List <User>();
try
{
DataTable dt = KiemQuyDAL.DV_DSNhanVien_MaCN(Thong_tin_dang_nhap.ma_cn);
for (int i = 0; i < dt.Rows.Count; i++)
{
users.Add(new User(dt.Rows[i]));
cbToTruong.Items.Add(users[i].tennv);
cbGiamSat1.Items.Add(users[i].tennv);
cbGiamSat2.Items.Add(users[i].tennv);
}
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
public frmKiemQuy()
{
InitializeComponent();
listNguon = new List <string>();
listDich = new List <string>();
LayTTCanBo();
try
{
DataTable dt = KiemQuyDAL.DV_ATM_MACN();
for (int i = 0; i < dt.Rows.Count; i++)
{
cbATMID.Items.Add(dt.Rows[i]["ID"].ToString());
}
if (cbATMID.Items.Count > 0)
{
cbATMID.SelectedIndex = 0;
}
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
public frmThongTinThe(string soTK, string loaiThe)
{
InitializeComponent();
try
{
DataRow row = ThongTinTheDAL.LayThongTinThe(soTK, loaiThe);
if (row != null)
{
the = new The(row);
}
txtHoTen.Text = the.hoTen;
txtSoTK.Text = the.soTK;
txtSoThe.Text = the.soThe;
txtLoaiThe.Text = the.loaiThe;
txtHangThe.Text = the.hangThe;
txtHTPH.Text = the.hinhThucPhatHanh;
txtHTNT.Text = the.hinhThucNhanThe;
txtDTDD.Text = the.dtdd;
txtUser.Text = the.userPhatHanh;
DataRow rPb = ThongTinTheDAL.LayPhongBan(the.maPB);
if (!(bool)rPb["HS"])
{
txtNoiPhatHanh.Text = rPb["TENPB"].ToString();
}
else
{
txtNoiPhatHanh.Text = ThongTinTheDAL.LayTenChiNhanh(the.maPB);
}
if (the.maPB != Thong_tin_dang_nhap.ma_pb)
{
btnLuu.Enabled = false;
}
if (the.hmgd != 0)
{
txtHMGD.Text = the.hmgd.ToString();
}
txtNgayDangKy.Text = the.ngayDK.ToString("dd/MM/yyyy");
if (the.ngayNhan == DateTime.MinValue)
{
txtNgayNhanThe.Text = "";
}
else
{
txtNgayNhanThe.Text = the.ngayNhan.ToString("dd/MM/yyyy");
}
if (the.ngayGiao == DateTime.MinValue)
{
txtNgayGiaoThe.Text = "";
}
else
{
txtNgayGiaoThe.Text = the.ngayGiao.ToString("dd/MM/yyyy");
}
if (!string.IsNullOrEmpty(txtDTDD.Text))
{
ckbSMS.Checked = true;
}
if (!string.IsNullOrEmpty(txtHMGD.Text))
{
ckbInternet.Checked = true;
}
if (the.baoHiem)
{
ckbBaoHiem.Checked = true;
}
var txts = GetAll(this, typeof(TextBox));
var txtms = GetAll(this, typeof(MaskedTextBox));
foreach (var c in txts)
{
if (!string.IsNullOrEmpty(c.Text))
{
c.Enabled = false;
}
}
foreach (var c in txtms)
{
if (c.Text != " / /")
{
c.Enabled = false;
}
}
}
catch
{
ErrorMessageDAL.DataAccessError();
this.Close();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSoThe.Text))
{
MessageBox.Show("Hãy nhập số thẻ!", "Thông báo", MessageBoxButtons.OK);
txtSoThe.Focus();
return;
}
else
{
the.soThe = txtSoThe.Text;
}
//Check ngay nhan
if (CommonMethods.KiemTraNhapNgay(txtNgayNhanThe.Text))
{
the.ngayNhan = DateTime.ParseExact(txtNgayNhanThe.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
else
{
if (txtNgayGiaoThe.Text != " / /")
{
MessageBox.Show("Nhập sai định dạng ngày tháng!", "Thông báo", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Hãy nhập ngày nhận thẻ!", "Thông báo", MessageBoxButtons.OK);
}
txtNgayNhanThe.Focus();
return;
}
//check ngay giao
if (CommonMethods.KiemTraNhapNgay(txtNgayGiaoThe.Text))
{
the.ngayGiao = DateTime.ParseExact(txtNgayGiaoThe.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
try
{
ThongTinTheDAL.GiaoThe(the);
this.Close();
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
else
{
if (txtNgayGiaoThe.Text != " / /")
{
MessageBox.Show("Nhập sai định dạng ngày tháng!", "Thông báo", MessageBoxButtons.OK);
txtNgayGiaoThe.Focus();
return;
}
try
{
ThongTinTheDAL.NhanThe(the);
this.Close();
}
catch
{
ErrorMessageDAL.DataAccessError();
}
}
}
//public Version curVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
//string curVersion = Application.ProductVersion;
private bool Kiemtracapnhat()
{
bool has_update = false;
string newVersion = "";
// in newVersion variable we will store the
// version info from xml file
//Version newVersion = null;
// and in this variable we will put the url we
// would like to open so that the user can
// download the new version
// it can be a homepage or a direct
// link to zip/exe file
//string url = "";
//XmlTextReader reader = null;
try
{
// provide the XmlTextReader with the URL of
// our xml document
//string xmlURL = "http://192.168.1.150/update_crm.xml";
////string xmlURL = "http://10.14.0.30/update_crm.xml";
//reader = new XmlTextReader(xmlURL);
//// simply (and easily) skip the junk at the beginning
//reader.MoveToContent();
//// internal - as the XmlTextReader moves only
//// forward, we save current xml element name
//// in elementName variable. When we parse a
//// text node, we refer to elementName to check
//// what was the node name
//string elementName = "";
//// we check if the xml starts with a proper
//// "ourfancyapp" element node
//if ((reader.NodeType == XmlNodeType.Element) &&
// (reader.Name == "bss"))
//{
// while (reader.Read())
// {
// // when we find an element node,
// // we remember its name
// if (reader.NodeType == XmlNodeType.Element)
// elementName = reader.Name;
// else
// {
// // for text nodes...
// if ((reader.NodeType == XmlNodeType.Text) &&
// (reader.HasValue))
// {
// // we check what the name of the node was
// switch (elementName)
// {
// case "version":
// // thats why we keep the version info
// // in xxx.xxx.xxx.xxx format
// // the Version class does the
// // parsing for us
// newVersion = new Version(reader.Value);
// break;
// case "url":
// url = reader.Value;
// break;
// }
// }
// }
// }
//}
newVersion = DangNhapDAL.DV_GET_CURRENT_APP_VERSION(Application.ProductName);
//newVersion = new Version(newV);
}
catch (Exception)
{
ErrorMessageDAL.DataAccessError();
}
//finally
//{
// //if (reader != null) reader.Close();
//}
if (curVersion.CompareTo(newVersion) < 0)
{
// ask the user if he would like
// to download the new version
string title = "Thông báo cập nhật";
string question = "Phiên bản bạn đang dùng " + curVersion.ToString() + ". Đã có phiên bản mới " + newVersion.ToString() + ". Bạn có muốn tải về?";
if (DialogResult.Yes ==
MessageBox.Show(this, question, title,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
// navigate the default web
// browser to our app
// homepage (the url
// comes from the xml content)
//System.Diagnostics.Process.Start(url);
Process.Start(Application.StartupPath.ToString() + @"\BSS_UPDATE.exe");
has_update = true;
}
}
return(has_update);
}
void KhoiTaoTiepQuy()
{
listNguon.Clear();
listDich.Clear();
//TT CHUNG
listDich.Add("<CHI_NHANH>");
listNguon.Add(Thong_tin_dang_nhap.ten_cn.ToUpper());
listDich.Add("<KINH_GUI>");
listNguon.Add("Giám đốc " + Thong_tin_dang_nhap.ten_cn);
listDich.Add("<NGAY>");
listNguon.Add(DateTime.Now.Day.ToString());
listDich.Add("<THANG>");
listNguon.Add(DateTime.Now.Month.ToString());
listDich.Add("<NAM>");
listNguon.Add(DateTime.Now.Year.ToString());
listDich.Add("<ATM_ID>");
listNguon.Add(cbATMID.SelectedItem.ToString());
listDich.Add("<DIA_DIEM_ATM>");
try
{
listNguon.Add(TiepQuyDAL.DV_GET_DIADIEM_ATM(cbATMID.SelectedItem.ToString()));
}
catch
{
ErrorMessageDAL.DataAccessError();
return;
}
listDich.Add("<NGUOI_DE_NGHI>");
listNguon.Add(txtTenCanBo.Text);
listDich.Add("<PHONG>");
listNguon.Add(Thong_tin_dang_nhap.tenPb + "" + Thong_tin_dang_nhap.ten_cn);
//So to tiep quy
listDich.Add("<SO_TO_50>");
listNguon.Add(CommonMethods.ThemDauPhay(soTo50.ToString()));
listDich.Add("<SO_TO_100>");
listNguon.Add(CommonMethods.ThemDauPhay(soTo100.ToString()));
listDich.Add("<SO_TO_200>");
listNguon.Add(CommonMethods.ThemDauPhay(soTo200.ToString()));
listDich.Add("<SO_TO_500>");
listNguon.Add(CommonMethods.ThemDauPhay(soTo500.ToString()));
listDich.Add("<THANH_TIEN_50>");
listNguon.Add(CommonMethods.ThemDauPhay(tt50.ToString()));
listDich.Add("<THANH_TIEN_100>");
listNguon.Add(CommonMethods.ThemDauPhay(tt100.ToString()));
listDich.Add("<THANH_TIEN_200>");
listNguon.Add(CommonMethods.ThemDauPhay(tt200.ToString()));
listDich.Add("<THANH_TIEN_500>");
listNguon.Add(CommonMethods.ThemDauPhay(tt500.ToString()));
listDich.Add("<TONG_TIEN_SO>");
listNguon.Add(CommonMethods.ThemDauPhay(tong.ToString()));
listDich.Add("<TONG_TIEN_CHU>");
listNguon.Add(CommonMethods.FirstCharToUpper(CommonMethods.ChuyenSoSangChu(tong.ToString())));
}
