public void Check(string id, DateTime start, EnmResult status, string comment) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@Comment", SqlDbType.VarChar, 512) }; using (var conn = new SqlConnection(this._databaseConnectionString)) { if (conn.State != ConnectionState.Open) { conn.Open(); } var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(start); parms[2].Value = (int)status; parms[3].Value = SqlTypeConverter.DBNullStringChecker(comment); SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Sc.Sql_M_Reservation_Repository_Check, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } }
public void Check(string id, DateTime start, EnmResult status, string comment) { if (id == null || string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } _repository.Check(id, start, status, comment); }
public static string GetResStatusDisplay(EnmResult status) { switch (status) { case EnmResult.Failure: return("未通过"); case EnmResult.Success: return("已通过"); default: return("未审核"); } }