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);
}