/// <summary> /// 保存menufunctionpointdata数据集数据 /// </summary> /// <param name="menufunctionpointdata">数据集对象</param> /// <returns>返回保存后的响应信息</returns> public String SaveMenuFunctionPoint(MenuFunctionPointData menufunctionpointdata) { #region MenuFunctionPointClass menufunctionpointclass = new MenuFunctionPointClass(); return(base.Save(menufunctionpointdata, menufunctionpointclass)); #endregion }
/// <summary> /// 获取MenuFunctionPoint数据表的全部数据 /// </summary> /// <returns>Json字符串</returns> public string GetJsonByAll() { #region int totalCount = 0; MenuFunctionPointData menufunctionpointdata = this.getData(null); totalCount = menufunctionpointdata.Tables[0].Rows.Count; return(base.GetJson(menufunctionpointdata, totalCount)); #endregion }
/// <summary> /// 根据主键值检索符合该条件的记录,用于编辑和删除记录时。 /// </summary> /// <param name="functionId">主键-功能点编号</param> /// <returns></returns> private MenuFunctionPointData getData(string functionId) { #region MenuFunctionPointData menufunctionpointdata = new MenuFunctionPointData(); DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(MenuFunctionPointData.functionId, EnumSqlType.sqlint, EnumCondition.Equal, functionId); this._menufunctionpointclass.GetSingleTAllWithoutCount(menufunctionpointdata, querybusinessparams); return(menufunctionpointdata); #endregion }
/// <summary> /// 添加MenuFunctionPoint表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="menufunctionpointdata">数据集对象</param> /// <param name="menufunctionpoint">实体对象</param> public void AddRow(ref MenuFunctionPointData menufunctionpointdata, EntityMenuFunctionPoint menufunctionpoint) { #region DataRow dr = menufunctionpointdata.Tables[0].NewRow(); menufunctionpointdata.Assign(dr, MenuFunctionPointData.functionId, menufunctionpoint.functionId); menufunctionpointdata.Assign(dr, MenuFunctionPointData.menuId, menufunctionpoint.menuId); menufunctionpointdata.Assign(dr, MenuFunctionPointData.functionPointName, menufunctionpoint.functionPointName); menufunctionpointdata.Assign(dr, MenuFunctionPointData.eventName, menufunctionpoint.eventName); menufunctionpointdata.Assign(dr, MenuFunctionPointData.sort, menufunctionpoint.sort); menufunctionpointdata.Assign(dr, MenuFunctionPointData.remark, menufunctionpoint.remark); menufunctionpointdata.Assign(dr, MenuFunctionPointData.usable, menufunctionpoint.usable); menufunctionpointdata.Tables[0].Rows.Add(dr); #endregion }
/// <summary> /// 删除menufunctionpointdata数据集中指定的行数据 /// </summary> /// <param name="menufunctionpointdata">数据集对象</param> /// <param name="functionId">主键-功能点编号</param> public void DeleteRow(ref MenuFunctionPointData menufunctionpointdata, string functionId) { #region if (menufunctionpointdata.Tables[0].Rows.Count <= 0) { menufunctionpointdata = this.getData(functionId); } DataRow dr = menufunctionpointdata.Tables[0].Rows.Find(new object[1] { functionId }); if (dr != null) { dr.Delete(); } #endregion }
/// <summary> /// 编辑menufunctionpointdata数据集中指定的行数据 /// </summary> /// <param name="menufunctionpointdata">数据集对象</param> /// <param name="menufunctionpoint">实体对象</param> public void EditRow(ref MenuFunctionPointData menufunctionpointdata, EntityMenuFunctionPoint menufunctionpoint) { #region if (menufunctionpointdata.Tables[0].Rows.Count <= 0) { menufunctionpointdata = this.getData(menufunctionpoint.functionId); } DataRow dr = menufunctionpointdata.Tables[0].Rows.Find(new object[1] { menufunctionpoint.functionId }); menufunctionpointdata.Assign(dr, MenuFunctionPointData.functionId, menufunctionpoint.functionId); menufunctionpointdata.Assign(dr, MenuFunctionPointData.menuId, menufunctionpoint.menuId); menufunctionpointdata.Assign(dr, MenuFunctionPointData.functionPointName, menufunctionpoint.functionPointName); menufunctionpointdata.Assign(dr, MenuFunctionPointData.eventName, menufunctionpoint.eventName); menufunctionpointdata.Assign(dr, MenuFunctionPointData.sort, menufunctionpoint.sort); menufunctionpointdata.Assign(dr, MenuFunctionPointData.remark, menufunctionpoint.remark); menufunctionpointdata.Assign(dr, MenuFunctionPointData.usable, menufunctionpoint.usable); #endregion }
/// <summary> /// 根据条件筛选所有MenuFunctionPoint指定页码的数据(分页型) /// </summary> /// <param name="menufunctionpoint">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public DataSet GetData(EntityMenuFunctionPoint menufunctionpoint, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(MenuFunctionPointData.functionId, EnumSqlType.sqlint, EnumCondition.Equal, menufunctionpoint.functionId); querybusinessparams.Add(MenuFunctionPointData.menuId, EnumSqlType.sqlint, EnumCondition.Equal, menufunctionpoint.menuId); querybusinessparams.Add(MenuFunctionPointData.functionPointName, EnumSqlType.nvarchar, EnumCondition.Equal, menufunctionpoint.functionPointName); querybusinessparams.Add(MenuFunctionPointData.eventName, EnumSqlType.nvarchar, EnumCondition.Equal, menufunctionpoint.eventName); querybusinessparams.Add(MenuFunctionPointData.sort, EnumSqlType.sqlint, EnumCondition.Equal, menufunctionpoint.sort); querybusinessparams.Add(MenuFunctionPointData.remark, EnumSqlType.nvarchar, EnumCondition.Equal, menufunctionpoint.remark); querybusinessparams.Add(MenuFunctionPointData.usable, EnumSqlType.bit, EnumCondition.Equal, menufunctionpoint.usable); MenuFunctionPointData menufunctionpointdata = new MenuFunctionPointData(); totalCount = this._menufunctionpointclass.GetSingleT(menufunctionpointdata, querybusinessparams); return(menufunctionpointdata); #endregion }