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 List <T> Load <T>(CommonSqlKey sqlKey, T parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); var resultLst = GetFromDictionary <T>(sqlKey, parmDic); return(resultLst); }
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 object Single <T>(CommonSqlKey sqlKey, T parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetSingleFromDicDictionary(sqlKey, parmDic)); }
public int CountByDictionary <T>(CommonSqlKey sqlKey, IDictionary <string, object> parmObj) { var parmDic = SqlConstructor.MakeParms(parmObj); return(GetCountFromDictionary <T>(sqlKey, parmDic)); }
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)); }