Verify_Execute 验证SQL语句执行结果

#region Verify_Execute
/// <summary>
/// 验证insert、update、delete执行
/// </summary>
/// <param name=”tran”>事务</param>
/// <param name=”retrow”>执行返回值</param>
/// <param name=”inputmessage”>提示信息</param>
/// <param name=”errorMessage”></param>
/// <returns>-1执行错误；0执行成功影响行数为零；>0执行成功</returns>
protected int VerifyExecute(IDbTransaction tran, int retrow, string inputmessage,string warningmessage,string EventModel, ref string errorMessage)
{
if (!string.IsNullOrEmpty(errorMessage))
{
this.RollbackTransaction(tran);
return -1;
}
else if (retrow == 0)
{
TSYSLOGDao dao = new TSYSLOGDao();
dao.InsertRecord(new TSYSLOG()
{
EVENTTYPE = “warning”,
EVENTCONTENT = warningmessage,
EVENTMODEL = EventModel,
USERID = CommonObjectsDA.USERID
}, ref errorMessage);
return 1;
// errorMessage = inputmessage + “,影响行数为0”;
// this.RollbackTransaction(tran);
// return 0;
}
else
{
return retrow;
}
}
/// <summary>
/// 验证insert、update、delete执行
/// </summary>
/// <param name=”tran”>事务</param>
/// <param name=”retrow”>执行返回值</param>
/// <param name=”inputmessage”>提示信息</param>
/// <param name=”errorMessage”></param>
/// <returns>-1执行错误；0执行成功影响行数为零；>0执行成功</returns>
protected int VerifyExecute(IDbTransaction tran, int retrow, string inputmessage, ref string errorMessage)
{
if (!string.IsNullOrEmpty(errorMessage))
{
this.RollbackTransaction(tran);
return -1;
}
//else if (retrow == 0)
//{

// errorMessage = inputmessage + “,影响行数为0”;
// this.RollbackTransaction(tran);
// return 0;
//}
else
{
return retrow;
}
}
protected int VerifyExecute(IDbTransaction tran, ref string errorMessage)
{
if (!string.IsNullOrEmpty(errorMessage))
{
this.RollbackTransaction(tran);
return -1;
}
else
{
return 0;
}
}
/// <summary>
/// 验证select执行
/// </summary>
/// <param name=”tran”>事务</param>
/// <param name=”retvalue”>执行返回值(double、decimal、int、List.Count)</param>
/// <param name=”inputmessage”>提示信息</param>
/// <param name=”_nullable”>执行返回值可否为0或null；true可以</param>
/// <param name=”errorMessage”></param>
/// <returns>-1执行错误；0返回行数为零；>0返回数据</returns>
protected int VerifyExecute(IDbTransaction tran, decimal retvalue, string inputmessage, bool _nullable, ref string errorMessage)
{
this.nullable = _nullable;
if (!string.IsNullOrEmpty(errorMessage))
{
this.RollbackTransaction(tran);
return -1;
}
else
{
if (!_nullable && retvalue == 0)
{
errorMessage = inputmessage;
this.RollbackTransaction(tran);
return 0;
}
return 1;
}
}

/// <summary>
/// 验证select执行
/// </summary>
/// <param name=”tran”>事务</param>
/// <param name=”retvalue”>执行返回值(string)</param>
/// <param name=”inputmessage”>提示信息</param>
/// <param name=”_nullable”>执行返回值可否为0或null；true可以</param>
/// <param name=”errorMessage”></param>
/// <returns>-1执行错误；0返回行数为零；>0返回数据</returns>
protected int VerifyExecute(IDbTransaction tran, string retvalue, string inputmessage, bool _nullable, ref string errorMessage)
{
this.nullable = _nullable;
if (!string.IsNullOrEmpty(errorMessage))
{
this.RollbackTransaction(tran);
return -1;
}
else
{
if (!_nullable && retvalue == null)
{
errorMessage = inputmessage;
this.RollbackTransaction(tran);
return 0;
}
return 1;
}
}
#endregion