/*----------------自定义------------------*/
public void GetContactsByCustomerId()
{
string sqland = "";
string FCustomerID = HttpContext.Current.Request["FCustomerID"];
if (FCustomerID != null && FCustomerID != "")
{
sqland += " and FCustomerID = '" + FCustomerID + "'";
}
String sql = "select * from T_Contact where 1=1 and FDeleted !='1' " + sqland + "";
DataTable dt = Dal.DBUtil.SelectDataTable(sql);
Hashtable result = new Hashtable();
if (dt.Rows.Count > 0)
{
ArrayList data = Dal.DBUtil.DataTable2ArrayList(dt);
result["data"] = data;
result["total"] = dt.Rows.Count;
}
else
{
result["total"] = 0;
}
result["CurrentUserName"] = Sys_UserService.GetSession("FName");
String json = PluSoft.Utils.JSON.Encode(result);
HttpContext.Current.Response.Write(json);
}
/*----------------自定义------------------*/
/// <summary>
/// baidu地图获取mark点
/// </summary>
public void GetGroupBaidu()
{
string sqland = "";
//数据权限
string isadmin = Sys_UserService.GetSession("FUserType").ToString();
if (isadmin != "1")
{
//数据权限
string customerid = Sys_UserService.GetSession("FCustomerID").ToString();
sqland += " and FCustomerID = '" + customerid + "'";
}
String sql = "select * from PumpManager where 1=1" + sqland;
DataTable dt = Dal.DBUtil.SelectDataTable(sql);
StringBuilder str = new StringBuilder();
int count = dt.Rows.Count;
string id = "";
string name = "";
string position = "";
str.Append("[");
for (int i = 0; i < count; i++)
{
id = dt.Rows[i]["id"].ToString();
name = dt.Rows[i]["fname"].ToString();
position = dt.Rows[i]["FLatAndLong"].ToString();
if (position == "")
{
position = "116.404, 39.915";
}
if (i == count - 1)
{
str.Append("{id: \"" + id + "\", name: \"" + name + "\", position: \"" + position + "\"}");
}
else
{
str.Append("{id: \"" + id + "\", name: \"" + name + "\", position: \"" + position + "\"},");
}
}
str.Append("]");
HttpContext.Current.Response.Write(str.ToString());
}
/// <summary>
///
/// </summary>
/// <summary>
///
/// </summary>
public void Search()
{
//查询条件
string sqland = "";
string fnumber = HttpContext.Current.Request["FNumber"];
if (fnumber != null && fnumber != "")
{
sqland += " and FNumber like '%" + fnumber + "%'";
}
string fname = HttpContext.Current.Request["FName"];
if (fname != null && fname != "")
{
sqland += " and FName like '%" + fname + "%'";
}
//数据权限
string isadmin = Sys_UserService.GetSession("FUserType").ToString();
if (isadmin != "1")
{
string customerid = Sys_UserService.GetSession("FCustomerID").ToString();
sqland += " and FCustomerID = '" + customerid + "'";
}
//分页
int pageIndex = Convert.ToInt32(HttpContext.Current.Request["pageIndex"]);
int pageSize = Convert.ToInt32(HttpContext.Current.Request["pageSize"]);
//字段排序
String sortField = HttpContext.Current.Request["sortField"];
String sortOrder = HttpContext.Current.Request["sortOrder"];
//业务层：数据库操作
//Hashtable result = new TestDB().SearchEmployees(key, pageIndex, pageSize, sortField, sortOrder);
Hashtable result = Bll.PumpManagerBll.Search(sqland, pageIndex, pageSize, sortField, sortOrder);
result["CurrentUserName"] = Sys_UserService.GetSession("FName");
//JSON
String json = PluSoft.Utils.JSON.Encode(result);
HttpContext.Current.Response.Write(json);
}
/*----------------自定义------------------*/
public void SearchAll()
{
string sqland = "";
string fnumber = HttpContext.Current.Request["FNumber"];
if (fnumber != null && fnumber != "")
{
sqland += " and FNumber like '%" + fnumber + "%'";
}
string fname = HttpContext.Current.Request["FName"];
if (fname != null && fname != "")
{
sqland += " and FName like '%" + fname + "%'";
}
//数据权限
string isadmin = Sys_UserService.GetSession("FUserType").ToString();
if (isadmin != "1")
{
//数据权限
string customerid = Sys_UserService.GetSession("FCustomerID").ToString();
sqland += " and FCustomerID = '" + customerid + "'";
}
String sql = "select * from PumpManager where 1=1 and PumpManager.FDeleted !='1' " + sqland + " order by FSortIndex asc";
DataTable dt = Dal.DBUtil.SelectDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["FIsOnline"].ToString() == "1")
{
string id = dt.Rows[i]["ID"].ToString();
String sqlalarm = "select * from T_Alarm where FPumpID='" + id + "' and FStatus='1' ";
DataTable dtalarm = Dal.DBUtil.SelectDataTable(sqlalarm);
if (dtalarm.Rows.Count > 0)
{
dt.Rows[i]["FIsOnline"] = "2";
}
}
}
Hashtable result = new Hashtable();
if (dt.Rows.Count > 0)
{
ArrayList data = Dal.DBUtil.DataTable2ArrayList(dt);
result["data"] = data;
result["total"] = dt.Rows.Count;
result["oncount"] = dt.Select("FIsOnline='1' or FIsOnline='2'").Length.ToString();
result["offcount"] = dt.Select("FIsOnline='0'").Length.ToString();
}
else
{
result["total"] = 0;
result["oncount"] = 0;
result["offcount"] = 0;
}
result["CurrentUserName"] = Sys_UserService.GetSession("FName");
String json = PluSoft.Utils.JSON.Encode(result);
HttpContext.Current.Response.Write(json);
}
/// <summary>
///
/// </summary>
/// <summary>
///
/// </summary>
public void Search()
{
//查询条件
string key = HttpContext.Current.Request["FPumpID"];
string sqland = "";
string fpumpid = HttpContext.Current.Request["FPumpID"];
if (fpumpid != null && fpumpid != "")
{
sqland += " and T_AlarmHistory.FPumpID = '" + fpumpid + "'";
}
string begDateTime = HttpContext.Current.Request["begDateTime"];
if (begDateTime != null && begDateTime != "")
{
sqland += " and T_AlarmHistory.FCreateDate >= '" + begDateTime + "'";
}
string endDateTime = HttpContext.Current.Request["endDateTime"];
if (endDateTime != null && endDateTime != "")
{
sqland += " and T_AlarmHistory.FCreateDate <= '" + endDateTime + "'";
}
string FName = HttpContext.Current.Request["FName"];
if (FName != null && FName != "")
{
sqland += " and PumpManager.FName like '%" + FName + "%'";
}
string FKey = HttpContext.Current.Request["FKey"];
if (FKey != null && FKey != "")
{
sqland += " and FKey = '" + FKey + "'";
}
//数据权限
string isadmin = Sys_UserService.GetSession("FUserType").ToString();
if (isadmin != "1")
{
string customerid = Sys_UserService.GetSession("FCustomerID").ToString();
sqland += " and PumpManager.FCustomerID = '" + customerid + "'";
}
//分页
int pageIndex = Convert.ToInt32(HttpContext.Current.Request["pageIndex"]);
int pageSize = Convert.ToInt32(HttpContext.Current.Request["pageSize"]);
//字段排序
String sortField = HttpContext.Current.Request["sortField"];
String sortOrder = HttpContext.Current.Request["sortOrder"];
//业务层：数据库操作
//Hashtable result = new TestDB().SearchEmployees(key, pageIndex, pageSize, sortField, sortOrder);
Hashtable result = Bll.T_AlarmHistoryBll.Search(sqland, pageIndex, pageSize, sortField, sortOrder);
//JSON
String json = PluSoft.Utils.JSON.Encode(result);
HttpContext.Current.Response.Write(json);
}
