110,534
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
Web.DAL.Base.BomTableAdapters.T_G_BomPTableAdapter ad = new DAL.Base.BomTableAdapters.T_G_BomPTableAdapter();
System.Data.SqlClient.SqlCommand cmd= ad.Connection.CreateCommand();
cmd.CommandText = @"select * from T_G_BomP Where (no=@no or @no is null) and (isVerify=@isVerify @isVerify is null)";
System.Data.SqlClient.SqlParameter no = new System.Data.SqlClient.SqlParameter("@no",System.Data.SqlDbType.Text);
if (string.IsNullOrEmpty(TextBox1.Text.Trim())) { no.Value = TextBox1.Text.Trim(); }
System.Data.SqlClient.SqlParameter isVerify = new System.Data.SqlClient.SqlParameter("@isVerify", System.Data.SqlDbType.Text);
if (string.IsNullOrEmpty(TextBox1.Text.Trim())) { isVerify.Value = TextBox2.Text.Trim(); }
cmd.Parameters.Add(no);
cmd.Parameters.Add(isVerify);
}