/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <param name="list"></param>
/// <returns></returns>
public static bool AuditMainAdd(AuditMain model)
{
using (SqlConnection con = new SqlConnection(ConfigSetting.DataConnection))
{
con.Open();
var transaction = con.BeginTransaction();
try
{
string sql = string.Format("insert into {0}([UserId],[Money],[ConfigId],[CompanyId],[CreateDate],[IsDeleted],[Status],[OperateId],[Remark],[MainId],[Images],[NextOperateId],[NowCount],[TotalCount]) values(@UserId,@Money,@ConfigId,@CompanyId,getdate(),0,@Status,@OperateId,@Remark,@MainId,@Images,@NextOperateId,@NowCount,@TotalCount)", TableName);
con.Execute(sql, model, transaction);
sql = string.Format("insert into {0}([UserId],[Step],[AuditMainId],[CompanyId],[Remark],[OperateBy],[Status],[CreateDate],[ModifyDate]) values(@UserId,@Step,@AuditMainId,@CompanyId,@Remark,@OperateBy,@Status,getdate(),getdate())", DetailTableName);
con.Execute(sql, model.DetailList, transaction);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
SystemLogDBOperate.AddSystemLog(new SystemLog()
{
Ip = Util.CommonMethod.GetClientIP,
LogLevel = LogLevel.Error.ToString(),
MainContent = ex.Message,
MainKey = "AuditMainAdd",
MainRequest = Util.CommonMethod.ToJson(model),
UserId = model.UserId,
});
return(false);
}
}
return(false);
}
public static AuditMain GetAuditMainById(int id, out string message)
{
message = "";
AuditMain main = new AuditMain();
try
{
main = AuditMainDBOperate.GetAuditMainById(id);
if (main == null)
{
message = "MainNull"; return(null);
}
var list = AuditMainDBOperate.GetAuditDetailList(main.MainId);
var memeberList = CompanyUserDBOperate.GetUserByIds(list.Select(a => a.OperateBy).ToArray());
list.ForEach(a => {
var model = memeberList.FirstOrDefault(b => b.Id == a.OperateBy);
if (model == null)
{
return;
}
a.OperateName = model.Name;
a.OperateHeadUrl = model.WeChatHeadUrl;
});
main.DetailList = list;
}
catch (Exception ex)
{
LogBussiness.AddLog("GetAuditMainById", id + "", ex.Message, Util.LogLevel.Error);
}
return(main);
}
internal IEnumerable <AuditMain> GetaAuditMain(int SourceInfoId = 0, DateTime?LastAudited = null)
{
SqlConnection conn = null;
SqlDataReader dr = null;
List <AuditMain> audits = new List <AuditMain>();
try
{
conn = new SqlConnection(cnxString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.QA_Audit_sel_main";
cmd.Parameters.AddWithValue("@SourceInfoid", DbType.String).Value = SourceInfoId;
cmd.Parameters.AddWithValue("@Last_Audited", DbType.DateTime).Value = LastAudited;
using (dr = cmd.ExecuteReader())
{
while (dr.HasRows && dr.Read())
{
AuditMain audit = new AuditMain();
audit.SourceInfoId = dr.GetInt32(0);
audit.SourceType = dr.GetString(1);
audit.SourceName = dr.GetString(2);
audit.PriorityID = dr.GetInt32(3);
audit.SourcePoints = dr.GetInt32(4);
audit.LastAudited = dr.IsDBNull(5) ? DateTime.MinValue : dr.GetDateTime(5);
audit.SourceIsActive = dr.GetBoolean(6);
audit.SourcePass = dr.IsDBNull(7) ? false : dr.GetBoolean(7);
audit.SourceUrl = dr.IsDBNull(8) ? string.Empty : dr.GetString(8);
audit.InProgress = dr.GetInt32(9);
//audit.PassedRecords = dr.GetInt32(11);//dr.GetInt32(10) failed records;
audit.PriorityName = dr.GetString(10);
audits.Add(audit);
}
dr.Close();
}
}
catch (Exception e)
{ }
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(audits);
}
/// <summary>
/// 添加审核
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddAudit(AuditMain model, out string msg)
{
msg = "";
try
{
var auditStepList = AuditStepDBOperate.GetAuditStepByDepartId(model.DepartId);//获取当前人部门的审核步骤
if (auditStepList.Count() == 0)
{
msg = "StepNull"; return(false);
}
var auditDetail = auditStepList.ConvertAll(a => new AuditDetail()
{
AuditMainId = model.MainId,
OperateBy = a.UserId,
Status = (int)AuditStatus.NotCheck,
Step = a.Step,
UserId = model.UserId,
CompanyId = model.CompanyId
}).ToList();//插入详情
auditDetail[0].Status = (int)AuditStatus.NextCheck;
model.Status = (int)AuditStatus.Pass;
model.NowCount = 0;
model.TotalCount = auditDetail.Count();
model.NextOperateId = auditDetail[0].OperateBy;
#region 默认插入发起审核记录
auditDetail.Insert(0, new AuditDetail()
{
AuditMainId = model.MainId,
Step = 0,
ModifyDate = DateTime.Now,
CreateDate = DateTime.Now,
CompanyId = model.CompanyId,
Status = (int)AuditStatus.Pass,
UserId = model.UserId,
OperateBy = model.UserId,
Remark = "发起审核"
});
#endregion
model.DetailList = auditDetail;
var flag = AuditMainDBOperate.AuditMainAdd(model);
return(flag);
}
catch (Exception ex)
{
LogBussiness.AddLog("AddAudit", CommonMethod.ToJson(model), ex.Message, Util.LogLevel.Error);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Int32.TryParse(Request.QueryString.Get("Sourceinfoid"), out Sourceinfoid);
//Sourceinfoid = 2224;
if (Sourceinfoid == 0)
{
Response.Redirect("Default.aspx", true);
}
else
{
lnk_see_all.NavigateUrl = lnk_see_all.NavigateUrl + "?SourceInfoid=" + Sourceinfoid.ToString();
IEnumerable <AuditArchive> history = serv.GetAllArchive(Sourceinfoid).Take(3);
gv_lastest.DataSource = history;
gv_lastest.DataBind();
AuditArchive activeArchive = serv.GetActiveArchive(Sourceinfoid, 0);
if (activeArchive != null)
{
startTimeActive.Value = activeArchive.StartTime.ToString("dd-MM-yyyy HH:mm:ss");
endTimeActive.Value = activeArchive.EndTime.ToString("dd-MM-yyyy HH:mm:ss");
}
if (activeArchive != null && activeArchive.EndTime > DateTime.Now)
{
CreateGridAndHeaderInfo(true);
}
else
{
if (activeArchive != null)
{
activeArchive.IsActive = false;
serv.UpdateArchive(activeArchive);
Response.Redirect(Request.RawUrl);
}
btn_confirm_start_audit.Visible = true;
AuditMain audit = serv.GetAuditBySourceInfoId(Sourceinfoid, true);
lb_sourceinfoid.Text = Sourceinfoid.ToString();
lb_sourcename.Text = audit.SourceName;
lb_sourcetype.Text = audit.SourceType;
lb_lastaudited.Text = audit.LastAudited.ToString();;
lb_passfail.Text = audit.SourcePass == true ? "Passed" : "Failed";
lb_url.Text = audit.SourceUrl;
}
}
}
}
protected void grid1_UpdateCommand(object sender, Obout.Grid.GridRecordEventArgs e)
{
try
{
//int isActive = e.Record["SourceIsActive"].ToString() == "true" ? 1 : 0;
//int passFail = e.Record["SourcePass"].ToString() == "true" ? 1 : 0;
AuditMain audit = new AuditMain();
audit.SourceInfoId = Int32.Parse(e.Record["SourceInfoId"].ToString());
audit.PriorityName = e.Record["PriorityName"].ToString();
audit.SourcePoints = Int32.Parse(e.Record["SourcePoints"].ToString());
audit.SourceIsActive = e.Record["SourceIsActive"].ToString() == "true" ? true : false;
audit.SourcePass = e.Record["SourcePass"].ToString() == "true" ? true : false;
serv.UpdateAuditMain(audit);
}
catch (Exception err)
{ }
}
protected void CreateGridAndHeaderInfo(bool headerInfo = false)
{
Int32.TryParse(Request.QueryString.Get("Sourceinfoid"), out Sourceinfoid);
//Sourceinfoid = 2224;
AuditMain audit = serv.GetAuditBySourceInfoId(Sourceinfoid, true);
//todo: if all qstns are passed, show finishing answering button.
if (headerInfo)
{
lb_sourceinfoid.Text = Sourceinfoid.ToString();
lb_sourcename.Text = audit.SourceName;
lb_sourcetype.Text = audit.SourceType;
lb_lastaudited.Text = audit.LastAudited.ToString();;
lb_passfail.Text = audit.SourcePass == true ? "Passed" : "Failed";
lb_url.Text = audit.SourceUrl;
}
grid1.Visible = true;
grid1.DataSource = audit.TestData;
grid1.DataBind();
}
/// <summary>
/// 发起审核
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult AddAuditMain(AuditMain model)
{
ResultInfo info = new ResultInfo();
string message = "";
if (model.Id == 0)
{
model.DepartId = CookieOperate.MemberCookie.DepartId;
model.CompanyId = CookieOperate.MemberCookie.CompanyId;
model.UserId = CookieOperate.MemberCookie.Id;
model.Status = 1;
model.OperateId = CookieOperate.MemberCookie.Id;
model.MainId = Guid.NewGuid().ToString().Replace("-", "");
info.IsSuccess = AuditBussiness.AddAudit(model, out message);
info.Code = message;
}
else
{
}
return(Json(info));
}
internal bool UpdateAuditMain(AuditMain audit)
{
bool flag = false;
SqlConnection conn = null;
try
{
conn = new SqlConnection(cnxString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.QA_Audit_upd_main";
cmd.Parameters.AddWithValue("@Sourceinfoid", DbType.Int32).Value = audit.SourceInfoId;
cmd.Parameters.AddWithValue("@PriorityName", DbType.String).Value = audit.PriorityName;
cmd.Parameters.AddWithValue("@Points", DbType.Int32).Value = audit.SourcePoints;
cmd.Parameters.AddWithValue("@SourceIsActive", DbType.Int32).Value = Convert.ToInt32(audit.SourceIsActive);
int result = cmd.ExecuteNonQuery();
flag = true;
}
catch (Exception e)
{
flag = false;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(flag);
}
public IActionResult CancelAudit(AuditViewModel audit)
{
try
{
object response = "";
if (isAuditor)
{
if (audit != null)
{
if (audit.AuditorQuitReasonId != null && int.TryParse(audit.AuditorQuitReasonId, out int tempreasonid))
{
if (tempreasonid > 0)
{
var cancelreason = _auditToolContext.ListOfValue.Where(x => x.Id == Int32.Parse(audit.AuditorQuitReasonId)).FirstOrDefault();
AuditMain main = new AuditMain
{
TicketId = audit.TicketId,
Agent34Id = audit.Agent34Id,
AgentName = audit.AgentName,
AuditorName = audit.AuditorName,
AuditType = audit.EnvironmentType,
ServiceGroupId = audit.ServiceCatId,
SubcategoryId = audit.SubCatId,
SubmitDt = DateTime.Now,
AuditorQuit = "Quit",
AuditorQuitReason = cancelreason.Code,
TicketDate = audit.TicketDate,
CreatedDate = DateTime.Now,
CreatedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName,
ModifiedDate = DateTime.Now,
ModifiedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName
};
_auditToolContext.AuditMain.Add(main);
_auditToolContext.SaveChanges();
}
else
{
response = "1";
}
}
else
{
response = "1";
}
}
else
{
response = "1";
}
return(Json(response));
}
}
catch (Exception ex)
{
_logger.LogInformation($"Exception in CancelAudit method");
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "AuditController_CancelAudit", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
return(RedirectToAction("Index", "Home"));
}
public IActionResult SaveAudit(AuditViewModel audit)
{
try
{
if (isAuditor)
{
if (audit != null)
{
AuditMain main = new AuditMain
{
TicketId = audit.TicketId,
Agent34Id = audit.Agent34Id,
AgentName = audit.AgentName,
AuditNotes = audit.AuditNote,
AuditorName = audit.AuditorName,
AuditType = audit.EnvironmentType,
ServiceGroupId = audit.ServiceCatId,
SubcategoryId = audit.SubCatId,
SubmitDt = DateTime.Now,
TicketDate = audit.TicketDate,
IsEscalated = audit.isEscalated,
CreatedDate = DateTime.Now,
CreatedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName,
ModifiedDate = DateTime.Now,
ModifiedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName
};
_auditToolContext.AuditMain.Add(main);
_auditToolContext.SaveChanges();
foreach (var item in audit.Question)
{
AuditMainResponse obj = new AuditMainResponse
{
QuestionId = item.QuestionId,
AuditMainId = main.Id,
QuestionRank = item.QuestionSequence,
TicketId = main.TicketId,
IsCompliant = item.Action.IsCompliance,
IsCorrectionRequired = item.CorrectionRequire,
IsHighNonComplianceImpact = item.Action.Impact.IsHighImpact,
IsLowNonComplianceImpact = item.Action.Impact.IsLowImpact,
IsNa = item.Action.IsNotApplicable,
IsNonCompliant = item.Action.IsNonCompliance,
NonComplianceComments = item.Comments,
CreatedDate = DateTime.Now,
CreatedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName,
ModifiedDate = DateTime.Now,
ModifiedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName
};
_auditToolContext.AuditMainResponse.Add(obj);
_auditToolContext.SaveChanges();
}
FormatAndSendEmail(main.Id);
}
ViewBag.Success = "Success";
var listOfValues = _auditToolContext.ListOfValue.Where(x => x.IsActive == true &&
x.CodeType.Trim().ToLower() == "audit cancel reason").ToList();
var cancelReason = new List <SelectListItem>
{
new SelectListItem()
{
Text = "--Select--", Value = "0", Selected = true
}
};
foreach (var item in listOfValues)
{
cancelReason.Add(new SelectListItem()
{
Text = item.Code, Value = item.Id.ToString()
});
}
audit.CancellationReason = cancelReason;
return(View("Index", audit));
}
}
catch (Exception ex)
{
_logger.LogInformation($"Exception in SaveAudit method");
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "AuditController_SaveAudit", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
return(RedirectToAction("Index", "Home"));
}
public bool UpdateAuditMain(AuditMain audit)
{
return(dbClient.UpdateAuditMain(audit));
}
