//保存
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;
}
}
}
}
