public object GetData(string userid, string caseId, string baid) { //只有待办箱才有设置为已读 if (!String.IsNullOrEmpty(baid)) engineAPI.SetIsReaded(caseId, baid, userid); GetDataModel data = new GetDataModel(); B_OA_Supervision_Delay_Apply en = new B_OA_Supervision_Delay_Apply(); en.Condition.Add("caseId=" + caseId); data.delayApplyBaseInfor = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(en); if (data.delayApplyBaseInfor == null) { var baseInfo = new B_OA_Supervision_Delay_Apply(); baseInfo.createDate = DateTime.Now.ToString(); baseInfo.applyManId = userid; baseInfo.applyManName = ComClass.GetUserInfo(userid).CnName; data.delayApplyBaseInfor = baseInfo; } data.userid = userid; return data; }
/// <summary> /// 创建一个Word数据 /// </summary> /// <param name="caseid"></param> /// <returns></returns> private Dictionary<string, Object> CreateWrodData(string caseId, IDbTransaction tran) { B_OA_Supervision_Delay_Apply en = new B_OA_Supervision_Delay_Apply(); en.Condition.Add("caseId = " + caseId);//设置查询条件 en = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(en); Dictionary<string, Object> list = new Dictionary<string, Object> { {"title",en.title },//收文日期 {"delayReson",en.applyReason},//延期理由 {"delayDate",en.delayDate.ToString()},//延期时间 }; //读取签发图片 StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"select s.*,u.CnName from B_OA_Sighture as s LEFT JOIN FX_UserInfo as u on s.userid = u.UserID where s.caseid='{0}' and s.tableName='{1}' and s.type='{2}'", caseId, "B_OA_Supervision_Delay_Apply", "0"); DataSet sightureDs = Utility.Database.ExcuteDataSet(strSql.ToString()); string jsonData = JsonConvert.SerializeObject(sightureDs.Tables[0]); List<B_OA_Sighture> listSighture = (List<B_OA_Sighture>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_OA_Sighture>)); if (listSighture.Count > 0) { var leaderList = new List<B_OA_Sighture>(); var assitantList = new List<B_OA_Sighture>(); for (int i = 0; i < listSighture.Count; i++) { //领导批示 if (listSighture[i].columnName == "learderApproval") { leaderList.Add(listSighture[i]); } else if (listSighture[i].columnName == "assitanLeaderSighture") { assitantList.Add(listSighture[i]); } } var leaderSightureStr = new OpenXmlHelper.ImageTextArray[leaderList.Count]; var assitanSightureStr = new OpenXmlHelper.ImageTextArray[assitantList.Count]; for (var j = 0; j < leaderList.Count; j++) { B_OA_Sighture sighture_leader = new B_OA_Sighture(); sighture_leader = leaderList[j]; string rootPath = HttpContext.Current.Server.MapPath("/"); rootPath = rootPath.Replace("\\", "/"); string path = rootPath + sighture_leader.path; if (File.Exists(path)) { leaderSightureStr[j] = new OpenXmlHelper.ImageTextArray(); leaderSightureStr[j].Images = System.Drawing.Image.FromFile(path); leaderSightureStr[j].Foots = sighture_leader.CnName + " " + Convert.ToDateTime(sighture_leader.createtime).ToString("yyyy年MM月dd日"); leaderSightureStr[j].FootAlign = DocumentFormat.OpenXml.Wordprocessing.JustificationValues.Right; } } for (var k = 0; k < assitantList.Count; k++) { B_OA_Sighture sighture_assistant = new B_OA_Sighture(); sighture_assistant = assitantList[k]; string rootPath = HttpContext.Current.Server.MapPath("/"); rootPath = rootPath.Replace("\\", "/"); string path = rootPath + sighture_assistant.path; if (File.Exists(path)) { assitanSightureStr[k] = new OpenXmlHelper.ImageTextArray(); assitanSightureStr[k].Images = System.Drawing.Image.FromFile(path); assitanSightureStr[k].Foots = sighture_assistant.CnName + " " + Convert.ToDateTime(sighture_assistant.createtime).ToString("yyyy年MM月dd日"); assitanSightureStr[k].FootAlign = DocumentFormat.OpenXml.Wordprocessing.JustificationValues.Right; } } if (assitanSightureStr.Count() > 0) { list.Add("assistanSiggestion", assitanSightureStr); } if (leaderSightureStr.Count() > 0) { list.Add("leaderSuggesion", leaderSightureStr); } } strSql.Clear(); strSql.AppendFormat("select CaseId,ActID,UserName,ReceDate,Remark from FX_WorkFlowBusAct where CaseID = '{0}' order by ReceDate asc", caseId); DataSet busSet = Utility.Database.ExcuteDataSet(strSql.ToString()); string jsonData_bus = JsonConvert.SerializeObject(busSet.Tables[0]); List<FX_WorkFlowBusAct> wfbaList = (List<FX_WorkFlowBusAct>)JsonConvert.DeserializeObject(jsonData_bus, typeof(List<FX_WorkFlowBusAct>)); List<string> listString = new List<string>(); for (int i = 0; i < wfbaList.Count; i++) { // 拟稿部门负责人核稿wfbaList[i].ActID == "A002" || if (wfbaList[i].ActID == "A004") { listString.Add(wfbaList[i].Remark + "--" + wfbaList[i].UserName + " " + wfbaList[i].ReceDate.ToString("yyyy年MM月dd日 hh:mm")); } } if (listString.Count > 0) { list.Add("officeSuggesion", listString); } return list; }
public void SetLimiteData(string caseid, IDbTransaction tran) { B_OA_Supervision_Delay_Apply delay = new B_OA_Supervision_Delay_Apply(); delay.Condition.Add("caseId = " + caseid); delay = Utility.Database.QueryObject<B_OA_Supervision_Delay_Apply>(delay, tran); StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@"select * from B_OA_Supervision where caseId =( select relationCaseId from B_OA_Supervision_Delay_Apply where caseId = '{0}')", delay.caseId); DataSet sightureDs = Utility.Database.ExcuteDataSet(strSql.ToString()); string jsonData = JsonConvert.SerializeObject(sightureDs.Tables[0]); List<B_OA_Supervision> supervision = (List<B_OA_Supervision>)JsonConvert.DeserializeObject(jsonData, typeof(List<B_OA_Supervision>)); for (int i = 0; i < supervision.Count; i++) { supervision[i].limiteDate = delay.delayDate; supervision[i].Condition.Add("id = " + supervision[i].id); Utility.Database.Update(supervision[i], tran); } }