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