public void init(string dbfile, string Wdir, Boolean edit)
{
string sqlStr;
OleDbDataReader oleReader;
lstMaKH = new ArrayList();
dbname = dbfile;
ContractDB = new db(dbfile);
workingdir = Wdir;
sqlStr = "SELECT [MaHD], [MaKH], FORMAT([NgayHD], 'dd/mm/yyyy') AS NgayHD, [Tongtien], [Real], [Hoanthanh], [NoQH], [Laisuat]/100 AS LaiSuat, [Desc] FROM [HOPDONG] ORDER BY [MaHD]";
FillDG(sqlStr);
dtGridContracts.AllowUserToAddRows = false;
sqlStr = "SELECT [MaKH], [TenKH] FROM [KHACHHANG]";
oleReader = ContractDB.genDataReader(sqlStr);
if (oleReader == null)
{
MessageBox.Show("Loi ket noi den database");
return;
}
while (oleReader.Read())
{
cbxCusName.Items.Add(oleReader["TenKH"]);
lstMaKH.Add(oleReader["MaKH"]);
}
cbxCusName.Items.Add("All");
cbxCusName.Text = "All";
nhapdulieu = edit;
if (nhapdulieu == false)
cmdAdd.Enabled = false;
else cmdAdd.Enabled = true;
chk_Denhan();
//ShowDialog()
}
public void init(string dbname, string wdir)
{
int i;
Int64 tiendu;
CashDB = new db(dbname);
if (create_dtGrid() == false) return;
if (FillDG() == false) return;
dbfile = dbname;
realdata = false;
workingdir = wdir;
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Tienvao"].Value.ToString());
if (dtGridCash.Rows[i].Cells["Tienra"].Value != null)
tiendu = tiendu - Int64.Parse(dtGridCash.Rows[i].Cells["Tienra"].Value.ToString());
dtGridCash.Rows[i].Cells["Ducuoi"].Value = tiendu;
}
Tinh_So_Du();
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Ducuoi"].Value.ToString());
if (tiendu < 0)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
if (tiendu > 1000000000)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
this.ShowDialog();
}
public void init(string dbName)
{
string sqlStr;
string matien, sotien;
OleDbDataReader oleReader;
CashDB = new db(dbName);
sqlStr = "SELECT [Matien], [SoLuong] FROM [Tien]";
oleReader = CashDB.genDataReader(sqlStr);
if (oleReader == null)
return;
try
{
while (oleReader.Read())
{
matien = oleReader["Matien"].ToString();
sotien = oleReader["SoLuong"].ToString();
if (matien == "TienVon")
txtTienvon.Text = sotien;
else if (matien == "Tienlai")
txtLai.Text = sotien;
else txtTienmat.Text = sotien;
}
voncu = Int64.Parse(txtTienvon.Text);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
return;
}
}
public void init(string database, string username)
{
DataSet ds;
DataGridViewButtonColumn dtGridBt = new DataGridViewButtonColumn();
datafile = database;
dtGridUser.AllowUserToAddRows = true;
int i, cullCount;
string sqlString = "SELECT [Username] AS [Ten nguoi dung], [Locked] AS [Khoa] FROM [QUANLYUSER]";
dbUser = new db(database);
ds = dbUser.genDataset(sqlString);
dtGridUser.DataSource = ds.Tables[0];
dtGridBt.Width = 60;
dtGridBt.Text = "Cap nhat";
dtGridBt.Name = "capnhat";
dtGridBt.UseColumnTextForButtonValue = true;
for (i = 0; i < dtGridUser.Columns.Count; i++)
{
dtGridUser.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dtGridUser.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
dtGridUser.Columns.Add(dtGridBt);
cullCount = dtGridUser.Columns.Count;
for (i = 0; i < dtGridUser.Rows.Count; i++)
{
dtGridUser.Rows[i].Cells[cullCount - 1].Value = "Cap nhat";
}
dtGridUser.AllowUserToAddRows = false;
if (username != "admin")
cmdDelete.Enabled = false;
}
public void init(string dbname, string ngaydt, Int64 soducu, Int64 dunocuoiky, Boolean real)
{
string sqlStrVG, sqlStrVL;
string sqlStrRG, sqlStrRL;
CashDB = new db(dbname);
lblDunocu.Text = soducu.ToString();
lblSoducuoi.Text = dunocuoiky.ToString();
lblNgay.Text = ngaydt;
sqlStrVG = "SELECT [MaDT], [Sotien], [MaHD], [NoQH], [Datra], [Real], [Mota] FROM [DONGTIEN] ";
sqlStrVG = sqlStrVG + "WHERE [Sotien] > 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
sqlStrVG = sqlStrVG + "AND [Real] = Yes";
FillDG(sqlStrVG, dtGridGIn);
sqlStrVL = "SELECT [MaDT], [Sotienlai], [MaHD], [NoQH], [Datra], [Real], [Mota], [Tienchiulai], ([Laisuat] / 100) AS LaiSuat FROM [Tienlai] ";
sqlStrVL = sqlStrVL + "WHERE [Sotienlai] > 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
sqlStrVL = sqlStrVL + "AND [Real] = Yes";
FillDG(sqlStrVL, dtGridLIn);
sqlStrRG = "SELECT [MaDT], ABS([Sotien]) AS Tientra, [MaHD], [NoQH], [Datra], [Real], [Mota] FROM [DONGTIEN] ";
sqlStrRG = sqlStrRG + "WHERE [Sotien] < 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
sqlStrRG = sqlStrRG + "AND [Real] = Yes";
FillDG(sqlStrRG, dtGridGOut);
sqlStrRL = "SELECT [MaDT], ABS([Sotienlai]) AS Tienlaitra, [MaHD], [NoQH], [Datra], [Real], [Mota], [Tienchiulai], ([Laisuat] / 100) AS LaiSuat FROM [Tienlai] ";
sqlStrRL = sqlStrRL + "WHERE [Sotienlai] < 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
sqlStrRL = sqlStrVL + "AND [Real] = Yes";
FillDG(sqlStrRL, dtGridLOut);
this.Show();
}
/*
* Init function using to create object db for Quanlykhachhang
* And this function is using to import list custommer from database to form
*/
public void init(string dbFile)
{
string sqlString;
OleDbDataReader oleReader;
string LoaiKH;
int MaLoaiKH, i;
DataGridViewButtonColumn dtGridBt = new DataGridViewButtonColumn();
LoaiKHList = new ArrayList();
QlkhDb = new db(dbFile);
dbname = dbFile;
sqlString = "SELECT [MaLoaiKH], [TenLoaiKH] FROM [LOAIKH]";
dtGridKH.AllowUserToAddRows = true;
try
{
oleReader = QlkhDb.genDataReader(sqlString);
if (oleReader == null)
{
MessageBox.Show("Loi ket noi den database!");
this.Close();
return;
}
while(oleReader.Read())
{
MaLoaiKH = int.Parse(oleReader.GetValue(0).ToString());
LoaiKH = oleReader.GetString(1);
cbxLoaiKH.Items.Add(LoaiKH);
LoaiKHList.Add(MaLoaiKH);
}
cbxLoaiKH.Items.Add("All");
cbxLoaiKH.Text = cbxLoaiKH.Items[0].ToString();
sqlString = "SELECT [MAKH], [TenKH], [TaikhoanNH], [TenNH], [DinhDanh],[SoDT], [Diachi] FROM [KHACHHANG]";
QlkhDb.fillDtGridView(sqlString, dtGridKH);
for (i =0; i < dtGridKH.Columns.Count; i++)
{
dtGridKH.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
for (i = 0; i < dtGridKH.Rows.Count; i++)
{
if (rowColor)
dtGridKH.Rows[i].DefaultCellStyle.BackColor = activeC;
else dtGridKH.Rows[i].DefaultCellStyle.BackColor = NegativeC;
rowColor = !rowColor;
}
dtGridBt.Text = "...";
dtGridBt.Name = "Capnhat";
dtGridBt.Width = 60;
dtGridBt.HeaderText = "Cap nhat";
dtGridBt.UseColumnTextForButtonValue = true;
dtGridKH.Columns.Add(dtGridBt);
dtGridKH.AllowUserToAddRows = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
QlkhDb.close();
this.Close();
}
}
public void init(string dbname, string mahd, int intlaisuat)
{
CashDB = new db(dbname);
txtMaHD.Text = mahd;
laisuat = intlaisuat;
txtLaisuat.Text = float.Parse(laisuat.ToString()) / 100 + "";
dtGridCF.AllowUserToAddRows = false;
Tinhlailai();
dtGridCF.ReadOnly = true;
}
public void init(string dbname, string cusId)
{
string sqlStr;
OleDbDataReader oleReader;
string tenKH, dinhdanh, ngaycap, noicap, SoDT, Diachi, TKNH, TenNH, MaLoaiKH;
CusDb = new db(dbname);
txtCusCode.Text = cusId;
txtCusCode.Enabled = false;
sqlStr = "SELECT [TenKH], [DinhDanh], [Ngaycap], [Noicap], [SoDT], [Diachi], [TaikhoanNH], [TenNH], [MaLoaiKH]";
sqlStr = sqlStr + "FROM [KHACHHANG] WHERE [MaKH] ='" + cusId + "'";
oleReader = CusDb.genDataReader(sqlStr);
if (oleReader == null)
return;
if (oleReader.Read())
{
tenKH = oleReader["TenKH"].ToString();
dinhdanh = oleReader["DinhDanh"].ToString();
ngaycap = oleReader["Ngaycap"].ToString();
noicap = oleReader["Noicap"].ToString();
SoDT = oleReader["SoDT"].ToString();
Diachi = oleReader["Diachi"].ToString();
TKNH = oleReader["TaikhoanNH"].ToString();
TenNH = oleReader["TenNH"].ToString();
MaLoaiKH = oleReader["MaLoaiKH"].ToString();
if (tenKH.Length > 0)
this.txtCusName.Text = tenKH;
if (dinhdanh.Length > 0)
txtIdentCardNum.Text = dinhdanh;
if (ngaycap.Length > 0)
txtIssDate.Text = ngaycap;
if (noicap.Length > 0)
txtIssPlace.Text = noicap;
if (SoDT.Length > 0)
txtPhoneNum.Text = SoDT;
if (Diachi.Length > 0)
txtAddress.Text = Diachi;
if (TKNH.Length > 0)
txtAccount.Text = TKNH;
if (tenKH.Length > 0)
txtBank.Text = TenNH;
if (check_loai_KH(int.Parse(MaLoaiKH)))
{
chkPhanloai.Checked = false; //Khach hang doanh nghiep
lblIdenti.Text = "So DKKD";
}
else //Khach hang ca nhan
{
chkPhanloai.Checked = true;
lblIdenti.Text = "So CMT";
}
this.Text = "Chinh sua thong tin nguoi dung";
newuser = false;
}
}
public void init(string dbfilename, Boolean administrator)
{
dbName = dbfilename;
hdbhData = new db(dbName);
admin = administrator;
if (admin)
{
txtUser.Text = "admin";
txtUser.Enabled = false;
}
}
public Boolean init(string dbname, string workingdir)
{
string sqlStr;
OleDbDataReader oleReader;
contractDb = new db(dbname);
edit = false;
laisuat = 0;
MaHD = "";
HTTra = TraDinhKy;
optTraDK.Checked = true;
dbfile = dbname;
frmNhapTN = new NhapKyTraNo();
frmNhapTN.saved = false;
dirWork = workingdir;
if (contractDb == null)
{
MessageBox.Show("Loi ket noi den database");
this.Close();
}
sqlStr = "SELECT [MaKH] FROM [KHACHHANG] ORDER BY [MaKH]";
try
{
oleReader = contractDb.genDataReader(sqlStr);
while (oleReader.Read())
{
cbxMaKH.Items.Add(oleReader[0].ToString());
}
cbxMaKH.Text = cbxMaKH.Items[0].ToString();
sqlStr = "SELECT [LaiSuat], [LoaiLS] FROM [LAISUAT]";
oleReader = contractDb.genDataReader(sqlStr);
LSChovay = new ArrayList();
LSHuydong = new ArrayList();
while (oleReader.Read())
{
if (oleReader["LoaiLS"].ToString() == "1")
{
LSChovay.Add(oleReader["LaiSuat"].ToString());
cbxLaisuat.Items.Add(oleReader["LaiSuat"].ToString());
}
else LSHuydong.Add(oleReader["LaiSuat"].ToString());
}
Create_List_CT();
return true;
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
contractDb.close();
this.Close();
return false;
}
}
public void init(string dbfile)
{
string sqlString, user;
OleDbDataReader oleReader;
useridlist = new ArrayList();
dbFileName = dbfile;
roledb = new db(dbFileName);
sqlString = "SELECT DISTINCT UserName FROM [UserRole] WHERE RoleID <> 8";
oleReader = roledb.genDataReader(sqlString);
while (oleReader.Read())
{
user = oleReader.GetString(0);
cbxUserName.Items.Add(user);
}
oleReader.Close();
cbxUserName.Text = cbxUserName.Items[0].ToString();
}
/*
* Init function using to create object db for Quanlykhachhang
* And this function is using to import list custommer from database to form
*/
public void init(string dbFile, string dbuser, int dbport)
{
string sqlString;
OleDbDataReader oleReader;
string LoaiKH;
int MaLoaiKH, i;
LoaiKHList = new ArrayList();
QlkhDb = new db(dbFile, dbuser, dbport);
sqlString = "SELECT [MaLoaiKH], [LoaiKH] FROM [LOAIKH]";
try
{
oleReader = QlkhDb.genDataReader(sqlString);
if (oleReader == null)
{
MessageBox.Show("Loi ket noi den database!");
this.Close();
}
while(oleReader.Read())
{
MaLoaiKH = int.Parse(oleReader.GetValue(0).ToString());
LoaiKH = oleReader.GetString(1);
cbxLoaiKH.Items.Add(LoaiKH);
LoaiKHList.Add(MaLoaiKH);
}
cbxLoaiKH.Items.Add("All");
cbxLoaiKH.Text = cbxLoaiKH.Items[0].ToString();
sqlString = "SELECT [MAKH], [TenKH], [DinhDanh],[SoDT], [Diachi] FROM [KHACHHANG]";
QlkhDb.fillDtGridView(sqlString, dtGridKH);
for (i = 0; i < dtGridKH.Rows.Count; i++)
{
if (rowColor)
dtGridKH.Rows[i].DefaultCellStyle.BackColor = activeC;
else dtGridKH.Rows[i].DefaultCellStyle.BackColor = NegativeC;
rowColor = !rowColor;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
}
public void init(string dbname, string ngaydt, Int64 soducu, Int64 dunocuoiky, Boolean real)
{
string sqlStrVG, sqlStrVL;
string sqlStrRG, sqlStrRL;
CashDB = new db(dbname);
lblDunocu.Text = soducu.ToString();
lblSoducuoi.Text = dunocuoiky.ToString();
lblNgay.Text = ngaydt;
sqlStrVG = "SELECT [MaDT], [Sotien], [MaHD], [NoQH], [Datra], [Real], [Mota] FROM [DONGTIEN] ";
sqlStrVG = sqlStrVG + "WHERE [Sotien] > 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
{
sqlStrVG = sqlStrVG + "AND [Real] = Yes";
}
FillDG(sqlStrVG, dtGridGIn);
sqlStrVL = "SELECT [MaDT], [Sotienlai], [MaHD], [NoQH], [Datra], [Real], [Mota], [Tienchiulai], ([Laisuat] / 100) AS LaiSuat FROM [Tienlai] ";
sqlStrVL = sqlStrVL + "WHERE [Sotienlai] > 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
{
sqlStrVL = sqlStrVL + "AND [Real] = Yes";
}
FillDG(sqlStrVL, dtGridLIn);
sqlStrRG = "SELECT [MaDT], ABS([Sotien]) AS Tientra, [MaHD], [NoQH], [Datra], [Real], [Mota] FROM [DONGTIEN] ";
sqlStrRG = sqlStrRG + "WHERE [Sotien] < 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
{
sqlStrRG = sqlStrRG + "AND [Real] = Yes";
}
FillDG(sqlStrRG, dtGridGOut);
sqlStrRL = "SELECT [MaDT], ABS([Sotienlai]) AS Tienlaitra, [MaHD], [NoQH], [Datra], [Real], [Mota], [Tienchiulai], ([Laisuat] / 100) AS LaiSuat FROM [Tienlai] ";
sqlStrRL = sqlStrRL + "WHERE [Sotienlai] < 0 AND FORMAT([Ngaytra], 'dd/mm/yyyy') = '" + lblNgay.Text + "'";
if (realdata)
{
sqlStrRL = sqlStrVL + "AND [Real] = Yes";
}
FillDG(sqlStrRL, dtGridLOut);
this.Show();
}
public void init(string dbname, string wdir)
{
int i;
Int64 tiendu;
CashDB = new db(dbname);
if (create_dtGrid() == false)
{
return;
}
if (FillDG() == false)
{
return;
}
dbfile = dbname;
realdata = false;
workingdir = wdir;
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Tienvao"].Value.ToString());
if (dtGridCash.Rows[i].Cells["Tienra"].Value != null)
{
tiendu = tiendu - Int64.Parse(dtGridCash.Rows[i].Cells["Tienra"].Value.ToString());
}
dtGridCash.Rows[i].Cells["Ducuoi"].Value = tiendu;
}
Tinh_So_Du();
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Ducuoi"].Value.ToString());
if (tiendu < 0)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
if (tiendu > 1000000000)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
this.ShowDialog();
}
public void init(string dbName)
{
string sqlStr;
string matien, sotien;
OleDbDataReader oleReader;
CashDB = new db(dbName);
sqlStr = "SELECT [Matien], [SoLuong] FROM [Tien]";
oleReader = CashDB.genDataReader(sqlStr);
if (oleReader == null)
{
return;
}
try
{
while (oleReader.Read())
{
matien = oleReader["Matien"].ToString();
sotien = oleReader["SoLuong"].ToString();
if (matien == "TienVon")
{
txtTienvon.Text = sotien;
}
else if (matien == "Tienlai")
{
txtLai.Text = sotien;
}
else
{
txtTienmat.Text = sotien;
}
}
voncu = Int64.Parse(txtTienvon.Text);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
return;
}
}
private void MainPoint_Load(object sender, EventArgs e)
{
string sqlString;
OleDbDataReader oleReader;
config();
userdb = new db(dbFileName);
sqlString = "SELECT * FROM QUANLYUSER WHERE [Username] = 'admin'";
oleReader = userdb.genDataReader(sqlString);
if (oleReader == null)
{
this.Close();
Application.Exit();
return;
}
if (!oleReader.Read())
{
CreateUser frmCreateUser = new CreateUser();
frmCreateUser.Text = "Khoi tao user admin cho he thong";
frmCreateUser.init(dbFileName, true);
frmCreateUser.ShowDialog();
if (frmCreateUser.created == false)
{
this.Close();
}
return;
}
Login frmLogin = new Login();
frmLogin.init(dbFileName);
frmLogin.ShowDialog();
if (frmLogin.logined == false)
{
this.Close();
}
username = frmLogin.user;
check_role(username);
// userdb.Batch_Process();
}
public void init(string dbname, Boolean real, int namtien, Int64 sodu, string wdir)
{
int i;
Int64 tiendu;
CashDB = new db(dbname);
nam = namtien;
realdata = real;
create_dtGrid();
FillDG();
lblNam.Text = namtien.ToString();
dbfile = dbname;
workingdir = wdir;
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
dtGridCash.Rows[i].Cells["Ducuoi"].Value = Int64.Parse(dtGridCash.Rows[i].Cells["Tienvao"].Value.ToString()) - Int64.Parse(dtGridCash.Rows[i].Cells["Tienra"].Value.ToString());
}
dtGridCash.Rows[0].Cells["Ducuoi"].Value = Int64.Parse(dtGridCash.Rows[0].Cells["Ducuoi"].Value.ToString()) + sodu;
dunamtruoc = sodu;
lblDuno.Text = dunamtruoc.ToString();
Tinh_So_Du();
//Dua ra nguong canh bao voi dong tien
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Ducuoi"].Value.ToString());
if (tiendu < 0)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
if (tiendu > 1000000000)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
this.ShowDialog();
}
public void init(string dbfile, string Wdir, Boolean edit)
{
string sqlStr;
OleDbDataReader oleReader;
lstMaKH = new ArrayList();
dbname = dbfile;
ContractDB = new db(dbfile);
workingdir = Wdir;
sqlStr = "SELECT [MaHD], [MaKH], FORMAT([NgayHD], 'dd/mm/yyyy') AS NgayHD, [Tongtien], [Real], [Hoanthanh], [NoQH], [Laisuat]/100 AS LaiSuat, [Desc] FROM [HOPDONG] ORDER BY [MaHD]";
FillDG(sqlStr);
dtGridContracts.AllowUserToAddRows = false;
sqlStr = "SELECT [MaKH], [TenKH] FROM [KHACHHANG]";
oleReader = ContractDB.genDataReader(sqlStr);
if (oleReader == null)
{
MessageBox.Show("Loi ket noi den database");
return;
}
while (oleReader.Read())
{
cbxCusName.Items.Add(oleReader["TenKH"]);
lstMaKH.Add(oleReader["MaKH"]);
}
cbxCusName.Items.Add("All");
cbxCusName.Text = "All";
nhapdulieu = edit;
if (nhapdulieu == false)
{
cmdAdd.Enabled = false;
}
else
{
cmdAdd.Enabled = true;
}
chk_Denhan();
//ShowDialog()
}
public void init(string dbname, Boolean real, int namtien, Int64 sodu, string wdir)
{
int i;
Int64 tiendu;
CashDB = new db(dbname);
nam = namtien;
realdata = real;
create_dtGrid();
FillDG();
lblNam.Text = namtien.ToString();
dbfile = dbname;
workingdir = wdir;
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
dtGridCash.Rows[i].Cells["Ducuoi"].Value = Int64.Parse(dtGridCash.Rows[i].Cells["Tienvao"].Value.ToString()) - Int64.Parse(dtGridCash.Rows[i].Cells["Tienra"].Value.ToString());
}
dtGridCash.Rows[0].Cells["Ducuoi"].Value = Int64.Parse(dtGridCash.Rows[0].Cells["Ducuoi"].Value.ToString()) + sodu;
dunamtruoc = sodu;
lblDuno.Text = dunamtruoc.ToString();
Tinh_So_Du();
//Dua ra nguong canh bao voi dong tien
for (i = 0; i < dtGridCash.Rows.Count; i++)
{
tiendu = Int64.Parse(dtGridCash.Rows[i].Cells["Ducuoi"].Value.ToString());
if (tiendu < 0)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
if (tiendu > 1000000000)
{
dtGridCash.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
}
this.ShowDialog();
}
public void Save_Data(Boolean real, string MaHD, string dbname, Boolean chovay, int laisuat, double phiuythac)
{
string sqlStrG, sqlStrL, sqlStrP;
string tientraG, tientraL;
int i;
int lephi;
double lephiuythac_i, ngaychiulai, dunogoc;
TimeSpan difDays;
CashDB = new db(dbname);
lephi = (int)(phiuythac * 100);
for (i = 0; i < dtGridCF.Rows.Count; i++)
{
string ngaytra;
ngaytra = dtGridCF.Rows[i].Cells["Ngaytra"].Value.ToString();
tientraG = dtGridCF.Rows[i].Cells["Sotien"].Value.ToString();
tientraL = dtGridCF.Rows[i].Cells["Tienlai"].Value.ToString();
dunogoc = double.Parse(dtGridCF.Rows[i].Cells["Duno"].Value.ToString());
if (chovay == false)
{
tientraG = "-" + tientraG;
tientraL = "-" + tientraL;
}
sqlStrG = "INSERT INTO [DONGTIEN] ([MaHD], [NoQH], [Datra], [Real], [MoTa], [Sotien], [NgayTra]) ";
sqlStrG = sqlStrG + "VALUES ('" + MaHD +"', No, No, " + real.ToString() + ", 'Tra goc ky " + (i+1).ToString();
sqlStrG = sqlStrG + "', " + tientraG + ", '" + ngaytra + "')";
sqlStrL = "INSERT INTO [TIENLAI] ([MaHD], [NoQH], [Datra], [Real], [MoTa], [Sotienlai], [NgayTra], [Tienchiulai], [Laisuat])";
sqlStrL = sqlStrL + "VALUES ('" + MaHD + "', 0, No, " + real.ToString() + ", 'Tra lai ky " + (i+1).ToString();
sqlStrL = sqlStrL + "', " + tientraL + ", '" + ngaytra + "', " + dtGridCF.Rows[i].Cells["Duno"].Value.ToString();
sqlStrL = sqlStrL + ", " + laisuat + ")";
CashDB.runSQLCmd(sqlStrG);
CashDB.runSQLCmd(sqlStrL);
if (chovay == false)
{
difDays = DateTime.Parse(this.ngaytra).Subtract(DateTime.Parse(ngayvay));
ngaychiulai = (double)(difDays.Days);
lephiuythac_i = (double)Math.Round((decimal)(ngaychiulai * phiuythac * dunogoc) / (360 * 100));
sqlStrP = "INSERT INTO [TIENLAI] ([MaHD], NoQH, [Datra], [Real], [Mota], [Sotienlai], [Ngaytra], [Tienchiulai], [Laisuat]) VALUES";
sqlStrP = sqlStrP + "('" + MaHD + "', 0, No, " + real.ToString() + ", 'Phi uy thac quan ly von', ";
sqlStrP = sqlStrP + lephiuythac_i.ToString() + ", '" + ngaytra + "', " + Math.Abs(tongtien) + ", " + lephi.ToString() + ")";
CashDB.runSQLCmd(sqlStrP);
}
}
//Neu la tien cho vay phi se duoc tinh dua tren so tien gui ban dau
if (chovay == true)
{
difDays = DateTime.Parse(this.ngaytra).Subtract(DateTime.Parse(ngayvay));
ngaychiulai = (double)(difDays.Days);
lephiuythac_i = (double)Math.Round((decimal)(ngaychiulai * phiuythac * tongtien) / (360 * 100));
lephiuythac_i = Math.Abs(lephiuythac_i);
try
{
sqlStrP = "INSERT INTO [TIENLAI] ([MaHD], [NoQH], [Datra], [Real], [Mota], [Sotienlai], [Ngaytra], [Tienchiulai], [Laisuat]) VALUES";
sqlStrP = sqlStrP + "('" + MaHD + "', 0, No, " + real.ToString() + ", 'Phi dich vu cho vay bang', ";
sqlStrP = sqlStrP + lephiuythac_i.ToString() + ", '" + ngaytra + "', " + Math.Abs(tongtien) + ", " + lephi.ToString() + ")";
CashDB.runSQLCmd(sqlStrP);
}
catch (Exception ex)
{
return;
}
}
CashDB.close();
}
public void init(string user, string dbfile)
{
username = user;
pwddb = new db(dbfile);
}
public NhapKyTraNo(string dbname)
{
InitializeComponent();
CashDB = new db(dbname);
}
public void init(string dbname)
{
CusDb = new db(dbname);
newuser = true;
chkPhanloai.Checked = true;
}
public void init(string dbfilename, string dbuser, int dbport)
{
dbName = dbfilename;
hdbhData = new db(dbName, dbuser, dbport);
}
public void init(string user, string dbfile, string dbuser, int dbport)
{
username = user;
pwddb = new db(dbfile, dbuser, dbport);
}
public void init(string mahd, string dbname)
{
string sqlStrG, sqlStrL, sqlStr;
string matien;
OleDbDataReader oleReader;
Mahd = mahd;
int i;
try
{
CashDB = new db(dbname);
DatraG = new ArrayList();
DatraL = new ArrayList();
KytraG = new ArrayList();
KytraL = new ArrayList();
txtMaHD.Text = mahd;
sqlStr = "SELECT [SoLuong], [MaTien] FROM [TIEN]";
oleReader = CashDB.genDataReader(sqlStr);
if (oleReader == null)
{
return;
}
while (oleReader.Read())
{
matien = oleReader["Matien"].ToString();
if (matien == "TongTien")
{
tienmat = Int64.Parse(oleReader["SoLuong"].ToString());
}
if (matien == "Tienlai")
{
tienlai = Int64.Parse(oleReader["SoLuong"].ToString());
}
}
sqlStrG = "SELECT [MaDT], [Sotien], FORMAT([NgayTra], 'dd/mm/yyyy') AS Ngaytratien, [NoQH], [Datra], [Real] FROM [DONGTIEN] WHERE [MaHD] ='" + mahd + "'";
sqlStrL = "SELECT [MaDT], [Sotienlai], FORMAT([NgayTra], 'dd/mm/yyyy') AS Ngaytratien, [NoQH], [Datra], [Real] FROM [TIENLAI] WHERE [MaHD] ='" + mahd + "'";
FillDG(sqlStrG, ref dtGridCFG);
FillDG(sqlStrL, ref dtGridCFL);
if (dtGridCFL.Rows.Count == 0)
{
return;
}
if (dtGridCFG.Rows.Count == 0)
{
return;
}
dtGridCFL.Columns["MaDT"].ReadOnly = true;
dtGridCFL.Columns["Sotienlai"].ReadOnly = true;
dtGridCFL.Columns["Real"].ReadOnly = true;
dtGridCFL.Columns["Ngaytratien"].ReadOnly = true;
dtGridCFL.Columns["NoQH"].ReadOnly = true;
dtGridCFG.Columns["MaDT"].ReadOnly = true;
dtGridCFG.Columns["Sotien"].ReadOnly = true;
dtGridCFG.Columns["Real"].ReadOnly = true;
dtGridCFG.Columns["Ngaytratien"].ReadOnly = true;
dtGridCFG.Columns["NoQH"].ReadOnly = true;
for (i = 0; i < dtGridCFL.Rows.Count; i++)
{
DateTime ngaytralai = DateTime.Parse(dtGridCFL.Rows[i].Cells["Ngaytratien"].Value.ToString());
TimeSpan difDay = ngaytralai.Subtract(DateTime.Today);
if ((dtGridCFL.Rows[i].Cells["Datra"].Value.ToString() == "True") || (difDay.Days > 0))
{
KytraL.Add("False");
}
else
{
KytraL.Add("True");
}
if (dtGridCFL.Rows[i].Cells["Datra"].Value.ToString() == "True")
{
DatraL.Add("True");
}
else
{
DatraL.Add("False");
}
}
for (i = 0; i < dtGridCFG.Rows.Count; i++)
{
DateTime ngaytralai = DateTime.Parse(dtGridCFG.Rows[i].Cells["Ngaytratien"].Value.ToString());
TimeSpan difDay = ngaytralai.Subtract(DateTime.Today);
if ((dtGridCFG.Rows[i].Cells["Datra"].Value.ToString() == "True") || (difDay.Days > 0))
{
KytraG.Add("False");
}
else
{
KytraG.Add("True");
}
if (dtGridCFG.Rows[i].Cells["Datra"].Value.ToString() == "True")
{
DatraG.Add("True");
}
else
{
DatraG.Add("False");
}
}
this.ShowDialog();
}
catch (Exception ex)
{
return;
}
}
public void init(string user, string dbfile, string dbuser, int dbport)
{
username = user;
pwddb = new db(dbfile, dbuser, dbport);
}
public void init(string dbfilename, string dbuser, int dbport, Boolean administrator)
{
dbName = dbfilename;
hdbhData = new db(dbName, dbuser, dbport);
admin = administrator;
}
public void Save_Data(Boolean real, string MaHD, string dbname, Boolean chovay, int laisuat, double phiuythac)
{
string sqlStrG, sqlStrL, sqlStrP;
string tientraG, tientraL;
int i;
int lephi;
double lephiuythac_i, ngaychiulai, dunogoc;
TimeSpan difDays;
CashDB = new db(dbname);
lephi = (int)(phiuythac * 100);
for (i = 0; i < dtGridCF.Rows.Count; i++)
{
string ngaytra;
ngaytra = dtGridCF.Rows[i].Cells["Ngaytra"].Value.ToString();
tientraG = dtGridCF.Rows[i].Cells["Sotien"].Value.ToString();
tientraL = dtGridCF.Rows[i].Cells["Tienlai"].Value.ToString();
dunogoc = double.Parse(dtGridCF.Rows[i].Cells["Duno"].Value.ToString());
if (chovay == false)
{
tientraG = "-" + tientraG;
tientraL = "-" + tientraL;
}
sqlStrG = "INSERT INTO [DONGTIEN] ([MaHD], [NoQH], [Datra], [Real], [MoTa], [Sotien], [NgayTra]) ";
sqlStrG = sqlStrG + "VALUES ('" + MaHD + "', No, No, " + real.ToString() + ", 'Tra goc ky " + (i + 1).ToString();
sqlStrG = sqlStrG + "', " + tientraG + ", '" + ngaytra + "')";
sqlStrL = "INSERT INTO [TIENLAI] ([MaHD], [NoQH], [Datra], [Real], [MoTa], [Sotienlai], [NgayTra], [Tienchiulai], [Laisuat])";
sqlStrL = sqlStrL + "VALUES ('" + MaHD + "', 0, No, " + real.ToString() + ", 'Tra lai ky " + (i + 1).ToString();
sqlStrL = sqlStrL + "', " + tientraL + ", '" + ngaytra + "', " + dtGridCF.Rows[i].Cells["Duno"].Value.ToString();
sqlStrL = sqlStrL + ", " + laisuat + ")";
CashDB.runSQLCmd(sqlStrG);
CashDB.runSQLCmd(sqlStrL);
if (chovay == false)
{
difDays = DateTime.Parse(this.ngaytra).Subtract(DateTime.Parse(ngayvay));
ngaychiulai = (double)(difDays.Days);
lephiuythac_i = (double)Math.Round((decimal)(ngaychiulai * phiuythac * dunogoc) / (360 * 100));
sqlStrP = "INSERT INTO [TIENLAI] ([MaHD], NoQH, [Datra], [Real], [Mota], [Sotienlai], [Ngaytra], [Tienchiulai], [Laisuat]) VALUES";
sqlStrP = sqlStrP + "('" + MaHD + "', 0, No, " + real.ToString() + ", 'Phi uy thac quan ly von', ";
sqlStrP = sqlStrP + lephiuythac_i.ToString() + ", '" + ngaytra + "', " + Math.Abs(tongtien) + ", " + lephi.ToString() + ")";
CashDB.runSQLCmd(sqlStrP);
}
}
//Neu la tien cho vay phi se duoc tinh dua tren so tien gui ban dau
if (chovay == true)
{
difDays = DateTime.Parse(this.ngaytra).Subtract(DateTime.Parse(ngayvay));
ngaychiulai = (double)(difDays.Days);
lephiuythac_i = (double)Math.Round((decimal)(ngaychiulai * phiuythac * tongtien) / (360 * 100));
lephiuythac_i = Math.Abs(lephiuythac_i);
try
{
sqlStrP = "INSERT INTO [TIENLAI] ([MaHD], [NoQH], [Datra], [Real], [Mota], [Sotienlai], [Ngaytra], [Tienchiulai], [Laisuat]) VALUES";
sqlStrP = sqlStrP + "('" + MaHD + "', 0, No, " + real.ToString() + ", 'Phi dich vu cho vay bang', ";
sqlStrP = sqlStrP + lephiuythac_i.ToString() + ", '" + ngaytra + "', " + Math.Abs(tongtien) + ", " + lephi.ToString() + ")";
CashDB.runSQLCmd(sqlStrP);
}
catch (Exception ex)
{
return;
}
}
CashDB.close();
}
public void init(string dbname, string cusId)
{
string sqlStr;
OleDbDataReader oleReader;
string tenKH, dinhdanh, ngaycap, noicap, SoDT, Diachi, TKNH, TenNH, MaLoaiKH;
CusDb = new db(dbname);
txtCusCode.Text = cusId;
txtCusCode.Enabled = false;
sqlStr = "SELECT [TenKH], [DinhDanh], [Ngaycap], [Noicap], [SoDT], [Diachi], [TaikhoanNH], [TenNH], [MaLoaiKH]";
sqlStr = sqlStr + "FROM [KHACHHANG] WHERE [MaKH] ='" + cusId + "'";
oleReader = CusDb.genDataReader(sqlStr);
if (oleReader == null)
{
return;
}
if (oleReader.Read())
{
tenKH = oleReader["TenKH"].ToString();
dinhdanh = oleReader["DinhDanh"].ToString();
ngaycap = oleReader["Ngaycap"].ToString();
noicap = oleReader["Noicap"].ToString();
SoDT = oleReader["SoDT"].ToString();
Diachi = oleReader["Diachi"].ToString();
TKNH = oleReader["TaikhoanNH"].ToString();
TenNH = oleReader["TenNH"].ToString();
MaLoaiKH = oleReader["MaLoaiKH"].ToString();
if (tenKH.Length > 0)
{
this.txtCusName.Text = tenKH;
}
if (dinhdanh.Length > 0)
{
txtIdentCardNum.Text = dinhdanh;
}
if (ngaycap.Length > 0)
{
txtIssDate.Text = ngaycap;
}
if (noicap.Length > 0)
{
txtIssPlace.Text = noicap;
}
if (SoDT.Length > 0)
{
txtPhoneNum.Text = SoDT;
}
if (Diachi.Length > 0)
{
txtAddress.Text = Diachi;
}
if (TKNH.Length > 0)
{
txtAccount.Text = TKNH;
}
if (tenKH.Length > 0)
{
txtBank.Text = TenNH;
}
if (check_loai_KH(int.Parse(MaLoaiKH)))
{
chkPhanloai.Checked = false; //Khach hang doanh nghiep
lblIdenti.Text = "So DKKD";
}
else //Khach hang ca nhan
{
chkPhanloai.Checked = true;
lblIdenti.Text = "So CMT";
}
this.Text = "Chinh sua thong tin nguoi dung";
newuser = false;
}
}
public void init(string dbname)
{
CusDb = new db(dbname);
newuser = true;
chkPhanloai.Checked = true;
}
public void init(string dbname, string maHD, string workingdir)
{
string sqlStr;
OleDbDataReader oleReader;
contractDb = new db(dbname);
Int64 tongtien = 0;
int i;
MaHD = maHD;
edit = true;
dbfile = dbname;
txtMaHD.Text = maHD;
txtMaHD.Enabled = false;
cmdKytraShow.Enabled = false;
frmNhapTN = new NhapKyTraNo(dbname);
frmNhapTN.saved = false;
cmdViewContracts.Enabled = true;
cmdViewContracts.Visible = true;
dirWork = workingdir;
if (contractDb == null)
{
MessageBox.Show("Loi ket noi den database");
this.Close();
}
sqlStr = "SELECT [MaKH] FROM [KHACHHANG] ORDER BY [MaKH]";
oleReader = contractDb.genDataReader(sqlStr);
while (oleReader.Read())
{
cbxMaKH.Items.Add(oleReader[0].ToString());
}
sqlStr = "SELECT [MaKH], [NgayHD], [Tongtien], [Real], [Kyhan], [DonVT], [Laisuat], [Desc] FROM [HOPDONG]";
sqlStr = sqlStr + " WHERE [MaHD] = '" + maHD + "'";
try
{
oleReader = contractDb.genDataReader(sqlStr);
while (oleReader.Read())
{
cbxMaKH.Text = oleReader["MaKH"].ToString();
cbxMaKH.Enabled = false;
tongtien = Int64.Parse(oleReader["Tongtien"].ToString());
cbxKyhan.Text = oleReader["Kyhan"].ToString();
cbxKyhan.Enabled = false;
cbxDonvitinh.Text = oleReader["DonVT"].ToString();
cbxDonvitinh.Enabled = false;
chkReal.Checked = !(Boolean.Parse(oleReader["Real"].ToString()));
cbxDateContracts.Value = DateTime.Parse(oleReader["NgayHD"].ToString());
cbxDateContracts.Enabled = false;
txtDesc.Text = oleReader["Desc"].ToString();
laisuat = int.Parse(oleReader["Laisuat"].ToString());
cbxLaisuat.Text = float.Parse(laisuat.ToString()) / 100 + "";
oldLS = cbxLaisuat.Text;
// cbxLaisuat.Enabled = false;
}
if (chkReal.Checked == false)
{
chkReal.Enabled = false;
}
if (tongtien > 0)
{
cbxLoaiHD.Text = cbxLoaiHD.Items[1].ToString();
txtTongtien.Text = tongtien.ToString();
}
else
{
cbxLoaiHD.Text = cbxLoaiHD.Items[0].ToString();
tongtien = Math.Abs(tongtien);
txtTongtien.Text = tongtien.ToString();
}
txtTongtien.Enabled = false;
cbxLoaiHD.Enabled = false;
// cbxMaKH.Text = cbxMaKH.Items[0].ToString();
grBoxKytra.Enabled = false;
sqlStr = "SELECT [LaiSuat], [LoaiLS] FROM [LAISUAT]";
oleReader = contractDb.genDataReader(sqlStr);
LSChovay = new ArrayList();
LSHuydong = new ArrayList();
while (oleReader.Read())
{
if (oleReader["LoaiLS"].ToString() == "1")
{
LSChovay.Add(oleReader["LaiSuat"].ToString());
cbxLaisuat.Items.Add(oleReader["LaiSuat"].ToString());
}
else
{
LSHuydong.Add(oleReader["LaiSuat"].ToString());
}
}
Create_List_CT();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
contractDb.close();
this.Close();
}
}
public void init(string dbfilename, string dbuser, int dbport)
{
dbName = dbfilename;
hdbhData = new db(dbName, dbuser, dbport);
}
public void init(string dbfilename)
{
dbName = dbfilename;
hdbhData = new db(dbName);
}
public void init(string dbfilename, string dbuser, int dbport, Boolean administrator)
{
dbName = dbfilename;
hdbhData = new db(dbName, dbuser, dbport);
admin = administrator;
}
public void init(string dbname, string maHD, string workingdir)
{
string sqlStr;
OleDbDataReader oleReader;
contractDb = new db(dbname);
Int64 tongtien = 0;
int i;
MaHD = maHD;
edit = true;
dbfile = dbname;
txtMaHD.Text = maHD;
txtMaHD.Enabled = false;
cmdKytraShow.Enabled = false;
frmNhapTN = new NhapKyTraNo(dbname);
frmNhapTN.saved = false;
cmdViewContracts.Enabled = true;
cmdViewContracts.Visible = true;
dirWork = workingdir;
if (contractDb == null)
{
MessageBox.Show("Loi ket noi den database");
this.Close();
}
sqlStr = "SELECT [MaKH] FROM [KHACHHANG] ORDER BY [MaKH]";
oleReader = contractDb.genDataReader(sqlStr);
while (oleReader.Read())
{
cbxMaKH.Items.Add(oleReader[0].ToString());
}
sqlStr = "SELECT [MaKH], [NgayHD], [Tongtien], [Real], [Kyhan], [DonVT], [Laisuat], [Desc] FROM [HOPDONG]";
sqlStr = sqlStr + " WHERE [MaHD] = '" + maHD + "'";
try
{
oleReader = contractDb.genDataReader(sqlStr);
while (oleReader.Read())
{
cbxMaKH.Text = oleReader["MaKH"].ToString();
cbxMaKH.Enabled = false;
tongtien = Int64.Parse(oleReader["Tongtien"].ToString());
cbxKyhan.Text = oleReader["Kyhan"].ToString();
cbxKyhan.Enabled = false;
cbxDonvitinh.Text = oleReader["DonVT"].ToString();
cbxDonvitinh.Enabled = false;
chkReal.Checked = !(Boolean.Parse(oleReader["Real"].ToString()));
cbxDateContracts.Value = DateTime.Parse(oleReader["NgayHD"].ToString());
cbxDateContracts.Enabled = false;
txtDesc.Text = oleReader["Desc"].ToString();
laisuat = int.Parse(oleReader["Laisuat"].ToString());
cbxLaisuat.Text = float.Parse(laisuat.ToString()) / 100 + "";
oldLS = cbxLaisuat.Text;
// cbxLaisuat.Enabled = false;
}
if (chkReal.Checked == false)
chkReal.Enabled = false;
if (tongtien > 0)
{
cbxLoaiHD.Text = cbxLoaiHD.Items[1].ToString();
txtTongtien.Text = tongtien.ToString();
}
else
{
cbxLoaiHD.Text = cbxLoaiHD.Items[0].ToString();
tongtien = Math.Abs(tongtien);
txtTongtien.Text = tongtien.ToString();
}
txtTongtien.Enabled = false;
cbxLoaiHD.Enabled = false;
// cbxMaKH.Text = cbxMaKH.Items[0].ToString();
grBoxKytra.Enabled = false;
sqlStr = "SELECT [LaiSuat], [LoaiLS] FROM [LAISUAT]";
oleReader = contractDb.genDataReader(sqlStr);
LSChovay = new ArrayList();
LSHuydong = new ArrayList();
while (oleReader.Read())
{
if (oleReader["LoaiLS"].ToString() == "1")
{
LSChovay.Add(oleReader["LaiSuat"].ToString());
cbxLaisuat.Items.Add(oleReader["LaiSuat"].ToString());
}
else LSHuydong.Add(oleReader["LaiSuat"].ToString());
}
Create_List_CT();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
contractDb.close();
this.Close();
}
}
public void init(string dbfilename)
{
dbName = dbfilename;
hdbhData = new db(dbName);
}
public NhapKyTraNo(string dbname)
{
InitializeComponent();
CashDB = new db(dbname);
}
/*
* Init function using to create object db for Quanlykhachhang
* And this function is using to import list custommer from database to form
*/
public void init(string dbFile)
{
string sqlString;
OleDbDataReader oleReader;
string LoaiKH;
int MaLoaiKH, i;
DataGridViewButtonColumn dtGridBt = new DataGridViewButtonColumn();
LoaiKHList = new ArrayList();
QlkhDb = new db(dbFile);
dbname = dbFile;
sqlString = "SELECT [MaLoaiKH], [TenLoaiKH] FROM [LOAIKH]";
dtGridKH.AllowUserToAddRows = true;
try
{
oleReader = QlkhDb.genDataReader(sqlString);
if (oleReader == null)
{
MessageBox.Show("Loi ket noi den database!");
this.Close();
return;
}
while (oleReader.Read())
{
MaLoaiKH = int.Parse(oleReader.GetValue(0).ToString());
LoaiKH = oleReader.GetString(1);
cbxLoaiKH.Items.Add(LoaiKH);
LoaiKHList.Add(MaLoaiKH);
}
cbxLoaiKH.Items.Add("All");
cbxLoaiKH.Text = cbxLoaiKH.Items[0].ToString();
sqlString = "SELECT [MAKH], [TenKH], [TaikhoanNH], [TenNH], [DinhDanh],[SoDT], [Diachi] FROM [KHACHHANG]";
QlkhDb.fillDtGridView(sqlString, dtGridKH);
for (i = 0; i < dtGridKH.Columns.Count; i++)
{
dtGridKH.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
for (i = 0; i < dtGridKH.Rows.Count; i++)
{
if (rowColor)
{
dtGridKH.Rows[i].DefaultCellStyle.BackColor = activeC;
}
else
{
dtGridKH.Rows[i].DefaultCellStyle.BackColor = NegativeC;
}
rowColor = !rowColor;
}
dtGridBt.Text = "...";
dtGridBt.Name = "Capnhat";
dtGridBt.Width = 60;
dtGridBt.HeaderText = "Cap nhat";
dtGridBt.UseColumnTextForButtonValue = true;
dtGridKH.Columns.Add(dtGridBt);
dtGridKH.AllowUserToAddRows = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
QlkhDb.close();
this.Close();
}
}
private void MainPoint_Load(object sender, EventArgs e)
{
string sqlString;
OleDbDataReader oleReader;
config();
userdb = new db(dbFileName, dbuser, dbport);
sqlString = "SELECT * FROM QUANLYUSER";
oleReader = userdb.genDataReader(sqlString);
if (oleReader == null)
{
this.Close();
Application.Exit();
return;
}
if (!oleReader.Read())
{
CreateUser frmCreateUser = new CreateUser();
frmCreateUser.Text = "Khoi tao user admin cho he thong";
frmCreateUser.init(dbFileName, dbuser, dbport, true);
frmCreateUser.ShowDialog();
if (frmCreateUser.created == false)
this.Close();
return;
}
Login frmLogin = new Login();
frmLogin.init(dbFileName, dbuser, dbport);
frmLogin.ShowDialog();
if (frmLogin.logined == false)
this.Close();
username = frmLogin.user;
check_role(username);
}
public void init(string mahd, string dbname)
{
string sqlStrG, sqlStrL, sqlStr;
string matien;
OleDbDataReader oleReader;
Mahd = mahd;
int i;
try
{
CashDB = new db(dbname);
DatraG = new ArrayList();
DatraL = new ArrayList();
KytraG = new ArrayList();
KytraL = new ArrayList();
txtMaHD.Text = mahd;
sqlStr = "SELECT [SoLuong], [MaTien] FROM [TIEN]";
oleReader = CashDB.genDataReader(sqlStr);
if (oleReader == null)
return;
while (oleReader.Read())
{
matien = oleReader["Matien"].ToString();
if (matien == "TongTien")
tienmat = Int64.Parse(oleReader["SoLuong"].ToString());
if (matien == "Tienlai") tienlai = Int64.Parse(oleReader["SoLuong"].ToString());
}
sqlStrG = "SELECT [MaDT], [Sotien], FORMAT([NgayTra], 'dd/mm/yyyy') AS Ngaytratien, [NoQH], [Datra], [Real] FROM [DONGTIEN] WHERE [MaHD] ='" + mahd + "'";
sqlStrL = "SELECT [MaDT], [Sotienlai], FORMAT([NgayTra], 'dd/mm/yyyy') AS Ngaytratien, [NoQH], [Datra], [Real] FROM [TIENLAI] WHERE [MaHD] ='" + mahd + "'";
FillDG(sqlStrG, ref dtGridCFG);
FillDG(sqlStrL, ref dtGridCFL);
if (dtGridCFL.Rows.Count == 0)
return;
if (dtGridCFG.Rows.Count == 0)
return;
dtGridCFL.Columns["MaDT"].ReadOnly = true;
dtGridCFL.Columns["Sotienlai"].ReadOnly = true;
dtGridCFL.Columns["Real"].ReadOnly = true;
dtGridCFL.Columns["Ngaytratien"].ReadOnly = true;
dtGridCFL.Columns["NoQH"].ReadOnly = true;
dtGridCFG.Columns["MaDT"].ReadOnly = true;
dtGridCFG.Columns["Sotien"].ReadOnly = true;
dtGridCFG.Columns["Real"].ReadOnly = true;
dtGridCFG.Columns["Ngaytratien"].ReadOnly = true;
dtGridCFG.Columns["NoQH"].ReadOnly = true;
for (i = 0; i < dtGridCFL.Rows.Count; i++)
{
DateTime ngaytralai = DateTime.Parse(dtGridCFL.Rows[i].Cells["Ngaytratien"].Value.ToString());
TimeSpan difDay = ngaytralai.Subtract(DateTime.Today);
if ((dtGridCFL.Rows[i].Cells["Datra"].Value.ToString() == "True") || (difDay.Days > 0))
{
KytraL.Add("False");
}
else KytraL.Add("True");
if (dtGridCFL.Rows[i].Cells["Datra"].Value.ToString() == "True")
DatraL.Add("True");
else DatraL.Add("False");
}
for (i = 0; i < dtGridCFG.Rows.Count; i++)
{
DateTime ngaytralai = DateTime.Parse(dtGridCFG.Rows[i].Cells["Ngaytratien"].Value.ToString());
TimeSpan difDay = ngaytralai.Subtract(DateTime.Today);
if ((dtGridCFG.Rows[i].Cells["Datra"].Value.ToString() == "True") || (difDay.Days > 0))
{
KytraG.Add("False");
}
else
{
KytraG.Add("True");
}
if (dtGridCFG.Rows[i].Cells["Datra"].Value.ToString() == "True")
{
DatraG.Add("True");
}
else DatraG.Add("False");
}
this.ShowDialog();
}
catch (Exception ex)
{
return;
}
}