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("未审核");
}
}
