public frmTK_CLSPDV()
{
InitializeComponent();
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.MaximizeBox = false;
this.StartPosition = FormStartPosition.CenterScreen;
dataGridViewX2.RowHeadersVisible = false;
dataGridViewX2.AllowUserToAddRows = false;
dataGridViewX2.ReadOnly = true;
dataGridViewX2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridViewX2.MultiSelect = false;
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Tất cả";
dt.Rows.InsertAt(first_row, 0);
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
}
private void frmTK_KeHoach_Load(object sender, EventArgs e)
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Tất cả";
dt.Rows.InsertAt(first_row, 0);
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
optCN.Checked = true;
layDS_Tieuchi();
layLoaiKH();
if (Thongtindangnhap.macn != Thongtindangnhap.ma_hoi_so)
{
//cbCN.Text = CRM.frmDangnhap.macn;
cbCN.Enabled = false;
}
else
{
cbCN.Enabled = true;
}
}
private void layDS_CN()
{
//cbbMaCN.DataSource = null;
//cbbMaCN.Items.Clear();
//cbbMaCN.Refresh();
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
//DataRow first_row = dt.NewRow();
//first_row[0] = "Tất cả";
//dt.Rows.InsertAt(first_row, 0);
cbbMaCN.DataSource = dt;
cbbMaCN.DisplayMember = "MACN";
cbbMaCN.ValueMember = "MACN";
//cbbMaCN.DataSource = dt;
cbbMaCN.SelectedValue = Thongtindangnhap.macn;
//strCmd = "SELECT * FROM CHINHANH ";
//SqlDataAdapter adapter = new SqlDataAdapter();
//try
//{
// frmMain.conn.Open();
// adapter.SelectCommand = new SqlCommand(strCmd, frmMain.conn);
// adapter.SelectCommand.ExecuteReader();
// frmMain.conn.Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.ToString());
//}
//DataSet ds = new DataSet();
//adapter.Fill(ds);
//dtResult = ds.Tables[0];
//int iRows = dtResult.Rows.Count;
//for (int i = 0; i < iRows; i++)
//{
// try
// {
// cbbMaCN.Items.Add(dtResult.Rows[i]["MaCN"].ToString());
// //arrPhong.Add(dtResult.Rows[i]["MaPB"].ToString());
// //arrChucvu.Add(dtResult.Rows[i]["Chucvu"].ToString());
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
//}
//cbbMaCN.Text = frmMain.cn;
}
private void frmKSKhachHang_Load(object sender, EventArgs e)
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
}
public frmKSDTKH()
{
InitializeComponent();
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
}
private void frmCSKH_GiamSat_Load(object sender, EventArgs e)
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Tất cả";
dt.Rows.InsertAt(first_row, 0);
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
if (Thongtindangnhap.macn != Thongtindangnhap.ma_hoi_so)
{
//cbCN.Text = Thongtindangnhap.macn;
cbCN.Enabled = false;
}
}
private void layDS_CN()
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
//cbbMaCN.DataSource = dt;
cbbMaCN.DisplayMember = "MACN";
cbbMaCN.ValueMember = "MACN";
cbbMaCN.DataSource = dt;
cbbMaCN.SelectedValue = Thongtindangnhap.macn;
}
private void frmHH_TKVIPCT_Load(object sender, EventArgs e)
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Tất cả";
dt.Rows.InsertAt(first_row, 0);
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
//cbCN.SelectedValue = Thongtindangnhap.macn;
cbCN.Text = "Tất cả";
}
public frmTK19892b()
{
InitializeComponent();
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Tất cả";
dt.Rows.InsertAt(first_row, 0);
//cbCN.DataSource = dt;
cbCN.DisplayMember = "MACN";
cbCN.ValueMember = "MACN";
cbCN.DataSource = dt;
cbCN.SelectedValue = Thongtindangnhap.macn;
}
private void frmKH_TKKHTNCN_Load(object sender, EventArgs e)
{
DataTable dt = cnbus.DANH_SACH_MA_CHI_NHANH();
DataRow first_row = dt.NewRow();
first_row[0] = "Toàn tỉnh";
dt.Rows.InsertAt(first_row, 0);
//cbChiNhanh.DataSource = dt;
cbChiNhanh.DisplayMember = "MACN";
cbChiNhanh.ValueMember = "MACN";
cbChiNhanh.DataSource = dt;
cbChiNhanh.SelectedValue = Thongtindangnhap.macn;
layLoaiKH();
}
private void buttonX1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
String sCommand = "";
Cursor.Current = Cursors.WaitCursor;
System.Data.DataTable dshd = new System.Data.DataTable();
DataColumn col = null;
dataGridViewX32.DataSource = dshd;
col = new DataColumn("Mã CN", typeof(string));
dshd.Columns.Add(col);
col = new DataColumn("< 1,200", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("1,200 - 2,400", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("2,400 - 4,800", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("4,800 - 7,200", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("7,200 - 12,000", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("12,000 - 36,000", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("36,000 - 72,000", typeof(Int64));
dshd.Columns.Add(col);
col = new DataColumn("> 72,000", typeof(Int64));
dshd.Columns.Add(col);
DataTable dt_macn = cnbus.DANH_SACH_MA_CHI_NHANH();
if ((cbCN.Text == "Tất cả") || (cbCN.Text == ""))
{
//for (int k = 2300; k <= 2313; k++)
for (int i = 0; i < dt_macn.Rows.Count; i++)
{
//if (k != 4812)
//{
DataRow row = dshd.NewRow();
//row[0] = k.ToString();
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<1200 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[1] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[1] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<2400 and diem>=1200 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[2] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[2] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<4800 and diem>=2400 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[3] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[3] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<7200 and diem>=4800 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[4] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[4] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<12000 and diem>=7200 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[5] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[5] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<36000 and diem>=12000 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[6] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[6] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<72000 and diem>=36000 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[7] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[7] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem>=72000 and ma='" + dt_macn.Rows[i]["MACN"].ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[8] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[8] = "0";
};
dshd.Rows.Add(row);
//}
}
}
else
{
DataRow row = dshd.NewRow();
int k = Convert.ToInt32(cbCN.Text);
row[0] = cbCN.Text;
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<1200 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[1] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[1] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<2400 and diem>=1200 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[2] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[2] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<4800 and diem>=2400 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[3] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[3] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<7200 and diem>=4800 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[4] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[4] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<12000 and diem>=7200 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[5] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[5] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<36000 and diem>=12000 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[6] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[6] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem<72000 and diem>=36000 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[7] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[7] = "0";
};
dt.Clear();
sCommand = "SELECT ma,count(ma) as cou from DIEM_CN ,khachhang where diem_cn.makh=khachhang.makh and khachhang.loaikh=1 and diem>=72000 and ma='" + k.ToString() + "' GROUP BY ma";
if (DataAccess.conn.State == ConnectionState.Open)
{
DataAccess.conn.Close();
}
DataAccess.conn.Open();
new SqlDataAdapter(sCommand, DataAccess.conn).Fill(dt);
DataAccess.conn.Close();
try
{
row[8] = dt.Rows[0]["cou"].ToString();
}
catch
{
row[8] = "0";
};
dshd.Rows.Add(row);
}
dataGridViewX32.DataSource = dshd;
dataGridViewX32.Columns[0].FillWeight = 50;
dataGridViewX32.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridViewX32.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//dataGridViewX1.Columns[6].Visible = false;
dataGridViewX32.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewX32.Columns[1].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[2].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[3].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[4].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[5].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[6].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[7].DefaultCellStyle.Format = "N0";
dataGridViewX32.Columns[8].DefaultCellStyle.Format = "N0";
Cursor.Current = Cursors.Default;
}