public string SetPricingPlan(IoT_Pricing info, List <IoT_PricingMeter> meterList) { string result = ""; M_SetParameterService sp = new M_SetParameterService(); //整理调价参数 foreach (IoT_PricingMeter m in meterList) { PricingPlan pp = new PricingPlan() { IsUsedLadder = (bool)info.IsUsed, Ladder = (int)info.Ladder, MeterType = info.MeterType, SettlementType = info.SettlementType, Price1 = (decimal)info.Price1, Price2 = (decimal)info.Price2, Price3 = (decimal)info.Price3, Price4 = (decimal)info.Price4, Price5 = (decimal)info.Price5, Gas1 = (decimal)info.Gas1, Gas2 = (decimal)info.Gas2, Gas3 = (decimal)info.Gas3, Gas4 = (decimal)info.Gas4, UseDate = ((DateTime)info.UseDate).ToString("yyyy-MM-dd") }; pp.MeterNo = m.MeterNo.Trim(); result = sp.SetPricingPlan(pp, m); //记录调价计划 } return(result); }
/// <summary> /// 设置结算日 /// </summary> /// <param name="settlementDay"></param> /// <param name="meters"></param> /// <returns></returns> public string SetSettlementDay(IoT_SetSettlementDay settlementDay, List <IoT_SettlementDayMeter> meters) { string result = ""; M_SetParameterService sp = new M_SetParameterService(); foreach (IoT_SettlementDayMeter m in meters) { result = sp.SetSettlementDay(settlementDay, m); } return(result); }
/// <summary> /// 设置上传周期(通讯层) /// </summary> /// <param name="info"></param> /// <param name="meterList"></param> /// <returns></returns> public string SetUploadCycle(IoT_SetUploadCycle info, List <IoT_UploadCycleMeter> meterList) { string result = ""; M_SetParameterService sp = new M_SetParameterService(); foreach (IoT_UploadCycleMeter m in meterList) { result = sp.SetUploadCycle(info, m); } return(result); }
/// <summary> /// 添加报警参数设置任务 /// </summary> /// <param name="info"></param> /// <param name="meterList"></param> /// <returns></returns> public string SetWarinningPararmeter(IoT_SetAlarm info, List <IoT_AlarmMeter> meterList) { string result = ""; M_SetParameterService sp = new M_SetParameterService(); foreach (IoT_AlarmMeter alarm in meterList) { result = sp.SetWariningParameter(info, alarm); } return(result); }
/// <summary> /// 撤销调价计划 /// </summary> /// <param name="info"></param> /// <param name="meterList"></param> /// <returns></returns> public Message UnSetParamter(IoT_Pricing info) { // 定义执行结果 Message m; string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"]; //Linq to SQL 上下文对象 DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString); try { Table <IoT_PricingMeter> tbl_meter = dd.GetTable <IoT_PricingMeter>(); List <IoT_PricingMeter> list = tbl_meter.Where(p => p.ID == info.ID && p.State == '0').ToList(); M_SetParameterService ps = new M_SetParameterService(); foreach (IoT_PricingMeter meter in list) { string result = new SetMeterParameter().UnSetParamter(meter.TaskID); meter.State = '2'; meter.FinishedDate = DateTime.Now; ps.UnSetParameter(meter.TaskID); } if (list.Count > 0) { Table <IoT_Pricing> tbl = dd.GetTable <IoT_Pricing>(); var dbinfo = tbl.Where(p => p.CompanyID == info.CompanyID && p.ID == info.ID).Single(); dbinfo.State = '1'; //任务撤销 dbinfo.Context = info.Context; //撤销原因 dd.SubmitChanges(); m = new Message() { Result = true, TxtMessage = "操作成功" }; } else { m = new Message() { Result = false, TxtMessage = "调价计划已执行完成。" }; } } catch (Exception e) { m = new Message() { Result = false, TxtMessage = "撤销设置报警参数失败!" + e.Message }; } return(m); }
public Message revoke(string ID, string CompanyID) { // 定义执行结果 Message m; string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"]; //Linq to SQL 上下文对象 DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString); try { M_SetParameterService ps = new M_SetParameterService(); //更新主表 IoT_SetSettlementDay dbinfo = dd.GetTable <IoT_SetSettlementDay>().Where(p => p.CompanyID == CompanyID && p.ID == int.Parse(ID.Trim())).SingleOrDefault(); dbinfo.State = '1'; ps.UnSetParameter(dbinfo.TaskID); List <IoT_SettlementDayMeter> LstdbinfoMeter = dd.GetTable <IoT_SettlementDayMeter>().Where(p => p.ID == int.Parse(ID.Trim())).ToList(); foreach (var item in LstdbinfoMeter) { item.State = '1'; ps.UnSetParameter(item.TaskID); } dd.SubmitChanges(); // 更新操作 m = new Message() { Result = true, TxtMessage = JSon.TToJson <IoT_SetSettlementDay>(dbinfo) }; } catch (Exception e) { m = new Message() { Result = false, TxtMessage = "编辑设置结算日失败!" + e.Message }; } return(m); }
/// <summary> /// 撤销参数设置 /// </summary> /// <param name="taskID"></param> /// <returns></returns> public string UnSetParamter(string taskID) { M_SetParameterService sp = new M_SetParameterService(); return(sp.UnSetParameter(taskID)); }