public IActionResult SendForm(DataContact model)
{
if (ModelState.IsValid)
{
dataManager.DataContacts.SaveDataContacts(model);
return(View(model));
}
return(RedirectToAction(nameof(HomeController.Index), nameof(HomeController).CutController()));
}
public void SaveDataContacts(DataContact entity)
{
if (entity.Id == default)
{
context.Entry(entity).State = EntityState.Added;
}
else
{
context.Entry(entity).State = EntityState.Modified;
}
context.SaveChanges();
}
//public String
#endregion
protected void Page_Load(object sender, EventArgs e)
{
if (Request.RequestType == "POST")
{
try
{
if (Request.Form["name"] == "")
{
msg = "Bạn cần nhập tên đầy đủ";
return;
}
//if (Request.Form["email"] == "")
//{
// msg = "Bạn cần nhập tên đầy đủ";
// return;
//}
if (Request.Form["title"] == "")
{
msg = "Bạn cần nhập tiêu đề";
return;
}
if (Request.Form["noidung"] == "")
{
msg = "Bạn cần nhập nội dung";
return;
}
//SystemClass objSystem = new SystemClass();
DataContact objContact = new DataContact();
if (objContact.addData(Request.Form["name"], Request.Form["email"], Request.Form["title"], Request.Form["noidung"]) != 0)
{
Response.Redirect("/ContactOk");
}
else
{
msg = "Có lỗi xảy ra! Xin thử lại.";
}
}
catch { }
}
}
public ResultQueryPie GetQueryPieChart(DataContact.BasicQuery query)
{
#region 定义区
var resultList = new ResultView.ResultQueryPie
{
ObjectName = new List<string>(),
Enery = new List<decimal>(),
Dept = new List<string>()
};
#endregion
var objectList =
new BLL.BaseLayerObject().GetBaseLayerObjectList(
string.Format(" and layerobjectparentid={0}", query.ObjectNum), " order by LayerObjectID");
if (objectList.Count > 0)
{
decimal eTotal = 0;
for (var i = 0; i < objectList.Count; i++)
{
var querynew = new BasicQuery
{
StartTime = query.StartTime,
EndTime = query.EndTime,
ItemCode = query.ItemCode,
ObjectNum = objectList[i].LayerObjectID,
ObjectType = query.ObjectType,
Unit = query.Unit
};
//if (i < 5)
//{
if (query.ItemCode != "00000")
{
var item =
new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'",
" order by ItemcodeID")[0];
resultList.Dept.Add(item.Unit);
}
else
{
resultList.Dept.Add("T");
}
resultList.ObjectName.Add(objectList[i].LayerObjectName);
resultList.Enery.Add(new QueryEnery().GetQueryEneryTotal(querynew).TotalEnergy);
//}
//else
//{
// eTotal += new QueryEnery().GetQueryEneryTotal(querynew).TotalEnergy;
// if (i == objectList.Count - 1)
// {
// if (query.ItemCode != "00000")
// {
// var item =
// new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'",
// " order by ItemcodeID")[0];
// resultList.Dept.Add(item.Unit);
// }
// else
// {
// resultList.Dept.Add("T");
// }
// resultList.ObjectName.Add("其他");
// resultList.Enery.Add(eTotal);
// }
//}
}
if (resultList.Enery.Count > 5)
{
//resultList.ObjectName[5] = "其他";
List<EnergyRank> lstEnergy = new List<EnergyRank>();
for (var i = 0; i < resultList.Enery.Count; i++)
{
EnergyRank er = new EnergyRank();
er.ObjName = resultList.ObjectName[i];
er.Energy = resultList.Enery[i];
lstEnergy.Add(er);
}
lstEnergy = lstEnergy.OrderByDescending(p => p.Energy).ToList();
resultList.Dept.Clear();
resultList.ObjectName.Clear();
resultList.Enery.Clear();
if (lstEnergy.Count < 6)
{
foreach (EnergyRank er in lstEnergy)
{
resultList.Dept.Add("T");
resultList.ObjectName.Add(er.ObjName);
resultList.Enery.Add(er.Energy);
}
}
else
{
for (int i = 0; i < 5; i++)
{
resultList.Dept.Add("T");
resultList.ObjectName.Add(lstEnergy[i].ObjName);
resultList.Enery.Add(lstEnergy[i].Energy);
}
resultList.Dept.Add("T");
resultList.ObjectName.Add("其他");
//统计排名第五以后的能耗总和。
resultList.Enery.Add(lstEnergy.GetRange(5, lstEnergy.Count - 5).Sum(p => p.Energy));
}
}
return resultList;
}
else
{
var deviceList = new List<Device>();
if (query.ItemCode == "00000")
{
deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and areaid=" + query.ObjectNum, " order by deviceid");
}
else
{
string itemCodeAll = query.ItemCode;
string tempCode = string.Empty;
var itemcodeList = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'", " order by itemcodeid")[0];
var itemcodeListChild = new NTS.WEB.BLL.Itemcode().GetItemcodeList(" and ParentID=" + itemcodeList.ParentID, " order by itemcodeid");
foreach (Model.Itemcode itemcode in itemcodeListChild)
tempCode += ",'" + itemcode.ItemCodeNumber + "'";
itemCodeAll = itemCodeAll.Length > 0 ? "'" + itemCodeAll + "'" : itemCodeAll.Substring(1);
deviceList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(" and ItemCodeID in (" + itemCodeAll + ") and areaid=" + query.ObjectNum, " order by deviceid");
}
if (deviceList.Count > 0)
{
decimal eTotal = 0;
for (var i = 0; i < deviceList.Count; i++)
{
var querynew = new BasicQuery
{
StartTime = query.StartTime,
EndTime = query.EndTime,
ItemCode = query.ItemCode,
ObjectNum = deviceList[i].DeviceID,
ObjectType = query.ObjectType,
Unit = query.Unit
};
if (i < 5)
{
if (query.ItemCode != "00000")
{
var item =
new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'",
" order by ItemcodeID")[0];
resultList.Dept.Add(item.Unit);
}
else
{
resultList.Dept.Add("T");
}
resultList.ObjectName.Add(deviceList[i].DeviceName);
resultList.Enery.Add(new QueryEnery().GetDeviceQueryEneryTotal(querynew).TotalEnergy);
}
else
{
eTotal += new QueryEnery().GetDeviceQueryEneryTotal(querynew).TotalEnergy;
if (i == deviceList.Count - 1)
{
if (query.ItemCode != "00000")
{
var item =
new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + query.ItemCode + "'",
" order by ItemcodeID")[0];
resultList.Dept.Add(item.Unit);
}
else
{
resultList.Dept.Add("T");
}
resultList.ObjectName.Add("其他");
resultList.Enery.Add(eTotal);
}
}
}
return resultList;
}
}
return null;
}
