staffdao.cs

值班管理系统源码 net2005+sqlserver2005 ,三层模式

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;
///51aspx.com
/// <summary>
/// StaffDao 的摘要说明
/// </summary>
public class StaffDao
{
	public StaffDao()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public static DataSet dsStaff()
    {
        string sql = "select a.id,a.L_user_name,(case a.L_user_sex when 0 then '男' when 1 then '女' end) as L_user_sex ,b.L_KS_KSMC,a.L_user_Number from LHB_Office_ZBB_USER  a ,LHB_Office_ZBB_KS b where a.L_user_KSBM=b.id";
        return ShareCommon.dsBySql(sql);
    }

    public static void insertStaff(StaffPo sp)
    {
        string sql = "insert into LHB_Office_ZBB_USER(L_user_name,L_user_sex,L_user_KSBM,L_user_Number) values('"+sp.UserName+"',"+sp.Sex+","+sp.DepartId+",'"+sp.UserId+"')";
        ShareCommon.executeNonQuery(sql);
    }


    public static void updateStaff(StaffPo sp,int keyId)
    {

        string sql = "update LHB_Office_ZBB_USER set L_user_name = '" + sp.UserName + "',L_user_Number='"+sp.UserId+"', L_user_sex=" + sp.Sex + ",L_user_KSBM=" + sp.DepartId + " where id=" + keyId + "";
        ShareCommon.executeNonQuery(sql);
    }

    public static DataSet dsStaff(int deptId)
    {
        string sql = "select id,L_user_name from LHB_Office_ZBB_USER where L_user_KSBM=" + deptId + "";
        return ShareCommon.dsBySql(sql);
    }
    public static void deleteStaff(int id)
    {
        string sql = "delete from LHB_Office_ZBB_USER where id="+id;
        ShareCommon.executeNonQuery(sql);
    }
}