public HttpResponseMessage Get_tb_Alarm()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
int cnt = 0;
string ProjectCode = DictionaryPro.GetDicValue(dcParams, "ProjectCode"); //工程编号
int pageNumber = int.Parse(DictionaryPro.GetDicValue(dcParams, "pageNumber")); //页码
int pageSize = int.Parse(DictionaryPro.GetDicValue(dcParams, "pageSize")); //页面信息数量
DateTime startm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "startm"));
DateTime endtm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "endtm"));
//DAL
tb_Alarm_DAL dal = new tb_Alarm_DAL();
string list = dal.Get_tb_Alarm(startm, endtm, pageNumber, pageSize, out cnt);
//返回数据
responseMessage.message = new { total = cnt, rows = list };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//responseMessage.status = -1;
//responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GetRealtimedata()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
bool flag = false;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
DataTable td = new DataTable();
系统采集器实时_DAL dal = new 系统采集器实时_DAL();
td = dal.GetLastDate();
responseMessage.message = new { rows = td };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//返回错误信息
responseMessage.status = -1;
responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GetMonitoringcurve()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*"); //解决跨域问题
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
string stcd = DictionaryPro.GetDicValue(dcParams, "stcd");
string list = "";
//DAL
VW_Monitoringindex_DAL dal = new VW_Monitoringindex_DAL();
if (stcd != "")
{
list = dal.GetMonitoringcurve(stcd);
}
int cnt = 0;
//返回数据
responseMessage.message = new { total = cnt, rows = list };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//responseMessage.status = -1;
//responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GettrueName()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
bool flag = false;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
string UserID = DictionaryPro.GetDicValue(dcParams, "UserID");//用户名
DataTable account = new DataTable();
ProjectInfo_DAL dal = new ProjectInfo_DAL();
account = dal.Getaccount(UserID);
responseMessage.message = new { rows = account };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//返回错误信息
responseMessage.status = -1;
responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GetVW_TodayEmissionreduction()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
int cnt = 0;
DateTime starttm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "starttm"));
DateTime endtm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "endtm"));
DataTable MyDataTable = new DataTable();
//DAL
系统采集器Index_DAL dal = new 系统采集器Index_DAL();
DataTable list = dal.GetVW_TodayEmissionreduction(starttm, endtm);
//构造列
MyDataTable.Columns.Add(new DataColumn("AllQuse", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("AllQss", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmco2", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmso2", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmnox", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmfc", typeof(float)));
//构造行
DataRow dr;
dr = MyDataTable.NewRow();
dr["AllQuse"] = Convert.ToDouble(list.Rows[list.Rows.Count - 1][1]) - Convert.ToDouble(list.Rows[0][1]);
dr["AllQss"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][2]) - Convert.ToDouble(list.Rows[0][2])) * 0.001; //*0.001是为了单位换算
dr["Allmco2"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][3]) - Convert.ToDouble(list.Rows[0][3])) * 0.001;
dr["Allmso2"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][4]) - Convert.ToDouble(list.Rows[0][4])) * 0.001;
dr["Allmnox"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][5]) - Convert.ToDouble(list.Rows[0][5])) * 0.001;
dr["Allmfc"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][6]) - Convert.ToDouble(list.Rows[0][6])) * 0.001;
MyDataTable.Rows.Add(dr);
//返回数据
responseMessage.message = new { total = cnt, rows = MyDataTable };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//responseMessage.status = -1;
//responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage UpdateProjectInfo()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
bool flag = false;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
string UserID = DictionaryPro.GetDicValue(dcParams, "UserID"); //用户名
string OldUserPassword = DictionaryPro.GetDicValue(dcParams, "OldUserPassword"); //密码
string newUserPassword = DictionaryPro.GetDicValue(dcParams, "newUserPassword"); //密码
DataTable account = new DataTable();
ProjectInfo_DAL dal = new ProjectInfo_DAL();
//验证密码
account = dal.Getaccount(UserID);
if (account != null)
{
//验证通过标志
//用户名
string username = "";
if (account.Rows[0][7].Equals(OldUserPassword))
{
flag = dal.UpdateProjectInfo(UserID, newUserPassword);
}
}
responseMessage.message = new { rows = flag };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//返回错误信息
responseMessage.status = -1;
responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GetTemperatureandswitch()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
int cnt = 0;
string stcd = DictionaryPro.GetDicValue(dcParams, "stcd");
DateTime starttm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "starttm"));
DateTime endtm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "endtm"));
//DAL
RealTime_DAL dal = new RealTime_DAL();
DataTable list = dal.GetTemperatureandswitch(starttm, endtm, stcd);
DataTable MyDataTable = new DataTable();
//构造列
MyDataTable.Columns.Add(new DataColumn("Num", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("time", typeof(DateTime)));
DataRow dr;
for (int i = 0; i < list.Rows.Count - 1; i++)
{
dr = MyDataTable.NewRow();
dr["time"] = list.Rows[i][0];
dr["Num"] = list.Rows[i][1];
MyDataTable.Rows.Add(dr);
}
//返回数据
responseMessage.message = new { total = cnt, rows = MyDataTable };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//responseMessage.status = -1;
//responseMessage.message = ex.Message;
}
return(result);
}