public int DeleteByCommandIdStatus(int commandId, EntrustStatus status)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_DeleteByCommandIdStatus);
_dbHelper.AddInParameter(dbCommand, "@CommandId", System.Data.DbType.Int32, commandId);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)status);
return _dbHelper.ExecuteNonQuery(dbCommand);
}
//public int Create(EntrustCommandItem item)
//{
// var dbCommand = _dbHelper.GetStoredProcCommand(SP_Create);
// _dbHelper.AddInParameter(dbCommand, "@CommandId", System.Data.DbType.Int32, item.CommandId);
// _dbHelper.AddInParameter(dbCommand, "@Copies", System.Data.DbType.Int32, item.Copies);
// _dbHelper.AddInParameter(dbCommand, "@CreatedDate", System.Data.DbType.DateTime, DateTime.Now);
// _dbHelper.AddReturnParameter(dbCommand, "@return", System.Data.DbType.Int32);
// int ret = _dbHelper.ExecuteNonQuery(dbCommand);
// int entrustId = -1;
// if (ret > 0)
// {
// entrustId = (int)dbCommand.Parameters["@return"].Value;
// }
// return entrustId;
//}
//public int Update(EntrustCommandItem item)
//{
// var dbCommand = _dbHelper.GetStoredProcCommand(SP_Modify);
// _dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, item.SubmitId);
// _dbHelper.AddInParameter(dbCommand, "@EntrustNo", System.Data.DbType.Int32, item.EntrustNo);
// _dbHelper.AddInParameter(dbCommand, "@BatchNo", System.Data.DbType.Int32, item.BatchNo);
// _dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, item.EntrustStatus);
// _dbHelper.AddInParameter(dbCommand, "@DealStatus", System.Data.DbType.Int32, item.DealStatus);
// _dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, DateTime.Now);
// _dbHelper.AddInParameter(dbCommand, "@EntrustFailCode", System.Data.DbType.Int32, item.EntrustFailCode);
// _dbHelper.AddInParameter(dbCommand, "@EntrustFailCause", System.Data.DbType.String, item.EntrustFailCause);
// return _dbHelper.ExecuteNonQuery(dbCommand);
//}
public int UpdateEntrustCommandStatus(int submitId, EntrustStatus entrustStatus)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_ModifyEntrustStatus);
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, DateTime.Now);
return _dbHelper.ExecuteNonQuery(dbCommand);
}
public int UpdateEntrustStatusByEntrustNo(int entrustNo, EntrustStatus entrustStatus)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_ModifyEntrustStatusByEntrustNo);
_dbHelper.AddInParameter(dbCommand, "@EntrustNo", System.Data.DbType.Int32, entrustNo);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, DateTime.Now);
return(_dbHelper.ExecuteNonQuery(dbCommand));
}
//public int UpdateEntrustStatus(List<int> submitIds, EntrustStatus entrustStatus)
//{
// int ret = -1;
// foreach (var submitId in submitIds)
// {
// ret = UpdateOneEntrustStatus(submitId, entrustStatus);
// }
// return ret;
//}
public int UpdateOneEntrustStatus(int submitId, EntrustStatus entrustStatus)
{
var dbCommand = _dbHelper.GetCommand();
_dbHelper.Open(dbCommand);
//use transaction to execute
DbTransaction transaction = dbCommand.Connection.BeginTransaction();
dbCommand.Transaction = transaction;
dbCommand.CommandType = System.Data.CommandType.StoredProcedure;
int ret = -1;
try
{
DateTime now = DateTime.Now;
dbCommand.CommandText = SP_ModifyEntrustCommandStatus;
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, now);
ret = dbCommand.ExecuteNonQuery();
if (ret > 0)
{
dbCommand.Parameters.Clear();
dbCommand.CommandText = SP_ModifyEntrustSecurityStatusBySubmitId;
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, now);
ret = dbCommand.ExecuteNonQuery();
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
//TODO: add log
logger.Error(ex);
ret = -1;
throw;
}
finally
{
_dbHelper.Close(dbCommand);
transaction.Dispose();
}
return(ret);
}
public int UpdateEntrustStatus(int submitId, int commandId, string secuCode, EntrustStatus entrustStatus)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_ModifyEntrustStatus);
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
_dbHelper.AddInParameter(dbCommand, "@CommandId", System.Data.DbType.Int32, commandId);
_dbHelper.AddInParameter(dbCommand, "@SecuCode", System.Data.DbType.String, secuCode);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, DateTime.Now);
return(_dbHelper.ExecuteNonQuery(dbCommand));
}
public int UpdateEntrustCommandBatchNo(int submitId, int batchNo, EntrustStatus entrustStatus, int entrustFailCode, string entrustFailCause)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_ModifyBatchNo);
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
_dbHelper.AddInParameter(dbCommand, "@BatchNo", System.Data.DbType.Int32, batchNo);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)entrustStatus);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, DateTime.Now);
_dbHelper.AddInParameter(dbCommand, "@EntrustFailCode", System.Data.DbType.Int32, entrustFailCode);
_dbHelper.AddInParameter(dbCommand, "@EntrustFailCause", System.Data.DbType.String, entrustFailCause);
return _dbHelper.ExecuteNonQuery(dbCommand);
}
public int UpdateSecurityEntrustStatus(List <EntrustSecurity> entrustItems, EntrustStatus entrustStatus)
{
return(_entrustdao.UpdateSecurityEntrustStatus(entrustItems, entrustStatus));
}
//public int UpdateEntrustStatus(List<int> submitIds, EntrustStatus entrustStatus)
//{
// return _entrustdao.UpdateEntrustStatus(submitIds, entrustStatus);
//}
public int UpdateOneEntrustStatus(int submitId, EntrustStatus entrustStatus)
{
return(_entrustdao.UpdateOneEntrustStatus(submitId, entrustStatus));
}
public int DeleteByCommandIdEntrustStatus(int commandId, EntrustStatus status)
{
return(_entrustsecudao.DeleteByCommandIdEntrustStatus(commandId, status));
}
//public int UpdateEntrustStatusByRequestId(int requestId, int entrustNo, int batchNo, int entrustFailCode, string entrustFailCause)
//{
// return _entrustsecudao.UpdateEntrustStatusByRequestId(requestId, entrustNo, batchNo, entrustFailCode, entrustFailCause);
//}
public int UpdateEntrustNo(int submitId, int commandId, string secuCode, int entrustNo, int batchNo, EntrustStatus entrustStatus)
{
return(_entrustsecudao.UpdateEntrustNo(submitId, commandId, secuCode, entrustNo, batchNo, entrustStatus));
}
public int UpdateEntrustStatusByEntrustNo(int entrustNo, EntrustStatus entrustStatus)
{
return(_entrustsecudao.UpdateEntrustStatusByEntrustNo(entrustNo, entrustStatus));
}
public int UpdateEntrustStatus(int submitId, int commandId, string secuCode, EntrustStatus entrustStatus)
{
return(_entrustsecudao.UpdateEntrustStatus(submitId, commandId, secuCode, entrustStatus));
}
public static string GetEntrustName(EntrustStatus status)
{
return(EnumAttributeHelper.GetEnumDescription <EntrustStatus>(status));
}
public int DeleteByCommandIdStatus(int commandId, EntrustStatus status)
{
Tracking(ActionType.Delete, ResourceType.EntrustCommand, commandId, status.ToString());
return(_entrustcmddao.DeleteByCommandIdStatus(commandId, status));
}
public int UpdateEntrustCommandBatchNo(int submitId, int batchNo, EntrustStatus entrustStatus, int entrustFailCode, string entrustFailCause)
{
Tracking(ActionType.Edit, ResourceType.EntrustCommand, submitId, entrustStatus.ToString());
return(_entrustcmddao.UpdateEntrustCommandBatchNo(submitId, batchNo, entrustStatus, entrustFailCode, entrustFailCause));
}
public int UpdateEntrustCommandStatus(int submitId, EntrustStatus entrustStatus)
{
Tracking(ActionType.Edit, ResourceType.EntrustCommand, submitId, entrustStatus.ToString());
return(_entrustcmddao.UpdateEntrustCommandStatus(submitId, entrustStatus));
}
