public string BindingTermSection(IList <CV_PM_BPM_TERMINAL_SECTION> param) { //检查该工段是否已经绑定该工位 try { string alreadyBindTerm = ""; foreach (var item in param) { PM_BPM_TERMINAL_SECTION_QueryParam chkModel = new PM_BPM_TERMINAL_SECTION_QueryParam(); chkModel.TerminalGuid = item.TerminalGuid; IList <PM_BPM_TERMINAL_SECTION> bindList = term_sectionBO.GetEntities(chkModel); string sql = "SELECT SectionName FROM PM_BPM_SECTION WHERE SectionGuid='{0}'"; sql = string.Format(sql, item.SectionGuid.ToString()); ICO_BSC_BO _CO_BSC_BO = ObjectContainer.BuildUp <ICO_BSC_BO>(); DataTable dt = _CO_BSC_BO.GetDataTableBySql(sql); if (dt == null || dt.Rows.Count == 0) { alreadyBindTerm += "工位:" + item.TerminalID + ",已绑定"; } else { if (bindList.Count != 0) { //如果该工位已经进行了绑定,则记录 alreadyBindTerm += "工位:" + item.TerminalID + ",已绑定至:" + dt.Rows[0][0].ToString() + "工段"; } else { //如果没有绑定,则添加 PM_BPM_TERMINAL_SECTION insrtModel = new PM_BPM_TERMINAL_SECTION(); insrtModel.TermSectionGuid = Guid.NewGuid(); insrtModel.TerminalGuid = item.TerminalGuid; insrtModel.SectionGuid = item.SectionGuid; insrtModel.CreatedOn = SSGlobalConfig.Now; insrtModel.UpdatedOn = insrtModel.CreatedOn; term_sectionBO.Insert(insrtModel); } } } if (!string.IsNullOrEmpty(alreadyBindTerm)) { //除去末位的逗号 alreadyBindTerm.Substring(0, alreadyBindTerm.Length - 2); return("[" + alreadyBindTerm + "],如需要修改,请先解绑!"); } else { return("绑定成功!"); } } catch (Exception ex) { return("系统异常:" + ex.Message); } }
public string UnbindindTermSection(CV_PM_BPM_TERMINAL_SECTION param) { try { PM_BPM_TERMINAL_SECTION delModel = new PM_BPM_TERMINAL_SECTION(); delModel.TerminalGuid = param.TerminalGuid; delModel.TermSectionGuid = param.TermSectionGuid; term_sectionBO.Delete(delModel); return("解绑成功!"); } catch (Exception ex) { return("系统异常!" + ex.Message); } }
public HttpResponseMessage addTerminalsection(PM_BPM_TERMINAL_SECTION definitions) { definitions.CreatedOn = SSGlobalConfig.Now; definitions.TermSectionGuid = Guid.NewGuid(); PM_BPM_TERMINAL_SECTION bpmExt = terminalsecBO.Insert(definitions); if (bpmExt != null) { return(Request.CreateResponse(HttpStatusCode.OK, "新增成功")); } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "新增失败")); } }
public string ModifyTermSeq(CV_PM_BPM_TERMINAL_SECTION param) { try { PM_BPM_TERMINAL_SECTION modifyModel = new PM_BPM_TERMINAL_SECTION(); modifyModel.TermSectionGuid = param.TermSectionGuid; //modifyModel.TerminalGuid = param.TerminalGuid; //modifyModel.TermSectionGuid = param.SectionGuid; modifyModel.Sequence = param.TerminalSequence; term_sectionBO.UpdateSome(modifyModel); return("编辑成功!"); } catch (Exception ex) { return("系统异常:" + ex.Message); } }
public void updateTerminalsection(PM_BPM_TERMINAL_SECTION terminalsec) { terminalsec.CreatedOn = SSGlobalConfig.Now; terminalsecBO.Update(terminalsec); }