private void ResetMainText(List <RunModel> runModel) { runs = GetRuns(Title, FunType.ToString(), tbMain, runModel); tbMain.Inlines.Clear(); foreach (var item in runs) { tbMain.Inlines.Add(item); } }
public static string Format(string str, FunType funType, FunFormat funFormat) { if (funType != FunType.Null) { string formatstring = "YYYY-MM-DD"; if (funFormat == FunFormat.YYYYMM) { formatstring = "YYYY-MM"; } else if (funFormat == FunFormat.YYYYMMDDHH24MI) { formatstring = "YYYY-MM-DD HH24:MI"; } else if (funFormat == FunFormat.YYYYMMDDHH24MISS) { formatstring = "YYYY-MM-DD HH24:MI:SS"; } return(string.Format(" {0}({1},'{2}')", funType.ToString(), str, formatstring)); } return(str); }
//for between...and public static void Add <T>(T value1, T value2, string fieldName, FunType funType, FunFormat funFormat, IDbCommand cmd) { if (value1 != null && value2 != null) { IDbDataParameter parameter1; IDbDataParameter parameter2; string str1 = fieldName.Replace('.', '_') + "_1"; string str2 = string.Format(":{0}", str1); string str3 = fieldName.Replace('.', '_') + "_2"; string str4 = string.Format(":{0}", str3); string str = string.Format(" AND {0} BETWEEN {1} AND {2}", fieldName, str2, str4); if (funType != FunType.Null) { string formatstring = "YYYY-MM-DD"; if (funFormat == FunFormat.YYYYMM) { formatstring = "YYYY-MM"; } else if (funFormat == FunFormat.YYYYMMDDHH24MI) { formatstring = "YYYY-MM-DD HH24:MI"; } else if (funFormat == FunFormat.YYYYMMDDHH24MISS) { formatstring = "YYYY-MM-DD HH24:MI:SS"; } str = string.Format(" AND {0} BETWEEN {1}({2},'{3}') AND {1}({4},'{3}')", fieldName, funType.ToString(), str2, formatstring, str4); } if (value1.GetType() == typeof(string) && value2.GetType() == typeof(string)) { object obj1 = value1; object obj2 = value2; if (string.IsNullOrEmpty((string)obj1) || string.IsNullOrEmpty((string)obj2)) { Conditions.Add(""); return; } parameter1 = Driver.GenerateParameter(str2, (DbType)13); parameter2 = Driver.GenerateParameter(str4, (DbType)13); } else if (value1.GetType() == typeof(int) && value2.GetType() == typeof(int)) { parameter1 = Driver.GenerateParameter(str2, (DbType)2); parameter2 = Driver.GenerateParameter(str4, (DbType)2); } else if (value1.GetType() == typeof(float) && value2.GetType() == typeof(float)) { parameter1 = Driver.GenerateParameter(str2, (DbType)2); parameter2 = Driver.GenerateParameter(str4, (DbType)2); } else if (value1.GetType() == typeof(DateTime) && value2.GetType() == typeof(DateTime)) { parameter1 = Driver.GenerateParameter(str2, (DbType)11); parameter2 = Driver.GenerateParameter(str4, (DbType)11); } else { if (value1.GetType() != typeof(decimal) || value2.GetType() != typeof(decimal)) { throw new Exception("不支持的参数类型"); } parameter1 = Driver.GenerateParameter(str2, (DbType)7); parameter2 = Driver.GenerateParameter(str4, (DbType)7); } parameter1.Value = value1; parameter2.Value = value2; cmd.Parameters.Add(parameter1); cmd.Parameters.Add(parameter2); //sqltext.Replace("{0}", str.ToString()); Conditions.Add(str); } }