/// <summary>
/// 通用更新或删除数据(不同的sql语句)
/// </summary>
/// <param name="cmdType">命令类型</param>
/// <param name="cmdText">sql语句或存储过程</param>
/// <param name="sqlParms">参数集合</param>
/// <returns></returns>
public DbExecMsg TOpListData(CommandType cmdType, List <string> cmdText, ref List <SortedList <string, SqlParameter> > sqlParms)
{
DbExecMsg execMsg = new DbExecMsg();
execMsg.IsSuccess = true;
execMsg.ErrType = false;
using (SqlDbOp dbOp = new SqlDbOp(ConnStr))
{
try
{
bool isOpera = false;
dbOp.BeginTrans();
dbOp.DbCmdParm.CmdType = cmdType;
int index = 0;
foreach (var sqlItem in cmdText)
{
dbOp.DbCmdParm.CmdText = sqlItem;
dbOp.DbCmdParm.SqlParms.Clear();
if (sqlParms != null && sqlParms.Count >= index + 1 && sqlParms[index] != null)
{
foreach (var pnItem in sqlParms[index].Keys)
{
dbOp.DbCmdParm.SqlParms.Add(pnItem, sqlParms[index][pnItem]);
}
}
if (dbOp.BExecNonCmd())
{
isOpera = true;
}
else
{
isOpera = false;
break;
}
index++;
}
if (isOpera)
{
dbOp.CommitTrans();
}
else
{
dbOp.RollbackTrans();
}
dbOp.CloseDb();
}
catch (Exception ex)
{
execMsg.IsSuccess = false;
execMsg.ErrMsg = ex;
}
}
return(execMsg);
}
/// <summary>
/// 通用获取DataTable
/// </summary>
/// <param name="cmdType">命令类型</param>
/// <param name="cmdText">sql语句或存储过程名称</param>
/// <param name="sqlParms">参数</param>
/// <param name="dt">返回数据表</param>
/// <returns></returns>
public DbExecMsg TGetTable(CommandType cmdType, string cmdText, ref SortedList <string, SqlParameter> sqlParms, out DataTable dt)
{
DbExecMsg execMsg = new DbExecMsg();
execMsg.IsSuccess = true;
execMsg.ErrType = false;
dt = null;
using (SqlDbOp dbOp = new SqlDbOp(ConnStr))
{
dbOp.DbCmdParm.CmdType = cmdType;
dbOp.DbCmdParm.CmdText = cmdText;
foreach (var pnItem in sqlParms.Keys)
{
dbOp.DbCmdParm.SqlParms.Add(pnItem, sqlParms[pnItem]);
}
try
{
dt = dbOp.GetTable();
dt.TableName = "Table";
//判断是否有业务逻辑错误
foreach (var pnItem in dbOp.DbCmdParm.SqlParms.Keys)
{
if (sqlParms.ContainsKey(pnItem) && dbOp.DbCmdParm.SqlParms[pnItem].Direction == ParameterDirection.Output)
{
if (pnItem == CmdExecErrFlag)
{
if (!string.IsNullOrEmpty(sqlParms[pnItem].Value.ToString().Trim()))
{
execMsg.IsSuccess = false;
execMsg.ErrType = true;
execMsg.ErrMsg = new Exception(sqlParms[pnItem].Value.ToString());
break;
}
}
}
}
}
catch (Exception ex)
{
execMsg.IsSuccess = false;
execMsg.ErrMsg = ex;
}
}
return(execMsg);
}
/// <summary>
/// 通用更新或删除数据
/// </summary>
/// <param name="cmdType">命令类型</param>
/// <param name="cmdText">sql语句或存储过程名称</param>
/// <param name="sqlParms">参数</param>
/// <param name="opRowCount">返回受影响行数</param>
/// <returns></returns>
public DbExecMsg TOpData(CommandType cmdType, string cmdText, ref SortedList <string, SqlParameter> sqlParms, out int opRowCount)
{
DbExecMsg execMsg = new DbExecMsg();
execMsg.IsSuccess = true;
execMsg.ErrType = false;
opRowCount = 0;
using (SqlDbOp dbOp = new SqlDbOp(ConnStr))
{
dbOp.DbCmdParm.CmdType = cmdType;
dbOp.DbCmdParm.CmdText = cmdText;
foreach (var pnItem in sqlParms.Keys)
{
dbOp.DbCmdParm.SqlParms.Add(pnItem, sqlParms[pnItem]);
}
try
{
opRowCount = dbOp.ExecNonCmd();
foreach (var pnItem in dbOp.DbCmdParm.SqlParms.Keys)
{
if (sqlParms.ContainsKey(pnItem) && dbOp.DbCmdParm.SqlParms[pnItem].Direction == ParameterDirection.Output)
{
if (!string.IsNullOrEmpty(sqlParms[pnItem].Value.ToString().Trim()))
{
execMsg.IsSuccess = false;
execMsg.ErrType = true;
execMsg.ErrMsg = new Exception(sqlParms[pnItem].Value.ToString());
opRowCount = -1;
break;
}
}
}
}catch (Exception ex)
{
execMsg.IsSuccess = false;
execMsg.ErrMsg = ex;
}
}
return(execMsg);
}