代码之家  ›  专栏  ›  技术社区  ›  mahesh

FlowLayOutPanel有问题

  •  -1
  • mahesh  · 技术社区  · 14 年前

    我的问题如下。这是我的密码:

    private void textBox2_KeyPress(object sender, KeyPressEventArgs e)
    {
        if ((Keys)e.KeyChar == Keys.Enter)
        {
            foreach (Control abcl  in this.flowLayoutPanel1.Controls)
            {
                if (abcl.Name.Contains("bb") && abcl  is TextBox)
                {
                    int indx = this.flowLayoutPanel1.Controls.Count-1;
                    for (int i = 0; i < indx; i++)
                    {
                        string mess = "Sorry Empty.Records";
                        if (this.flowLayoutPanel1.Controls[i].Text == "")
                        {
                            MessageBox.Show(mess);
                            mess = null;
                        }
                        else
                        {
                            string connstr = "server=.;initial catalog= myDataBase  pwd=mypasward";
                            SqlConnection con = new SqlConnection(connstr);
                            con.Open();
    
                            SqlCommand cmd1 = new SqlCommand("insert into debankA(companyID,transID,date,bank,totdepo,narrat) values " +
                            "(@companyID,@transID,Convert(datetime,'" + maskedTextBox1.Text.ToString() + "',103),@bank,@totdepo,@narrat)", con);
                            cmd1.Parameters.Add("@bank", SqlDbType.VarChar).Value = textBox1.Text;
                            cmd1.Parameters.Add("@totdepo", SqlDbType.Decimal).Value = label13.Text;
                            cmd1.Parameters.Add("@narrat", SqlDbType.VarChar).Value = textBox2.Text;
                            cmd1.Parameters.Add("@companyID", SqlDbType.Int).Value = label6.Text;
                            cmd1.Parameters.Add("@transID", SqlDbType.Int).Value = textBox4.Text;
                            cmd1.ExecuteNonQuery();
    
                            string pparticulars = null;
                            double? depo = null;
                            string messs = "Record Save Successfully";
                            foreach (Control ctl in this.flowLayoutPanel1.Controls)
                            {
                                if (ctl.Name.Contains("tbb") && ctl is TextBox)
                                {
                                    pparticulars = ctl.Text;
                                }
    
                                if (ctl.Name.Contains("bb") && ctl is TextBox)
                                {
                                    double ddepo = 0;
    
                                    if (double.TryParse(ctl.Text, out ddepo))
                                        depo = ddepo;
    
                                    if (pparticulars != null && depo != null)
                                    {
                                        SqlCommand cmd = new SqlCommand("insert into debankB(particulars,deposit,companyID,transID)values" +
                                        "(@particulars,@deposit,@companyID,@transID)", con);
                                        cmd.Parameters.Add("@particulars", SqlDbType.VarChar).Value = pparticulars;
                                        cmd.Parameters.Add("@deposit", SqlDbType.Decimal).Value = depo;
                                        cmd.Parameters.Add("@companyID", SqlDbType.Int).Value = label6.Text;
                                        cmd.Parameters.Add("@transID", SqlDbType.Int).Value = textBox4.Text;
                                        cmd.ExecuteNonQuery();
                                        pparticulars = null;
                                        depo = null;
    
                                        MessageBox.Show("Record Saved Successfully");
                                        messs = null;
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    

    上面是flowlayoutpanel1上的多个文本框项目。有两个名为“tbb”和“bb”的文本框。问题是,上面的工作很好,但只是有一个问题,即消息显示的时间和控件中的总文本框一样多。此代码中的else条件不起作用。这就是为什么两条消息都显示而不是一个条件为真。我不熟悉flowlayoutpanel。

    1 回复  |  直到 13 年前
        1
  •  0
  •   Madeleine    14 年前