private void button2_Click(object sender, EventArgs e) { UserControl1 c = new UserControl1(); c.Visible = true; c.Show(); // CashForm cash = new CashForm(); //cash.Show(); }
public Informacion(UserControl1 actual) { InitializeComponent(); control1 = actual; }
private void diancai_Load(object sender, EventArgs e) { dcxdczh.Text = this.dcxdxy; DataTable dt = new DataTable(); String sql = "Server=111.9.116.106;Database=ceshi;uid=sa;pwd=BKLserver@123!@#"; SqlConnection sssqlconn = new SqlConnection(sql); sssqlconn.Open(); SqlCommand comm = new SqlCommand(); comm.CommandText = "select lbmc from splb "; comm.Connection = sssqlconn; string mmmmm = "select count(distinct lbid) from splb"; SqlCommand cmd = new SqlCommand(mmmmm, sssqlconn); cmd.ExecuteScalar().ToString(); int x = Convert.ToInt32(cmd.ExecuteScalar().ToString()); using (SqlDataReader dr = comm.ExecuteReader()) { dt.Clear(); dt.Load(dr); sssqlconn.Close(); sssqlconn.Dispose(); } try { if (dt.Rows[0]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl1.Parent = tapcpfl;//显示 cpfl1.Text = dt.Rows[0]["lbmc"].ToString(); } if (dt.Rows[1]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl2.Parent = tapcpfl;//显示 cpfl2.Text = dt.Rows[1]["lbmc"].ToString(); } if (dt.Rows[2]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl3.Parent = tapcpfl;//显示 cpfl3.Text = dt.Rows[2]["lbmc"].ToString(); } if (dt.Rows[3]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl4.Parent = tapcpfl;//显示 cpfl4.Text = dt.Rows[3]["lbmc"].ToString(); } if (dt.Rows[4]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl5.Parent = tapcpfl;//显示 cpfl5.Text = dt.Rows[4]["lbmc"].ToString(); } if (dt.Rows[5]["lbmc"].ToString() == "") { tapcpfl.Parent = null;//隐藏 } else { cpfl6.Parent = tapcpfl;//显示 cpfl6.Text = dt.Rows[5]["lbmc"].ToString(); } } catch (Exception ex) { } //分类1 string ssb; string sssb; string ssssb; DataTable dtt = new DataTable(); String ssql = "Server=111.9.116.106;Database=ceshi;uid=sa;pwd=BKLserver@123!@#"; SqlConnection sqlconn = new SqlConnection(ssql); sqlconn.Open(); SqlCommand cocc = new SqlCommand(); cocc.CommandText = "select hh,pm,lsj from spzl a left join splb b on a.llb=b.lbid where b.lbmc='"+ cpfl1.Text+ "'"; cocc.Connection = sqlconn; string cccc = "select count(distinct spbh) from spzl a left join splb b on a.llb=b.lbid where b.lbmc='"+cpfl1.Text+"'"; SqlCommand cmddd = new SqlCommand(cccc, sqlconn); cmddd.ExecuteScalar().ToString(); int xm = Convert.ToInt32(cmddd.ExecuteScalar().ToString()); using (SqlDataReader drr = cocc.ExecuteReader()) { dtt.Clear(); dtt.Load(drr); sqlconn.Close(); sqlconn.Dispose(); } try { for (int ii = 0; ii < xm; ii++) { UserControl1 tb = new UserControl1(); //设定位置 tb.Top = 10 + ii * 58; tb.BackColor = Color.DeepSkyBlue; tb.Size = new Size(80, 55); ssb = dtt.Rows[ii]["hh"].ToString(); sssb = dtt.Rows[ii]["pm"].ToString(); ssssb = dtt.Rows[ii]["lsj"].ToString(); tb.labid = ssb; tb.lablsj = ssssb; tb.labname = sssb; this.flowLayoutPanel1.Controls.Add(tb); tb.Click += (object sne, EventArgs ed) => { tb.BackColor = Color.Maroon; string[] str = { tb.labid, tb.labname, tb.lablsj, "1" }; this.dcxdjm.Items.Add(new ListViewItem(str)); }; } } catch (Exception ex) { MessageBox.Show(ex.Message); ; } //分类2; string ssb1; string sssb1; string ssssb1; DataTable dttr = new DataTable(); String ssql1 = "Server=111.9.116.106;Database=ceshi;uid=sa;pwd=BKLserver@123!@#"; SqlConnection sqlconn111 = new SqlConnection(ssql1); sqlconn111.Open(); SqlCommand cocc1 = new SqlCommand(); cocc1.CommandText = "select hh,pm,lsj from spzl a left join splb b on a.llb=b.lbid where b.lbmc='" + cpfl2.Text + "'"; cocc1.Connection = sqlconn111; string cccc11 = "select count(distinct spbh) from spzl a left join splb b on a.llb=b.lbid where b.lbmc='"+cpfl2.Text + "'"; SqlCommand cmddd1 = new SqlCommand(cccc11, sqlconn111); cmddd1.ExecuteScalar().ToString(); int xmm = Convert.ToInt32(cmddd1.ExecuteScalar().ToString()); using (SqlDataReader drr1 = cocc1.ExecuteReader()) { dttr.Clear(); dttr.Load(drr1); sqlconn111.Close(); sqlconn111.Dispose(); } try { for (int iii = 0; iii < xmm; iii++) { UserControl1 tb1 = new UserControl1(); //设定位置 tb1.Top = 15 + iii * 58; tb1.BackColor = Color.DeepSkyBlue; tb1.Size = new Size(80, 55); ssb1 = dttr.Rows[iii]["hh"].ToString(); sssb1 = dttr.Rows[iii]["pm"].ToString(); ssssb1 = dttr.Rows[iii]["lsj"].ToString(); tb1.labid = ssb1; tb1.lablsj = ssssb1; tb1.labname = sssb1; this.flowLayoutPanel2.Controls.Add(tb1);//动态控件生成 tb1.Click += (object sne, EventArgs ed) => { //将控件的赋予给 listview 控件 tb1.BackColor = Color.Maroon; string[] str1 = { tb1.labid, tb1.labname, tb1.lablsj, "1" }; this.dcxdjm.Items.Add(new ListViewItem(str1)); //将控件的赋予给 listview 控件 }; } } catch (Exception ex) { MessageBox.Show(ex.Message); ; } //分类3; string ssbx; string sssbx; string ssssbx; DataTable dttrx = new DataTable(); String ssql1x = "Server=111.9.116.106;Database=ceshi;uid=sa;pwd=BKLserver@123!@#"; SqlConnection sqlconn111x = new SqlConnection(ssql1x); sqlconn111x.Open(); SqlCommand cocc1x = new SqlCommand(); cocc1x.CommandText = "select hh,pm,lsj from spzl a left join splb b on a.llb=b.lbid where b.lbmc='" + cpfl3.Text + "'"; cocc1x.Connection = sqlconn111x; string cccc11x = "select count(distinct spbh) from spzl a left join splb b on a.llb=b.lbid where b.lbmc='" + cpfl3.Text + "'"; SqlCommand cmddd1x = new SqlCommand(cccc11x, sqlconn111x); cmddd1x.ExecuteScalar().ToString(); int xmmx = Convert.ToInt32(cmddd1x.ExecuteScalar().ToString()); using (SqlDataReader drr1x = cocc1x.ExecuteReader()) { dttrx.Clear(); dttrx.Load(drr1x); sqlconn111x.Close(); sqlconn111x.Dispose(); } try { for (int iiix = 0; iiix < xmmx; iiix++) { UserControl1 tb1x = new UserControl1(); //设定位置 tb1x.Top = 10 + iiix * 58; tb1x.BackColor = Color.DeepSkyBlue; tb1x.Size = new Size(80, 55); ssbx = dttr.Rows[iiix]["hh"].ToString(); sssbx = dttr.Rows[iiix]["pm"].ToString(); ssssbx = dttr.Rows[iiix]["lsj"].ToString(); tb1x.labid = ssbx; tb1x.lablsj = ssssbx; tb1x.labname = sssbx; this.flowLayoutPanel3.Controls.Add(tb1x); tb1x.Click += (object sne, EventArgs ed) => { tb1x.BackColor = Color.Maroon; string[] str1x = { tb1x.labid, tb1x.labname, tb1x.lablsj, "1" }; this.dcxdjm.Items.Add(new ListViewItem(str1x)); }; } } catch (Exception ex) { } }
public PanelAgregar(UserControl1 actual) { InitializeComponent(); principal = actual; }
public PanelReportes(UserControl1 actual) { InitializeComponent(); principal = actual; }