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