筛选函数
来源:互联网 发布:centos 安装yum 编辑:程序博客网 时间:2024/06/02 23:50
private void queryIndent_Click(object sender, EventArgs e)
{
string GS = this.CompanySelect.Text;
string DDBH = this.OrderNumber.Text.Trim();
string KHBH = this.CustomerNumber.Text.Trim();
string CPBH = this.GoodsNumber.Text;
string State = this.state.Text;
string GGTZD = this.ChangeDoc.Text;
string JLY = this.Recorder.Text.Trim();
string StringKDRQfrom = this.OrderDateFrom.Value.ToString();
string StringKDRQto = this.OrderDateTo.Value.ToString();
string StringJHRQfrom = this.DeliveryDateFrom.Value.ToString();
string StringJHRQto = this.DeliveryDateTo.Value.ToString();
if (DDBH != "")
DDBH = "DDBH like '%" + DDBH+"%'";
if (GS != "")
if(DDBH!="")
GS = "and Company ='" + GS + "'";
else
GS = "Company ='" + GS + "'";
if (KHBH != "")
if(DDBH!="" || GS != "")
KHBH = "and KHBH like '%" + KHBH + "%'";
else
KHBH = "KHBH like '%" + KHBH + "%'";
if (CPBH != "")
if (DDBH != "" || GS != "" || KHBH!="")
CPBH = "and CX like '%" + CPBH + "%'";
else
CPBH = "CX like '%" + CPBH + "%'";
if (State != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH!="")
State = "and State like '%" + State + "%'";
else
State = "State like '%" + State + "%'";
if (GGTZD != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "")
GGTZD = "and GGD like '%" + GGTZD + "%'";
else
GGTZD = "GGD like '%" + GGTZD + "%'";
if (JLY != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "")
JLY = "and ZDY like '%" + JLY + "%'";
else
JLY = "ZDY like '%" + JLY + "%'";
if (StringKDRQfrom!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "")
StringKDRQfrom = "and ZDRQ >'" + StringKDRQfrom + "'";
else
StringKDRQfrom = "ZDRQ >'" + StringKDRQfrom + "'";
if (StringKDRQto!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "")
StringKDRQto = "and ZDRQ < '" + StringKDRQto + "'";
else
StringKDRQto = "ZDRQ < '" + StringKDRQto + "'";
if (StringJHRQfrom!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "")
StringJHRQfrom = "and CHRQ > '" + StringJHRQto + "'";
else
StringJHRQfrom = "CHRQ > '" + StringJHRQfrom + "'";
if (StringJHRQto!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "" || StringJHRQfrom != "")
StringJHRQto = "and CHRQ < '" + StringJHRQto + "'";
else
StringJHRQto = "CHRQ < '" + StringJHRQto + "'";
string sql = "select DDBH,Company,ZDRQ,KHBH,DHDW,CX,SL,CHRQ,State,SM,ZDY,GGD from DHZZD where " + DDBH + GS + KHBH + CPBH + State + GGTZD + JLY + StringKDRQfrom + StringKDRQto + StringJHRQfrom + StringJHRQto;
BindSearchResult(sql);
SetColumns();
}
}
}
{
string GS = this.CompanySelect.Text;
string DDBH = this.OrderNumber.Text.Trim();
string KHBH = this.CustomerNumber.Text.Trim();
string CPBH = this.GoodsNumber.Text;
string State = this.state.Text;
string GGTZD = this.ChangeDoc.Text;
string JLY = this.Recorder.Text.Trim();
string StringKDRQfrom = this.OrderDateFrom.Value.ToString();
string StringKDRQto = this.OrderDateTo.Value.ToString();
string StringJHRQfrom = this.DeliveryDateFrom.Value.ToString();
string StringJHRQto = this.DeliveryDateTo.Value.ToString();
if (DDBH != "")
DDBH = "DDBH like '%" + DDBH+"%'";
if (GS != "")
if(DDBH!="")
GS = "and Company ='" + GS + "'";
else
GS = "Company ='" + GS + "'";
if (KHBH != "")
if(DDBH!="" || GS != "")
KHBH = "and KHBH like '%" + KHBH + "%'";
else
KHBH = "KHBH like '%" + KHBH + "%'";
if (CPBH != "")
if (DDBH != "" || GS != "" || KHBH!="")
CPBH = "and CX like '%" + CPBH + "%'";
else
CPBH = "CX like '%" + CPBH + "%'";
if (State != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH!="")
State = "and State like '%" + State + "%'";
else
State = "State like '%" + State + "%'";
if (GGTZD != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "")
GGTZD = "and GGD like '%" + GGTZD + "%'";
else
GGTZD = "GGD like '%" + GGTZD + "%'";
if (JLY != "")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "")
JLY = "and ZDY like '%" + JLY + "%'";
else
JLY = "ZDY like '%" + JLY + "%'";
if (StringKDRQfrom!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "")
StringKDRQfrom = "and ZDRQ >'" + StringKDRQfrom + "'";
else
StringKDRQfrom = "ZDRQ >'" + StringKDRQfrom + "'";
if (StringKDRQto!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "")
StringKDRQto = "and ZDRQ < '" + StringKDRQto + "'";
else
StringKDRQto = "ZDRQ < '" + StringKDRQto + "'";
if (StringJHRQfrom!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "")
StringJHRQfrom = "and CHRQ > '" + StringJHRQto + "'";
else
StringJHRQfrom = "CHRQ > '" + StringJHRQfrom + "'";
if (StringJHRQto!="")
if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "" || StringJHRQfrom != "")
StringJHRQto = "and CHRQ < '" + StringJHRQto + "'";
else
StringJHRQto = "CHRQ < '" + StringJHRQto + "'";
string sql = "select DDBH,Company,ZDRQ,KHBH,DHDW,CX,SL,CHRQ,State,SM,ZDY,GGD from DHZZD where " + DDBH + GS + KHBH + CPBH + State + GGTZD + JLY + StringKDRQfrom + StringKDRQto + StringJHRQfrom + StringJHRQto;
BindSearchResult(sql);
SetColumns();
}
}
}
- 筛选函数
- 筛选法求欧拉函数phi
- 筛选法求欧拉函数
- excel筛选查询函数
- [模板]筛选法求欧拉函数
- 筛选数据函数
- jquery筛选过滤函数
- 改进后的筛选函数
- 【转】jQuery筛选函数总结
- hdu2824筛选法欧拉函数+求和
- excel筛选不重复 函数
- 线性筛选欧拉函数
- 欧拉函数筛选素数
- 线性筛选素数和线性筛选欧拉函数【bzoj2190]
- 筛选
- 筛选
- 筛选
- SQL 筛选 字母 数字 中文 函数
- ComboTreeView控件-Winform树型ComboBox
- java开发都必去的网站
- 中海优质成长
- MVC设计模式带来更好的软件结构和代码重用
- 延华智能(002178)新股发行资料一览(发行价,中签率,申购)
- 筛选函数
- Log4j学习- -
- javascript通过中间类实现类变量不可修改
- 用VS2005.NET进行三层结构应用程序的开发(转于冷枫)
- rational rose 2003 破解和下载
- 关于.net中获取用户控件的值的问题
- 這個認真的很厲害,,,
- 待完善。。
- javascript取得汉字的字节编码