Beispiel #1
0
 string StringLikeFull(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, string likeFormat,object args)
 {
     string parName = string.Format("@like{0}" , parIndex);
     parIndex += 1;
     if (!args.ToString().Contains("%"))
     {
         args = string.Format(likeFormat, args);
     }
     addParame(parName, args);
     if (nodeType == ExpressionType.Equal)
     {
         return dBAdapter.StringLikeFormat(field, parName);
     }
     else
     {
         return dBAdapter.StringNotLikeFormat(field, parName);
     }
     //return string.Format("{0} LIKE {1}", field, parName);
 }
Beispiel #2
0
 public string StringLikeRight(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string str = args[0].ToString();
     str = str.Replace("%","");
     return StringLikeFull(field, nodeType, ref parIndex, addParame, "{0}%", str);
 }
Beispiel #3
0
 public string StartsWith(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     var par = args[0].ToString();
     string parName = string.Format("@StartsWith{0}", parIndex);
     parIndex += 1;
     addParame(parName, par);
     var str = dBAdapter.SubstringFormat(field, 0, par.Length);
     if (nodeType == ExpressionType.Equal)
     {
         return string.Format("{0}={1}", str, parName);
     }
     else
     {
         return string.Format("{0}!={1}", str, parName);
     }
 }
Beispiel #4
0
 public string Substring(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     return dBAdapter.SubstringFormat(field, (int)args[0], (int)args[1]);
     //return string.Format(" SUBSTRING({0},{1},{2})", field, args[0], args[1]);
 }
Beispiel #5
0
 public string In(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string str = InFormat(args[0], ref parIndex, addParame);
     if (nodeType == ExpressionType.Equal)
     {
         return dBAdapter.InFormat(field, str);
     }
     else
     {
         return dBAdapter.NotInFormat(field, str);
     }
     //return string.Format("{0} IN ({1})", field, str);
 }
Beispiel #6
0
 public string Equals(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string parName = string.Format("@equalEnum{0}", parIndex);
     parIndex += 1;
     var obj = args[0];
     obj = ObjectConvert.ConvertObject(obj.GetType(), obj);
     addParame(parName, obj);
     if (nodeType == ExpressionType.Equal)
     {
         return string.Format("{0}={1}", field, parName);
     }
     else
     {
         return string.Format("{0}!={1}", field, parName);
     }
 }
Beispiel #7
0
 string InFormat(object value, ref int parIndex, AddParameHandler addParame)
 {
     string str = "";
     var par2 = value;
     if (par2 is string)
     {
         string parName = string.Format("@in{0}", parIndex);
         addParame(parName, value);
         str = parName;
     }
     else if (par2 is string[])
     {
         IEnumerable list = par2 as IEnumerable;
         foreach (var s in list)
         {
             string parName = string.Format("@in{0}", parIndex);
             addParame(parName, s);
             parIndex += 1;
             str += string.Format("{0},", parName);
         }
         if (str.Length > 1)
         {
             str = str.Substring(0, str.Length - 1);
         }
     }
     else//按数字
     {
         IEnumerable list = par2 as IEnumerable;
         foreach (var s in list)
         {
             string parName = string.Format("@in{0}", parIndex);
             addParame(parName, (int)s);
             parIndex += 1;
             str += string.Format("{0},", parName);
         }
         if (str.Length > 1)
         {
             str = str.Substring(0, str.Length - 1);
         }
     }
     return str;
 }
Beispiel #8
0
 public string AVG(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     return string.Format("avg({0})", field);
 }
Beispiel #9
0
 public string DateTimeDateDiff(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string parName = string.Format("@DateDiff{0}", parIndex);
     addParame(parName, args[1]);
     parIndex += 1;
     //DateDiff(2015/2/5 17:59:44,t1.AddTime,@DateDiff1)>1 
     return dBAdapter.DateDiffFormat(field, args[0].ToString(), parName);
     //return string.Format("DateDiff({0},{1},{2}){3}", args[0], field, parName, args[2]);
 }
Beispiel #10
0
 public string Between(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string parName = string.Format("@between{0}", parIndex);
     addParame(parName, args[0]);
     parIndex += 1;
     string parName2 = string.Format("@between{0}", parIndex);
     addParame(parName2, args[1]);
     parIndex += 1;
     if (nodeType == ExpressionType.Equal)
     {
         return dBAdapter.BetweenFormat(field, parName, parName2);
     }
     else
     {
         return dBAdapter.NotBetweenFormat(field, parName, parName2);
     }
     //return string.Format("{0} between {1} and {2}", field, parName, parName2);
 }
Beispiel #11
0
 public string StringContains(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args)
 {
     string parName = string.Format("@contrains{0}", parIndex);
     addParame(parName, args[0]);
     parIndex += 1;
     if (nodeType == ExpressionType.Equal)
     {
         return dBAdapter.StringContainsFormat(field, parName);
     }
     else
     {
         return dBAdapter.StringNotContainsFormat(field, parName);
     }
     //return string.Format("CHARINDEX({1},{0})>0", field, parName);
 }