//保存 protected void btnSubmit_Click(object sender, EventArgs e) { if (action == DTEnums.ActionEnum.Edit.ToString()) //修改 { if (!DoEdit(this.id)) { JscriptMsg("保存过程中发生错误!", ""); return; } JscriptMsg_Parent("修改设备信息成功", $"electricity_add.aspx?action={DTEnums.ActionEnum.Edit}&id={this.id}"); } else //添加 { BLL.dt_item bll = new BLL.dt_item(); if (bll.GetRecordCount($"onenetnum='{tbequipmentId.Text.Replace("'","").Trim()}' ") > 0) { JscriptMsg("设备ID已存在!", string.Empty); return; } int newid = 0; if ((newid = DoAdd()) > 0) { JscriptMsg("保存过程中发生错误!", ""); return; } JscriptMsg_Parent("添加设备信息成功", $"electricity_add.aspx?action={DTEnums.ActionEnum.Edit}&id={newid}"); } }
void device() { BLL.dt_item bll = new BLL.dt_item(); int pageSize = int.Parse(request["pagesize"]); int pageIdx = int.Parse(request["pageidx"]); int totalCount = 0; var ds = bll.GetList(pageSize, pageIdx, " ", " i.id desc", out totalCount); var data = (from DataRow dr in ds.Tables[0].Rows select new DBRowConvertor(dr).ConvertToEntity <Model.dt_item>()).ToList(); this.res = DTcms.Common.JsonHelper2.GetCommonObj(0, data); }
private bool DoEdit(int _id) { bool result = false; BLL.dt_item bll = new BLL.dt_item(); Model.dt_item model = bll.GetModel(_id); if (cbIsLock.Checked == true) { model.state = 2; } else { model.state = 1; } model.addr = ""; model.area_code = ddlArea.SelectedValue; model.name = tbName.Text.Trim(); //model.onenetnum = tbequipmentId.Text.Trim(); model.position = ""; model.remarks = ""; model.trailerAI = double.Parse(tbtrailerAI.Text.Trim()); // model.warningAI = double.Parse(tbwarningAI.Text.Trim()); model.trailerBI = double.Parse(tbtrailerBI.Text.Trim()); // model.warningBI = double.Parse(tbwarningBI.Text.Trim()); model.trailerCI = double.Parse(tbtrailerCI.Text.Trim()); //model.warningCI = double.Parse(tbwarningCI.Text.Trim()); model.trailerLI = double.Parse(tbtrailerLI.Text.Trim()); // model.warningLI = double.Parse(tbwarningLI.Text.Trim()); model.trailerOneTemperature = double.Parse(tbtrailerOneTemperature.Text.Trim()); // model.warningOneTemperature = double.Parse(tbwarningOneTemperature.Text.Trim()); model.trailerTwoTemperature = double.Parse(tbtrailerTwoTemperature.Text.Trim()); // model.warningTwoTemperature = double.Parse(tbwarningTwoTemperature.Text.Trim()); model.trailerThreeTemperature = double.Parse(tbtrailerThreeTemperature.Text.Trim()); //model.warningThreeTemperature = double.Parse(tbwarningThreeTemperature.Text.Trim()); model.trailerFourTemperature = double.Parse(tbtrailerFourTemperature.Text.Trim()); //model.warningFourTemperature = double.Parse(tbwarningFourTemperature.Text.Trim()); model.trailerAV = double.Parse(tbTrailerU1.Text.Trim()); model.trailerBV = double.Parse(tbTrailerU2.Text.Trim()); model.trailerCV = double.Parse(tbTrailerU3.Text.Trim()); model.position = tbPosition.Text.Trim(); model.user_id = int.Parse(ddlUser.SelectedValue); if (bll.Update(model)) { AddAdminLog("package_edit", "修改设备:" + model.id + "_" + model.name + "成功"); //记录日志 result = true; } return(result); }
protected void btnOpen_Click(object sender, EventArgs e) { ChkAdminLevel("electricity_list", DTEnums.ActionEnum.Edit.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; string ids = ""; BLL.dt_item bll = new BLL.dt_item(); string idstr = Request.Form["chkId"]; string[] idlist = idstr.Split(','); if (idlist.Length > 0) { for (int i = 0; i < idlist.Length; i++) { if (idlist[i].Trim() != null) { Model.dt_item model = bll.GetModel(int.Parse(idlist[i])); if (model != null && model.state != 2) { Model.manager usermodel = GetAdminInfo(); if (usermodel.id != model.user_id && usermodel.role_type != 1) { errorCount += 1; } else { ids += "," + idlist[i]; model.state = 2; if (bll.Update(model)) { sucCount += 1; } else { errorCount += 1; } } } else { errorCount += 1; } } } } AddAdminLog("item_open", "批量启用成功" + sucCount + "条,失败" + errorCount + "条," + ids); //记录日志 JscriptMsg_Parent("批量启用成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("electricity_list.aspx", "state={0}&keywords={1}&page={2}&online={3}", ddlState.SelectedValue, this.keywords, this.page.ToString(), this.online.ToString())); }
private int DoAdd() { Model.dt_item model = new Model.dt_item(); BLL.dt_item bll = new BLL.dt_item(); if (cbIsLock.Checked == true) { model.state = 2; } else { model.state = 1; } model.addr = ""; model.addtime = DateTime.Now; model.area_code = ddlArea.SelectedValue; model.name = tbName.Text.Trim(); model.onenetnum = tbequipmentId.Text.Trim(); model.position = ""; model.remarks = ""; model.trailerAI = double.Parse(tbtrailerAI.Text.Trim()); //model.warningAI = double.Parse(tbwarningAI.Text.Trim()); model.trailerBI = double.Parse(tbtrailerBI.Text.Trim()); // model.warningBI = double.Parse(tbwarningBI.Text.Trim()); model.trailerCI = double.Parse(tbtrailerCI.Text.Trim()); // model.warningCI = double.Parse(tbwarningCI.Text.Trim()); model.trailerLI = double.Parse(tbtrailerLI.Text.Trim()); // model.warningLI = double.Parse(tbwarningLI.Text.Trim()); model.trailerOneTemperature = double.Parse(tbtrailerOneTemperature.Text.Trim()); // model.warningOneTemperature = double.Parse(tbwarningOneTemperature.Text.Trim()); model.trailerTwoTemperature = double.Parse(tbtrailerTwoTemperature.Text.Trim()); // model.warningTwoTemperature = double.Parse(tbwarningTwoTemperature.Text.Trim()); model.trailerThreeTemperature = double.Parse(tbtrailerThreeTemperature.Text.Trim()); // model.warningThreeTemperature = double.Parse(tbwarningThreeTemperature.Text.Trim()); model.trailerFourTemperature = double.Parse(tbtrailerFourTemperature.Text.Trim()); // model.warningFourTemperature = double.Parse(tbwarningFourTemperature.Text.Trim()); model.trailerAV = double.Parse(tbTrailerU1.Text.Trim()); model.trailerBV = double.Parse(tbTrailerU2.Text.Trim()); model.trailerCV = double.Parse(tbTrailerU3.Text.Trim()); model.position = tbPosition.Text.Trim(); model.user_id = int.Parse(ddlUser.SelectedValue); int newid = bll.Add(model); if (newid > 0) { AddAdminLog("item_add", "添加设备:" + model.id + "_" + model.name + "成功"); //记录日志 return(newid); } return(0); }
public string mapToJson(string jsonName, string areacode, string keywords, int page, int pageSize) { ManagePage pg = new ManagePage(); var model = pg.GetAdminInfo(); string strwhere = " 1=1 "; StringBuilder strTemp = new StringBuilder(); keywords = keywords.Replace("'", ""); if (model.role_type != 1) { strwhere += $" and user_id={model.id} "; } if (!string.IsNullOrEmpty(areacode)) { strwhere += $" and area_code='{areacode.Replace("'", "")}' "; } if (!string.IsNullOrEmpty(keywords)) { strwhere += $" and (name like '%{keywords}%' or onenetnum='{keywords}')"; } BLL.dt_item bll = new BLL.dt_item(); var itemlist = bll.GetModelList(strwhere + " order by addtime desc "); string jsonstr = string.Empty; if (itemlist != null && itemlist.Count > 0) { itemlist = itemlist.Skip((page - 1) * pageSize).Take(pageSize).ToList(); jsonstr = JsonHelper2.Serialize(itemlist.Select(p => new { id = p.id, sbid = p.onenetnum, title = p.name, gps = p.position, online = p.online?1:0 })); //for (int i = 0; i < itemlist.Count; i++) //{ // Json.Append("{"); // Json.Append("id:\"" + itemlist[i].id + "\""); // Json.Append(","); // Json.Append("sbid:\"" + itemlist[i].onenetnum + "\""); // Json.Append(","); // Json.Append("title:\"" + itemlist[i].name + "\""); // Json.Append(","); // Json.Append("gps:\"" + itemlist[i].position + "\""); // Json.Append(","); // Json.Append("online:\"" + itemlist[i].online + "\""); // Json.Append("}"); // if (i != itemlist.Count - 1) // { // Json.Append(","); // } //} } return(jsonstr); }
private void RptBind(string _strWhere, string _orderby) { ddlState.SelectedValue = this.state.ToString(); ddlOnLine.SelectedValue = this.online.ToString(); this.page = DTRequest.GetQueryInt("page", 1); BLL.dt_item bll = new BLL.dt_item(); //this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //this.rptList.DataBind(); ds = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("warning_list.aspx", "keywords={0}&page={1}&state={2}&online={3}", this.keywords, "__id__", this.state.ToString(), this.online.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); BLL.dt_item bll = new BLL.dt_item(); //this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //this.rptList.DataBind(); int startIdx = (this.page - 1) * this.pageSize; int endIdx = startIdx + this.pageSize; datalist = new Model.dt_device_h().GetListByPage(new Model.dt_device_h_adq { sqlwhere = _strWhere }, _orderby, startIdx, endIdx, this.type); //ds = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("deviceInspection.aspx", "keywords={0}&page={1}&type={2}", this.keywords, "__id__", this.type.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void ShowInfo(int _id, string zb) { BLL.dt_item bll = new BLL.dt_item(); Model.dt_item model = bll.GetModel(_id); if (model.state == 1) { cbIsLock.Checked = false; } else { cbIsLock.Checked = true; } tbName.Text = model.name; tbequipmentId.Text = model.onenetnum; ddlUser.SelectedValue = model.user_id.ToString(); ddlArea.SelectedValue = model.area_code; tbtrailerAI.Text = model.trailerAI.ToString(); //tbwarningAI.Text = model.warningAI.ToString(); tbtrailerBI.Text = model.trailerBI.ToString(); //tbwarningBI.Text = model.warningBI.ToString(); tbtrailerCI.Text = model.trailerCI.ToString(); //tbwarningCI.Text = model.warningCI.ToString(); tbtrailerLI.Text = model.trailerLI.ToString(); //tbwarningLI.Text = model.warningLI.ToString(); tbtrailerOneTemperature.Text = model.trailerOneTemperature.ToString(); //tbwarningOneTemperature.Text = model.warningOneTemperature.ToString(); tbtrailerTwoTemperature.Text = model.trailerTwoTemperature.ToString(); //tbwarningTwoTemperature.Text = model.warningTwoTemperature.ToString(); tbtrailerThreeTemperature.Text = model.trailerThreeTemperature.ToString(); //tbwarningThreeTemperature.Text = model.warningThreeTemperature.ToString(); tbtrailerFourTemperature.Text = model.trailerFourTemperature.ToString(); //tbwarningFourTemperature.Text = model.warningFourTemperature.ToString(); tbTrailerU1.Text = model.trailerAV.ToString(); tbTrailerU2.Text = model.trailerBV.ToString(); tbTrailerU3.Text = model.trailerCV.ToString(); tbPosition.Text = model.position; if (zb != "") { tbPosition.Text = zb; } }
protected void databind() { var model = GetAdminInfo(); this.page = DTRequest.GetQueryInt("page", 1); tbKeys.Text = this.keywords; string strwhere = " 1=1 "; StringBuilder strTemp = new StringBuilder(); this.keywords = this.keywords.Replace("'", ""); if (model.role_type != 1) { strwhere += $" and i.user_id={model.id} "; } if (!string.IsNullOrEmpty(this.areacode)) { strwhere += $" and i.area_code='{this.areacode.Replace("'","")}' "; } if (!string.IsNullOrEmpty(this.keywords)) { strwhere += $" and (i.name like '%{this.keywords}%' or i.onenetnum='{this.keywords}')"; } BLL.dt_item bll = new BLL.dt_item(); string _orderby = " addtime desc "; var q = bll.GetList(this.pageSize, this.page, strwhere, _orderby, out this.totalCount); rptList1.DataSource = q; rptList1.DataBind(); if (this.totalCount > 0) { string position = q.Tables[0].Rows[0]["position"].ToString(); point1 = position.Substring(0, position.IndexOf(",")); point2 = position.Substring(position.IndexOf(",") + 1); } string pageUrl = Utils.CombUrlTxt("map_show.aspx", "areacode={0}&keywords={1}&page={2}", this.areacode, this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 3); }
protected void Page_Load(object sender, EventArgs e) { Model.manager model = GetAdminInfo(); //取得当前管理员信息 string _action = DTRequest.GetQueryString("action"); if (!string.IsNullOrEmpty(_action) && _action == DTEnums.ActionEnum.Edit.ToString()) { ChkAdminLevel("electricity_list", DTEnums.ActionEnum.Edit.ToString()); //检查权限 tbequipmentId.Enabled = false; this.action = DTEnums.ActionEnum.Edit.ToString(); //修改类型 if (!int.TryParse(Request.QueryString["id"] as string, out this.id)) { JscriptMsg("传输参数不正确!", "back"); return; } if (!new BLL.dt_item().Exists(this.id)) { JscriptMsg("记录不存在或已被删除!", "back"); return; } else if (model.role_type != 1) { Model.dt_item itemmodel = new BLL.dt_item().GetModel(this.id); if (itemmodel.user_id != model.id) { JscriptMsg("记录不存在或已被删除!", "back"); return; } } } else { ChkAdminLevel("electricity_list", DTEnums.ActionEnum.Add.ToString()); //检查权限 } if (!Page.IsPostBack) { string zb = ""; string elng = DTRequest.GetQueryStringValue("elng", ""); string elat = DTRequest.GetQueryStringValue("elat", ""); if (!string.IsNullOrEmpty(elat) && !string.IsNullOrEmpty(elng)) { zb = elng.Replace("D", ".") + "," + elat.Replace("D", "."); } //BLL.dt_area_code bll = new BLL.dt_area_code ddlArea.DataTextField = "name"; ddlArea.DataValueField = "code"; ddlArea.DataSource = ManagePage.arealist; ddlArea.DataBind(); BLL.manager bll = new BLL.manager(); ddlUser.DataTextField = "real_name"; ddlUser.DataValueField = "id"; ddlUser.DataSource = bll.GetList(9999, "", " id asc"); ddlUser.DataBind(); ListItem li = new ListItem(); li.Value = ""; li.Text = "请选择区域"; ddlArea.Items.Insert(0, li); li.Value = ""; li.Text = "请选择用户"; ddlUser.Items.Insert(0, li); if (this.action == DTEnums.ActionEnum.Edit.ToString()) //修改 { ShowInfo(this.id, zb); } else { if (!string.IsNullOrEmpty(zb)) { tbPosition.Text = zb; } } } }