public ActionResult getRealTimeValue(string tagid) //获取测点实时温度信息 修改于 20160525
{
string sid = getSessionID().Split(';')[0];
string strJson = "";
string pdrlist = "";
if (sid != null && sid != "")
{
t_CM_UserInfo user = (t_CM_UserInfo)Session[sid];
//pdrlist = user.PDRList;
pdrlist = HomeController.GetPID(user.UNITList);
string pdrSQL = "SELECT * FROM V_DeviceInfoState_PDR1 WHERE TagID in (" + tagid + ") and pid in (" + pdrlist + ")";
List <V_DeviceInfoState_PDR1> list = bll.ExecuteStoreQuery <V_DeviceInfoState_PDR1>(pdrSQL).ToList();
if (list.Count > 0)
{
foreach (V_DeviceInfoState_PDR1 model in list)
{
strJson += "{\"TagID\":" + model.TagID + ",\"PV\":" + model.PV + ",\"Units\":\"" + model.Units + "\",\"RecTime\":\"" + model.RecTime + "\"},";
}
strJson = strJson.TrimEnd(',');
strJson = "{\"rows\":[" + strJson + "]," + "\"total\":" + list.Count + "}";
}
}
else
{
strJson = "no login";
}
return(Content(strJson));
}
public static t_CM_UserInfo Login(string username, string password, ControllerContext actionContext, out int ErrCode)
{
ErrCode = 0;
t_CM_UserInfo userInf = null;
if (!GetLicense())
{
ErrCode = -1;
return(userInf);
}
string MD5password = Lib.Base.Encrypt.MD5Encrypt(password);
//List<t_CM_UserInfo> list = bll.t_CM_UserInfo.Where(u => u.UserName == username && u.UserPassWord == MD5password).ToList();
IList <IDAO.Models.t_CM_UserInfo> list = UserInfoDAL.getInstance().GetUsers(username, MD5password);
if (list.Count > 0)
{
actionContext.HttpContext.Session["Huerinfo"] = userInf = list[0];
try
{
HttpCookie cookie = new HttpCookie("myYWAppInf");
//cookie.Expires = DateTime.Now.AddYears(20);
cookie.Values.Set("appkey", Lib.Base.Encrypt.MD5Encrypt2(username));
cookie.Values.Add("appu", Lib.Base.Encrypt.MD5Encrypt2(password));
actionContext.HttpContext.Response.SetCookie(cookie);
actionContext.HttpContext.Response.Cookies.Add(cookie);
}
catch (Exception ex)
{
LogHelper.Warn(ex);
}
}
return(userInf);
}
public ActionResult getPointsInfo(int did) //获取权限内配电房的设备的测点信息 修改于 20160525
{
string sid = getSessionID().Split(';')[0];
string strJson = "";
string pdrlist = "";
if (sid != null && sid != "")
{
t_CM_UserInfo user = (t_CM_UserInfo)Session[sid];
pdrlist = HomeController.GetPID(user.UNITList);
//pdrlist = user.PDRList;
string pdrSQL = "SELECT * FROM V_PointsInfo WHERE DID = " + did + " and pid in (" + pdrlist + ")";
List <V_PointsInfo> list = bll.ExecuteStoreQuery <V_PointsInfo>(pdrSQL).ToList();
List <t_CM_DeviceType> DTlist = bll.t_CM_DeviceType.ToList();
if (list.Count > 0)
{
foreach (V_PointsInfo model in list)
{
strJson += "{\"TagID\":" + model.TagID + ",\"TagName\":\"" + model.Position + "\",\"TypeName\":\"" + model.TypeName + "\"},";
}
strJson = strJson.TrimEnd(',');
strJson = "{\"rows\":[" + strJson + "]," + "\"total\":" + list.Count + "}";
}
}
else
{
strJson = "no login";
}
return(Content(strJson));
}
public ActionResult getPtAlarmInfo(int pid, string ALarmType, string startdate, string enddate) //获取报警信息 修改于 20160525
{
string sid = getSessionID().Split(';')[0];
string strJson = "";
string pdrlist = "";
if (sid != null && sid != "")
{
t_CM_UserInfo user = (t_CM_UserInfo)Session[sid];
pdrlist = HomeController.GetPID(user.UNITList);
// pdrlist = user.PDRList;
string pdrSQL = "SELECT * FROM t_AlarmTable_en WHERE PID = " + pid + " and pid in (" + pdrlist + ")";
if (ALarmType != "" && ALarmType != null)
{
pdrSQL += " and ALarmType = " + ALarmType;
}
if (startdate != "" && startdate != null)
{
startdate = startdate.Replace('-', '/');
}
else
{
startdate = DateTime.Now.ToString("yyyy/MM/dd");
}
if (enddate != "" && enddate != null)
{
enddate = enddate.Replace('-', '/');
}
else
{
enddate = DateTime.Now.ToString("yyyy/MM/dd");
}
pdrSQL += " and AlarmDate>='" + startdate + "' and AlarmDate<='" + enddate + "'";
List <t_AlarmTable_en> list = bll.ExecuteStoreQuery <t_AlarmTable_en>(pdrSQL).ToList();
if (list.Count > 0)
{
foreach (t_AlarmTable_en model in list)
{
strJson += "{\"TagID\":\"" + model.TagID + "\",\"AlarmCate\":\"" + model.AlarmArea + model.AlarmAddress + "\",\"AlarmValue\":\"" + model.AlarmValue + "\",\"ALarmType\":\"" + model.ALarmType + "\",\"AlarmState\":\"" + model.AlarmState + "\",\"AlarmConfirm\":\"" + model.AlarmConfirm + "\",\"AlarmTime\":\"" + model.AlarmTime + "\"},";
}
strJson = strJson.TrimEnd(',');
strJson = "{\"rows\":[" + strJson + "]," + "\"total\":" + list.Count + "}";
}
}
else
{
strJson = "no login";
}
return(Content(strJson));
}
public IList <t_CM_UserInfo> GetUnitLIstByUserID(t_CM_UserInfo user)
{
IList <t_CM_UserInfo> data = new List <t_CM_UserInfo>();
try
{
data = _dbFactory.userInf.GetUnitLIstByUserID(user);
}
catch (Exception ex)
{
throw ex;
}
return(data);
}
public ActionResult getPDRInfo(string UserName) //获取权限内配电房信息 修改于 20160525
{
string sid = getSessionID().Split(';')[0];
string strJson = "";
string pdrlist = "0";
string getNandS = "";
string[] NandS = { "", "" };
string[] PDRType = { "地上开闭站", "地下开闭站", "高低压电缆分界室", "高低压电缆分界箱 ", "低压配电室", "地上小区配电室", "地下小区配电室", "用户配电室", "开闭器", "小区配电室(箱变)" };
if (sid != null && sid != "")
{
t_CM_UserInfo user = (t_CM_UserInfo)Session[sid];
List <t_CM_UserInfo> UserList = bll.t_CM_UserInfo.Where(u => u.UserName == UserName && u.UserName != "admin").ToList();
if (UserList.Count > 0)
{
pdrlist = HomeController.GetPID(UserList.First().UNITList);
}
string pdrSQL = "SELECT * FROM t_CM_PDRInfo WHERE pid in (" + pdrlist + ")";
List <t_CM_PDRInfo> list = bll.ExecuteStoreQuery <t_CM_PDRInfo>(pdrSQL).ToList();
List <t_CM_Area> Arealist = bll.t_CM_Area.ToList();
if (list.Count > 0)
{
foreach (t_CM_PDRInfo model in list)
{
getNandS = "";
if (model.Coordination != null)
{
NandS = model.Coordination.Split('|');
getNandS = "\",\"latitude\":\"" + NandS[0] + "\",\"longtitude\":\"" + NandS[1];
strJson += "{\"PID\":" + model.PID + ",\"Name\":\"" + model.Name + getNandS + "\",\"status\":\"" + model.AlarmState + "\",\"Area\":\"" + Arealist.Where(a => a.AreaID == model.AreaID).First().AreaName + "\",\"Type\":\"" + PDRType[(int)model.TypeID - 1] + "\"},";
}
else
{
strJson += "";
}
}
strJson = strJson.TrimEnd(',');
strJson = "{\"rows\":[" + strJson + "]," + "\"total\":" + list.Count + "}";
}
}
else
{
strJson = "no login";
}
return(Content(strJson));
}
public static t_CM_UserInfo WxLogin(string openid, ControllerContext actionContext, out int ErrCode)
{
ErrCode = 0;
t_CM_UserInfo userInf = null;
if (!GetLicense())
{
ErrCode = -1;
return(userInf);
}
IList <IDAO.Models.t_CM_UserInfo> list = UserInfoDAL.getInstance().GetWxUsers(openid);
if (list.Count > 0)
{
actionContext.HttpContext.Session["Huerinfo"] = userInf = list[0];
}
return(userInf);
}
public IList <t_CM_UserInfo> GetUnitLIstByUserID(t_CM_UserInfo user)
{
string sql = "";
if (user.RoleID == 1)
{
sql = "select * from t_CM_UserInfo";
}
else if (Convert.ToBoolean(user.IsAdmin))
{
sql = $"select * from t_CM_UserInfo where UID = {user.UID} AND RoleID!= 1";
}
else
{
sql = $"select * from t_CM_UserInfo where UserID={user.UserID}";
}
return(SQLQuery <t_CM_UserInfo>(sql));
}
/// <summary>
/// 依据uid获取使用者名称
/// </summary>
/// <param name="uid">用户编号</param>
/// <returns></returns>
private string GetUserByUid(int uid)
{
string UserName = string.Empty;
string strsql = string.Empty;
strsql = string.Format("select * from t_CM_UserInfo where UserID = {0}", uid);
if (!string.IsNullOrEmpty(strsql))
{
List <t_CM_UserInfo> list = bll.ExecuteStoreQuery <t_CM_UserInfo>(strsql).ToList();
if (list.Count > 0)
{
t_CM_UserInfo UserInfo = list[0];
UserName = UserInfo.UserName;
}
}
else
{
}
return(UserName);
}
public void SendConTemp(object sender, System.Timers.ElapsedEventArgs e)
{
try
{
var list = bll.t_ES_ContractTemplet.Where(p => p.IsOk == 0).ToList();
foreach (var item in list)
{
//var sss = item.StartTime.Value.Date;
//var ss = DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date;
if (null != item.StartTime && null != item.AlarmTime)
{
if (
(item.StartTime.Value.Date == DateTime.Now.AddDays(Convert.ToDouble(item.BeforDay)).Date&& item.AlarmTime.Value.Date != DateTime.Now.Date) ||
item.AlarmTime.Value.Date == Convert.ToDateTime("1900-01-01").Date ||
(item.StartTime.Value.Date == DateTime.Now.Date && item.AlarmTime.Value.Date != DateTime.Now.Date)
)
{
t_CM_UserInfo user = bll.t_CM_UserInfo.Where(p => p.UserID == item.PersonID).FirstOrDefault();
if (user != null)
{
item.AlarmTime = DateTime.Now;
bll.ObjectStateManager.ChangeObjectState(item, System.Data.EntityState.Modified);
UtilsSms.smsConTemp(user.Telephone);
}
}
}
}
bll.SaveChanges();
}
catch (Exception ex)
{
string error = ex.ToString();
return;
}
}
public LoginBean(string sID, t_CM_UserInfo t_CM_UserInfo)
{
// TODO: Complete member initialization
this.sID = sID;
this.t_CM_UserInfo = t_CM_UserInfo;
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
var noAuthorizeAttributes = filterContext.ActionDescriptor.GetCustomAttributes(typeof(AuthorizeIgnoreAttribute), false);
if (noAuthorizeAttributes.Length > 0)//不需要登陆
{
return;
}
base.OnActionExecuting(filterContext);
//LogHelper.Debug(filterContext.HttpContext.Timestamp.ToString());
if (CurrentUser == null)
{
//获取页面设置的单点登录页面
//if (ConfigurationManager.AppSettings["SSO"] != null)
//{
// string url = ConfigurationManager.AppSettings["SSO"];
//}
//cookie 登陆
try
{
HttpCookie cookie = filterContext.HttpContext.Request.Cookies["myYWAppInf"];
if (null != cookie)
{
string username = Encrypt.MD5Decrypt2(cookie["appkey"]);
string MD5password = Encrypt.MD5Decrypt2(cookie["appu"]);
//List<t_CM_UserInfo> list = bll.t_CM_UserInfo.Where(u => u.UserName == username && u.UserPassWord == MD5password).ToList();
//List<t_CM_UserInfo> list = UserInfoDAL.getInstance().GetUsers(username, MD5password) as List<t_CM_UserInfo>;
t_CM_UserInfo userInf = LoginManager.Login(username, MD5password, this.ControllerContext, out int errCode);
if (null != userInf)//(list.Count > 0)
{
// filterContext.HttpContext.Session["Huerinfo"] = list[0];
//LogHelper.Debug(username + "--auto login");
LogDebug(username + "--auto login");
return;
}
}
}
catch (Exception ex)
{
//LogHelper.Warn(ex);
LogInfo(ex.ToString());
}
filterContext.HttpContext.Session.RemoveAll();
filterContext.HttpContext.Response.Write("<script language=javascript>top.location.href='/Home/Login';</script>");
//filterContext.HttpContext.Response.Redirect("~/Home/Login");
//filterContext.Result = RedirectToAction("Login", "Home", new { area = "" });
}
else
{
//string sid = filterContext.HttpContext.Session.SessionID;
//string username = CurrentUser.UserName;
//List<t_CM_UserLogin> listLogin = bll.t_CM_UserLogin.Where(l => l.UserName.ToLower() == username.ToLower()).ToList();
//if (listLogin.Count > 0)
//{
// if (sid != listLogin[0].SessionID)
// {
// filterContext.HttpContext.Response.Write("<script language=javascript>alert('此用户已在其他地方登录，请重新登录！');top.location.href='/Home/Login';</script>");
// }
//}
}
}
