gongzi.asp

erp系統有進銷存,產品管理 供大家學習,

            <td align="center"><input name="jibengongzi" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("jibengongzi")
else response.write 0
																

  end if %>'></td>
            <td align="center"><input name="jiangjin" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("jiangjin")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="koushui" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("koushui")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="sanjin" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("sanjin")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="gongjijin" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("gongjijin")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="koujia" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("koujia")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="qita" type="text"  size="10" value='<% if isedit then
		                                                         response.write rs("qita")
else response.write 0
																

  end if %>'></td>
			<td align="center"><input name="heji" readonly type="text"  size="15" value='<% if isedit then
		                                                         response.write rs("heji")
else response.write 0
																

  end if %>'></td>

<tr><td width="96%" colspan="9" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">备  注</td></tr>

<tr><td colspan="9"><textarea name="content" cols="110" rows="2"><% if isedit then
		                                                         response.write rs("content")
  end if %></textarea></td>

</tr>







          </tr>

		  <tr>

		    <td colspan="5" align="center"><input type="submit" class="button" value="<% if isedit then
		                                                         response.write "编辑"
																

 else
																

 response.write "添加"
																

  end if %>"></td>
		    </tr>
		  </form>
		  
           </table>
        </fieldset>
		<%end if%>
<fieldset style="width:98%"><br><br><br>
<legend>员 工 工 资 列 表</legend>
			<form action="gongzi.asp" method="post" name="selform" >
  <table width="100%"  border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8" align="center">
    <tr> 
      
      <td width="100%" align="center" valign="top">
	 
        <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
          <tr class="but"> 
			<td width="10%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">姓名</td>
            <td width="8%" height="12" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">基本工资</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">奖金</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">扣税</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">三金</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">公积金</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">扣假</td>
			<td width="8%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">其他</td>
			<td width="10%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">合计</td>
            <td width="5%" height="18" align="center" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">操 作</td>
          </tr>
		 <%
set rs=server.CreateObject("ADODB.RecordSet") 
rs.Source="select* from gongzi"
rs.Open rs.Source,conn,1,1
if not rs.EOF then
do while not rs.eof
%>
<tr>
<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><a href="gongzi.Asp?id=<%=rs("ID")%>&action=edit"><%=rs("name")%></a></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("jibengongzi")%><%if rs("jibengongzi")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("jiangjin")%><%if rs("jiangjin")="" then%>&nbsp;<%end if%></td>


<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("koushui")%><%if rs("koushui")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("sanjin")%><%if rs("sanjin")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("gongjijin")%><%if rs("gongjijin")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("koujia")%><%if rs("koujia")="" then%>&nbsp;<%end if%></td>


<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("qita")%><%if rs("qita")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><%=rs("heji")%><%if rs("heji")="" then%>&nbsp;<%end if%></td>

<td height="18" align="center" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><input name="selBigClass" type="checkbox" id="selBigClass" value="<%=rs("ID")%>"></td>
</tr>

<%
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
<tr><td align="right" colspan="10" height="22"> <%if oskey="supper" or oskey="caiwu" then%>
        <input type="checkbox" name="checkbox" value="checkbox" onClick="javascript:SelectAll()"> 选择/反选
              <input onClick="{if(confirm('此操作将删除该信息！\n\n确定要执行此项操作吗？')){this.document.selform.submit();return true;}return false;}" type=submit value=删除 name=action2> 
              <input type="Hidden" name="action" value='del'><%end if%></td></tr>
        </table>

	  
</td>
    </tr>

  </table></fieldset>
</form>
			</TD>
              </TR>
          </table>
		          

  </TBODY>
</TABLE>
<%end sub%>
<P>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
  <TBODY>
  <TR vAlign=center>
    <TD align=middle width="100%"><!--#include file="footer.htm"--></TD>
  </TR></TBODY></TABLE></P></BODY></HTML>