public ResultQuotaLogs GetQuotaLogs()
{
var inputValue = _ntsPage.Request.Form["Inputs"];
var query = Newtonsoft.Json.JsonConvert.DeserializeObject<QueryQuotaLogContract>(inputValue);
var result = new OperateQuotaBll().GetQuotaLogs(query);
return result;
}
public int DealQuota()
{
var inputValue = _ntsPage.Request.Form["Inputs"];
var query = Newtonsoft.Json.JsonConvert.DeserializeObject<QuotaDataContact>(inputValue);
query.UserName = Framework.Common.Utils.GetCookie("userid");
var result = new OperateQuotaBll().InsertOrEditQuota(query);
return result;
}
public override string FormateContent(object primaryKey)
{
try
{
#region 变量
string content = string.Empty;
int id = (int)primaryKey;
string itemCodeName = string.Empty;
string objectDes = string.Empty;
string editTime = string.Empty;
string quotaDate = string.Empty;
string type = string.Empty;
string oldValue = string.Empty;
string newValue = string.Empty;
string objectUnit = string.Empty;
OperateQuotaBll quotaOper = new OperateQuotaBll();
#endregion
#region 数据来源
var quotaInfo = quotaOper.GetQuotaInfoById(id);
var itemCodeInfo = new NTS.WEB.BLL.Itemcode().GetItemcodeList(string.Format(" and itemcodenumber='{0}'", quotaInfo.QuotaData.ItemCode), "")[0];
QuotaLog newQoutaLog = quotaInfo.QuotaLogList[0];
#endregion
#region 组织数据
itemCodeName = itemCodeInfo.ItemCodeName;
objectUnit = itemCodeInfo.Unit;
objectDes = quotaInfo.QuotaData.ObjectDesc;
newValue = quotaInfo.QuotaData.QuotaValue.ToString();
editTime = newQoutaLog.LogTime.ToString("yyyy年MM月dd日HH时mm分ss秒");
type = quotaInfo.QuotaData.QuotaType == QuotaType.Month ? "月" : "年";
if (quotaInfo.QuotaData.QuotaType == QuotaType.Month)
{
quotaDate = string.Format("{0}年{1}月", quotaInfo.QuotaData.QuotaTime.Year, quotaInfo.QuotaData.QuotaTime.Month);
}
else if (quotaInfo.QuotaData.QuotaType == QuotaType.Year)
{
quotaDate = string.Format("{0}年", quotaInfo.QuotaData.QuotaTime.Year);
}
if (quotaInfo.QuotaLogList.Count > 1)
{
QuotaLog oldQUotaLog = quotaInfo.QuotaLogList[1];
oldValue = oldQUotaLog.QuotaValue.ToString();
content = string.Format("{0}用户于{1}修改\"{2}-{3}-{4}定额\":修改前为{5}kwh,修改后为{6}{7}。", _userName, editTime, objectDes, itemCodeName, type, oldValue, newValue, objectUnit);
}
else if (quotaInfo.QuotaLogList.Count == 1)
{
content = string.Format("{0}用户于{1}添加\"{2}-{3}-{4}定额\":{5}{6}。", _userName, editTime, objectDes, itemCodeName, type, newValue, objectUnit);
}
return content;
#endregion
}
catch (Exception ex)
{
return ex.Message;
}
}
/// <summary>
/// 获取定额告警列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ResultQuotaAlarmList GetQuotaAlarmList(Model.QueryQuotaAlarmContact query)
{
ResultQuotaAlarmList result = new ResultQuotaAlarmList();
result.ResultInfo = new ExecuteResult();
result.QuotaAlarmList = new List<QuotaAlarmData>();
result.Page = new Padding();
try
{
StringBuilder where = new StringBuilder();
#region 组织条件
if (!string.IsNullOrEmpty(query.ItemCode))
{
where.Append(string.Format(" and itemcode='{0}'", query.ItemCode));
}
if (query.AlarmType != 0)
{
where.Append(string.Format(" and alarmtype={0}", query.AlarmType));
}
if (query.QuotaType != 0)
{
where.Append(string.Format(" and quotatype={0}", query.QuotaType));
}
if (!string.IsNullOrEmpty(query.ObjectName))
{
where.Append(string.Format(" and objectdesc like '%{0}%'", query.ObjectName.Trim()));
}
#endregion
var list = quotaAlarmOperator.GetQuotaAlarmList(where.ToString());
while ((query.PageCurrent - 1) * query.PageSize >= list.Count())
{
query.PageCurrent--;
}
result.QuotaAlarmList = list
.Select(p => new QuotaAlarmData
{
AlarmType = p.AlarmType,
Id = p.Id,
ItemCode = p.ItemCode,
ObjectDesc = p.ObjectDesc,
ObjectId = p.ObjectId,
ObjectType = p.ObjectType,
Percent = p.Percent,
QuotaType = p.QuotaType
}).Skip((query.PageCurrent - 1) * query.PageSize).Take(query.PageSize).ToList();
result.Page.Current = query.PageCurrent;
result.Page.Total = list.Count();
//设置itemName 及 alarmName(减少全部转换)
var itemList = new OperateQuotaBll().GetAllItemcodeList();
var alarmTypeList = GetAlarmTypes("QoutaAlarm");
foreach (var item in result.QuotaAlarmList)
{
item.ItemName = GetItemNameByItemNumber(item.ItemCode, itemList);
item.AlarmName = GetAlarmNameByValue(item.AlarmType.ToString(), alarmTypeList);
}
result.ResultInfo.Success = true;
return result;
}
catch (Exception ex)
{
result.ResultInfo.Success = false;
result.ResultInfo.ExceptionMsg = ex.Message;
result.ResultInfo.ExtendContent = null;
return result;
}
}
/// <summary>
/// 获取定额告警列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ResultQuotaAlarmList GetQuotaAlarmList(Model.QueryQuotaAlarmContact query)
{
ResultQuotaAlarmList result = new ResultQuotaAlarmList();
result.ResultInfo = new ExecuteResult();
result.QuotaAlarmList = new List <QuotaAlarmData>();
result.Page = new Padding();
try
{
StringBuilder where = new StringBuilder();
#region 组织条件
if (!string.IsNullOrEmpty(query.ItemCode))
{
where.Append(string.Format(" and itemcode='{0}'", query.ItemCode));
}
if (query.AlarmType != 0)
{
where.Append(string.Format(" and alarmtype={0}", query.AlarmType));
}
if (query.QuotaType != 0)
{
where.Append(string.Format(" and quotatype={0}", query.QuotaType));
}
if (!string.IsNullOrEmpty(query.ObjectName))
{
where.Append(string.Format(" and objectdesc like '%{0}%'", query.ObjectName.Trim()));
}
#endregion
var list = quotaAlarmOperator.GetQuotaAlarmList(where.ToString());
while ((query.PageCurrent - 1) * query.PageSize >= list.Count())
{
query.PageCurrent--;
}
result.QuotaAlarmList = list
.Select(p => new QuotaAlarmData
{
AlarmType = p.AlarmType,
Id = p.Id,
ItemCode = p.ItemCode,
ObjectDesc = p.ObjectDesc,
ObjectId = p.ObjectId,
ObjectType = p.ObjectType,
Percent = p.Percent,
QuotaType = p.QuotaType
}).Skip((query.PageCurrent - 1) * query.PageSize).Take(query.PageSize).ToList();
result.Page.Current = query.PageCurrent;
result.Page.Total = list.Count();
//设置itemName 及 alarmName(减少全部转换)
var itemList = new OperateQuotaBll().GetAllItemcodeList();
var alarmTypeList = GetAlarmTypes("QoutaAlarm");
foreach (var item in result.QuotaAlarmList)
{
item.ItemName = GetItemNameByItemNumber(item.ItemCode, itemList);
item.AlarmName = GetAlarmNameByValue(item.AlarmType.ToString(), alarmTypeList);
}
result.ResultInfo.Success = true;
return(result);
}
catch (Exception ex)
{
result.ResultInfo.Success = false;
result.ResultInfo.ExceptionMsg = ex.Message;
result.ResultInfo.ExtendContent = null;
return(result);
}
}