/// <summary>
/// 组合字符串
/// </summary>
protected override string CombSqlTxt(BasicsPageDataModel Obj_DaModel)
{
DataModel daModel = new DataModel();
try { daModel = (DataModel)Obj_DaModel; } catch (Exception) { }
List <string> sqls = new List <string>();
if (!CheckData.IsStringNull(daModel.Name))
{
sqls.Add(CreateSQL.WhereEqual(BLL_vismsg.ColName_name, daModel.Name));
}
daModel.Time_Start = daModel.Time_Start.Replace("'", "");
if (!CheckData.IsStringNull(daModel.Time_Start))
{
sqls.Add(CreateSQL.WhereBigThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_Start));
}
daModel.Time_End = daModel.Time_End.Replace("'", "");
if (!CheckData.IsStringNull(daModel.Time_End))
{
sqls.Add(CreateSQL.WhereSmallThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_End));
}
if (!CheckData.IsStringNull(daModel.LikeSelectValue))
{
string[] valArr = ConvertTool.ToArrayList(daModel.LikeSelectValue, ',');
string likeSelString = CreateSQL.WhereLikeAllPropertyInfo(new Model.visitor_message(), valArr);
if (!CheckData.IsStringNull(likeSelString))
{
sqls.Add(likeSelString);
}
}
string resultSQLStr = ConvertTool.ToString(sqls, CreateSQL.WHERE_AND);
if (CheckData.IsStringNull(resultSQLStr.Trim()))
{
return(string.Empty);
}
return(CreateSQL.WHERE_AND + resultSQLStr);
}
/// <summary>
/// Microsoft SQL Server SQL 操作符解析器
/// </summary>
public static string MSQLServer_OperChar_Parser(FieldValueModel FVm)
{
if (CheckData.IsObjectNull(FVm))
{
return(string.Empty);
}
switch (FVm.KeyChar)
{
case DataChar.OperChar.EQUAL:
return(CreateSQL.WhereEqual(FVm.Name, FVm.Value));
case DataChar.OperChar.EQUAL_NOT:
return(CreateSQL.WhereEqualNot(FVm.Name, FVm.Value));
case DataChar.OperChar.LIKE:
return(CreateSQL.WhereLike(FVm.Name, FVm.Value));
case DataChar.OperChar.IN:
return(CreateSQL.WhereIn(FVm.Name, ConvertTool.ToArrayList(FVm.Value, DataChar.ARRAYLIST_INTERVAL_CHAR)));
case DataChar.OperChar.IN_NOT:
return(CreateSQL.WhereInNot(FVm.Name, ConvertTool.ToArrayList(FVm.Value, DataChar.ARRAYLIST_INTERVAL_CHAR)));
case DataChar.OperChar.BigTHAN:
return(CreateSQL.WhereBigThan(FVm.Name, FVm.Value));
case DataChar.OperChar.BigTHAN_EQUAL:
return(CreateSQL.WhereBigThanEqual(FVm.Name, FVm.Value));
case DataChar.OperChar.SmallTHAN:
return(CreateSQL.WhereSmallThan(FVm.Name, FVm.Value));
case DataChar.OperChar.SmallTHAN_EQUAL:
return(CreateSQL.WhereSmallThanEqual(FVm.Name, FVm.Value));
default:
FVm.SetKeyChar(DataChar.OperChar.EQUAL);
return(MSQLServer_OperChar_Parser(FVm));
}
}
