复合查询

        /// <summary>

        /// 复合查询

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnCheck_Click(object sender, EventArgs e)

        {

            //方法一

            //StringBuilder sb = new StringBuilder();

            //sb.Append("select * from T_Customers where 1=1\n");

            //if (ckbName.Checked)

            //{

            //    sb.Append("and Name like @name\n");

            //}

            //if (ckbPhone.Checked)

            //    sb.Append("and Phone like @phone\n");

            //if (ckbCarNum.Checked)

            //    sb.Append("and CarNum like @carnum\n");

            //MessageBox.Show(sb.ToString());

            //方法二

            List<string> listWhere = new List<string>();

            if (ckbName.Checked)

            {

                listWhere.Add("Name like @name\n");

            }

            if (ckbPhone.Checked)

                listWhere.Add("Phone like @phone\n");

            if (ckbCarNum.Checked)

                listWhere.Add("CarNum like @carnum\n");

            string sql = "select * from T_Custumers\n";

            if (listWhere.Count>0)

                string sqlWhere = string.Join("and ", listWhere.ToArray());

                sql += " where " + sqlWhere;

            MessageBox.Show(sql);

        }

本文转自蓬莱仙羽51CTO博客，原文链接：http://blog.51cto.com/dingxiaowei/1366789，如需转载请自行联系原作者