itemdao.cs.svn-base

来自「医院医德医风管理系统 B/S架构」· SVN-BASE 代码 · 共 149 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
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.Generic;

/// <summary>
/// ExamineItemDAO 的摘要说明
/// </summary>
public class ItemDAO
{
	private static string constr = ConfigurationManager.ConnectionStrings["dahuaConnectionString"].ConnectionString;

    public ItemDAO()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static List<Item> GetAllExamineItems()
    {
       
        using (SqlConnection con = new SqlConnection(constr))
        {
            List<Item> list = new List<Item>();
            con.Open();
            string sql = "Select * from Item Order By ItemOrder";
            SqlCommand command = new SqlCommand(sql, con);
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                Item item = new Item();
                item.ItemId = (int)reader["ItemId"];
                item.ItemName = reader["ItemName"].ToString();
                item.ItemOrder = (int)reader["ItemOrder"];
                item.ItemType = reader["ItemType"].ToString();


                list.Add(item);
            }
            if (list.Count == 0)
            {
                list.Add(new Item());
            }
            return list;
        }
    }
    public static bool AddExamineItem(Item item)
    {
         using (SqlConnection con = new SqlConnection(constr))
        {
        con.Open();

        string sql = "insert into Item (ItemId,ItemOrder,ItemName,ItemType)";
        sql += "values (@ItemId,@ItemOrder,@ItemName,@ItemType)";

        SqlCommand command = new SqlCommand(sql, con);
        command.Parameters.Add(new SqlParameter("@ItemId", item.ItemId));
        command.Parameters.Add(new SqlParameter("@ItemOrder", item.ItemOrder ));
        command.Parameters.Add(new SqlParameter("@ItemName", item.ItemName ));
        command .Parameters .Add (new SqlParameter ("@ItemType",item.ItemType ));
        
        try
        {
            command.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
        }
       
        }
        
    }
    public static bool UpdateExamineItem(Item item)
    {
        using (SqlConnection con = new SqlConnection(constr))
        {
        con.Open();
        string sql = "Update Item  set ItemOrder=@ItemOrder,";
        sql += "ItemName=@ItemName ,ItemType=@ItemType where ItemId=@ItemId";
        
        SqlCommand command = new SqlCommand(sql, con);
        command.Parameters.Add(new SqlParameter("@ItemId",item.ItemId));
        command.Parameters.Add(new SqlParameter("@ItemOrder", item.ItemOrder));
        command.Parameters.Add(new SqlParameter("@ItemName", item.ItemName));
        command.Parameters.Add(new SqlParameter("@ItemType", item.ItemType));
       
        try
        {
            command.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
        }
       
        }
        
    }
    public static bool DeleteExamineItem(Item item)
    {
       using (SqlConnection con = new SqlConnection(constr))
        {
        con.Open();
        string sql = "delete  from  Item  where ItemId=@ItemId ";
      

        SqlCommand command = new SqlCommand(sql, con);
        command.Parameters.Add(new SqlParameter("@ItemId", item.ItemId));

        
        try
        {
            command.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
        }
       
        }
    }

    public static int GetItemCount()//获取考核项目总数
    {
        using (SqlConnection con = new SqlConnection(constr))
        {
            con.Open();
            string sql = "Select count(*) from Item";
            SqlCommand command = new SqlCommand(sql, con);
            int count = (int)command.ExecuteScalar();

            return count;
        }
    }
}