//获取变压器设备的回路列表 -电能质量用
public ActionResult BindTransformerCircuit(int DID)
{
List <t_DM_DeviceInfo> DL = bll.t_DM_DeviceInfo.Where(o => o.DID == DID).ToList();
List <t_DM_CircuitInfo> list = bll.t_DM_CircuitInfo.Where(c => c.DID == Convert.ToInt32(DL[0].B)).ToList();
t_DM_CircuitInfo nc = new t_DM_CircuitInfo();
nc.CID = 0;
nc.DID = 0;
nc.CName = "==全部==";
list.Add(nc);
list = list.OrderBy(m => m.CID).ToList();
string strJson = "";
if (list.Count > 0)
{
strJson = JsonHelper.ToJson(list);
}
return(Content(strJson));
}
//private t_CM_UserInfo CurrentUser
//{
// get { return loginbll.CurrentUser; }
//}
//回路列表
public ActionResult BindCircuit(int pid = 8, int did = 0, int showall = 0)
{
string strsql = "select * FROM t_DM_CircuitInfo";
if (did > 0 & showall == 0)
{
strsql = strsql + " where did=" + did;
}
else if (pid > 0 & showall == 0)
{
strsql = strsql + " where pid=" + pid;
}
List <t_DM_CircuitInfo> list = bll.ExecuteStoreQuery <t_DM_CircuitInfo>(strsql).ToList();
t_DM_CircuitInfo nc = new t_DM_CircuitInfo();
nc.CID = 0;
nc.CName = "全部";
list.Add(nc);
list = list.OrderBy(c => c.CID).ToList();
string strJson = JsonHelper.ToJson(list);
return(Content(strJson));
}
