/// <summary> /// 根据条件筛选所有CollectType指定页码的数据(分页型) /// </summary> /// <param name="collecttype">实体对象</param> /// <param name="pageparams">分页对象</param> /// <returns></returns> public string GetJsonByPage(EntityCollectType collecttype, PageParams pageparams) { #region int totalCount = 0; pageparams.PageSorts.Add(new PageSort(CollectTypeData.releaseNo, EnumSQLOrderBY.ASC)); DataSet collecttypedata = this.GetData(collecttype, pageparams, out totalCount); return(base.GetJson(collecttypedata, totalCount)); #endregion }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityCollectType collecttype) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(collecttype, queryparams, out totalcount); ExportExcelCollectType exportexcelcollecttype = new ExportExcelCollectType(filename, ds, grid); exportexcelcollecttype.Output(); #endregion }
/// <summary> /// 添加CollectType表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="collecttypedata">数据集对象</param> /// <param name="collecttype">实体对象</param> public void AddRow(ref CollectTypeData collecttypedata, EntityCollectType collecttype) { #region DataRow dr = collecttypedata.Tables[0].NewRow(); collecttypedata.Assign(dr, CollectTypeData.collectTypeId, collecttype.collectTypeId); collecttypedata.Assign(dr, CollectTypeData.releaseNo, collecttype.releaseNo); collecttypedata.Assign(dr, CollectTypeData.releaseType, collecttype.releaseType); collecttypedata.Assign(dr, CollectTypeData.releaseTime, collecttype.releaseTime); collecttypedata.Assign(dr, CollectTypeData.writeUser, collecttype.writeUser); collecttypedata.Assign(dr, CollectTypeData.writeTime, collecttype.writeTime); collecttypedata.Assign(dr, CollectTypeData.writeIp, collecttype.writeIp); collecttypedata.Tables[0].Rows.Add(dr); #endregion }
/// <summary> /// 编辑collecttypedata数据集中指定的行数据 /// </summary> /// <param name="collecttypedata">数据集对象</param> /// <param name="collecttype">实体对象</param> public void EditRow(ref CollectTypeData collecttypedata, EntityCollectType collecttype) { #region if (collecttypedata.Tables[0].Rows.Count <= 0) { collecttypedata = this.getData(collecttype.collectTypeId); } DataRow dr = collecttypedata.Tables[0].Rows.Find(new object[1] { collecttype.collectTypeId }); collecttypedata.Assign(dr, CollectTypeData.collectTypeId, collecttype.collectTypeId); collecttypedata.Assign(dr, CollectTypeData.releaseNo, collecttype.releaseNo); collecttypedata.Assign(dr, CollectTypeData.releaseType, collecttype.releaseType); collecttypedata.Assign(dr, CollectTypeData.releaseTime, collecttype.releaseTime); collecttypedata.Assign(dr, CollectTypeData.writeUser, collecttype.writeUser); collecttypedata.Assign(dr, CollectTypeData.writeTime, collecttype.writeTime); collecttypedata.Assign(dr, CollectTypeData.writeIp, collecttype.writeIp); #endregion }
/// <summary> /// 根据条件筛选所有CollectType指定页码的数据(分页型) /// </summary> /// <param name="collecttype">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public DataSet GetData(EntityCollectType collecttype, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(CollectTypeData.collectTypeId, EnumSqlType.sqlint, EnumCondition.Equal, collecttype.collectTypeId); querybusinessparams.Add(CollectTypeData.releaseNo, EnumSqlType.nvarchar, EnumCondition.Equal, collecttype.releaseNo); querybusinessparams.Add(CollectTypeData.releaseType, EnumSqlType.tinyint, EnumCondition.Equal, collecttype.releaseType); querybusinessparams.Add(CollectTypeData.releaseTime, EnumSqlType.datetime, EnumCondition.Equal, collecttype.releaseTime); querybusinessparams.Add(CollectTypeData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, collecttype.writeUser); querybusinessparams.Add(CollectTypeData.writeTime, EnumSqlType.datetime, EnumCondition.Equal, collecttype.writeTime); querybusinessparams.Add(CollectTypeData.writeIp, EnumSqlType.nvarchar, EnumCondition.Equal, collecttype.writeIp); CollectTypeData collecttypedata = new CollectTypeData(); totalCount = this._collecttypeclass.GetSingleT(collecttypedata, querybusinessparams); return(collecttypedata); #endregion }