public void DealStartTime(string tokenId, string id, string time) { HttpContext.Current.Response.ContentType = "application/json;charset=utf-8"; var jsonCallBackFunName = HttpContext.Current.Request.Params["jsoncallback"]; Dugufeixue.Common.SystemConfig.ConnectionStringKey = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStringDes"].ToString(); //判断TokenId是否合法 if (Common.VerifyTokenId(tokenId)) { time = Convert.ToDateTime(time).ToString("yyyy-MM-dd 12:00:00"); //查询接班人 MySqlCommand sqlcom = new MySqlCommand { CommandText = "UPDATE ep_maintain SET maintain_date = now(),expect_finish_date=@time, maintain_status = 2 where maintain_id =@id" }; MySqlParameter[] commandParameters = new MySqlParameter[] { new MySqlParameter("@id", id), new MySqlParameter("@time", time), }; MySqlCommand sqlcom2 = new MySqlCommand { CommandText = "UPDATE ep_equipment_component SET status = 5 WHERE equipment_component_id IN (SELECT relation_equipment_component_id FROM ep_maintain_relation WHERE maintain_id =@id)" }; MySqlParameter[] commandParameters2 = new MySqlParameter[] { new MySqlParameter("@id", id) }; try { var Info = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sqlcom.CommandText, commandParameters); var Info2 = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sqlcom2.CommandText, commandParameters2); if (Info == 1 && Info2 >= 1) //信息存在 { // var json = Common.DataTableToJson(Info.Table); //信息的Json形式 HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(1, "处理成功")); tbl_ep_maintain tbl = BF <bll_ep_maintain> .Instance.GetModel(id); sendAllCenterPerson("接收到一条设置预期完成时间消息", "设置预期完成时间提醒:现场【" + tbl.scene_name + "】的设备【" + tbl.equipment_name + "】的部件【" + tbl.maintain_component_name + "】的保养人员设置了预期完成的时间!", "管理员保养提醒", id, tbl.scene_id, tbl.scene_name, tbl.equipment_id, tbl.equipment_name, tbl.maintain_equipment_component_id, tbl.maintain_component_name); return; } else //不存在或已删除 { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "处理失败")); return; } } catch (Exception e) { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "系统异常")); DLog.w("系统异常:" + e.Message); return; } } else//TokenId过期 { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "TokenId过期")); return; } }
public void DealMaintainInfo(string tokenId, string equi, string solu, string id) { HttpContext.Current.Response.ContentType = "application/json;charset=utf-8"; var jsonCallBackFunName = HttpContext.Current.Request.Params["jsoncallback"]; Dugufeixue.Common.SystemConfig.ConnectionStringKey = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStringDes"].ToString(); //判断TokenId是否合法 if (Common.VerifyTokenId(tokenId)) { //查询接班人 MySqlCommand sqlcom = new MySqlCommand { CommandText = "UPDATE ep_maintain SET solution = @solution,maintain_date = NOW(),maintain_status = 2 where maintain_id =@id" }; MySqlParameter[] commandParameters = new MySqlParameter[] { new MySqlParameter("@id", id), new MySqlParameter("@solution", solu) }; MySqlCommand sqlcom2 = new MySqlCommand { CommandText = "INSERT INTO ep_maintain_relation (maintain_relation_id,maintain_id,relation_equipment_component_id) VALUES( UUID(), @maintain_id , @relation_equipment_component_id)" }; MySqlCommand sqlcom3 = new MySqlCommand { CommandText = "UPDATE ep_equipment_component SET status = 6 WHERE equipment_component_id =@equipment_component_id" }; string[] sArray = equi.Split(','); for (var i = 0; i < sArray.Length - 1; i++) { MySqlParameter[] commandParameters2 = new MySqlParameter[] { // 循环插入数据 new MySqlParameter("@maintain_id", id), new MySqlParameter("@relation_equipment_component_id", sArray[i]) }; MySqlParameter[] commandParameters3 = new MySqlParameter[] { // 循环插入数据 new MySqlParameter("@equipment_component_id", sArray[i]) }; try { var Info2 = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sqlcom2.CommandText, commandParameters2); var Info3 = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sqlcom3.CommandText, commandParameters3); if (Info2 != 1 || Info3 != 1) { return; } tbl_ep_maintain maintain = BF <bll_ep_maintain> .Instance.GetModel(id); sendAllCenterPerson("接收到一条提交保养单消息", "提交保养单提醒:现场【" + maintain.scene_name + "】的设备【" + maintain.equipment_name + "】的部件【" + maintain.maintain_component_name + "】的保养人员提交了保养单!", "管理员保养提醒", id, maintain.scene_id, maintain.scene_name, maintain.equipment_id, maintain.equipment_name, maintain.maintain_equipment_component_id, maintain.maintain_component_name); } catch (Exception e) { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "系统异常")); DLog.w("系统异常:" + e.Message); return; } } try { var Info = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sqlcom.CommandText, commandParameters); if (Info == 1) //信息存在 { // var json = Common.DataTableToJson(Info.Table); //信息的Json形式 HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(1, "处理成功")); return; } else //不存在或已删除 { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "处理失败")); return; } } catch (Exception e) { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "系统异常")); DLog.w("系统异常:" + e.Message); return; } } else//TokenId过期 { HttpContext.Current.Response.Write(jsonCallBackFunName + Common.GetResultJson(0, "TokenId过期")); return; } }