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