public override void Encode() { encodeBuf.Clear(); encodeBuf.AddRange(AddString(NoteId, 13)); encodeBuf.AddRange(AddString(LineId, 2)); encodeBuf.AddRange(AddString(StationId, 4)); encodeBuf.AddRange(AddString(OperateTime, 14)); encodeBuf.AddRange(AddString(TicketType, 4)); encodeBuf.AddRange(AddString(BeginNumber.PadLeft(8, '0'), 8)); encodeBuf.AddRange(AddString(EndNumber.PadLeft(8, '0'), 8)); encodeBuf.AddRange(AddString(Unit.PadLeft(8, '0'), 8)); }
/// <summary> /// 分页查询返回DATASET /// </summary> /// <param name="TableName">需要查询的表名</param> /// <param name="Fields">需要返回的列(所以列*)</param> /// <param name="PageSize">页容量(每页显示页的数量)</param> /// <param name="PageIndex">当前页</param> /// <param name="Where">查询条件(Id=Id)</param> /// <param name="OrderBy">排序(ID desc)</param> /// <returns></returns> public static DataSet Table_List(string TableName, string OrderBy, string Fields, int PageSize, int PageIndex, string Where) { SqlParameter[] parameters = { new SqlParameter("@TableName", SqlDbType.VarChar, 20), new SqlParameter("@Fields", SqlDbType.VarChar, 500), new SqlParameter("@Where", SqlDbType.VarChar, 500), new SqlParameter("@OrderBy", SqlDbType.VarChar, 200), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int) }; parameters[0].Value = TableName; parameters[1].Value = Fields; parameters[2].Value = Common.LCommon.ClearSql(Where); parameters[3].Value = OrderBy; parameters[4].Value = PageSize; parameters[5].Value = PageIndex; //return DbHelperSQL.RunProcedure("Table_List", parameters, "ds"); //不调用存储过程直接执行查询语句 string Row = ""; string TableWhere = parameters[0].SqlValue.ToString(); int StartNumber; int EndNumber; if (!String.IsNullOrEmpty(parameters[2].SqlValue.ToString())) { TableWhere = parameters[0].SqlValue.ToString() + " where " + parameters[2].SqlValue.ToString(); } if (parameters[4].SqlValue.ToString() != "0") { StartNumber = (Int32.Parse(parameters[5].SqlValue.ToString()) - 1) * Int32.Parse(parameters[4].SqlValue.ToString()) + 1; EndNumber = (Int32.Parse(parameters[5].SqlValue.ToString()) - 1) * Int32.Parse(parameters[4].SqlValue.ToString()) + Int32.Parse(parameters[4].SqlValue.ToString()); Row = " where Row between " + StartNumber.ToString() + " and " + EndNumber.ToString(); } return(DbHelperSQL.Query("with temptbl AS (SELECT ROW_NUMBER() OVER (ORDER BY " + parameters[3].SqlValue.ToString() + ")AS Row, " + parameters[1].SqlValue.ToString() + " FROM " + TableWhere + ") SELECT * FROM temptbl" + Row)); }