private int GetCountFromDictionary <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmDic) { DbDataReader dr = null; int tLst = 0; var logStep = 0; try { //如果为空sql可以,则根据类型和传入参数自动构造select语句,同时where条件为传入参数 var sqlTxt = sqlKey == CommonSqlKey.Null ? SqlConstructor.GetSelectSqlByParmDic <T>(parmDic) : CommSqlText.Instance[sqlKey]; logStep++; var sqlParameters = sqlKey == CommonSqlKey.Null ? null : parmDic; // SqlConstructor.MakeParms(parmDic, CommSqlText.SqlParms[sqlKey]); sqlTxt = SqlConstructor.FilterSQLWithInsteadValue(sqlTxt, sqlParameters); logStep++; sqlParameters = sqlKey == CommonSqlKey.Null ? null : SqlConstructor.FilterParmsWithList(sqlParameters, CommSqlText.SqlParms[sqlKey]); logStep++; tLst = DbHelper.ExecuteScalar(sqlTxt, sqlParameters) == null ? 0 : int.Parse(DbHelper.ExecuteScalar(sqlTxt, sqlParameters).ToString()); } catch (MySqlException ee) { Logger.LogInfo(String.Format("GetFromDictionary ERROR STEP:{0}, EXCEPTION:{1}", logStep, ee.Message), 0, LogType.ERROR); throw ee; } finally { if (dr != null) { dr.Close(); dr.Dispose(); } } return(tLst); }
public DataTable LoadDataTable(CommonSqlKey sqlKey, IDictionary <string, object> parmDic) { var logStep = 0; try { if (sqlKey == CommonSqlKey.Null) { return(null); } var sqlTxt = CommSqlText.Instance[sqlKey]; logStep++; sqlTxt = SqlConstructor.FilterSQLWithInsteadValue(sqlTxt, parmDic); logStep++; parmDic = SqlConstructor.FilterParmsWithList(parmDic, CommSqlText.SqlParms[sqlKey]); logStep++; return(DbHelper.ExecuteDataTable(sqlTxt, parmDic)); } catch (MySqlException ee) { Logger.LogInfo(String.Format("GetSingleFromDicDictionary ERROR STEP:{0}, EXCEPTION:{1}", logStep, ee.Message), 0, LogType.ERROR); throw ee; } }
public DataTable LoadDataTableByConditions(CommonSqlKey sqlKey, IList <Condition> parmObj) { var logStep = 0; try { if (sqlKey == CommonSqlKey.Null) { return(null); } var sqlTxt = CommSqlText.Instance[sqlKey]; logStep++; var parmDic = SqlConstructor.MakeParms(parmObj); List <DbParameter> parameter; var whereSql = ConditionHandler.GetWhereSql(parmObj.ToList(), out parameter, sqlKey); sqlTxt = SqlConstructor.FilterSQLWithInsteadValue(sqlTxt + whereSql, parmDic); logStep++; parmDic = SqlConstructor.FilterParmsWithList(parmDic, CommSqlText.SqlParms[sqlKey]); logStep++; return(DbHelper.ExecuteDataTable(sqlTxt, parmDic)); } catch (MySqlException ee) { Logger.LogInfo(String.Format("GetSingleFromDicDictionary ERROR STEP:{0}, EXCEPTION:{1}", logStep, ee.Message), 0, LogType.ERROR); throw ee; } }
public List <T> Load <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); //parmDic = SqlConstructor.FilterParmsWithList(parmDic, CommSqlText.SqlParms[sqlKey]); return(GetFromDictionary <T>(sqlKey, parmDic)); }
public object Execute(CommonSqlKey sqlKey) { var sqlContent = CommSqlText.Instance[sqlKey]; var result = DbHelper.ExecuteScalar(sqlContent); return(result); }
public List <T> Load <T>(CommonSqlKey sqlKey, T parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); var resultLst = GetFromDictionary <T>(sqlKey, parmDic); return(resultLst); }
private List <T> GetFromDictionary <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmDic) { DbConnection dbConn = null; DbDataReader dr = null; var tLst = new List <T>(); var logStep = 0; try { //如果为空sql可以,则根据类型和传入参数自动构造select语句,同时where条件为传入参数 var sqlTxt = sqlKey == CommonSqlKey.Null ? SqlConstructor.GetSelectSqlByParmDic <T>(parmDic) : CommSqlText.Instance[sqlKey]; logStep++; var sqlParameters = sqlKey == CommonSqlKey.Null ? null : parmDic; // SqlConstructor.MakeParms(parmDic, CommSqlText.SqlParms[sqlKey]); sqlTxt = SqlConstructor.FilterSQLWithInsteadValue(sqlTxt, sqlParameters); logStep++; sqlParameters = sqlKey == CommonSqlKey.Null ? null : SqlConstructor.FilterParmsWithList(sqlParameters, CommSqlText.SqlParms[sqlKey]); logStep++; dr = DbHelper.ExecuteReader(sqlTxt, sqlParameters, ref dbConn); logStep = 100; if (dr == null) { return(tLst); } var hasCount = dr.Read(); while (hasCount) { logStep += 10; var t = MakeMapToObject <T>(dr); if (t != null) { tLst.Add(t); } logStep += 1; hasCount = dr.Read(); } } catch (MySqlException ee) { //Logger.LogInfo(String.Format("GetFromDictionary ERROR STEP:{0}, EXCEPTION:{1}", logStep, ee.Message), 0, LogType.ERROR); throw ee; } finally { if (dr != null) { dr.Close(); dr.Dispose(); } if (dbConn != null) { dbConn.Close(); dbConn.Dispose(); } } return(tLst); }
public object Execute <T>(CommonSqlKey sqlKey, T t) { var sqlContent = CommSqlText.Instance[sqlKey]; var sqlParameters = SqlConstructor.MakeParms(t); sqlParameters = SqlConstructor.FilterParmsWithList(sqlParameters, CommSqlText.SqlParms[sqlKey]); var result = DbHelper.ExecuteScalar(sqlContent, sqlParameters); return(result); }
public int Delete <T>(CommonSqlKey sqlKey, T t) { var sqlContent = CommSqlText.Instance[sqlKey]; var sqlParameters = SqlConstructor.MakeParms(t); sqlContent = SqlConstructor.FilterSQLWithInsteadValue(sqlContent, sqlParameters); sqlParameters = SqlConstructor.FilterParmsWithList(sqlParameters, CommSqlText.SqlParms[sqlKey]); var result = DbHelper.ExecuteNonQuery(sqlContent, sqlParameters); return(result); }
public int CountByConditions(CommonSqlKey sqlKey, IList <Condition> parmObj) { var result = 0; var parmDic = SqlConstructor.MakeParms(parmObj); var sqlTxt = CommSqlText.Instance[sqlKey]; var sqlParameters = parmDic; //解析where 后查询条件 List <DbParameter> parameter; var whereSql = ConditionHandler.GetWhereSql(parmObj.ToList(), out parameter, sqlKey); sqlTxt = sqlTxt + whereSql; result = DbHelper.ExecuteScalar(sqlTxt, sqlParameters) == null ? 0 : int.Parse(DbHelper.ExecuteScalar(sqlTxt, sqlParameters).ToString()); return(result); }
public T Get <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmDic) where T : class { var resultLst = Load <T>(sqlKey, parmDic); return(resultLst != null && resultLst.Count > 0 ? resultLst[0] : null); }
public T Get <T>(CommonSqlKey sqlKey, T t) where T : class { var resultLst = Load(sqlKey, t); return(resultLst != null && resultLst.Count > 0 ? resultLst[0] : null); }
public object Single <T>(CommonSqlKey sqlKey, T parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetSingleFromDicDictionary(sqlKey, parmDic)); }
public object Single(CommonSqlKey sqlKey, IDictionary <string, object> parmDic) { return(GetSingleFromDicDictionary(sqlKey, parmDic)); }
public object Single(CommonSqlKey sqlKey) { return(GetSingleFromDicDictionary(sqlKey, null)); }
public List <T> Load <T>(CommonSqlKey sqlKey) { return(GetFromDictionary <T>(sqlKey, null)); }
private List <T> GetFromDictionaryByConditionsWithOrder <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmDic, IList <Condition> conditions, string orderField = "", string orderType = "") { DbDataReader dr = null; DbConnection dbConn = null; var tLst = new List <T>(); var logStep = 0; try { var sqlTxt = CommSqlText.Instance[sqlKey]; logStep++; var sqlParameters = parmDic; //解析where 后查询条件 List <DbParameter> parameter; var whereSql = ConditionHandler.GetWhereSql(conditions.ToList(), out parameter, sqlKey, orderField, orderType); sqlTxt = sqlTxt + whereSql; logStep++; logStep++; dr = DbHelper.ExecuteReader(sqlTxt, sqlParameters, ref dbConn); logStep = 100; if (dr == null) { return(tLst); } var hasCount = dr.Read(); while (hasCount) { logStep += 10; var t = MakeMapToObject <T>(dr); if (t != null) { tLst.Add(t); } logStep += 1; hasCount = dr.Read(); } } catch (MySqlException ee) { Logger.LogInfo(String.Format("GetFromDictionary ERROR STEP:{0}, EXCEPTION:{1}", logStep, ee.Message), 0, LogType.ERROR); throw ee; } finally { if (dr != null) { dr.Close(); dr.Dispose(); } if (dbConn != null) { dbConn.Close(); dbConn.Dispose(); } } return(tLst); }
public List <T> LoadByConditionsWithOrder <T>(CommonSqlKey sqlKey, IList <Condition> parmObj, string orderField = "", string orderType = "") { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetFromDictionaryByConditionsWithOrder <T>(sqlKey, parmDic, parmObj, orderField, orderType)); }
public List <T> LoadByConditions <T>(CommonSqlKey sqlKey, IList <Condition> parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetFromDictionaryByConditions <T>(sqlKey, parmDic, parmObj)); }
public static string GetWhereSql(IList conditions, out List <DbParameter> parameter, CommonSqlKey sqlKey, string orderField = "", string orderType = "") { var text = "?"; var preParaName = "p_"; var list = new List <DbParameter>(); var stringBuilder = new StringBuilder(); var conditionsCount = ConditionsCounter(conditions); if (conditions.Count > 0 && conditionsCount > 0) { // stringBuilder.Append(" AND"); } var num = 0; foreach (Condition condition in conditions) { if (condition.Operation == ConditionOperate.None) { continue; } if (condition.ParamValue != null) { string text2; if (string.IsNullOrEmpty(condition.Logic)) { text2 = ""; } else { text2 = ((condition.Logic == "AND") ? "AND" : "OR"); } if (conditions.Count - 1 == num) { text2 = ""; } var paramName = condition.DbColumnName; var text3 = preParaName + condition.ParamName; switch (condition.Operation) { case ConditionOperate.Equal: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " = ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.IN: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " in ", "(", text, text3, ")", condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.INWithNoPara: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " in ", "(", condition.ParamValue.ToString(), ")", condition.RightBrace, " ", text2 })); break; case ConditionOperate.NotEqual: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " <> ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.Greater: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " > ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.GreaterThan: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " >= ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.Less: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " < ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.LessThan: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " <= ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue)); break; case ConditionOperate.Null: stringBuilder.Append(string.Format(" " + condition.LeftBrace + "{0} is null ", paramName) + condition.RightBrace + " " + text2); break; case ConditionOperate.NotNull: stringBuilder.Append(string.Format(" " + condition.LeftBrace + "{0} is not null ", paramName) + condition.RightBrace + " " + text2); break; case ConditionOperate.OrderBy: stringBuilder.Append(string.Format(" " + condition.LeftBrace + "order by {0} {1} ", paramName, condition.ParamValue) + condition.RightBrace + " " + text2); break; case ConditionOperate.GroupBy: stringBuilder.Append(string.Format(" " + condition.LeftBrace + "group by {0} {1} ", paramName, condition.ParamValue) + condition.RightBrace + " " + text2); break; case ConditionOperate.LimitIndex: //stringBuilder.Append($" limit {text + "p_" + condition.ParamName}"); stringBuilder.Append(string.Format(" limit {0} ", text + preParaName + condition.ParamName)); break; case ConditionOperate.LimitLength: //stringBuilder.Append($",{text + "p_" + condition.ParamName} "); stringBuilder.Append(string.Format(" ,{0} ", text + preParaName + condition.ParamName)); break; case ConditionOperate.Like: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " like ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, "%" + condition.ParamValue + "%")); break; case ConditionOperate.NotLike: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " not like ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, "%" + condition.ParamValue + "%")); break; case ConditionOperate.LeftLike: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " like ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, "%" + condition.ParamValue)); break; case ConditionOperate.RightLike: stringBuilder.Append(string.Concat(new string[] { " ", condition.LeftBrace, paramName, " like ", text, text3, condition.RightBrace, " ", text2 })); list.Add(CreateDbParameter(text + text3, condition.ParamValue + "%")); break; case ConditionOperate.Yesterday: { var dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(-1.0).ToString("yyyy-MM-dd") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(-1.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.Today: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTimeHandler.GetToday() + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTimeHandler.GetToday() + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.Tomorrow: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(1.0).ToString("yyyy-MM-dd") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(1.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.LastWeek: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays((double)(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) - 7)).ToString("yyyy-MM-dd") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(dateTime.AddDays(6.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.ThisWeek: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays((double)(1 - Convert.ToInt32(DateTime.Now.DayOfWeek))).ToString("yyyy-MM-dd") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(dateTime.AddDays(6.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.NextWeek: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays((double)(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) + 7)).ToString("yyyy-MM-dd") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(dateTime.AddDays(6.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.LastMonth: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddMonths(-1).ToString("yyyy-MM-01") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddDays(-1.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.ThisMonth: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.ToString("yyyy-MM-01") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTime.Now.AddMonths(1).AddDays(-1.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.NextMonth: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddMonths(1).ToString("yyyy-MM-01") + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(2).AddDays(-1.0).ToString("yyyy-MM-dd") + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.BeforeDay: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(double.Parse("-" + condition.ParamValue.ToString())) + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTimeHandler.GetToday() + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } case ConditionOperate.AfterDay: { DateTime dateTime = DateTimeHandler.GetDateTime(DateTime.Now.AddDays(double.Parse(condition.ParamValue.ToString())) + " 00:00"); DateTime dateTime2 = DateTimeHandler.GetDateTime(DateTimeHandler.GetToday() + " 23:59"); stringBuilder.Append(string.Format(string.Concat(new string[] { " ", condition.LeftBrace, "{0} between ", text, "start{1} AND ", text, "end_{2}", condition.RightBrace }), paramName, text3, text3) + " " + text2); list.Add(CreateDbParameter(text + string.Format("start{0}", text3), dateTime)); list.Add(CreateDbParameter(text + string.Format("end_{0}", text3), dateTime2)); break; } } num++; } } if (!string.IsNullOrEmpty(orderField)) { orderType = ((orderType.ToLower() == "desc") ? "desc" : "asc"); stringBuilder.Append(" Order By " + orderField + " " + orderType); } parameter = list; string finalWhereCondition = stringBuilder.ToString().Trim().ToUpper(); if (string.IsNullOrEmpty(finalWhereCondition) || finalWhereCondition.Length < 3) { return(finalWhereCondition); } switch (sqlKey) { case CommonSqlKey.GetCustomer: return(finalWhereCondition); case CommonSqlKey.GetCustomerCount: return(finalWhereCondition); case CommonSqlKey.GetAuth: return(finalWhereCondition); case CommonSqlKey.GetRankValue: return(finalWhereCondition); case CommonSqlKey.GetProductByMachine: return(finalWhereCondition); case CommonSqlKey.GetProductByMachineCount: return(finalWhereCondition); case CommonSqlKey.GetTotalMoneyByClient: return(finalWhereCondition); case CommonSqlKey.GetSalesAmountByMachine: return(finalWhereCondition); case CommonSqlKey.GetSalesAmountByMachineCount: return(finalWhereCondition); case CommonSqlKey.GetStatisticSalesMoneyByDate: return(finalWhereCondition); case CommonSqlKey.GetLogin: return(finalWhereCondition); case CommonSqlKey.GetUser: return(finalWhereCondition); case CommonSqlKey.GetUserCount: return(finalWhereCondition); case CommonSqlKey.GetMenuByUser: return(finalWhereCondition); case CommonSqlKey.GetAuthDic: return(finalWhereCondition); case CommonSqlKey.GetAuthByDmsId: return(finalWhereCondition); case CommonSqlKey.GetDic: return(finalWhereCondition); case CommonSqlKey.GetRank: return(finalWhereCondition); case CommonSqlKey.GetMachineCountWithStatus: return(finalWhereCondition); case CommonSqlKey.GetMachineType: return(finalWhereCondition); case CommonSqlKey.ExportByTunnel: return(finalWhereCondition); case CommonSqlKey.ExportByProduct: return(finalWhereCondition); case CommonSqlKey.GetProductInfoByWaresId: return(finalWhereCondition); } if (finalWhereCondition.Substring(0, 3) == "AND") { finalWhereCondition = " WHERE " + finalWhereCondition.Substring(3, finalWhereCondition.Length - 3) + " "; } return(finalWhereCondition); }
public int CountByDictionary <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetCountFromDictionary <T>(sqlKey, parmDic)); }