private void DeleteInputTag(HttpContext context) { HttpRequest Request = context.Request; HttpResponse Response = context.Response; Msg msg; try { InputTagEntity InputTag = new InputTagEntity { InputID = Request.Params["InputID"], InputCode = Request.Params["InputCode"], InputDesc = Request.Params["InputDesc"], InputEngunit = Request.Params["InputEngunit"] }; m_DataAccess.DeleteInputTag(InputTag); msg = new Msg { Status = "ok", Message = "数据删除成功!" }; } catch (Exception ex) { msg = new Msg { Status = "error", Message = "数据删除失败!错误信息:" + ex.Message, StackTrace = ex.StackTrace }; } Response.Write(JsonConvert.SerializeObject(msg)); }
///// <summary> ///// 通过主键得到实体对象 ///// </summary> ///// <param name="MainID">主键</param> ///// <param name="SetSnapShot">是否设置测点实时值</param> ///// <returns></returns> //public static string GetTagID(string TagName, string UnitID) //{ // KPI_InputTagEntity entity = new KPI_InputTagEntity(); // string sql = "select * from KPI_InputTag where TagName='{0}'"; // sql = string.Format(sql, TagName); // if (UnitID != "") // { // sql += " and UnitID='" + UnitID + "' "; // } // DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0]; // if (dt.Rows.Count > 0) // entity.DrToMember(dt.Rows[0]); // return entity.TagID; //} /// <summary> /// 通过主键得到实体对象 /// </summary> /// <param name="MainID">主键</param> /// <param name="SetSnapShot">是否设置测点实时值</param> /// <returns></returns> public static InputTagEntity GetEntity(string InputID) { InputTagEntity entity = new InputTagEntity(); string sql = "select * from KPI_InputTag where InputID='{0}'"; sql = string.Format(sql, InputID); DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0]; if (dt.Rows.Count > 0) { entity.DrToMember(dt.Rows[0]); } return(entity); }
///////////////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// 获得与主键对应的实体对象 /// </summary> /// <returns></returns> public static List <InputTagEntity> GetAllEntity() { List <InputTagEntity> ltInputs = new List <InputTagEntity>(); string sql = "select * from KPI_InputTag"; DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0]; foreach (DataRow dr in dt.Rows) { InputTagEntity entity = new InputTagEntity(); entity.DrToMember(dr); ltInputs.Add(entity); } return(ltInputs); }
private void SaveInputTag(HttpContext context) { HttpRequest Request = context.Request; HttpResponse Response = context.Response; Msg msg; try { InputTagEntity InputTag = new InputTagEntity { InputID = Request.Params["InputID"], InputCode = Request.Params["InputCode"], InputDesc = Request.Params["InputDesc"], InputEngunit = Request.Params["InputEngunit"], InputIndex = String.IsNullOrWhiteSpace(Request.Params["InputIndex"]) ? 1 : Convert.ToInt32(Request.Params["InputIndex"]), InputType = String.IsNullOrWhiteSpace(Request.Params["InputType"]) ? 1 : Convert.ToInt32(Request.Params["InputType"]) }; bool Successed = m_DataAccess.SaveInputTag(InputTag) > 0; msg = new Msg { Status = "ok", Message = "数据保存成功!" }; if (!Successed) { msg = new Msg { Status = "error", Message = "数据保存失败!" }; } } catch (Exception ex) { msg = new Msg { Status = "error", Message = "数据保存失败!错误信息:" + ex.Message, StackTrace = ex.StackTrace }; } Response.Write(JsonConvert.SerializeObject(msg)); }