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));
}