/// <summary> /// 添加巡检实施 /// </summary> /// <param name="context"></param> /// <returns></returns> private string AddInspectionImplement(HttpContext context) { var jr = new JsonResultModel <int>() { IsSucceed = false, Data = 0, Msg = "添加失败", RedirectUrl = string.Empty }; //获取传递参数 string orderid = context.Request.Params["orderid"]; string ordersn = context.Request.Params["ordersn"]; string content = context.Request.Params["content"]; HttpCookie cook = HttpContext.Current.Request.Cookies["EccmUserinfo"]; if (cook != null) { //解密Cookie HttpCookie decodeCookie = HttpSecureCookie.Decode(cook); string uid = decodeCookie.Values["userid"]; string imgurl = context.Request.Params["imgurl"]; string type = context.Request.Params["type"];//1巡检2维保3维修 //给对象赋值 EccmInspectionOrderImplementModel model = new EccmInspectionOrderImplementModel(); model.order_id = int.Parse(orderid); model.equCode = "";//该处没有设备编码 model.implement_content = content; model.implement_time = DateTime.Now; model.uid_handle = int.Parse(uid); EccmInspectionOrderImplementBLL bll = new EccmInspectionOrderImplementBLL(); int id = bll.Add(model); //插入并获取id if (id > 0) //实施内容插入成功 { EccmImplementImgModel img_model = new EccmImplementImgModel(); img_model.implement_id = id; img_model.img_path = imgurl; img_model.img_type = int.Parse(type);; //1巡检2维保3维修 EccmImplementImgBLL img_bll = new EccmImplementImgBLL(); if (img_bll.Add(img_model)) //插入实施图片 { EccmInspectionOrderModel inspection_model = new EccmInspectionOrderModel(); inspection_model.order_id = int.Parse(orderid); inspection_model.order_stats = 4;//0未派单1已派单2已接单3处理中4完成 inspection_model.order_finish_time = DateTime.Now; EccmInspectionOrderBLL inspection_bll = new EccmInspectionOrderBLL(); inspection_bll.UpdateStates(inspection_model);//更改订单为完成 jr.IsSucceed = true; jr.Msg = "添加成功"; } } } return(JsonConvert.SerializeObject(jr)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EccmImplementImgModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" insert into eccm_implement_img(implement_id, img_path, img_type) values "); foreach (string s in model.img_path.Split(',')) { strSql.Append("(" + model.implement_id + ",'" + s + "'," + model.img_type + "),"); } int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString().Substring(0, strSql.Length - 1)); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EccmImplementImgModel model) { return(dal.Add(model)); }