public static string sql_UpdateTrialLogStatus(long Id, TrialLogStatus status)
{
string sql = $@"update [TrialLog]
set TrialLogStatus = {(int)status}
where Id={Id}";
return(sql);
}
public static string GetTrialLogStatusName(TrialLogStatus trialLogStatus)
{
switch (trialLogStatus)
{
case TrialLogStatus.Cancel:
return("取消");
case TrialLogStatus.Done:
return("完成");
case TrialLogStatus.TecConfirm:
return("已安排");
case TrialLogStatus.UserApply:
return("用户申请");
case TrialLogStatus.UserNotCome:
return("未参加");
}
return("");
}
public void UpdateTrialStatus(long Id, TrialLogStatus status)
{
var sql = sql_UpdateTrialLogStatus(Id, status);
_dbContext.Database.ExecuteSqlRaw(sql);
}