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