archivesxdao.cs

小型ERP系统源码,修改版本

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using DLOA.Model;
using DLOA.DALFactory;
using System.Security;
using System.Configuration;

namespace DLOA.DAO
{
    /// <summary>
    /// 数据访问类ArchivesX。
    /// </summary>
    public class ArchivesXDAO
    {
        public ArchivesXDAO()
        { }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from ArchivesX");
            strSql.Append(" where id= @id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
				};
            parameters[0].Value = id;
            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(DLOA.Model.ArchivesX model)
        {
            StringBuilder strSql = new StringBuilder();         
            //保存公文信息
            strSql = new StringBuilder();
            strSql.Append("insert into ArchivesX(");
            strSql.Append("name,keyword,type,confidential,urgentDegree,condition,content,drafter,verification,draftDate,edition,finallyRevises,note,DocNO)");
            strSql.Append(" values (");
            strSql.Append("@name,@keyword,@type,@confidential,@urgentDegree,@condition,@content,@drafter,@verification,@draftDate,@edition,@finallyRevises,@note,@DocNo)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.VarChar,50),
					new SqlParameter("@keyword", SqlDbType.VarChar,500),
					new SqlParameter("@type", SqlDbType.Int,4),
					new SqlParameter("@confidential", SqlDbType.Int,4),
					new SqlParameter("@urgentDegree", SqlDbType.Int,4),
					new SqlParameter("@condition", SqlDbType.VarChar,10),
					new SqlParameter("@content", SqlDbType.VarChar,8000),
					new SqlParameter("@drafter", SqlDbType.Int,4),
					new SqlParameter("@verification", SqlDbType.Int,4),
					new SqlParameter("@draftDate", SqlDbType.DateTime),
					new SqlParameter("@edition", SqlDbType.VarChar,50),
					new SqlParameter("@finallyRevises", SqlDbType.DateTime),
					new SqlParameter("@note", SqlDbType.VarChar,500),
                    new SqlParameter("@DocNo",SqlDbType.VarChar)
            };
            parameters[0].Value = model.name;
            parameters[1].Value = model.keyword;
            parameters[2].Value = model.type;
            parameters[3].Value = model.confidential;
            parameters[4].Value = model.urgentDegree;
            parameters[5].Value = model.condition;
            parameters[6].Value = model.content;
            parameters[7].Value = model.drafter;
            parameters[8].Value = model.verification;
            parameters[9].Value = model.draftDate;
            parameters[10].Value = model.edition;
            parameters[11].Value = model.finallyRevises;
            parameters[12].Value = model.note;
            parameters[13].Value = model.DocNo;
            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null || obj == System.DBNull.Value)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }

        }
        /// <summary>
        /// 更新一条数据//
        /// <param name="model">公文实体对象</param>
        /// </summary>
        public void Update(DLOA.Model.ArchivesX model)
        {
            StringBuilder strSql = new StringBuilder();
         
            //修改公文
            strSql = new StringBuilder();
            strSql.Append("update ArchivesX set ");
            strSql.Append("name=@name,");
            strSql.Append("keyword=@keyword,");
            strSql.Append("type=@type,");
            strSql.Append("confidential=@confidential,");
            strSql.Append("urgentDegree=@urgentDegree,");
            strSql.Append("condition=@condition,");
            strSql.Append("content=@content,");
            //strSql.Append("drafter=@drafter,");
            //strSql.Append("verification=@verification,");
            //strSql.Append("draftDate=@draftDate,");
            strSql.Append("edition=@edition,");
            strSql.Append("finallyRevises=@finallyRevises,");
            strSql.Append("note=@note");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4),
					new SqlParameter("@name", SqlDbType.VarChar,50),
					new SqlParameter("@keyword", SqlDbType.VarChar,500),
                    new SqlParameter("@type",SqlDbType.Int,4),
					new SqlParameter("@confidential", SqlDbType.Int,4),
					new SqlParameter("@urgentDegree", SqlDbType.Int,4),
					new SqlParameter("@condition", SqlDbType.VarChar,10),
					new SqlParameter("@content", SqlDbType.VarChar,8000),
					new SqlParameter("@edition", SqlDbType.VarChar,50),
					new SqlParameter("@finallyRevises", SqlDbType.DateTime),
					new SqlParameter("@note", SqlDbType.VarChar,500)};
            parameters[0].Value = model.id;
            parameters[1].Value = model.name;
            parameters[2].Value = model.keyword;
            parameters[3].Value = model.type;
            parameters[4].Value = model.confidential;
            parameters[5].Value = model.urgentDegree;
            parameters[6].Value = model.condition;
            parameters[7].Value = model.content;
            parameters[8].Value = model.edition;
            parameters[9].Value = model.finallyRevises;
            parameters[10].Value = model.note;

            DbHelperSQL.GetSingle(strSql.ToString(),parameters);

        }

        /// <summary>
        /// 审核公文
        /// </summary>
        /// <param name="id">公文编号</param>
        public void Update(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql = new StringBuilder();
            strSql.Append(" update ArchivesX set Verification = 1");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
				};
            parameters[0].Value = id;
            DbHelperSQL.GetSingle(strSql.ToString(),parameters);
        }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int id,int typeId)
        {   

            //删除公文
            StringBuilder  strSql = new StringBuilder();
            strSql.Append("delete ArchivesX ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
				};
            parameters[0].Value = id;
            DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public DLOA.Model.ArchivesX GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select id,name,keyword,type,confidential,urgentDegree,condition,content,drafter,verification,draftDate,edition,finallyRevises,note from ArchivesX ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = id;
            DLOA.Model.ArchivesX model = new DLOA.Model.ArchivesX();
            DataTable dt = DbHelperSQL.QueryByParameter(strSql.ToString(), parameters);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["id"].ToString() != "")
                {
                    model.id = int.Parse(dt.Rows[0]["id"].ToString());
                }
                model.name = dt.Rows[0]["name"].ToString();
                model.keyword = dt.Rows[0]["keyword"].ToString();
                if (dt.Rows[0]["type"].ToString() != "")
                {
                    model.type = int.Parse(dt.Rows[0]["type"].ToString());
                }
                if (dt.Rows[0]["confidential"].ToString() != "")
                {
                    model.confidential = int.Parse(dt.Rows[0]["confidential"].ToString());
                }
                if (dt.Rows[0]["urgentDegree"].ToString() != "")
                {
                    model.urgentDegree = int.Parse(dt.Rows[0]["urgentDegree"].ToString());
                }
                model.condition = dt.Rows[0]["condition"].ToString();
                model.content = dt.Rows[0]["content"].ToString();
                if (dt.Rows[0]["drafter"].ToString() != "")
                {
                    model.drafter = int.Parse(dt.Rows[0]["drafter"].ToString());
                }
                if (dt.Rows[0]["verification"].ToString() != "")
                {
                    model.verification = int.Parse(dt.Rows[0]["verification"].ToString());
                }
                if (dt.Rows[0]["draftDate"].ToString() != "")
                {
                    model.draftDate = DateTime.Parse(dt.Rows[0]["draftDate"].ToString());
                }
                model.edition = dt.Rows[0]["edition"].ToString();
                if (dt.Rows[0]["finallyRevises"].ToString() != "")
                {
                    model.finallyRevises = DateTime.Parse(dt.Rows[0]["finallyRevises"].ToString());
                }
                model.note = dt.Rows[0]["note"].ToString();
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataTable GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT ArchivesX.Id,ArchivesX.name,ArchivesX.type, ArchivesX.keyword, ArchivesX.confidential,  ");
            strSql.Append(" ArchivesX.urgentDegree, ArchivesX.condition, ArchivesX.verification,  ");
            strSql.Append(" replace(convert(varchar(10),ArchivesX.draftDate,111),'/','-') As draftDate,");
            strSql.Append(" ArchivesX.edition, replace(convert(varchar(10),ArchivesX.finallyRevises,111),'/','-') As finallyRevises,");
            strSql.Append(" UrgentDegree.name AS UrgentDegreeName, Personnel.name  As PersonnelName, DocType.TypeName,  ");
            strSql.Append(" Confidential.name AS ConfidentialName,DocType.tilex,ArchivesX.Content,ArchivesX.DocNo ");
            strSql.Append(" FROM ArchivesX INNER JOIN ");
            strSql.Append(" Confidential ON ArchivesX.confidential = Confidential.id INNER JOIN ");
            strSql.Append(" UrgentDegree ON  ");
            strSql.Append(" ArchivesX.urgentDegree = UrgentDegree.id INNER JOIN ");
            strSql.Append(" Personnel ON ArchivesX.drafter = Personnel.id ");
            strSql.Append(" Inner Join DocType on DocType.id = ArchivesX.type");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where 1 = 1 " + strWhere);
            }
            return DbHelperSQL.QueryBySql(strSql.ToString());
        }


        public DataTable GetList()
        {
            return DbHelperSQL.QueryBySql("select id,name from ArchivesX");
        }
        #endregion  成员方法
    }
}