我想实现点击button1实现 按条件 查询sql数据库中td_stock的数据表,条件查询的控件有商品编号(tradeCode.Text),商品名称(tradeName .Text),商品型号(goodsType.Text),商品类别(用的是combobox控件)点击button2实现全部查询
用C#.net编写,用到的函数也一起写出,最好支持模糊查询,谢谢,小弟不胜感激,急
用C#.net编写,用到的函数也一起写出,最好支持模糊查询,谢谢,小弟不胜感激,急
2:string ssql = "select * from td_stock";
if(this.tradeCode.Text!=""){
str=this.tradeCode.Text;}
else if(tradeName .Text!=""){
str=str+"and"+tradeName .Text;
}else if(this.combox.text!=""){
str=str+"and"+tradeName .Text;
}
"select * from td_stock where tradeCode='"+str+"'"
2.select * from td_stock
string ORACLE_SQL_CONNECTION_STRING = ConfigurationManager.AppSettings["oracleconnectionString"].ToString();
string assembly_item_id;
if (DropDownList1.SelectedValue.Trim() == "-1")
{
Label1.Text = "Please choose Organization!";
return;
}
if (TextBox1.Text.Trim() == "")
{
Label1.Text = "Please enter Item Code!";
return;
}
else
{
OleDbDataReader dr;
string sqlstr = "select inventory_item_Id from mtl_system_items where organization_Id = " + DropDownList1.SelectedValue.Trim() + " and segment1 = '" + TextBox1.Text.Trim().Replace("'", "''") + "'";
//dr = SqlHelper.GetOracledataReadersource(sqlstr);
OleDbConnection conn = new OleDbConnection(ORACLE_SQL_CONNECTION_STRING);
OleDbCommand mycommand = new OleDbCommand(sqlstr, conn);
conn.Open();
dr = mycommand.ExecuteReader();
if (dr.Read() != false)
{ assembly_item_id = dr["inventory_item_Id"].ToString();
}
else
{
Label1.Text = "Please enter correct Item Code";
return;
}
dr.Close();
}
StringBuilder s = new StringBuilder();
s.Append(assembly_item_id + ", ");
s.Append(DropDownList1.SelectedValue.Trim());
//string Str = s.ToString().Substring(1, s.ToString().Length - 1);
string Str = s.ToString();
//Server.Transfer("Indented_BOM_Result.aspx?Str="+Server.UrlEncode(Str));
Response.Redirect("Indented_BOM_Result.aspx?Str=" + Str.ToString());以上是我随便copy过来的代码,应该有用,看看了
if(tradeCode.Text!="")
{
sql+=" and tradeCode='"+ tradeCode.Text +"'";
}
if(tradeName.Text!="")
{
sql+=" and tradeName='"+ tradeName.Text +"'";
}
......
用这种方式追加字符串
注意原来的sql语句后要加上where 1=1
string tradename = tradeName .Text;
string type = tradeType.Text;
string AddSql="";
if(tradecode!="")AddSql+="and tradecode like '%"+tradecode+"%";
if(tradename!="")AddSql+="and tradename like '%"+tradename+"%";
if(type!="")AddSql+="and type like '%"+type +"%";
SqlConnection conn= new SqlConnection("Data Source=(local);DataBase=db_Ewss;Integrated Security=SSPI");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select tradecode as [商品编号],tradename as [商品名称],type as [商品类型],unit as [单位],qty as[ 商品数量],price as [最后一次进价],saleprice as [最后一次销价],averageprice as [加权平均价],checkqty as [盘点数量] from td_stock where type like '%"+type+"%' "+AddSql+" Order by tradecode ",conn);
//FPara.connStr就是组件中的数据库连接字符串
DataSet ds = new DataSet();
sda.Fill(ds,"search");
StockCheck.DataSource = ds.Tables["search"].DefaultView;
Rds = ds;
StockCheck.SetDataBinding(ds,"search");
string tradename = tradeName .Text;
string type = tradeType.Text;
string AddSql="";
if(tradecode!="")AddSql+="and tradecode like '%"+tradecode+"%";
if(tradename!="")AddSql+="and tradename like '%"+tradename+"%";
if(type!="")AddSql+="and type like '%"+type +"%";
SqlConnection conn= new SqlConnection("Data Source=(local);DataBase=db_Ewss;Integrated Security=SSPI");
conn.Open();SqlDataAdapter sda = new SqlDataAdapter("select tradecode as [商品编号],tradename as [商品名称],type as [商品类型],unit as [单位],qty as[ 商品数量],price as [最后一次进价],saleprice as [最后一次销价],averageprice as [加权平均价],checkqty as [盘点数量] from td_stock where type like '%"+type+"%' "+AddSql+" Order by tradecode ",conn);
//FPara.connStr就是组件中的数据库连接字符串
DataSet ds = new DataSet();
sda.Fill(ds,"search");
StockCheck.DataSource = ds.Tables["search"].DefaultView;
Rds = ds;
StockCheck.SetDataBinding(ds,"search");