App_Code/DAO/PositionDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;

using Salary.Model;
using Salary.DB;

namespace Salary.DAO
{
    /// <summary>
    /// PositionDAO 的摘要说明
    /// </summary>
    public class PositionDAO
    {
        /*得到所有的职位信息*/
        public ArrayList QueryAllPosition()
        {
            ArrayList positionList = new ArrayList();
            String sql = "select * from [position]";
            DataBase db = new DataBase();
            DataSet ds = db.GetDataSet(sql);
            for(int i=0;i<ds.Tables[0].Rows.Count;i++)
            {
                DataRow dr = ds.Tables[0].Rows[i];
                Position position = new Position();
                position.setPositionId(Convert.ToInt32(dr["positionId"]));
                position.setPositionName(dr["positionName"].ToString());
                position.setBasicWage(Convert.ToSingle(dr["basicWage"]));
                position.setOvertimeHourMoney(Convert.ToSingle(dr["overtimeHourMoney"]));
                position.setSellGetPercent(Convert.ToInt32(dr["sellGetPercent"]));
                position.setTrafficWage(Convert.ToInt32(dr["trafficWage"]));
                position.setSecureReduce(Convert.ToSingle(dr["secureReduce"]));
                position.setChiDaoOnceMoney(Convert.ToSingle(dr["chiDaoOnceMoney"]));
                position.setZaoTuiOnceMoney(Convert.ToSingle(dr["zaoTuiOnceMoney"]));
                position.setKuangGongOneDayMoney(Convert.ToSingle(dr["kuangGongOneDayMoney"]));
                positionList.Add(position);
                   
           }
           return positionList;
        }

        /*根据职位id得到该职位的名称*/
        public String GetPositionNameById(int positionId)
        {
            String positionName = "";
            String sql = "select positionName from [position] where positionId=" + positionId;
            DataSet ds = (new DataBase()).GetDataSet(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow dr = ds.Tables[0].Rows[0];
                positionName = dr["positionName"].ToString();
            }
            return positionName;