/// <summary> /// 批量确认 /// </summary> /// <param name="SuperviseIds">督办任务ID(多个用逗号分隔)</param> /// <param name="result">审核结果(0:同意,1:不同意)</param> /// <param name="signImg">签名照片路径</param> /// <returns></returns> public bool MutilConfirm(string SuperviseIds, string result, string signImg, string remark = "") { try { SuperviseconfirmationBLL superviseconfirmationbll = new SuperviseconfirmationBLL(); DepartmentBLL departmentBLL = new DepartmentBLL(); string sql = string.Format("update BIS_SAFETYWORKSUPERVISE set FlowState='3',remark='{1}' where id in('{0}')", SuperviseIds.Trim(',').Replace(",", "','"), remark); int count = new DepartmentBLL().ExecuteSql(sql); if (count > 0) { string[] arr = SuperviseIds.Trim(',').Split(','); foreach (string str in arr) { DataTable dt = departmentBLL.GetDataTable(string.Format(@"select t1.id from BIS_SafetyWorkSupervise t left join (select id, superviseid from BIS_SafetyWorkFeedback where flag = '0') t1 on t.id = t1.superviseid left join(select feedbackid from BIS_SuperviseConfirmation where flag = '0') t2 on t1.id = t2.feedbackid where t.id = '{0}'", str)); if (dt.Rows.Count > 0) { SuperviseconfirmationEntity sf = new SuperviseconfirmationEntity { SuperviseResult = result, ConfirmationDate = DateTime.Now, SignUrl = signImg, FeedbackId = dt.Rows[0][0].ToString(), SuperviseId = str, Flag = "0" }; superviseconfirmationbll.SaveForm(str, sf); } } } return(true); } catch (Exception ex) { return(false); } }