/// <summary> /// 删除监测设备信息 /// </summary> /// <param name="itemInfo">监测设备信息</param> /// <returns>删除个数</returns> public int Delete(InspectDeviceEntity itemInfo) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //删除监测项目信息 string sql = "DELETE FROM deviceinfo WHERE Id=@Id"; count = session.ExecuteSql(sql, new DataParameter { ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id }); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
protected void btSave_Click(object sender, EventArgs e) { InspectDeviceEntity info = new InspectDeviceEntity(); InspectDeviceBLL bll = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <InspectDeviceBLL>(); if (this.hiID.Value == "") { bll.Insert(info); } else { info.Id = this.hiID.Value; bll.Update(info); } ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public DataPage GetList(InspectDeviceEntity condition, DataPage page) { string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { sql = this.GetQuerySql(condition, ref parameters); //分页关键字段及排序 page.KeyName = "Id"; if (string.IsNullOrEmpty(page.SortExpression)) { page.SortExpression = "DeviceCode ASC"; } using (IDataSession session = AppDataFactory.CreateMainSession()) { page = session.GetDataPage <InspectDeviceEntity>(sql, parameters.ToArray(), page); } return(page); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备信息 /// </summary> /// <param name="itemInfo">条件</param> /// <returns>获取监测项目信息</returns> public InspectDeviceEntity Get(InspectDeviceEntity itemInfo) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); List <DataParameter> parameters = new List <DataParameter>(); try { using (IDataSession session = AppDataFactory.CreateMainSession()) { sqlBuilder.Append(" SELECT Id,DeviceCode, "); sqlBuilder.Append(" DeviceName,DeviceIP,DevicePort,LanIP,LanPort, "); sqlBuilder.Append(" LastLoginTime,LastRegisterTime,Lon,Lat,A.OrganID,O.ORGANDESC AS OrganDESC,DeviceType,Remark, "); sqlBuilder.Append(" A.CREATEUSER,A.CREATETIME,A.UPDATEUSER,A.UPDATETIME "); sqlBuilder.Append(" FROM deviceinfo A LEFT JOIN t_organization O ON A.OrganID = O.OrganID WHERE Id = @Id "); parameters.Add(new DataParameter { ParameterName = "Id", DataType = DbType.String, Value = itemInfo.Id }); itemInfo = session.Get <InspectDeviceEntity>(sqlBuilder.ToString(), parameters.ToArray()); } return(itemInfo); } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入监测设备信息 /// </summary> /// <param name="itemInfo">监测设备信息</param> /// <returns>插入数</returns> public DataResult <int> Insert(InspectDeviceEntity model) { try { DataResult <int> result = new DataResult <int>(); InspectDeviceDAL cmdDAL = new InspectDeviceDAL(); if (ExistsInspectDevice(model)) { result.Msg = "名称已存在"; result.Result = -1; return(result); } model.Id = Guid.NewGuid().ToString(); model.CreateUser = this.LoginUser.UserID; model.CreateTime = DateTime.Now; model.UpdateUser = model.CreateUser; model.UpdateTime = model.CreateTime; result.Result = new InspectDeviceDAL().Insert(model); result.IsSuccess = true; return(result); } catch (Exception ex) { throw ex; } }
private void BindData() { string Id = Request.QueryString["Id"]; InspectDeviceBLL bll = null; InspectDeviceEntity info = new InspectDeviceEntity(); try { bll = BLLFactory.CreateBLL <InspectDeviceBLL>(); if (string.IsNullOrEmpty(Id) == false) { info.Id = Id; info = bll.Get(info); UIBindHelper.BindForm(this.Page, info); this.hiID.Value = info.Id; this.DeviceCode.Text = info.DeviceCode; this.DeviceName.Text = info.DeviceName; this.DeviceIP.Text = info.DeviceIP; this.DevicePort.Text = info.DevicePort + ""; this.LanIP.Text = info.LanIP; this.LanPort.Text = info.LanPort + ""; if (!"0001/1/1 0:00:00".Equals(info.LastLoginTime + "")) { this.LastLoginTime.Text = info.LastLoginTime + ""; } else { this.LastLoginTime.Text = ""; } if (!"0001/1/1 0:00:00".Equals(info.LastRegisterTime + "")) { this.LastRegisterTime.Text = info.LastRegisterTime + ""; } else { this.LastRegisterTime.Text = ""; } this.Lon.Text = info.Lon + ""; this.Lat.Text = info.Lat + ""; this.OrganID.Text = info.OrganID + ""; this.DeviceType.Text = info.DeviceType + ""; this.Remark.Text = info.Remark; this.HiCREATEUSER.Value = info.CreateUser; this.HiCREATETIME.Value = info.CreateTime.ToString(); } else { info = new InspectDeviceEntity(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备信息 /// </summary> /// <param name="itemInfo">条件</param> /// <returns>监测设备信息</returns> public InspectDeviceEntity Get(InspectDeviceEntity model) { try { return(new InspectDeviceDAL().Get(model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取用户信息列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public List <InspectDeviceEntity> GetAllItemInfo(InspectDeviceEntity condition) { try { return(new InspectDeviceDAL().GetAllItemInfo(condition)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public DataPage GetList(InspectDeviceEntity condition, DataPage page) { try { return(new InspectDeviceDAL().GetList(condition, page)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取用户信息列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public List <InspectDeviceEntity> GetAllDeviceByOrgAndType(InspectDeviceEntity condition) { try { return(new InspectDeviceDAL().GetAllDeviceByOrgAndType(condition)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="">信息</param> /// <returns>true:已存在;fasel:不存在。</returns> public bool ExistsInspectDevice(InspectDeviceEntity model) { try { return(new InspectDeviceDAL().ExistsInspectDevice(model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取设备列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public List <InspectDeviceEntity> GetList(InspectDeviceEntity condition) { try { return(new InspectMapDAL().GetList(condition)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public List <InspectDeviceEntity> GetAllDeviceByOrgAndType(InspectDeviceEntity condition) { List <InspectDeviceEntity> itemInfo = null; string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); sqlBuilder.Append(" SELECT Id,DeviceCode,DeviceName FROM deviceinfo A "); //查询条件 if (!string.IsNullOrEmpty(condition.OrganID)) { whereBuilder.Append(" AND A.OrganID = @OrganID"); parameters.Add(new DataParameter { ParameterName = "OrganID", DataType = DbType.String, Value = condition.OrganID }); } //查询条件 if (string.IsNullOrEmpty(condition.DeviceType) == false) { whereBuilder.Append(" AND DeviceType = @DeviceType"); parameters.Add(new DataParameter { ParameterName = "DeviceType", DataType = DbType.String, Value = condition.DeviceType }); } if (whereBuilder.Length > 0) { sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4)); } sqlBuilder.Append(" ORDER BY A.DeviceCode ASC "); sql = sqlBuilder.ToString(); using (IDataSession session = AppDataFactory.CreateMainSession()) { itemInfo = session.GetList <InspectDeviceEntity>(sql, parameters.ToArray()).ToList(); } return(itemInfo); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取查询语句 /// </summary> /// <param name="condition">查询条件</param> /// <param name="parameters">查询</param> /// <returns>查询语句</returns> private string GetQuerySql(InspectDeviceEntity condition, ref List <DataParameter> parameters) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); sqlBuilder.Append(" SELECT Id,DeviceCode,DeviceName,DeviceIP,DevicePort,LanIP,LanPort, "); sqlBuilder.Append(" LastLoginTime,LastRegisterTime,Lon,Lat,A.OrganID,O.ORGANDESC AS OrganDESC,DeviceType,Remark "); sqlBuilder.Append(" FROM deviceinfo A LEFT JOIN t_organization O ON A.OrganID = O.OrganID "); sqlBuilder.Append(" ORDER BY DeviceCode "); return(sqlBuilder.ToString()); }
/// <summary> /// 删除监测设备信息 /// </summary> /// <param name="itemInfo">删除监测设备信息</param> /// <returns>删除行数</returns> public int Delete(InspectDeviceEntity model) { int count = 0; try { count = new InspectDeviceDAL().Delete(model); return(count); } catch (Exception ex) { throw ex; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentEncoding = Encoding.UTF8; context.Response.ContentType = "application/json"; string OrganID = context.Request.QueryString["OrganID"]; string DeviceType = context.Request.QueryString["DeviceType"]; InspectDeviceEntity param = new InspectDeviceEntity(); param.OrganID = OrganID; param.DeviceType = DeviceType; InspectDeviceBLL bll = BLLFactory.CreateBLL <InspectDeviceBLL>(); List <InspectDeviceEntity> list = bll.GetAllDeviceByOrgAndType(param); context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(list)); }
private void BindData() { InspectDeviceBLL bll = null; DataPage dp = new DataPage(); InspectDeviceEntity condition = new InspectDeviceEntity(); try { bll = BLLFactory.CreateBLL <InspectDeviceBLL>(); condition.DeviceCode = this.DeviceCode.Text; condition.DeviceName = this.DeviceName.Text; condition.OrganID = this.OrganID.Text; PagerHelper.InitPageControl(this.AspNetPager1, dp, true); dp = bll.GetList(condition, dp); List <InspectDeviceEntity> list = dp.Result as List <InspectDeviceEntity>; CommonDropdown commonDropdown = new CommonDropdown(); List <DictInfo> typeList = commonDropdown.getInspectDeviceType(); foreach (InspectDeviceEntity ide in list) { var temp = typeList.Find(p => p.ID == ide.DeviceType); if (temp != null && temp.Des != null) { ide.DeviceTypeName = temp.Des; } } this.GvList.DataSource = list; this.GvList.DataBind(); for (int i = 0; i < this.GvList.Rows.Count; i++) { string click = string.Format("return edit('{0}');", this.GvList.DataKeys[i]["Id"].ToString()); (this.GvList.Rows[i].Cells[14].Controls[0] as WebControl).Attributes.Add("onclick", click); } PagerHelper.SetPageControl(AspNetPager1, dp, true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取查询语句 /// </summary> /// <param name="condition">查询条件</param> /// <param name="parameters">查询</param> /// <returns>查询语句</returns> private string GetQuerySql(InspectDeviceEntity condition, ref List <DataParameter> parameters) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); sqlBuilder.Append(" SELECT Id,DeviceCode, DeviceName,DeviceIP,DevicePort,LanIP,LanPort, "); sqlBuilder.Append(" LastLoginTime,LastRegisterTime,Lon,Lat,A.OrganID,O.ORGANDESC AS OrganDESC,DeviceType,Remark, "); sqlBuilder.Append(" A.CREATEUSER,A.CREATETIME,A.UPDATEUSER,A.UPDATETIME FROM deviceinfo A LEFT JOIN t_organization O ON A.OrganID = O.OrganID "); //查询条件 if (!string.IsNullOrEmpty(condition.DeviceCode)) { whereBuilder.Append(" AND DeviceCode like @DeviceCode"); parameters.Add(new DataParameter { ParameterName = "DeviceCode", DataType = DbType.String, Value = "%" + condition.DeviceCode + "%" }); } //查询条件 if (string.IsNullOrEmpty(condition.DeviceName) == false) { whereBuilder.Append(" AND DeviceName like @DeviceName"); parameters.Add(new DataParameter { ParameterName = "DeviceName", DataType = DbType.String, Value = "%" + condition.DeviceName + "%" }); } if (string.IsNullOrEmpty(condition.OrganID) == false) { whereBuilder.Append(" AND A.OrganID = @OrganID"); parameters.Add(new DataParameter { ParameterName = "OrganID", DataType = DbType.String, Value = condition.OrganID }); } if (whereBuilder.Length > 0) { sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4)); } return(sqlBuilder.ToString()); }
/// <summary> /// 插入监测设备信息 /// </summary> /// <param name="itemInfo">监测设备信息</param> /// <returns>插入数</returns> public int Insert(InspectDeviceEntity itemInfo) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //插入基本信息 session.Insert <InspectDeviceEntity>(itemInfo); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新监测设备信息 /// </summary> /// <param name="user">监测设备信息</param> /// <returns>更新个数</returns> public DataResult <int> Update(InspectDeviceEntity model) { try { DataResult <int> result = new DataResult <int>(); if (ExistsInspectDevice(model)) { result.Msg = "名称已存在"; result.Result = -1; return(result); } model.UpdateUser = this.LoginUser.UserID; model.UpdateTime = DateTime.Now; result.Result = new InspectDeviceDAL().Update(model); result.IsSuccess = true; return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新监测设备信息 /// </summary> /// <param name="itemInfo">监测设备信息</param> /// <returns>更新个数</returns> public int Update(InspectDeviceEntity itemInfo) { int count = 0; try { using (var session = AppDataFactory.CreateMainSession()) { session.OpenTs(); //更新基本信息 count = session.Update <InspectDeviceEntity>(itemInfo); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取监测设备列表 /// </summary> /// <param name="condition">条件</param> /// <param name="page">数据页</param> /// <returns>数据页</returns> public List <InspectDeviceEntity> GetList(InspectDeviceEntity condition) { string sql = null; List <DataParameter> parameters = new List <DataParameter>(); try { sql = this.GetQuerySql(condition, ref parameters); List <InspectDeviceEntity> list = null; using (IDataSession session = AppDataFactory.CreateMainSession()) { list = session.GetList <InspectDeviceEntity>(sql, parameters.ToArray()).ToList(); } return(list); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断名称是否存在 /// </summary> /// <param name="info"></param> /// <returns>true:已存在;fasel:不存在。</returns> public bool ExistsInspectDevice(InspectDeviceEntity model) { StringBuilder sqlBuilder = new StringBuilder(); StringBuilder whereBuilder = new StringBuilder(); List <DataParameter> parameters = new List <DataParameter>(); int count = 0; try { sqlBuilder.Append("SELECT COUNT(0) FROM deviceinfo"); whereBuilder.Append(" AND Id <> @Id "); parameters.Add(new DataParameter { ParameterName = "Id", DataType = DbType.String, Value = model.Id }); if (!string.IsNullOrEmpty(model.DeviceCode)) { whereBuilder.Append(" AND DeviceCode = @DeviceCode "); parameters.Add(new DataParameter { ParameterName = "DeviceCode", DataType = DbType.String, Value = model.DeviceCode }); } if (whereBuilder.Length > 0) { sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4)); } using (IDataSession session = AppDataFactory.CreateMainSession()) { count = Convert.ToInt32(session.ExecuteSqlScalar(sqlBuilder.ToString(), parameters.ToArray())); } return(count > 0); } catch (Exception ex) { throw ex; } }