characterdao.cs.svn-base

医院医德医风管理系统 B/S架构

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

/// <summary>
/// CharacterDAO 的摘要说明
/// </summary>
public class CharacterDAO
{
    private static string constr = ConfigurationManager.ConnectionStrings["dahuaConnectionString"].ConnectionString;
    public CharacterDAO()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    public static Character GetCharacterBydate(int ydate, int mdate, int personId,int unitid)
    {
        Character u = new Character();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select * from Character where Ydate=@Ydate and Mdate=@Mdate and PersonnelId=@Personnelid";
            if (personId == -1)
                sql += " and CharacterUnitId=@UnitID";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@Ydate", ydate));
            cmd.Parameters.Add(new SqlParameter("@Mdate", mdate));
            cmd.Parameters.Add(new SqlParameter("@Personnelid", personId));
            cmd.Parameters.Add(new SqlParameter("@UnitID", unitid));
            con.Open();
            SqlDataReader read = null;
            try
            {
                read = cmd.ExecuteReader();
            }
            catch (Exception e)
            { }
            while (read.Read())
            {
                SetCharacter(u, read);
            }
            read.Close();
            con.Close();
        }
        return u;
    }
    public static List<Character> GetCharacterList()
    {
        List<Character> list = new List<Character>();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select Character.*,Personnel.PersonnelName,Unit.UnitName from Character,Personnel,Unit where Personnel.PersonnelId=Character.PersonnelId and Unit.UnitId=Character.CharacterUnitId";
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            SqlDataReader read = null;
            try
            {
                read = cmd.ExecuteReader();
            }
            catch (Exception e)
            {
            }
            while (read.Read())
            {
                Character u = new Character();
                SetCharacter(u, read);
                u.PersonnelName = read["PersonnelName"].ToString();
                u.UnitName = read["UnitName"].ToString();
                list.Add(u);

            }
            read.Close();
            con.Close();
        }
        return list;
    }
    public static List<Character> GetCharacterListBy(int ydate, int mdate, int unitid, int perid)
    {
        List<Character> list = new List<Character>();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select Character.*,Personnel.*,Unit.* from Character,Personnel,Unit";
            sql += " where Personnel.PersonnelId=Character.PersonnelId and Unit.UnitId=Character.CharacterUnitId ";
            sql += "and Character.Ydate=@Ydate and Character.Mdate=@Mdate ";
            if (perid != 0)
                sql += "and Personnel.PersonnelId=@PersonnelId";
            else
            {
                if (unitid != 0)
                {
                    sql += "and Character.CharacterUnitId=@CharacterUnitId ";

                }
            }
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@Ydate", ydate));
            cmd.Parameters.Add(new SqlParameter("@Mdate", mdate));
            if (perid != 0)
                cmd.Parameters.Add(new SqlParameter("@PersonnelId", perid));
            else
            {
                if (unitid != 0)
                    cmd.Parameters.Add(new SqlParameter("@CharacterUnitId", unitid));
            }
            try
            {
                list = CharacterBL.GetCharacterListDepart(ydate, mdate, unitid);
            }
            catch (Exception ex)
            {
            }
            con.Open();
            SqlDataReader read = null;
            try
            {
                read = cmd.ExecuteReader();
            }
            catch (Exception e)
            {

            }

            while (read.Read())
            {
                Character u = new Character();
                SetCharacter(u, read);
                u.PersonnelName = read["PersonnelName"].ToString();
                u.UnitName = read["UnitName"].ToString();
                list.Add(u);

            }
            read.Close();
            con.Close();
        }
        return list;
    }
    public static Character GetCharacterByCharacterID(int id)
    {
        Character u = new Character();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select Character.*,Unit.* from Character,Unit where Character.CharacterUnitId=Unit.unitid and CharacterId=@ID";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@ID", id));
            con.Open();
            SqlDataReader read = cmd.ExecuteReader();
            while (read.Read())
            {
                SetCharacter(u, read);
                u.UnitName = read["UnitName"].ToString();
            }
            read.Close();
            con.Close();
        }
        return u;
    }
    public static Character GetCharacterById(int c)
    {
        Character u = new Character();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select Character.*,Personnel.PersonnelName,Character.CharacterUnitId,Unit.UnitName from Character,Personnel,Unit where Personnel.PersonnelId=Character.PersonnelId and Unit.UnitId=Character.CharacterUnitId and CharacterId=@Characterid";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@Characterid", c));
            con.Open();
            SqlDataReader read = cmd.ExecuteReader();
            while (read.Read())
            {
                u.PersonnelName = read["PersonnelName"].ToString();
                u.UnitName = read["UnitName"].ToString();
                SetCharacter(u, read);
            }
            read.Close();
            con.Close();
        }
        return u;
    }
    public static void SetCharacter(Character u, SqlDataReader read)
    {
        u.CharacterId = (int)read["CharacterId"];
        u.UnitId = (int)read["CharacterUnitId"];
        u.PersonnelId = (int)read["PersonnelId"];
        u.Record1 = read["Record1"].ToString();
        u.Record2 = read["Record2"].ToString();
        u.Record3 = read["Record3"].ToString();
        u.Record4 = read["Record4"].ToString();
        u.Record5 = read["Record5"].ToString();
        u.Record6 = read["Record6"].ToString();
        u.Record7 = read["Record7"].ToString();
        u.Record8 = read["Record8"].ToString();
        u.Positive = (int)read["Positive"];
        u.Positiveno = (int)read["Positiveno"];
        u.Redresist = (int)read["Redresist"];
        u.Red = (int)read["Red"];
        u.Recognition = (int)read["Recognition"];
        u.Flag = (int)read["Flag"];
        u.Tablet = (int)read["Tablet"];
        u.Other = (int)read["Other"];
        u.Complaint = (int)read["Complaint"];
        u.KouJiang = (int)read["KouJiang"];
        u.Mdate = (int)read["Mdate"];
        u.Ydate = (int)read["Ydate"];
        u.CreateUserId = (int)read["CreateUserId"];
        u.Record1Sum = (int)read["Record1Sum"];
        u.Record5Sum = (int)read["Record5Sum"];
        u.Record7Sum = (int)read["Record7Sum"];
    }
    public static bool AddCharacter(Character u)
    {
        using (SqlConnection con = new SqlConnection(constr))
        {
            con.Open();
            string sql = "insert into Character (CharacterUnitId,PersonnelId,Record1,Record2,Record3,Record4,Record5,Record6,Record7,Record8,Record1Sum,Record5Sum,Record7Sum,Positive,Positiveno,Redresist,Red,Recognition,Flag,Tablet,Other,Complaint,Mdate,Ydate,CreateUserId,KouJiang)";
            sql += " values (@CharacterUnitId,@PersonnelId,@Record1,@Record2,@Record3,@Record4,@Record5,@Record6,@Record7,@Record8,@Record1Sum,@Record5Sum,@Record7Sum,@Positive,@Positiveno,@Redresist,@Red,@Recognition,@Flag,@Tablet,@Other,@Complaint,@Mdate,@Ydate,@CreateUserId,@KouJiang)";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@CharacterUnitId", u.UnitId));
            cmd.Parameters.Add(new SqlParameter("@PersonnelId", u.PersonnelId));
            cmd.Parameters.Add(new SqlParameter("@Record1", u.Record1));
            cmd.Parameters.Add(new SqlParameter("@Record2", u.Record2));
            cmd.Parameters.Add(new SqlParameter("@Record3", u.Record3));
            cmd.Parameters.Add(new SqlParameter("@Record4", u.Record4));
            cmd.Parameters.Add(new SqlParameter("@Record5", u.Record5));
            cmd.Parameters.Add(new SqlParameter("@Record6", u.Record6));
            cmd.Parameters.Add(new SqlParameter("@Record7", u.Record7));
            cmd.Parameters.Add(new SqlParameter("@Record8", u.Record8));
            cmd.Parameters.Add(new SqlParameter("@Record1Sum", u.Record1Sum));
            cmd.Parameters.Add(new SqlParameter("@Record5Sum", u.Record5Sum));
            cmd.Parameters.Add(new SqlParameter("@Record7Sum", u.Record7Sum));
            cmd.Parameters.Add(new SqlParameter("@Positive", u.Positive));
            cmd.Parameters.Add(new SqlParameter("@Positiveno", u.Positiveno));
            cmd.Parameters.Add(new SqlParameter("@Redresist", u.Redresist));
            cmd.Parameters.Add(new SqlParameter("@Red", u.Red));
            cmd.Parameters.Add(new SqlParameter("@Recognition", u.Recognition));
            cmd.Parameters.Add(new SqlParameter("@Flag", u.Flag));
            cmd.Parameters.Add(new SqlParameter("@Tablet", u.Tablet));
            cmd.Parameters.Add(new SqlParameter("@Other", u.Other));
            cmd.Parameters.Add(new SqlParameter("@Complaint", u.Complaint));
            cmd.Parameters.Add(new SqlParameter("@KouJiang", u.KouJiang));
            cmd.Parameters.Add(new SqlParameter("@Mdate", u.Mdate));
            cmd.Parameters.Add(new SqlParameter("@Ydate", u.Ydate));
            cmd.Parameters.Add(new SqlParameter("@CreateUserId", u.CreateUserId));
            int i = cmd.ExecuteNonQuery();
            con.Close();
            try
            {
                if (i > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                return false;
            }
        }
    }
    public static bool UPCharacter(Character u)
    {