<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="departmentwageupdate.aspx.cs" Inherits="Web.gz.show.departmentwageupdate" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>OA标题页</title>
    <link href="../../css/css.css" rel="stylesheet" type="text/css" />
      <script type="text/javascript" src="../../css/popcalendar.js"></script>
</head>
<body>
    <form id="fom" runat="server">
        <div id ="main-c-03-right" >
            <table cellpadding="0"; cellspacing ="0"; style =" width :100%;background-image: url('../../css/images/right_top.png'); background-repeat :repeat-x" >
                <tr>
                    <td style ="width :720px; height :34px;  background-image: url('../../css/images/atghtj.png');	background-repeat: no-repeat;
                	background-position: left top;"><div id="main-c-03-right02-top">
                	   <!--这里添加页面标题 -->
                      	工资批量导入
                      	
                	</div></td>
                </tr>
            </table>
            <div id="main-c-03-right02-main">
                  <div style ="color :Red; text-align :left "> <asp:Label ID="lbMessage" runat="server"></asp:Label></div> 
              <asp:Panel ID="Panel1" runat="server">
<!--栏目开始 -->
            <table style ="width :100%" border="0" align="center" cellpadding="0" cellspacing="0" class="ziti04">
               <tr>
                    <td style ="font-weight:bolder;background-image: url('../../css/images/asdfrsg.png'); height :33px; padding-left :20px">
                    <!--这里添加栏目标题 -->
                    工资批量导入
                    
                     &gt;&gt;</td>
                    <td style ="background-image: url('../../css/images/asdfrsg.png'); width :103px"></td>
                    <td style ="background-image: url('../../css/images/asdfrsg.png'); width :64px"></td>
                    <td  style ="background-image: url('../../css/images/asdfrsg.png'); width :76px" ></td>
                </tr>
                <tr>
                    <td height="10" colspan="4" style="font-weight:bolder;"></td>
                </tr>
            </table>
            <!--这里添加内容 -->
<table style ="width :100%">
                <tr>
                    <td >
                    <div style =" padding-bottom :10px">  <table  border = "0"  cellpadding ="0" cellspacing ="0" style ="width :100%"><tr>
        <td class =" td_leftnoborder  " style =" width :90px"><div >
             <img src="../../css/admincss/images/dian.gif"  alt ="" 
                               style="width: 10px; height: 13px" /> 选择模块：
             </div> </td>
        <td class =" td_leftnoborder  ">                         
            <asp:RadioButtonList ID="rblProjectA" runat="server" 
                             RepeatDirection ="Horizontal" RepeatColumns ="8" 
                AutoPostBack="True" 
                onselectedindexchanged="rblProjectA_SelectedIndexChanged" >
                         </asp:RadioButtonList>    
  </td>
                        <td class=" td_leftnoborder  ">
                            &nbsp;</td>
        </tr> 
                        </table> </div> 
                        <div class =" td_leftnoborder ">    <img src="../../css/admincss/images/dian.gif"  alt ="" 
                               style="width: 10px; height: 13px" />部门：<asp:DropDownList 
                               ID="ddlDepartment" runat="server" AutoPostBack="True" 
                               onselectedindexchanged="ddlDepartment_SelectedIndexChanged"> </asp:DropDownList>
                                                &nbsp; 
                                日期：&nbsp;<asp:TextBox ID="date1" runat="server" 
                                    onclick="popUpCalendar(this,this,'yyyymmdd')" Width="70px"></asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                                    ControlToValidate="date1" Display="Dynamic" ErrorMessage="日期不能为空。" 
                                    ForeColor="Red" ValidationGroup="Inquires"></asp:RequiredFieldValidator>
                                <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
                                    ControlToValidate="date1" Display="Dynamic" ErrorMessage="请输入8位数字格式的日期。" 
                                    ForeColor="Red" ValidationExpression="^\d{8}$" ValidationGroup="Inquires"></asp:RegularExpressionValidator> </div>
        <div class =" td_leftnoborder " >
                                                <img src="../../css/admincss/images/dian.gif" style="width: 10px; height: 13px"  alt =""/> 
                                                EXCEL文件：<asp:FileUpload ID="FileUpload1" runat="server"  />
                                                &nbsp;<asp:Button ID="btLoad1" runat="server" onclick="btLoad1_Click" 
                                                    Text="导入预览" ValidationGroup="Inquires" /></div></td>
                    <td>
                        &nbsp;</td>
                    <td style ="text-align :right ; padding-right :10px ">
                              下载EXCEL样表
                              <asp:ImageButton ID="ImageButton1" runat="server" 
                                  ImageUrl="~/css/images/excel.jpg" onclick="ImageButton1_Click" />
                                            </td>
                </tr>
            </table>
           <div style =" height :30px; font-weight :bold">导入数据预览（如果数据多于10行，预览中只显示前10行）</div> 
                    <asp:Label ID="lbRowsNum1" runat="server" ForeColor="Red"></asp:Label>
      <div style ="margin-top :10px; margin-bottom :10px"  >
        <asp:GridView ID="GridView1" runat="server" BorderWidth="1px" 
                onrowdatabound="GridView1_RowDataBound" Width="100%" CssClass="gv" cellspacing="1">
            <RowStyle BorderWidth="1px" CssClass="gvrow" />
            <HeaderStyle BorderWidth="1px" CssClass="gvhead" />
        </asp:GridView></div>
        <table style ="width :100%" >
        <tr>
        <td style ="text-align :left ">
            &nbsp;</td>
        <td style ="text-align :right ">
            <asp:Button ID="btExcel" runat="server" CausesValidation="False" 
                onclick="btExcel_Click" Text="导出到EXCEL" Visible="False" />
            </td>
        </tr>
        </table>
        <div style =" height :30px; font-weight :bold">系统设定项目和EXCEL表项目对照</div>
        <table border="1" class ="table " cellpadding ="0" cellspacing ="0" style ="width :100%;border-collapse:collapse;"  >
                    <tr>
                        <td class ="tabletd_right " style ="width:110px">
                            系统设定项目</td>
                                                <td class ="tabletd_left ">
                                                    <asp:Label ID="lbsql" runat="server"></asp:Label>
                                                &nbsp;</td>
                                            </tr>
                                            <tr>
                                                <td class ="tabletd_right ">
                                                    EXCEL表中项目</td>
                                                <td class ="tabletd_left ">
                                                    <asp:Label ID="lbexcel" runat="server"></asp:Label>
                                                &nbsp;</td>
                                            </tr>
                                            </table>
                                            <div  style =" padding-bottom :15px; padding-top :15px;" id="divloadt" runat ="server" visible ="false" >
                           <img src="../../css/admincss/images/dian.gif"  alt ="" 
                               style="width: 10px; height: 13px" /> 项目相同。<asp:Button ID="btLoadt" runat="server" Text="确认导入" 
                                                    onclick="btLoadt_Click" /></div>
                                            <div id ="divloadf" runat ="server" visible ="false" >
                                            <div style =" padding-bottom :15px; padding-top :15px;">
                           <img src="../../css/admincss/images/dian.gif"  alt ="" style="width: 10px; height: 13px" /> 项目不同。以EXCEL表中项目为标准更新系统设定项目后导入。
                            <asp:Button ID="btLoadf1" runat="server"
                                                    Text="更新导入" onclick="btLoadf1_Click" /></div> 

                                                    <div  style =" padding-bottom :15px; padding-top :15px;">
                           <img src="../../css/admincss/images/dian.gif"  alt ="" style="width: 10px; height: 13px" /> 项目不同。手动选择EXCEL项目同系统设定项目对应后导入。
                           <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                                        BorderWidth="1px" CssClass="gv" cellspacing="1"
                                        onrowdatabound="GridView2_RowDataBound" Width="322px" 
                                        >
                                         <RowStyle BorderWidth="1px" CssClass="gvrow" />
                                        <HeaderStyle BorderWidth="1px" CssClass="gvhead" />
                     <Columns>
                 <asp:TemplateField HeaderText="数据库中项目">
      <ItemTemplate>
          <asp:Label ID="Label1" runat="server" Text="<%#Container.DataItem%>"></asp:Label>
           
       </ItemTemplate>
</asp:TemplateField>
                <asp:TemplateField HeaderText="EXCEL中项目" ShowHeader="False">
                    <ItemTemplate>
                        <asp:DropDownList ID="ddl1" runat="server">
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
         </asp:GridView>
                                    
        <asp:Button ID="btLoadf2" runat="server" 
                                                            Text="手动选择后导入" onclick="btLoadf2_Click" />
                                                       
                                                </div>
                                                            </div>
<!--栏目结束 -->
 
</asp:Panel> 
                </div>
            </div>
        </form>
    </body>
</html>


