/// <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; }