/// <summary>
/// 为即将执行准备一个命令
/// </summary>
/// <param name="conn">SqlConnection对象</param>
/// <param name="cmd">SqlCommand对象</param>
/// <param name="isOpenTrans">DbTransaction对象</param>
/// <param name="cmdType">执行命令的类型（存储过程或T-SQL，等等）</param>
/// <param name="cmdText">存储过程名称或者T-SQL命令行, e.g. Select * from Products</param>
/// <param name="dbParameter">执行命令所需的sql语句对应参数</param>
private void PrepareCommand(DbConnection conn, IDbCommand cmd, DbTransaction isOpenTrans, CommandType cmdType, string cmdText, params DbParameter[] dbParameter)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (isOpenTrans != null)
{
cmd.Transaction = isOpenTrans;
}
cmd.CommandType = cmdType;
if (dbParameter != null)
{
dbParameter = DbParameters.ToDbParameter(dbParameter);
foreach (var parameter in dbParameter)
{
cmd.Parameters.Add(parameter);
}
}
}
/// <summary>
/// 根据SQL语句获得对象列表
/// </summary>
/// <param name="strSql"></param>
/// <param name="dbParameter"></param>
/// <returns></returns>
public ResultClass <List <TEntity> > FindList(string strSql, Dictionary <string, object> dbParameters)
{
ResultClass <List <TEntity> > _ret = new ResultClass <List <TEntity> >();
try
{
List <DbParameter> dbParameter = DbParameters.ToDbParameter(dbParameters);
_ret.ResultData = dbcontext.Database.SqlQuery <TEntity>(strSql, dbParameter.ToArray()).ToList <TEntity>();
if (_ret.ResultData != null && _ret.ResultData.Count > 0)
{
_ret.Result = true;
}
else
{
_ret.ErrorMessage = "没有数据!";
}
}
catch (Exception ex)
{
_ret.ErrorMessage = ex.Message;
}
return(_ret);
}
/// <summary>
/// 删除一条信息
/// </summary>
/// <param name="strSql"></param>
/// <param name="dbParameter"></param>
/// <returns></returns>
public ResultClass <int> Delete(string strSql, Dictionary <string, object> dbParameters)
{
ResultClass <int> _ret = new ResultClass <int>();
try
{
List <DbParameter> dbParameter = DbParameters.ToDbParameter(dbParameters);
_ret.ResultData = dbcontext.Database.ExecuteSqlCommand(strSql, dbParameter.ToArray());
if (_ret.ResultData > 0)
{
_ret.Result = true;
}
else
{
_ret.ErrorMessage = "删除数据失败!";
}
}
catch (Exception ex)
{
_ret.ErrorMessage = ex.Message;
}
return(_ret);
}