private void SelectModelUser(FieldValueModel fieldValueWhereModel) { ModelUser modeluser = bllUser.GetModel(fieldValueWhereModel); if (CheckData.IsObjectNull(modeluser)) { Print.WriteLine("没有查到 id = {0} 的数据", fieldValueWhereModel.Value); } else { Print.WriteLine("id: " + modeluser.id); Print.WriteLine("RealName: " + modeluser.RealName); Print.WriteLine("Sex: " + modeluser.Sex.GetName()); } }
/// <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)); } }
public void CheckModelIsCanUse() { FieldValueModel fvmodel_1 = new FieldValueModel() { Name = "wwww", Value = "5468" }; Print.WriteLine("FV 两个给: " + FieldValueModel.CheckIsCanUse(fvmodel_1).ToString()); FieldValueModel fvmodel_2 = new FieldValueModel() { Value = "5468" }; Print.WriteLine("FV 只给Value: " + FieldValueModel.CheckIsCanUse(fvmodel_2).ToString()); FieldValueModel fvmodel_3 = new FieldValueModel() { Name = "wwww", }; Print.WriteLine("FV 只给Name: " + FieldValueModel.CheckIsCanUse(fvmodel_3).ToString()); WhereModel model_1 = null; Print.WriteLine("1: 赋值Null: " + WhereModel.CheckIsCanUse(model_1).ToString()); WhereModel model_2 = new WhereModel(); Print.WriteLine("2: 只new: " + WhereModel.CheckIsCanUse(model_2).ToString()); WhereModel model_3 = new WhereModel() { Wheres = new WhereModel[] { model_2 }, }; Print.WriteLine("3: 只给了Where 但给的是 model_2: " + WhereModel.CheckIsCanUse(model_3).ToString()); WhereModel model_4 = new WhereModel() { FielVals = new FieldValueModel[] { fvmodel_2 }, }; Print.WriteLine("4: 只给了FielVals, 但 fvmodel_2 没有name: " + WhereModel.CheckIsCanUse(model_4).ToString()); WhereModel model_5 = new WhereModel() { FielVals = new FieldValueModel[] { fvmodel_3 }, }; Print.WriteLine("5: 只给了FielVals, 并且 fvmodel_3 有name: " + WhereModel.CheckIsCanUse(model_5).ToString()); WhereModel model_6 = new WhereModel() { Wheres = new WhereModel[] { model_5 } }; Print.WriteLine("6: 只给了Wheres, 并且 给的是 model_5: " + WhereModel.CheckIsCanUse(model_6).ToString()); FieldOrderModel fomodel_1 = new FieldOrderModel() { Name = "wwww", IsAsc = true, }; Print.WriteLine("FO 两个给: " + FieldOrderModel.CheckIsCanUse(fomodel_1).ToString()); FieldOrderModel fomodel_2 = new FieldOrderModel() { IsAsc = false, }; Print.WriteLine("FO 只给IsAsc: " + FieldOrderModel.CheckIsCanUse(fomodel_2).ToString()); FieldOrderModel fomodel_3 = new FieldOrderModel() { Name = "wwww", }; Print.WriteLine("FO 只给Name: " + FieldOrderModel.CheckIsCanUse(fomodel_3).ToString()); }