/// <summary> /// 增加设备数据 /// </summary> public bool Add(EccmPlanDeviceModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" insert into eccm_plan_device(plan_id, equCode, community_id) values "); foreach (string s in model.equCode.Split(',')) { strSql.Append("(" + model.plan_id + ",'" + s + "'," + model.community_id + "),"); } int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString().Substring(0, strSql.Length - 1)); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加计划 /// </summary> /// <param name="context"></param> /// <returns></returns> private string AddPlan(HttpContext context) { var jr = new JsonResultModel <int>() { IsSucceed = false, Data = 0, Msg = "添加失败", RedirectUrl = string.Empty }; #region 递参数处理为对象 //获取传递参数 string plancycle = context.Request.Params["plancycle"]; string planrole = context.Request.Params["planrole"]; string executionfrequency = context.Request.Params["executionfrequency"]; string term_day = context.Request.Params["term_day"]; string planstime = context.Request.Params["planstime"]; string planetime = context.Request.Params["planetime"]; string communityID = context.Request.Params["communityID"]; string planstats = context.Request.Params["planstats"]; string choosetype = context.Request.Params["choosetype"]; string plantype = context.Request.Params["plantype"]; string Codes = context.Request.Params["Codes"]; EccmPlanModel model = new EccmPlanModel(); model.plan_cycle = int.Parse(plancycle); model.plan_role = planrole; model.execution_frequency = int.Parse(executionfrequency); model.term_day = int.Parse(term_day); model.plan_stime = DateTime.Parse(planstime); if (planetime != "") { model.plan_etime = DateTime.Parse(planetime); } model.communityID = int.Parse(communityID); model.plan_stats = int.Parse(planstats); model.choose_type = int.Parse(choosetype); model.plan_type = int.Parse(plantype); model.plan_creat_time = DateTime.Now; model.is_delete = 0; #endregion HttpCookie cook = HttpContext.Current.Request.Cookies["EccmUserinfo"]; if (cook != null) { //解密Cookie HttpCookie decodeCookie = HttpSecureCookie.Decode(cook); string uid = decodeCookie.Values["userid"]; //给对象赋值 model.uid = int.Parse(uid); } EccmPlanBLL bll = new EccmPlanBLL(); int id = bll.Add(model); //添加计划并获取id if (id > 0) //添加计划成功 { if (model.choose_type == 0) //设备类型 { EccmPlanDevicetypeModel pdt_model = new EccmPlanDevicetypeModel(); pdt_model.community_id = model.communityID; pdt_model.plan_id = id; pdt_model.system_type_code = Codes; EccmPlanDevicetypeBLL pdt_bll = new EccmPlanDevicetypeBLL(); if (pdt_bll.Add(pdt_model)) { jr.IsSucceed = true; jr.Msg = "添加成功"; } } else if (model.choose_type == 1)//设备 { EccmPlanDeviceModel pd_model = new EccmPlanDeviceModel(); pd_model.community_id = model.communityID; pd_model.plan_id = id; pd_model.equCode = Codes; EccmPlanDeviceBLL pd_bll = new EccmPlanDeviceBLL(); if (pd_bll.Add(pd_model)) { jr.IsSucceed = true; jr.Msg = "添加成功"; } } } return(JsonConvert.SerializeObject(jr)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EccmPlanDeviceModel model) { return(dal.Add(model)); }