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);
}
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 = "人工导入失败，请联系管理员。"};
}