public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); return sSQL; }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); return(sSQL); }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); // 12/06/2007 Paul. Keep the numeric test here because the case number will be a true numeric. // We may want to fix this in the future if we change the case number to an alpha numeric. if ( Information.IsNumeric(sUnifiedSearch) ) sSQL += sb.BuildQuery(" or ", "CASE_NUMBER" ); return sSQL; }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); if ( Information.IsNumeric(sUnifiedSearch) ) { sSQL += sb.BuildQuery(" or ", "PHONE_ALTERNATE"); sSQL += sb.BuildQuery(" or ", "PHONE_FAX" ); sSQL += sb.BuildQuery(" or ", "PHONE_OFFICE" ); } return sSQL; }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); if (Information.IsNumeric(sUnifiedSearch)) { sSQL += sb.BuildQuery(" or ", "CASE_NUMBER"); } return(sSQL); }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); if (Information.IsNumeric(sUnifiedSearch)) { sSQL += sb.BuildQuery(" or ", "PHONE_ALTERNATE"); sSQL += sb.BuildQuery(" or ", "PHONE_FAX"); sSQL += sb.BuildQuery(" or ", "PHONE_OFFICE"); } return(sSQL); }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); // 12/06/2007 Paul. Keep the numeric test here because the case number will be a true numeric. // We may want to fix this in the future if we change the case number to an alpha numeric. if (Information.IsNumeric(sUnifiedSearch)) { sSQL += sb.BuildQuery(" or ", "CASE_NUMBER"); } return(sSQL); }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); // 12/06/2007 Paul. Skip the attempt to be efficient. Something as simple as 555-1212 will fail the IsNumeric test. // if ( Information.IsNumeric(sUnifiedSearch) ) { sSQL += sb.BuildQuery(" or ", "PHONE_ALTERNATE"); sSQL += sb.BuildQuery(" or ", "PHONE_FAX"); sSQL += sb.BuildQuery(" or ", "PHONE_OFFICE"); } return(sSQL); }
private void Page_Load(object sender, System.EventArgs e) { // 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages. //Page.DataBind(); string sUnifiedSearch = Sql.ToString(Request["txtUnifiedSearch"]); if (!Sql.IsEmptyString(sUnifiedSearch.Trim())) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using (IDbConnection con = dbf.CreateConnection()) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwPROJECTS_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; using (IDbCommand cmd = con.CreateCommand()) { cmd.CommandText = sSQL; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); cmd.CommandText += sb.BuildQuery(" and ", "NAME"); if (bDebug) { RegisterClientScriptBlock("vwPROJECTS_List", Sql.ClientScriptBlock(cmd)); } try { using (DbDataAdapter da = dbf.CreateDataAdapter()) { ((IDbDataAdapter)da).SelectCommand = cmd; using (DataTable dt = new DataTable()) { da.Fill(dt); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.SortColumn = "NAME"; grdMain.SortOrder = "asc"; grdMain.ApplySort(); grdMain.DataBind(); } } } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); lblError.Text = ex.Message; } } } ctlListHeader.Visible = true; } else { ctlListHeader.Visible = false; } }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME" ); //sSQL += sb.BuildQuery(" or ", "LAST_NAME" ); //sSQL += sb.BuildQuery(" or ", "FIRST_NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); sSQL += sb.BuildQuery(" or ", "EMAIL1" ); sSQL += sb.BuildQuery(" or ", "EMAIL2" ); if ( Information.IsNumeric(sUnifiedSearch) ) { sSQL += sb.BuildQuery(" or ", "PHONE_HOME" ); sSQL += sb.BuildQuery(" or ", "PHONE_MOBILE"); sSQL += sb.BuildQuery(" or ", "PHONE_WORK" ); sSQL += sb.BuildQuery(" or ", "PHONE_OTHER" ); sSQL += sb.BuildQuery(" or ", "PHONE_FAX" ); } return sSQL; }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME" ); //sSQL += sb.BuildQuery(" or ", "LAST_NAME" ); //sSQL += sb.BuildQuery(" or ", "FIRST_NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); sSQL += sb.BuildQuery(" or ", "EMAIL1" ); sSQL += sb.BuildQuery(" or ", "EMAIL2" ); // 12/06/2007 Paul. Skip the attempt to be efficient. Something as simple as 555-1212 will fail the IsNumeric test. // if ( Information.IsNumeric(sUnifiedSearch) ) { sSQL += sb.BuildQuery(" or ", "PHONE_HOME" ); sSQL += sb.BuildQuery(" or ", "PHONE_MOBILE"); sSQL += sb.BuildQuery(" or ", "PHONE_WORK" ); sSQL += sb.BuildQuery(" or ", "PHONE_OTHER" ); sSQL += sb.BuildQuery(" or ", "PHONE_FAX" ); } return sSQL; }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); //sSQL += sb.BuildQuery(" or ", "LAST_NAME" ); //sSQL += sb.BuildQuery(" or ", "FIRST_NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); sSQL += sb.BuildQuery(" or ", "EMAIL1"); sSQL += sb.BuildQuery(" or ", "EMAIL2"); if (Information.IsNumeric(sUnifiedSearch)) { sSQL += sb.BuildQuery(" or ", "PHONE_HOME"); sSQL += sb.BuildQuery(" or ", "PHONE_MOBILE"); sSQL += sb.BuildQuery(" or ", "PHONE_WORK"); sSQL += sb.BuildQuery(" or ", "PHONE_OTHER"); sSQL += sb.BuildQuery(" or ", "PHONE_FAX"); } return(sSQL); }
public static string UnifiedSearch(string sUnifiedSearch, IDbCommand cmd) { string sSQL = String.Empty; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); sSQL += sb.BuildQuery(" and ", "NAME"); //sSQL += sb.BuildQuery(" or ", "LAST_NAME" ); //sSQL += sb.BuildQuery(" or ", "FIRST_NAME" ); sSQL += sb.BuildQuery(" or ", "ACCOUNT_NAME"); sSQL += sb.BuildQuery(" or ", "EMAIL1"); sSQL += sb.BuildQuery(" or ", "EMAIL2"); // 12/06/2007 Paul. Skip the attempt to be efficient. Something as simple as 555-1212 will fail the IsNumeric test. // if ( Information.IsNumeric(sUnifiedSearch) ) { sSQL += sb.BuildQuery(" or ", "PHONE_HOME"); sSQL += sb.BuildQuery(" or ", "PHONE_MOBILE"); sSQL += sb.BuildQuery(" or ", "PHONE_WORK"); sSQL += sb.BuildQuery(" or ", "PHONE_OTHER"); sSQL += sb.BuildQuery(" or ", "PHONE_FAX"); } return(sSQL); }
private void Page_Load(object sender, System.EventArgs e) { // 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages. //Page.DataBind(); string sUnifiedSearch = Sql.ToString(Request["txtUnifiedSearch"]); if ( !Sql.IsEmptyString(sUnifiedSearch.Trim()) ) { DbProviderFactory dbf = DbProviderFactories.GetFactory(); using ( IDbConnection con = dbf.CreateConnection() ) { string sSQL; sSQL = "select * " + ControlChars.CrLf + " from vwPROJECTS_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; using ( IDbCommand cmd = con.CreateCommand() ) { cmd.CommandText = sSQL; SearchBuilder sb = new SearchBuilder(sUnifiedSearch, cmd); cmd.CommandText += sb.BuildQuery(" and ", "NAME"); if ( bDebug ) RegisterClientScriptBlock("vwPROJECTS_List", Sql.ClientScriptBlock(cmd)); try { using ( DbDataAdapter da = dbf.CreateDataAdapter() ) { ((IDbDataAdapter)da).SelectCommand = cmd; using ( DataTable dt = new DataTable() ) { da.Fill(dt); vwMain = dt.DefaultView; grdMain.DataSource = vwMain ; if ( !IsPostBack ) { grdMain.SortColumn = "NAME"; grdMain.SortOrder = "asc" ; grdMain.ApplySort(); grdMain.DataBind(); } } } } catch(Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); lblError.Text = ex.Message; } } } ctlListHeader.Visible = true; } else { ctlListHeader.Visible = false; } }