//保存测点对照表 public ActionResult SavePointmapdts(t_cm_pointmapdts model) { string result = "OK"; //新增 try { List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.Where(p => p.tagid == model.tagid).ToList(); if (list.Count > 0)//修改 { string strsql = "update t_cm_pointmapdts set dname='" + model.dname + "',channelsinfoid=" + model.channelsinfoid + ",cname='" + model.cname + "',zonename='" + model.zonename + "',zoneno=" + model.zoneno + " where tagid=" + model.tagid; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "修改光纤分区对照[测点ID:" + model.tagid + "]"); } else { bll.t_cm_pointmapdts.AddObject(model); bll.SaveChanges(); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "新增光纤分区对照[定位点ID:" + model.tagid + "]"); } } catch (Exception ex) { result = ex.ToString(); } return(Content(result)); }
public ActionResult GetPointsInfo(int tagid) { string strJson = ""; List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.Where(p => p.tagid == tagid).ToList(); if (list.Count > 0) { t_cm_pointmapdts info = list[0]; strJson = JsonConvert.SerializeObject(info); } return(Content(strJson)); }
public ActionResult SaveLocate(t_cm_pointmapdts locate) { List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.ToList(); int locateid = locate.tagid; string result = "OK"; //新增 try { if (locateid < 1) { list = list.Where(s => s.tagname == locate.tagname).ToList(); if (list.Count > 0) { result = "此定位点已存在,请设置其他定位点!"; } else { bll.t_cm_pointmapdts.AddObject(locate); bll.SaveChanges(); locateid = locate.tagid; Common.InsertLog("定位点管理", CurrentUser.UserName, "新增定位点[定位点ID:" + locateid + "_" + locate.tagname + "]"); } } else//修改 { t_cm_pointmapdts model = bll.t_cm_pointmapdts.Where(l => l.tagid == locateid).First(); model.tagname = locate.tagname; model.pid = locate.pid; model.did = locate.did; model.devicesinfoid = locate.devicesinfoid; model.dname = locate.dname; model.channelsinfoid = locate.channelsinfoid; model.cname = locate.cname; model.zoneno = locate.zoneno; model.zonename = locate.zonename; model.parentid = locate.parentid; model.startPt = locate.startPt; model.endPt = locate.endPt; bll.ObjectStateManager.ChangeObjectState(model, EntityState.Modified); bll.SaveChanges(); Common.InsertLog("定位点管理", CurrentUser.UserName, "修改定位点[定位点ID:" + locateid + "_" + locate.tagname + "]"); } } catch (Exception ex) { result = ex.ToString(); } return(Content(result)); }
//保存测点对照表 public ActionResult SavePointmapdts(t_cm_pointmapdts model) { string result = "OK", strsql = ""; //新增 try { List <t_cm_pointmapdts> list2 = bll.t_cm_pointmapdts.Where(p => p.devicesinfoid == model.devicesinfoid && p.channelsinfoid == model.channelsinfoid && p.zoneno == model.zoneno && p.parentid == 0).ToList(); if (list2.Count == 0 || list2[0].tagid == model.tagid)//判断纤分区已分配是否已经分配 { List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.Where(p => p.tagid == model.tagid).ToList(); if (list.Count > 0)//修改 { strsql = " select beginIndex id,endIndex text from t_dts_bi_channelzone where zoneno=" + model.zoneno + " and channelsinfoid=" + model.channelsinfoid + " and devicesinfoid=" + model.devicesinfoid; List <DDLValue> listzone = SQLtoDataSet.GetMySqlList(strsql); int startPt = 0, endPt = 0; if (listzone.Count > 0) { startPt = listzone[0].id; endPt = Convert.ToInt32(listzone[0].text); } strsql = "update t_cm_pointmapdts set startPt=" + startPt + ",endPt=" + endPt + ",devicesinfoid=" + model.devicesinfoid + ", dname='" + model.dname + "',channelsinfoid=" + model.channelsinfoid + ",cname='" + model.cname + "',zonename='" + model.zonename + "',zoneno=" + model.zoneno + " where tagid=" + model.tagid; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "修改光纤分区对照[测点ID:" + model.tagid + "]"); } else { strsql = "insert into t_cm_pointmapdts values(" + model.pid + "," + model.did + "," + model.tagid + "," + model.devicesinfoid + ",'" + model.dname + "'," + model.channelsinfoid + ",'" + model.cname + "'," + model.zoneno + ",'" + model.zonename + "')"; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "新增光纤分区对照[定位点ID:" + model.tagid + "]"); } } else { result = "该光纤分区已分配,请从新分配!"; } } catch (Exception ex) { result = strsql; } return(Content(result)); }