public SaveResult SaveObjectEnery()
{
decimal temp;
var inputValue = _ntsPage.Request.Form["Inputs"];
var query = Newtonsoft.Json.JsonConvert.DeserializeObject <QueryEnery>(inputValue);
query.ObjectId = query.IsArea == 1 ? query.ObjectId : query.DeviceId;
if (!decimal.TryParse(query.ObjectValue.ToString(), out temp))
{
return(new SaveResult {
IsOK = false, MessageContent = "录入的能耗值的格式不正确。"
});
}
var import = new ImportTemp()
{
ImportValue = temp,
ExcelId = -1,
StartTime = query.Starttime,
EndTime = query.Starttime,
IsArea = query.IsArea,
ItemCode = query.ItemCode,
ObjectId = query.ObjectId,
MonthType = query.DateUnit
};
return(_bll.SaveImportEneryValue(import) > 0
? new SaveResult {
IsOK = true, MessageContent = "人工导入成功，等待后台服务进行处理。"
}
: new SaveResult {
IsOK = false, MessageContent = "人工导入失败，请联系管理员。"
});
}
public int SaveImportEneryValue(ImportTemp import)
{
var cmd = new DataCommand("ImportData", new SqlCustomDbCommand());
cmd.SetParameterValue("@ObjectID", import.ObjectId);
cmd.SetParameterValue("@IsArea", import.IsArea);
cmd.SetParameterValue("@StartTime", import.StartTime);
cmd.SetParameterValue("@EndTime", import.EndTime);
cmd.SetParameterValue("@ItemCode", import.ItemCode);
cmd.SetParameterValue("@ImportValue", import.ImportValue);
cmd.SetParameterValue("@MonthType", import.MonthType);
cmd.SetParameterValue("@ExcelId", import.ExcelId);
return(cmd.ExecuteNonQuery());
}
public int SaveImportEneryValue(ImportTemp import)
{
return(_import.SaveImportEneryValue(import));
}
