/// <summary>
/// 上级单位 首页
/// </summary>
/// <returns></returns>
public ActionResult ParentIndex()
{
var master = new MasterContext().Master;
if (master == null)
{
return(Redirect("/Temple/LoginError"));
}
else
{
//获取通知公告
XMLHealper XmlColl = new XMLHealper(Server.MapPath("~") + "Project\\Template\\notice.xml");
string notice = "";
foreach (XmlNode Nodes in XmlColl.GetXmlRoot().SelectNodes("tice"))
{
notice = Nodes.Attributes["value"].InnerText;
}
ViewData["Notice"] = notice;
ViewData["WebSiteName"] = ConfigurationManager.AppSettings["WebSiteName"];//系统站点名称
ViewData["Version"] = ConfigurationManager.AppSettings["Version"];
ViewData["copyright"] = "";
var model = new BllSysCompany().LoadData(key);
if (model != null)
{
ViewData["copyright"] = model.Name;
}
int UserCount = 0; //系统用户
int CompanyCount = 0; //使用单位
int EventCount = 0; //设备总量
int LostEvent = 0; //过期设备
int LostTime = 0; //超期未检
DataSet ds = new BllSysAppointed().Total(new MasterContext().Master.Cid);
if (ds.Tables[0].Rows.Count > 0)
{
UserCount = int.Parse(ds.Tables[0].Rows[0]["UserCount"].ToString());
CompanyCount = int.Parse(ds.Tables[0].Rows[0]["CompanyCount"].ToString());
EventCount = int.Parse(ds.Tables[0].Rows[0]["EventCount"].ToString());
LostEvent = int.Parse(ds.Tables[0].Rows[0]["LostEvent"].ToString());
LostTime = int.Parse(ds.Tables[0].Rows[0]["LostTime"].ToString());
}
//查询广告列表
BllEDynamic bllDynamic = new BllEDynamic();
List <ModEDynamic> list = bllDynamic.getListAll(9);
//查询待办任务
List <ModSysFlow> Flowlist = new BllSysFlow().getListAll(7, " and CompanyId='" + new MasterContext().Master.Cid + "'");
ViewData["UserCount"] = UserCount;
ViewData["CompanyCount"] = CompanyCount;
ViewData["EventCount"] = EventCount;
ViewData["LostEvent"] = LostEvent;
ViewData["LostTime"] = LostTime;
ViewData["list"] = list;
ViewData["Flowlist"] = Flowlist;
return(View());
}
}
/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
//判断类型是否还在使用
var mode = new BllSysAppointed().Exists(" Places in(" + id + ")");
if (mode == true)
{
msg.success = false;
msg.msg = "此地址正在使用,暂不能删除.";
}
else
{
if (new BllFireBox().DeleteStatus(id) > 0)
{
LogInsert(OperationTypeEnum.操作, "设备位置删除", "操作成功.");
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "操作失败";
LogInsert(OperationTypeEnum.操作, "设备位置删除", "操作失败.");
}
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
LogInsert(OperationTypeEnum.异常, "设备位置删除", "操作异常信息:" + ex);
}
WriteJsonToPage(msg.ToString());
}
/// <summary>
/// 已过期的数量（红色），异常状态设备数量（黄色），半年内即将过期的数量（蓝色），其他正常数量（绿色）
/// </summary>
public void ChartPart()
{
BllSysAppointed Bll = new BllSysAppointed();
var msg = new ModJsonResult();
List <Hashtable> info = new List <Hashtable>();
try
{
string CompanyId = Request["CompanyId"].ToString() == "" ? CurrentMaster.Cid : Request["CompanyId"].ToString();
DataSet ds = Bll.ChartAppointed(CompanyId);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Hashtable table = new Hashtable();
table.Add("已过期数量", ds.Tables[0].Rows[i]["Count1"].ToString());
table.Add("异常状态设备量", ds.Tables[0].Rows[i]["Count2"].ToString());
table.Add("半年内即将过期数量", ds.Tables[0].Rows[i]["Count3"].ToString());
table.Add("正常数量", ds.Tables[0].Rows[i]["Count4"].ToString());
info.Add(table);
}
}
msg.data = JsonHelper.ToJson(info);
LogInsert(OperationTypeEnum.访问, "设备统计模块", "访问页面成功.");
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "设备统计模块", "查询列表错误消息:" + ex.Message.ToString());
}
WriteJsonToPage(msg.ToString());
}
/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
//判断类型是否还在使用
var mode = new BllSysAppointed().Exists(" Gid='" + id + "'");
if (mode == true)
{
msg.success = false;
msg.msg = "此类别正在使用,暂不能删除.";
}
else
{
int result = new BllSysGroup().DeleteStatus(id);
if (result > 0)
{
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "删除失败.";
}
LogInsert(OperationTypeEnum.操作, "类型删除操作", "删除操作成功.");
}
}
catch (Exception ex)
{
LogInsert(OperationTypeEnum.异常, "类型删除操作", "删除操作异常消息:" + ex.Message.ToString());
}
WriteJsonToPage(msg.ToString());
}
/// <summary>
/// 超期未巡检列表统计
/// </summary>
public void SuperParentData()
{
try
{
BllSysAppointed Bll = new BllSysAppointed();
Search search = this.GetSearch();
if (Request["Id"].ToString() != "-1")
{
search.AddCondition("Cid='" + Request["Id"].ToString() + "'");
}
else
{
search.AddCondition("Cid in (select EmployerId from Sys_CompanyCognate where Cid='" + CurrentMaster.Cid + "' and Status=1 and SelectType=2)");
}
string searchType = Request["searchType"].ToString();
switch (int.Parse(searchType))
{
case 1: //全部
break;
case 2: //本月
search.AddCondition("datediff(month,MaintenanceDate,getdate())=0");
break;
case 3: //上月
search.AddCondition("datediff(month,MaintenanceDate,getdate())=1");
break;
}
search.AddCondition("MaintenanceDate<getDate()");
LogInsert(OperationTypeEnum.访问, "超期未巡检列表统计模块", "访问页面成功.");
WriteJsonToPage(Bll.SearchData(search));
}
catch (Exception ex)
{
LogErrorRecord.Info("查询列表:" + ex);
LogInsert(OperationTypeEnum.异常, "超期未巡检列表统计模块", "查询列表错误消息:" + ex.Message.ToString());
}
}
/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
//判断类型是否还在使用
var mode = new BllSysAppointed().Exists(" ResponsibleId='" + id + "'");
if (mode == true)
{
msg.success = false;
msg.msg = "该用户下还存在管理的设备,请先更改设备责任人再删除.";
}
else
{
BllSysMaster Master = new BllSysMaster();
var Model = Master.LoadData(id);
if (Model != null)
{
Model.Status = (int)StatusEnum.除;
int result = Master.Update(Model);
if (result > 0)
{
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
}
WriteJsonToPage(msg.ToString());
}
public static int DBImportFun(string sql)
{
BllSysAppointed bllsysCom = new BllSysAppointed();
return(bllsysCom.ExecuteNonQueryByText(sql));
}
