您好,欢迎访问一九零五行业门户网

二维报表数据表设计

报表原型: 这里随便挑了一个二维报表 二维报表设计分析: 上面的报表原型行和列都有数据项,我们可以根据地理位置的经纬度定坐标点的思想来进行设计 这里使用列行来表示 c1r1表示第一列第一行 c1r2表示第一列第二行 ..... c2r1表示第二列第一行 c2r2表示第二
报表原型:
这里随便挑了一个二维报表
二维报表设计分析:
上面的报表原型行和列都有数据项,我们可以根据地理位置的经纬度定坐标点的思想来进行设计
这里使用列行来表示
c1r1表示第一列第一行
c1r2表示第一列第二行
.....
c2r1表示第二列第一行
c2r2表示第二列第二行
......
以此类推
报表bean信息
/** *@author xiaoqun.yi *选矿技术经济指标报表 *r:报表 *r:行 可扩展 *c:列 可扩展 *r*c====指标值项数即相当于数据库中的迪卡尔积 */public class rxkjsjjzbbean { private int id;//主键 private int report_id;//报表id,外键 /*统计日期指标*/ private string year;//年 yyyy length:4 private string month;//月mm 如果是月报,必用此字段 length:2 private string day;//如果是日报,必用此字段dd length:2 private string yearmonth;//yyyymm,月报查询条件用 lenght:6 /*计算所有数据项的总和,若有需要可使用*/ private float sum; /*计算每列的数值和,不作为数据表字段*/ private float c1_sum;//c1r1-c1r19之和 private float c2_sum;//c2r1-c2r19之和 private float c3_sum;//c3r1-c3r19之和 private float c4_sum;//c4r1-c4r19之和 private float c5_sum;//c5r1-c5r19之和 /*计算每行的数值和,不作为数据表字段*/ private float r1_sum;//r1c1-r1c5之和,其下以此类推 private float r2_sum; private float r3_sum; private float r4_sum; private float r5_sum; private float r6_sum; private float r7_sum; private float r8_sum; private float r9_sum; private float r10_sum; private float r11_sum; private float r12_sum; private float r13_sum; private float r14_sum; private float r15_sum; private float r16_sum; private float r17_sum; private float r18_sum; private float r19_sum; /*第1列1-n行*/ private float c1r1; private float c1r2; private float c1r3; private float c1r4; private float c1r5; private float c1r6; private float c1r7; private float c1r8; private float c1r9; private float c1r10; private float c1r11; private float c1r12; private float c1r13; private float c1r14; private float c1r15; private float c1r16; private float c1r17; private float c1r18; private float c1r19; /*第2列1-n行*/ private float c2r1; private float c2r2; private float c2r3; private float c2r4; private float c2r5; private float c2r6; private float c2r7; private float c2r8; private float c2r9; private float c2r10; private float c2r11; private float c2r12; private float c2r13; private float c2r14; private float c2r15; private float c2r16; private float c2r17; private float c2r18; private float c2r19; /*第3列1-n行*/ private float c3r1; private float c3r2; private float c3r3; private float c3r4; private float c3r5; private float c3r6; private float c3r7; private float c3r8; private float c3r9; private float c3r10; private float c3r11; private float c3r12; private float c3r13; private float c3r14; private float c3r15; private float c3r16; private float c3r17; private float c3r18; private float c3r19; /*第4列1-n行*/ private float c4r1; private float c4r2; private float c4r3; private float c4r4; private float c4r5; private float c4r6; private float c4r7; private float c4r8; private float c4r9; private float c4r10; private float c4r11; private float c4r12; private float c4r13; private float c4r14; private float c4r15; private float c4r16; private float c4r17; private float c4r18; private float c4r19; /*第5列1-n行*/ private float c5r1; private float c5r2; private float c5r3; private float c5r4; private float c5r5; private float c5r6; private float c5r7; private float c5r8; private float c5r9; private float c5r10; private float c5r11; private float c5r12; private float c5r13; private float c5r14; private float c5r15; private float c5r16; private float c5r17; private float c5r18; private float c5r19; public int getid() { return id; } public void setid(int id) { this.id = id; } public string getyear() { return year; } public void setyear(string year) { this.year = year; } public string getmonth() { return month; } public void setmonth(string month) { this.month = month; } public string getday() { return day; } public void setday(string day) { this.day = day; } public string getyearmonth() { return yearmonth; } public void setyearmonth(string yearmonth) { this.yearmonth = yearmonth; } public int getreport_id() { return report_id; } public void setreport_id(int report_id) { this.report_id = report_id; } public float getsum() { return sum; } public void setsum(float sum) { this.sum = sum; } public float getr1_sum() { return r1_sum; } public void setr1_sum(float r1_sum) { this.r1_sum = r1_sum; } public float getr2_sum() { return r2_sum; } public void setr2_sum(float r2_sum) { this.r2_sum = r2_sum; } public float getr3_sum() { return r3_sum; } public void setr3_sum(float r3_sum) { this.r3_sum = r3_sum; } public float getr4_sum() { return r4_sum; } public void setr4_sum(float r4_sum) { this.r4_sum = r4_sum; } public float getr5_sum() { return r5_sum; } public void setr5_sum(float r5_sum) { this.r5_sum = r5_sum; } public float getr6_sum() { return r6_sum; } public void setr6_sum(float r6_sum) { this.r6_sum = r6_sum; } public float getr7_sum() { return r7_sum; } public void setr7_sum(float r7_sum) { this.r7_sum = r7_sum; } public float getr8_sum() { return r8_sum; } public void setr8_sum(float r8_sum) { this.r8_sum = r8_sum; } public float getr9_sum() { return r9_sum; } public void setr9_sum(float r9_sum) { this.r9_sum = r9_sum; } public float getr10_sum() { return r10_sum; } public void setr10_sum(float r10_sum) { this.r10_sum = r10_sum; } public float getr11_sum() { return r11_sum; } public void setr11_sum(float r11_sum) { this.r11_sum = r11_sum; } public float getr12_sum() { return r12_sum; } public void setr12_sum(float r12_sum) { this.r12_sum = r12_sum; } public float getr13_sum() { return r13_sum; } public void setr13_sum(float r13_sum) { this.r13_sum = r13_sum; } public float getr14_sum() { return r14_sum; } public void setr14_sum(float r14_sum) { this.r14_sum = r14_sum; } public float getr15_sum() { return r15_sum; } public void setr15_sum(float r15_sum) { this.r15_sum = r15_sum; } public float getr16_sum() { return r16_sum; } public void setr16_sum(float r16_sum) { this.r16_sum = r16_sum; } public float getr17_sum() { return r17_sum; } public void setr17_sum(float r17_sum) { this.r17_sum = r17_sum; } public float getr18_sum() { return r18_sum; } public void setr18_sum(float r18_sum) { this.r18_sum = r18_sum; } public float getr19_sum() { return r19_sum; } public void setr19_sum(float r19_sum) { this.r19_sum = r19_sum; } public float getc1_sum() { return c1_sum; } public void setc1_sum(float c1_sum) { this.c1_sum = c1_sum; } public float getc2_sum() { return c2_sum; } public void setc2_sum(float c2_sum) { this.c2_sum = c2_sum; } public float getc3_sum() { return c3_sum; } public void setc3_sum(float c3_sum) { this.c3_sum = c3_sum; } public float getc4_sum() { return c4_sum; } public void setc4_sum(float c4_sum) { this.c4_sum = c4_sum; } public float getc5_sum() { return c5_sum; } public void setc5_sum(float c5_sum) { this.c5_sum = c5_sum; } public float getc1r1() { return c1r1; } public void setc1r1(float c1r1) { this.c1r1 = c1r1; } public float getc1r2() { return c1r2; } public void setc1r2(float c1r2) { this.c1r2 = c1r2; } public float getc1r3() { return c1r3; } public void setc1r3(float c1r3) { this.c1r3 = c1r3; } public float getc1r4() { return c1r4; } public void setc1r4(float c1r4) { this.c1r4 = c1r4; } public float getc1r5() { return c1r5; } public void setc1r5(float c1r5) { this.c1r5 = c1r5; } public float getc1r6() { return c1r6; } public void setc1r6(float c1r6) { this.c1r6 = c1r6; } public float getc1r7() { return c1r7; } public void setc1r7(float c1r7) { this.c1r7 = c1r7; } public float getc1r8() { return c1r8; } public void setc1r8(float c1r8) { this.c1r8 = c1r8; } public float getc1r9() { return c1r9; } public void setc1r9(float c1r9) { this.c1r9 = c1r9; } public float getc1r10() { return c1r10; } public void setc1r10(float c1r10) { this.c1r10 = c1r10; } public float getc1r11() { return c1r11; } public void setc1r11(float c1r11) { this.c1r11 = c1r11; } public float getc1r12() { return c1r12; } public void setc1r12(float c1r12) { this.c1r12 = c1r12; } public float getc1r13() { return c1r13; } public void setc1r13(float c1r13) { this.c1r13 = c1r13; } public float getc1r14() { return c1r14; } public void setc1r14(float c1r14) { this.c1r14 = c1r14; } public float getc1r15() { return c1r15; } public void setc1r15(float c1r15) { this.c1r15 = c1r15; } public float getc1r16() { return c1r16; } public void setc1r16(float c1r16) { this.c1r16 = c1r16; } public float getc1r17() { return c1r17; } public void setc1r17(float c1r17) { this.c1r17 = c1r17; } public float getc1r18() { return c1r18; } public void setc1r18(float c1r18) { this.c1r18 = c1r18; } public float getc1r19() { return c1r19; } public void setc1r19(float c1r19) { this.c1r19 = c1r19; } public float getc2r1() { return c2r1; } public void setc2r1(float c2r1) { this.c2r1 = c2r1; } public float getc2r2() { return c2r2; } public void setc2r2(float c2r2) { this.c2r2 = c2r2; } public float getc2r3() { return c2r3; } public void setc2r3(float c2r3) { this.c2r3 = c2r3; } public float getc2r4() { return c2r4; } public void setc2r4(float c2r4) { this.c2r4 = c2r4; } public float getc2r5() { return c2r5; } public void setc2r5(float c2r5) { this.c2r5 = c2r5; } public float getc2r6() { return c2r6; } public void setc2r6(float c2r6) { this.c2r6 = c2r6; } public float getc2r7() { return c2r7; } public void setc2r7(float c2r7) { this.c2r7 = c2r7; } public float getc2r8() { return c2r8; } public void setc2r8(float c2r8) { this.c2r8 = c2r8; } public float getc2r9() { return c2r9; } public void setc2r9(float c2r9) { this.c2r9 = c2r9; } public float getc2r10() { return c2r10; } public void setc2r10(float c2r10) { this.c2r10 = c2r10; } public float getc2r11() { return c2r11; } public void setc2r11(float c2r11) { this.c2r11 = c2r11; } public float getc2r12() { return c2r12; } public void setc2r12(float c2r12) { this.c2r12 = c2r12; } public float getc2r13() { return c2r13; } public void setc2r13(float c2r13) { this.c2r13 = c2r13; } public float getc2r14() { return c2r14; } public void setc2r14(float c2r14) { this.c2r14 = c2r14; } public float getc2r15() { return c2r15; } public void setc2r15(float c2r15) { this.c2r15 = c2r15; } public float getc2r16() { return c2r16; } public void setc2r16(float c2r16) { this.c2r16 = c2r16; } public float getc2r17() { return c2r17; } public void setc2r17(float c2r17) { this.c2r17 = c2r17; } public float getc2r18() { return c2r18; } public void setc2r18(float c2r18) { this.c2r18 = c2r18; } public float getc2r19() { return c2r19; } public void setc2r19(float c2r19) { this.c2r19 = c2r19; } public float getc3r1() { return c3r1; } public void setc3r1(float c3r1) { this.c3r1 = c3r1; } public float getc3r2() { return c3r2; } public void setc3r2(float c3r2) { this.c3r2 = c3r2; } public float getc3r3() { return c3r3; } public void setc3r3(float c3r3) { this.c3r3 = c3r3; } public float getc3r4() { return c3r4; } public void setc3r4(float c3r4) { this.c3r4 = c3r4; } public float getc3r5() { return c3r5; } public void setc3r5(float c3r5) { this.c3r5 = c3r5; } public float getc3r6() { return c3r6; } public void setc3r6(float c3r6) { this.c3r6 = c3r6; } public float getc3r7() { return c3r7; } public void setc3r7(float c3r7) { this.c3r7 = c3r7; } public float getc3r8() { return c3r8; } public void setc3r8(float c3r8) { this.c3r8 = c3r8; } public float getc3r9() { return c3r9; } public void setc3r9(float c3r9) { this.c3r9 = c3r9; } public float getc3r10() { return c3r10; } public void setc3r10(float c3r10) { this.c3r10 = c3r10; } public float getc3r11() { return c3r11; } public void setc3r11(float c3r11) { this.c3r11 = c3r11; } public float getc3r12() { return c3r12; } public void setc3r12(float c3r12) { this.c3r12 = c3r12; } public float getc3r13() { return c3r13; } public void setc3r13(float c3r13) { this.c3r13 = c3r13; } public float getc3r14() { return c3r14; } public void setc3r14(float c3r14) { this.c3r14 = c3r14; } public float getc3r15() { return c3r15; } public void setc3r15(float c3r15) { this.c3r15 = c3r15; } public float getc3r16() { return c3r16; } public void setc3r16(float c3r16) { this.c3r16 = c3r16; } public float getc3r17() { return c3r17; } public void setc3r17(float c3r17) { this.c3r17 = c3r17; } public float getc3r18() { return c3r18; } public void setc3r18(float c3r18) { this.c3r18 = c3r18; } public float getc3r19() { return c3r19; } public void setc3r19(float c3r19) { this.c3r19 = c3r19; } public float getc4r1() { return c4r1; } public void setc4r1(float c4r1) { this.c4r1 = c4r1; } public float getc4r2() { return c4r2; } public void setc4r2(float c4r2) { this.c4r2 = c4r2; } public float getc4r3() { return c4r3; } public void setc4r3(float c4r3) { this.c4r3 = c4r3; } public float getc4r4() { return c4r4; } public void setc4r4(float c4r4) { this.c4r4 = c4r4; } public float getc4r5() { return c4r5; } public void setc4r5(float c4r5) { this.c4r5 = c4r5; } public float getc4r6() { return c4r6; } public void setc4r6(float c4r6) { this.c4r6 = c4r6; } public float getc4r7() { return c4r7; } public void setc4r7(float c4r7) { this.c4r7 = c4r7; } public float getc4r8() { return c4r8; } public void setc4r8(float c4r8) { this.c4r8 = c4r8; } public float getc4r9() { return c4r9; } public void setc4r9(float c4r9) { this.c4r9 = c4r9; } public float getc4r10() { return c4r10; } public void setc4r10(float c4r10) { this.c4r10 = c4r10; } public float getc4r11() { return c4r11; } public void setc4r11(float c4r11) { this.c4r11 = c4r11; } public float getc4r12() { return c4r12; } public void setc4r12(float c4r12) { this.c4r12 = c4r12; } public float getc4r13() { return c4r13; } public void setc4r13(float c4r13) { this.c4r13 = c4r13; } public float getc4r14() { return c4r14; } public void setc4r14(float c4r14) { this.c4r14 = c4r14; } public float getc4r15() { return c4r15; } public void setc4r15(float c4r15) { this.c4r15 = c4r15; } public float getc4r16() { return c4r16; } public void setc4r16(float c4r16) { this.c4r16 = c4r16; } public float getc4r17() { return c4r17; } public void setc4r17(float c4r17) { this.c4r17 = c4r17; } public float getc4r18() { return c4r18; } public void setc4r18(float c4r18) { this.c4r18 = c4r18; } public float getc4r19() { return c4r19; } public void setc4r19(float c4r19) { this.c4r19 = c4r19; } public float getc5r1() { return c5r1; } public void setc5r1(float c5r1) { this.c5r1 = c5r1; } public float getc5r2() { return c5r2; } public void setc5r2(float c5r2) { this.c5r2 = c5r2; } public float getc5r3() { return c5r3; } public void setc5r3(float c5r3) { this.c5r3 = c5r3; } public float getc5r4() { return c5r4; } public void setc5r4(float c5r4) { this.c5r4 = c5r4; } public float getc5r5() { return c5r5; } public void setc5r5(float c5r5) { this.c5r5 = c5r5; } public float getc5r6() { return c5r6; } public void setc5r6(float c5r6) { this.c5r6 = c5r6; } public float getc5r7() { return c5r7; } public void setc5r7(float c5r7) { this.c5r7 = c5r7; } public float getc5r8() { return c5r8; } public void setc5r8(float c5r8) { this.c5r8 = c5r8; } public float getc5r9() { return c5r9; } public void setc5r9(float c5r9) { this.c5r9 = c5r9; } public float getc5r10() { return c5r10; } public void setc5r10(float c5r10) { this.c5r10 = c5r10; } public float getc5r11() { return c5r11; } public void setc5r11(float c5r11) { this.c5r11 = c5r11; } public float getc5r12() { return c5r12; } public void setc5r12(float c5r12) { this.c5r12 = c5r12; } public float getc5r13() { return c5r13; } public void setc5r13(float c5r13) { this.c5r13 = c5r13; } public float getc5r14() { return c5r14; } public void setc5r14(float c5r14) { this.c5r14 = c5r14; } public float getc5r15() { return c5r15; } public void setc5r15(float c5r15) { this.c5r15 = c5r15; } public float getc5r16() { return c5r16; } public void setc5r16(float c5r16) { this.c5r16 = c5r16; } public float getc5r17() { return c5r17; } public void setc5r17(float c5r17) { this.c5r17 = c5r17; } public float getc5r18() { return c5r18; } public void setc5r18(float c5r18) { this.c5r18 = c5r18; } public float getc5r19() { return c5r19; } public void setc5r19(float c5r19) { this.c5r19 = c5r19; } }
其它类似信息

推荐信息