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.*");
}
