FineUI 官方论坛

标题: 社保代理系统，可编辑表格操作 [打印本页]

作者: leetle 时间: 2013-12-16 09:48
标题: 社保代理系统，可编辑表格操作
<x:Grid ID="Grid1" ShowBorder="false" ShowHeader="false" Title="养老保险费用计算表" Width="1600px"
                              runat="server" DataKeyNames="id" AllowCellEditing="true" AutoScroll="true" AutoWidth="true">
                              <GroupColumns>
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="缴费期间" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="80px" ColumnID="begin_month" DataField="begin_month" HeaderText="开始月份"
                                                      TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtbegin_month" NoDecimal="true" NoNegative="true" MinValue="198000"
                                                            MaxValue="202200" runat="server" Required="true" ShowRedStar="true" EmptyText="199101格式">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="80px" ColumnID="end_month" DataField="end_month" TextAlign="Center"
                                                      HeaderText="结束月份">
                                                      <Editor>
                                                         <x:NumberBox ID="txtend_month" NoDecimal="true" NoNegative="true" MinValue="198000"
                                                            MaxValue="202200" runat="server" Required="true" ShowRedStar="true" EmptyText="199101格式">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="80px" ColumnID="year" DataField="year" FieldType="Int" HeaderText="年度"
                                                      TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtYear" NoDecimal="true" NoNegative="true" MinValue="0" runat="server"
                                                            Required="true" ShowRedStar="true" EmptyText="1991格式">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="durationmonth" DataField="durationmonth" FieldType="Int"
                                                      HeaderText="月数" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtdurationmonth" NoDecimal="true" NoNegative="true" MinValue="1"
                                                            Required="true" ShowRedStar="true" EmptyText="整数" MaxValue="24" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="80px" ColumnID="income_year" DataField="income_year" FieldType="Auto"
                                                      HeaderText="平均年收入" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtincome_year" NoDecimal="false" NoNegative="true" MinValue="1"
                                                            Required="true" ShowRedStar="true" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>

作者: leetle 时间: 2013-12-16 09:48
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="基数" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="80px" ColumnID="income_minpercent" DataField="income_minpercent"
                                                      FieldType="Auto" HeaderText="最低基数(%)" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtincome_minpercent" NoDecimal="false" NoNegative="true" MinValue="1"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="80px" ColumnID="income_maxpercent" DataField="income_maxpercent"
                                                      FieldType="Auto" HeaderText="最高基数(%)" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtincome_maxpercent" NoDecimal="false" NoNegative="true" MinValue="1"
                                                            MaxValue="1000" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                                 <x:GridGroupColumn HeaderText="各项缴费比例(%)" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="养老保险" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="endowment_mpercent" DataField="endowment_mpercent"
                                                      FieldType="Auto" HeaderText="个人" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtendowment_mpercent" NoDecimal="false" NoNegative="true" MinValue="1"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="endowment_cpercent" DataField="endowment_cpercent"
                                                      FieldType="Auto" HeaderText="单位" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtendowment_cpercent" NoDecimal="false" NoNegative="true" MinValue="1"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>

作者: leetle 时间: 2013-12-16 09:49
                                                <x:RenderField Width="50px" ColumnID="endowment_percent" DataField="endowment_percent"
                                                      FieldType="Auto" HeaderText="总计" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                          <x:GridGroupColumn HeaderText="医疗保险" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="medical_mpercent" DataField="medical_mpercent"
                                                      FieldType="Auto" HeaderText="个人" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtmedical_mpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="medical_cpercent" DataField="medical_cpercent"
                                                      FieldType="Auto" HeaderText="单位" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtmedical_cpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="medical_percent" DataField="medical_percent"
                                                      FieldType="Auto" HeaderText="总计" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                          <x:GridGroupColumn HeaderText="工伤保险" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="injury_mpercent" DataField="injury_mpercent"
                                                      FieldType="Auto" HeaderText="个人" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtinjury_mpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="injury_cpercent" DataField="injury_cpercent"
                                                      FieldType="Auto" HeaderText="单位" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtinjury_cpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="injury_percent" DataField="injury_percent"
                                                      FieldType="Auto" HeaderText="总计" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                          <x:GridGroupColumn HeaderText="失业保险" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="unemployment_mpercent" DataField="unemployment_mpercent"
                                                      FieldType="Auto" HeaderText="个人" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtunemployment_mpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="unemployment_cpercent" DataField="unemployment_cpercent"
                                                      FieldType="Auto" HeaderText="单位" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtunemployment_cpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="unemployment_percent" DataField="unemployment_percent"
                                                      FieldType="Auto" HeaderText="总计" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                          <x:GridGroupColumn HeaderText="生育保险" TextAlign="Center">
                                             <Columns>

作者: leetle 时间: 2013-12-16 09:49
                                                <x:RenderField Width="50px" ColumnID="maternity_mpercent" DataField="maternity_mpercent"
                                                      FieldType="Auto" HeaderText="个人" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtmaternity_mpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="maternity_cpercent" DataField="maternity_cpercent"
                                                      FieldType="Auto" HeaderText="单位" TextAlign="Center">
                                                      <Editor>
                                                         <x:NumberBox ID="txtmaternity_cpercent" NoDecimal="false" NoNegative="true" MinValue="0"
                                                            MaxValue="100" runat="server">
                                                         </x:NumberBox>
                                                      </Editor>
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="maternity_percent" DataField="maternity_percent"
                                                      FieldType="Auto" HeaderText="总计" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                                 <x:GridGroupColumn HeaderText="" TextAlign="Center">
                                    <GroupColumns>
                                          <x:GridGroupColumn HeaderText="总计(%)" TextAlign="Center">
                                             <Columns>
                                                <x:RenderField Width="50px" ColumnID="mpercent" DataField="mpercent" FieldType="Auto"
                                                      HeaderText="个人" TextAlign="Center">
                                                </x:RenderField>
                                                <x:RenderField Width="50px" ColumnID="cpercent" DataField="cpercent" FieldType="Auto"
                                                      HeaderText="单位" TextAlign="Center">
                                                </x:RenderField>
                                             </Columns>
                                          </x:GridGroupColumn>
                                    </GroupColumns>
                                 </x:GridGroupColumn>
                              </GroupColumns>
                        </x:Grid>

作者: leetle 时间: 2013-12-16 09:50
   protected void Page_Load(object sender, EventArgs e)
      {
         if (!IsPostBack)
         {
            SetPermissionButtons(Toolbar1);

            var defaultObj = new JObject();
            defaultObj.Add("begin_month", "");
            defaultObj.Add("end_month", "");
            defaultObj.Add("year", "");
            defaultObj.Add("durationmonth", "");
            defaultObj.Add("income_year", "");
            defaultObj.Add("income_minpercent", "");
            defaultObj.Add("income_maxpercent", "");
            defaultObj.Add("endowment_percent", "");
            defaultObj.Add("endowment_mpercent", "");
            defaultObj.Add("endowment_cpercent", "");
            defaultObj.Add("medical_percent", "");
            defaultObj.Add("medical_mpercent", "");
            defaultObj.Add("medical_cpercent", "");
            defaultObj.Add("injury_percent", "");
            defaultObj.Add("injury_mpercent", "");
            defaultObj.Add("injury_cpercent", "");
            defaultObj.Add("unemployment_percent", "");
            defaultObj.Add("unemployment_mpercent", "");
            defaultObj.Add("unemployment_cpercent", "");
            defaultObj.Add("maternity_percent", "");
            defaultObj.Add("maternity_mpercent", "");
            defaultObj.Add("maternity_cpercent", "");

            // 在第一行新增一条数据
            btnAdd.OnClientClick = Grid1.GetAddNewRecordReference(defaultObj, false);

            BindGrid();
         }
      }

作者: erp8@live.cn 时间: 2013-12-17 13:45
{:soso_e179:}

欢迎光临 FineUI 官方论坛 (https://fineui.com/bbs/)