/// <summary>
/// 自定义查询条件
/// </summary>
/// <returns>返回查询的条件</returns>
/// <param name="tbName">查询的表名</param>
public string GetWhereSqlStr(string tbName)
{
var cmd = new SqlCommand("select * from Tb_Collect where tName=@tName");
cmd.Parameters.AddWithValue("@tName", tbName);
var dt = GetSqlTable(cmd);
if (dt.Rows.Count <= 0)
{
MessageBox.Show(@"未初始化该记录的列名,请联系管理员", @"Warning");
return("");
}
IFilterString fs = new FilterString(dt.Rows.Count);
for (var i = 0; i <= dt.Rows.Count - 1; i++)
{
switch (dt.Rows[i]["cType"].ToString())
{
case "DataType.Number":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.Number);
break;
case "DataType.DataTime":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.DataTime);
break;
case "DataType.String":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.String);
break;
}
}
Form frm = new SearchFilter.SearchFilter(fs);
frm.ShowDialog();
var s = fs.FilterText;
return(s);
}
/// <summary>
/// 自定义查询条件
/// </summary>
/// <returns>返回查询的条件</returns>
/// <param name="tbName">查询的表名</param>
public string GetWhereSqlStr(string tbName)
{
var cmd = new SqlCommand("select * from Tb_Collect where tName=@tName");
cmd.Parameters.AddWithValue("@tName", tbName);
var dt = GetSqlTable(cmd);
if (dt.Rows.Count <= 0)
{
MessageBox.Show(@"未初始化该记录的列名,请联系管理员", @"Warning");
return "";
}
IFilterString fs = new FilterString(dt.Rows.Count);
for (var i = 0; i <= dt.Rows.Count - 1; i++)
{
switch (dt.Rows[i]["cType"].ToString())
{
case "DataType.Number":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.Number);
break;
case "DataType.DataTime":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.DataTime);
break;
case "DataType.String":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.String);
break;
}
}
Form frm = new SearchFilter.SearchFilter(fs);
frm.ShowDialog();
var s = fs.FilterText;
return s;
}
