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