departmentdao.cs

来自「值班管理系统源码 net2005+sqlserver2005 ,三层模式」· CS 代码 · 共 46 行

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;

/// <summary>
/// DepartmentDao 的摘要说明
/// </summary>
public class DepartmentDao
{
	public DepartmentDao()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static DataSet dsDepartment()
    {

        string sql = "select  *  from  LHB_Office_ZBB_KS";
        return ShareCommon.dsBySql(sql);

    }
    public static void insertDepartment(DepartmentPo dp)
    {
        string sql = "insert into LHB_Office_ZBB_KS (L_KS_KSMC,L_KS_KSBM) values('"+dp.DepartName+"','"+dp.DepartId+"')";
        ShareCommon.executeNonQuery(sql);
    }
    public static void updateDepartment(DepartmentPo dp,int id)
    {
        string sql = "update LHB_Office_ZBB_KS set L_KS_KSMC='" + dp.DepartName + "',L_KS_KSBM='"+dp.DepartId+"' where id="+id+"";
        ShareCommon.executeNonQuery(sql);
    }
    public static void deleteDepart(int id)
    {
        string sql = "delete from LHB_Office_ZBB_KS where id = "+id+"";
        ShareCommon.executeNonQuery(sql);
    }
}
//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)