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 IList <PM_BPM_TERMINAL_SECTION> getTerminalsection(PM_BPM_TERMINAL_SECTION_QueryParam terminalsec) //传入的参数是对象，用Post，不能用Get
{
IList <PM_BPM_TERMINAL_SECTION> list = new List <PM_BPM_TERMINAL_SECTION>();
if (terminalsec != null)
{
list = terminalsecBO.GetEntities(terminalsec);
return(list);
}
return(list);
}
public void deleteTerminalsection(Guid TerminalGuid)
{
PM_BPM_TERMINAL_SECTION_QueryParam pq = new PM_BPM_TERMINAL_SECTION_QueryParam();
pq.TerminalGuid = TerminalGuid;
IList <PM_BPM_TERMINAL_SECTION> list = terminalsecBO.GetEntities(pq);
try
{
if (list != null && list.Count > 0)
{
Guid terminal = (Guid)list[0].TermSectionGuid;
terminalsecBO.Delete(terminal);
}
}
catch (Exception e)
{
throw e;
}
}
