public static string GetWhereSql(DataAccess.Business.QuickParameters qParas) { string WhereSentence = string.Empty; if (qParas != null && qParas is DataAccess.Business.QuickParametersDataObjectSurvey) { DataAccess.Business.QuickParametersDataObjectSurvey qpSurvay = qParas as DataAccess.Business.QuickParametersDataObjectSurvey; if (qpSurvay.IsContest.HasValue) { WhereSentence += string.Format("(hiobj_Survey.IsContest = {0})\r\n", Convert.ToInt32(qpSurvay.IsContest.Value)); } } return(WhereSentence); }
public static string GetFullTextWhereSql(DataAccess.Business.QuickParameters qParas) { //if (!string.IsNullOrEmpty(qParas.GeneralSearch)) //{ // if (qParas.CatalogSearchType == DBCatalogSearchType.FreetextTable) // return string.Format(" OR FREETEXT(hiobj_Survey.*, '{0}', LANGUAGE 0x0)\r\n", qParas.GeneralSearch.Replace("'", "''")); // else if (qParas.CatalogSearchType == DBCatalogSearchType.ContainsTable) // return " OR CONTAINS(hiobj_Survey.*, @ObjectGeneralSearch, LANGUAGE 0x0)\r\n"; // else // return string.Empty; //} //else //{ // return string.Empty; //} return(string.Empty); }
public static string GetFullTextWhereSQL(DataAccess.Business.QuickParameters qParas) { if (!string.IsNullOrEmpty(qParas.GeneralSearch)) { if (qParas.CatalogSearchType == DBCatalogSearchType.FreetextTable) { return(string.Format(" OR FREETEXT(hiobj_Product.*, '{0}', LANGUAGE 0x0)\r\n", qParas.GeneralSearch.Replace("'", "''"))); } else if (qParas.CatalogSearchType == DBCatalogSearchType.ContainsTable) { return(" OR CONTAINS(hiobj_Product.*, @ObjectGeneralSearch, LANGUAGE 0x0)\r\n"); } else { return(string.Empty); } } else { return(string.Empty); } }
public static string GetJoinSql(DataAccess.Business.QuickParameters qParas) { return("INNER JOIN hiobj_Survey ON hiobj_Survey.OBJ_ID = hitbl_DataObject_OBJ.OBJ_ID"); }
public static string GetSelectSql(DataAccess.Business.QuickParameters paras) { return(", hiobj_Survey.*"); }
public override string GetFullTextWhereSQL(DataAccess.Business.QuickParameters qParas, SqlParameterCollection parameters) { return(Data.DataObjectHTMLContent.GetFullTextWhereSQL(qParas)); }
public static string GetFullTextWhereSQL(DataAccess.Business.QuickParameters paras) { string retString = string.Empty; return(retString); }
public static string GetWhereSQL(DataAccess.Business.QuickParameters paras) { return(string.Empty); }
public static string GetJoinSQL(DataAccess.Business.QuickParameters paras) { return("INNER JOIN hiobj_HTMLContent ON hiobj_HTMLContent.OBJ_ID = hitbl_DataObject_OBJ.OBJ_ID"); }
public static string GetSelectSQL(DataAccess.Business.QuickParameters paras) { return(", hiobj_HTMLContent.*"); }
public static string GetSelectSQL(DataAccess.Business.QuickParameters qParas) { return(", hiobj_Product.*"); }
public static string GetSelectSQL(DataAccess.Business.QuickParameters paras) { return(", hiobj_Location.*"); }