wagesetupclass.cs

中小企业人力资源管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace HRP.BaseClass
{
    class WageSetupClass
    {
        //显示要修改的工资项目
        SqlClass sqlclass = new SqlClass();
        public DataSet WageEditOpen(int intId)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = new SqlCommand("select * from tb_WageSetup where ID=@intId", con);
            SqlParameter para = new SqlParameter("@intId",SqlDbType.BigInt,8);
            para.Value = intId;
            sda.SelectCommand.Parameters.Add(para);
            DataSet ds=new DataSet();
            sda.Fill(ds,"tb_WageSetupEdit");
            return ds;
        }
        public void WageEdit(string strWageName,double dbScalar,int intId)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("update tb_WageSetup set WageName=@WageName,Scalar=@Scalar where id=@intId",con);
            SqlParameter para = new SqlParameter("@WageName",SqlDbType.VarChar,50);
            para.Value =strWageName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@Scalar", SqlDbType.Money, 8);
            para.Value = dbScalar;
            scd.Parameters.Add(para);
            para = new SqlParameter("@intId", SqlDbType.BigInt, 8);
            para.Value = intId;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
        }
    }
}