public HttpResponseMessage Detail(string appId, string token, int Id)
{
ReturnResult obj = new ReturnResult();
//dynamic json = jData;
//string appId = json.appId;
//string token = json.token;
//int Id = Convert.ToInt32(json.Id);
try
{
var data = db.Equipment.Where(d => d.token == token && d.Id == Id).SingleOrDefault();
if (data != null)
{
obj.status = "0";
obj.msg = "ok";
obj.data = JsonHelp.ObjectToString(data);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "设备详情！", "Detail", appId, "Equipment");
}
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public ActionResult EditDeviceid(YLDeviceidData data)
{
ReturnResult result = new ReturnResult();
var model = db.YLDeviceidData.Where(d => d.Id == data.Id).SingleOrDefault();
model.Deviceid = data.Deviceid;
model.DeviceidName = data.DeviceidName;
model.AddTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
try
{
db.SaveChanges();
result.status = "200";
result.msg = "成功！";
result.data = "";
}
catch (Exception)
{
result.status = "2";
result.msg = "失败！";
result.data = "";
}
var json = JsonHelp.ObjectToString(result);
return(Content(json));
}
public ActionResult AddDeviceid(YLDeviceidData data)
{
ReturnResult result = new ReturnResult();
YLDeviceidData model = new YLDeviceidData();
model.Deviceid = data.Deviceid;
model.DeviceidName = data.DeviceidName;
model.AddTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
try
{
db.YLDeviceidData.Add(model);
db.SaveChanges();
result.status = "200";
result.msg = "成功！";
result.data = "";
}
catch (Exception ex)
{
result.status = "2";
result.msg = "失败！";
result.data = "";
}
var json = JsonHelp.ObjectToString(result);
return(Content(json));
}
public HttpResponseMessage List(string appId, string token, string username)
{
ReturnResult obj = new ReturnResult();
//dynamic json = jData;
//string appId = json.appId;
//string token = json.token;
//string username = json.username;
try
{
var data = db.FeedBack.Where(d => d.token == token && d.username == username).SingleOrDefault();
if (data != null)
{
obj.status = "0";
obj.msg = "ok";
obj.data = JsonHelp.ObjectToString(data);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "反馈列表！", "List", appId, "FeedBack");
}
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public HttpResponseMessage Login(JObject jData)
{
//定义
ResponseResult obj = new ResponseResult();
dynamic json = jData;
string username = json.phone;
string password = json.password;
string appId = json.appId;
var model = GetLoginModel(username, password);
if (model != null)
{
if (ValidateTicket(model.token))
{
obj.Token = model.token;
}
else
{
var token = Guid.NewGuid().ToString("N");
model.token = token;
model.expireDate = DateTime.Now.AddDays(7);
obj.Token = token;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
}
obj.status = "0";
obj.msg = "ok";
obj.data = JsonHelp.ObjectToString(model);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "用户登录", "Login", appId, "Account");
}
else
{
obj.status = "2";
obj.msg = "用户名或密码错误";
obj.data = "";
obj.Token = "";
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "用户名或密码错误", "Login", appId, "Account");
}
var resultObj = JsonConvert.SerializeObject(obj, Formatting.Indented);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public HttpResponseMessage Change(JObject jData)
{
ReturnResult obj = new ReturnResult();
dynamic json = jData;
string token = json.token;
string appId = json.appId;
string clientId = json.clientId;
string name = json.name;
string status = json.status;
string module = json.module;
string contacts = json.contacts;
string phone = json.phone;
string email = json.email;
string address = json.address;
try
{
Merchant model = db.Merchant.Where(d => d.token == token).Where(d => d.phone == phone).Where(d => d.name == name).SingleOrDefault();
model.address = address;
model.clientId = clientId;
model.token = token;
model.name = name;
model.status = status;
model.module = module;
model.email = email;
model.phone = phone;
model.appId = appId;
model.contacts = contacts;
db.SaveChanges();
obj.status = "0";
obj.msg = "成功";
obj.data = JsonHelp.ObjectToString(model);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "商户修改", "Change", appId, "Merchant");
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public HttpResponseMessage List(JObject jData)
{
ReturnResult obj = new ReturnResult();
dynamic json = jData;
string appId = json.appId;
string token = json.token;
string parent = json.parent;
string type = json.tyep;
try
{
var data = db.NodeList.Where(d => d.token == token && d.parent == parent && d.type == type).SingleOrDefault();
if (data != null)
{
obj.status = "0";
obj.msg = "ok";
obj.data = JsonHelp.ObjectToString(data);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "节点列表！", "List", appId, "Node");
}
else
{
obj.status = "2";
obj.msg = "no";
obj.data = "没有数据";
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "节点列表！", "List", appId, "Node");
}
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public HttpResponseMessage List(string token, string appId, string status)
{
ReturnResult obj = new ReturnResult();
//dynamic json = jData;
//string token = json.token;
//string appId = json.appId;
//string status = json.status;
Merchant model = new Merchant();
try
{
model = db.Merchant.Where(d => d.token == token && d.status == status).SingleOrDefault();
if (model != null)
{
obj.status = "0";
obj.msg = "成功";
obj.data = JsonHelp.ObjectToString(model);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "商户列表信息", "List", appId, "Merchant");
}
else
{
obj.status = "2";
obj.msg = "失败！";
obj.data = "";
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "商户列表信息", "List", appId, "Merchant");
}
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public HttpResponseMessage GetAccountInfo(string user, string pwd, string appId, string token)
{
ResponseResult obj = new ResponseResult();
//dynamic json = jData;
//string user = json.phone;
//string pwd = json.pwd;
//string appId = json.appId;
try
{
var model = GetLoginModel(user, pwd);
if (model != null)
{
obj.status = "0";
obj.Token = model.token;
obj.msg = "成功";
obj.data = JsonHelp.ObjectToString(model);
UtilSysLog.NewLogInfo(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "获取用户信息", "GetAccountInfo", appId, "Account");
}
}
catch (Exception ex)
{
obj.status = "6";
obj.msg = "失败";
obj.Token = "";
obj.data = "";
UtilSysLog.NewLogErre(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), ex.ToString());
}
var resultObj = JsonConvert.SerializeObject(obj);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(resultObj, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public string DahuaData(JObject jData)
{
//响应头开放(用于Web前端的XHR2调用)
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Methods", "GET,POST");
ReturnResult result = new ReturnResult();
//DHModel db = new DHModel();
YLMDBDBEntities db = new YLMDBDBEntities();
Dictionary <string, string> dic = new Dictionary <string, string>();
dynamic json = jData;
string key = json.key; //由雅量提供，专门用于大华客流的固定字符串
string deviceid = json.deviceid; //设备ID
string data = json.data; //数据：【时间/进人数/出人数/设备MAC】
string SysKey = JsonHelp.GetValue("key");
string Sysdeviceid = string.Empty;
var deviceidLs = db.YLDeviceidData.Where(d => d.Deviceid == deviceid).FirstOrDefault();
if (deviceidLs != null && deviceidLs.Deviceid != "")
{
Sysdeviceid = deviceidLs.Deviceid;
}
else
{
result.status = "2";
result.msg = "设备Id或key错误";
result.data = null;
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "信息：设备Id或key错误");
}
//GetValue("deviceid");
//string result = string.Empty;
if (key.Equals(SysKey) && deviceid.Equals(Sysdeviceid))
{
try
{
var list = JsonHelp.Deserialize <DahuaInfo>(data);
var newInNum = list.InNum;
var newOutNum = list.OutNum;
IntelligentDataDH oldlist = null;
//查询最后一条数据(最大的DataID)
try
{
var maxId = db.IntelligentDataDH.Where(p => p.IMEI.Contains(deviceid)).Max(p => p.DataID);
oldlist = db.IntelligentDataDH.FirstOrDefault(d => d.DataID == maxId);
}
catch (Exception)
{
oldlist = null;
}
if (oldlist != null)
{
var oldInNum = oldlist.InNum;
var oldOutNum = oldlist.OutNum;
newInNum = list.InNum - oldInNum;
newOutNum = list.OutNum - oldOutNum;
}
IntelligentDataDH da = null;
da = new YLDB.IntelligentDataDH();
da.GatewayID = 9999;
da.InNum = list.InNum;
da.OutNum = list.OutNum;
da.MAC = "";
da.IMEI = deviceid;
da.Flage = 1;
da.DataDateTime = Convert.ToDateTime(list.DataDateTime);
db.IntelligentDataDH.Add(da);
db.SaveChanges();
string strAction = SubStringByDeviceid(deviceid);//得到插入的表名
string sql = string.Format("insert into {0} (GatewayID, IMEI, MAC, DataDateTime, InNum, OutNum, Flage) values ({1},'{2}','{3}','{4}',{5},{6},{7})", strAction, 9999, deviceid, "", list.DataDateTime, newInNum, newOutNum, 1);
try
{
int count = DbHelperSQL.ExecuteSql(sql);
if (count > 0)
{
dic.Add("key", key);
dic.Add("deviceid", deviceid);
dic.Add("InNum", list.InNum + "");
dic.Add("OutNum", list.OutNum + "");
dic.Add("DataDateTime", list.DataDateTime + "");
result.status = "0";
result.msg = "ok";
result.data = JsonHelp.ObjectToString(dic);
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "信息：成功！" + "key=" + key + "， deviceid=" + deviceid);
}
}
catch (Exception ex)
{
result.status = "6";
result.msg = "程序异常";
result.data = null;
log.Error("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：" + ex.ToString());
}
//result = ObjectToString(dic);
//result = string.Format("result:数据推送成功！[key={0},deviceid={1},InNum={2},OutNum={3},DataDateTime={4}]",key,deviceid,list.InNum,list.OutNum,list.DataDateTime);
}
catch (Exception ex)
{
result.status = "6";
result.msg = "程序异常";
result.data = null;
log.Error("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：" + ex.ToString());
}
}
else
{
//result = "设备Id或key错误";
result.status = "2";
result.msg = "设备Id或key错误";
result.data = null;
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：设备Id或key错误");
}
var strResult = string.Empty;
try
{
strResult = JsonHelp.ObjectToString(result);
}
catch (Exception ex)
{
result.status = "6";
result.msg = "程序异常";
result.data = null;
log.Error("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：" + ex.ToString());
}
return(strResult);
//[{"datetime":"2018-5-18 12:23 251","in":1,"out":0,"MAC":"00:72:11:60:22:f0"},{"datetime":"2018-5-18 12:20 512","in":0,"out":2,"MAC":"00:72:11:60:22:f0"}]
}
public string DahuaTest(JObject jData)
{
//响应头开放(用于Web前端的XHR2调用)
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Methods", "GET,POST");
//DHModel db = new DHModel();
ReturnResult result = new ReturnResult();
YLMDBDBEntities db = new YLMDBDBEntities();
Dictionary <string, string> dic = new Dictionary <string, string>();
dynamic json = jData;
string key = json.key; //由雅量提供，专门用于大华客流的固定字符串
string deviceid = json.deviceid; //设备ID
string data = json.data; //数据：【时间/进人数/出人数/设备MAC】
string SysKey = JsonHelp.GetValue("key");
string Sysdeviceid = string.Empty;
var deviceidLs = db.YLDeviceidData.Where(d => d.Deviceid == deviceid).FirstOrDefault();
if (deviceidLs != null && deviceidLs.Deviceid != "")
{
Sysdeviceid = deviceidLs.Deviceid;
}
else
{
result.status = "6";
result.msg = "设备Id或key错误";
result.data = null;
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：设备Id或key错误");
}
//GetValue("deviceid");
//string result = string.Empty;
if (key.Equals(SysKey) && deviceid.Equals(Sysdeviceid))
{
var list = JsonHelp.Deserialize <DahuaInfo>(data);
IntelligentData da = null;
da = new YLDB.IntelligentData();
da.GatewayID = 9999;
da.InNum = list.InNum;
da.OutNum = list.OutNum;
da.MAC = "";
da.IMEI = deviceid;
da.Flage = 1;
da.DataDateTime = Convert.ToDateTime(list.DataDateTime);
db.IntelligentData.Add(da);
try
{
db.SaveChanges();
dic.Add("key", key);
dic.Add("deviceid", deviceid);
dic.Add("InNum", list.InNum + "");
dic.Add("OutNum", list.OutNum + "");
dic.Add("DataDateTime", list.DataDateTime + "");
result.status = "ok";
result.msg = "成功";
result.data = JsonHelp.ObjectToString(dic);
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "信息：成功！" + "key=" + key + "， deviceid=" + deviceid);
//result = string.Format("result:数据推送成功！[key={0},deviceid={1},InNum={2},OutNum={3},DataDateTime={4}]",key,deviceid,list[0].InNum,list[0].OutNum,list[0].DataDateTime);
}
catch (Exception ex)
{
result.status = "6";
result.msg = "程序异常";
result.data = null;
UtilSysLog.LogErr(ex);
log.Error("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：" + ex.ToString());
}
}
else
{
result.status = "2";
result.msg = "设备Id或key错误";
result.data = null;
log.Info("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：设备Id或key错误");
}
var strResult = string.Empty;
try
{
strResult = JsonHelp.ObjectToString(result);
}
catch (Exception ex)
{
result.status = "6";
result.msg = "程序异常";
result.data = null;
log.Error("时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "异常信息：" + ex.ToString());
}
return(strResult);
//[{"datetime":"2018-5-18 12:23 251","in":1,"out":0,"MAC":"00:72:11:60:22:f0"},{"datetime":"2018-5-18 12:20 512","in":0,"out":2,"MAC":"00:72:11:60:22:f0"}]
}