signsissuesdao.cs

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

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 DLOA.DALFactory;
using System.Data.SqlClient;
using System.Text;
using DLOA.Model;
using System.Collections;

namespace DLOA.DAO
{
    /// <summary>
    /// SignsIssuesDAO 的摘要说明
    /// </summary>
    public class SignsIssuesDAO
    {
        public SignsIssuesDAO()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from SignsIssues");
            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 void Add(DLOA.Model.SignsIssues model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SignsIssues(");
            strSql.Append("title,keyWord,docId,messageUnit,messageNumber,draftUnit,transmissionUnit,departmentList,datex,condition,note)");
            strSql.Append(" values (");
            strSql.Append("@title,@keyWord,@docId,@messageUnit,@messageNumber,@draftUnit,@transmissionUnit,@departmentList,@datex,@condition,@note)");
            SqlParameter[] parameters = {
					new SqlParameter("@title", SqlDbType.VarChar,500),
					new SqlParameter("@keyWord", SqlDbType.VarChar,8000),
					new SqlParameter("@docId", SqlDbType.Int,4),
					new SqlParameter("@messageUnit", SqlDbType.VarChar,50),
					new SqlParameter("@messageNumber", SqlDbType.Int,4),
					new SqlParameter("@draftUnit", SqlDbType.VarChar,50),
					new SqlParameter("@transmissionUnit", SqlDbType.VarChar,50),
					new SqlParameter("@departmentList", SqlDbType.VarChar,50),
					new SqlParameter("@datex", SqlDbType.DateTime),
					new SqlParameter("@condition", SqlDbType.VarChar,10),
					new SqlParameter("@note", SqlDbType.VarChar,500)};
            parameters[0].Value = model.title;
            parameters[1].Value = model.keyWord;
            parameters[2].Value = model.docId;
            parameters[3].Value = model.messageUnit;
            parameters[4].Value = model.messageNumber;
            parameters[5].Value = model.draftUnit;
            parameters[6].Value = model.transmissionUnit;
            parameters[7].Value = model.departmentList;
            parameters[8].Value = model.datex;
            parameters[9].Value = model.condition;
            parameters[10].Value = model.note;

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

        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(DLOA.Model.SignsIssues model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update SignsIssues set ");
            strSql.Append("title=@title,");
            strSql.Append("keyWord=@keyWord,");
            strSql.Append("docId=@docId,");
            strSql.Append("messageUnit=@messageUnit,");
            strSql.Append("messageNumber=@messageNumber,");
            strSql.Append("draftUnit=@draftUnit,");
            strSql.Append("transmissionUnit=@transmissionUnit,");
            strSql.Append("departmentList=@departmentList,");
            strSql.Append("datex=@datex,");
            strSql.Append("condition=@condition,");
            strSql.Append("note=@note");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4),
					new SqlParameter("@title", SqlDbType.VarChar,500),
					new SqlParameter("@keyWord", SqlDbType.VarChar,8000),
					new SqlParameter("@docId", SqlDbType.Int,4),
					new SqlParameter("@messageUnit", SqlDbType.VarChar,50),
					new SqlParameter("@messageNumber", SqlDbType.Int,4),
					new SqlParameter("@draftUnit", SqlDbType.VarChar,50),
					new SqlParameter("@transmissionUnit", SqlDbType.VarChar,50),
					new SqlParameter("@departmentList", SqlDbType.VarChar,50),
					new SqlParameter("@datex", SqlDbType.DateTime),
					new SqlParameter("@condition", SqlDbType.VarChar,10),
					new SqlParameter("@note", SqlDbType.VarChar,500)};
            parameters[0].Value = model.id;
            parameters[1].Value = model.title;
            parameters[2].Value = model.keyWord;
            parameters[3].Value = model.docId;
            parameters[4].Value = model.messageUnit;
            parameters[5].Value = model.messageNumber;
            parameters[6].Value = model.draftUnit;
            parameters[7].Value = model.transmissionUnit;
            parameters[8].Value = model.departmentList;
            parameters[9].Value = model.datex;
            parameters[10].Value = model.condition;
            parameters[11].Value = model.note;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete SignsIssues ");
            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.SignsIssues GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select id,title,keyWord,docId,messageUnit,messageNumber,draftUnit,departmentList,transmissionUnit,datex,condition,note from SignsIssues ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = id;
            DLOA.Model.SignsIssues model = new DLOA.Model.SignsIssues();
            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.title = dt.Rows[0]["title"].ToString();
                model.keyWord = dt.Rows[0]["keyWord"].ToString();
                if (dt.Rows[0]["docId"].ToString() != "")
                {
                    model.docId = int.Parse(dt.Rows[0]["docId"].ToString());
                }
                model.messageUnit = dt.Rows[0]["messageUnit"].ToString();
                if (dt.Rows[0]["messageNumber"].ToString() != "")
                {
                    model.messageNumber = int.Parse(dt.Rows[0]["messageNumber"].ToString());
                }
                model.draftUnit = dt.Rows[0]["draftUnit"].ToString();
                model.transmissionUnit = dt.Rows[0]["transmissionUnit"].ToString();
                if (dt.Rows[0]["datex"].ToString() != "")
                {
                    model.datex = DateTime.Parse(dt.Rows[0]["datex"].ToString());
                }
                model.condition = dt.Rows[0]["condition"].ToString();
                model.note = dt.Rows[0]["note"].ToString();

                if (dt.Rows[0]["departmentList"].ToString() != "")
                {
                    model.departmentList= dt.Rows[0]["departmentList"].ToString();
                }
            
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 得到最大的ID2008
        /// </summary>
        /// <returns></returns>
        public int  getMaxId()
        {
                int id = 0;
                StringBuilder strSql=new StringBuilder();
                strSql.Append("select id from SignsIssues where id in(select  Max(id)  from SignsIssues)");
                String idString = null;
                idString = (DbHelperSQL.QueryBySql(strSql.ToString()).Rows[0][0]).ToString();
                id=Convert.ToInt32(idString);
                return id;
                
        }
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataTable GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT SignsIssues.keyWord, SignsIssues.title, SignsIssues.id, ");
            strSql.Append(" SignsIssues.messageUnit, SignsIssues.messageNumber,  ");
            strSql.Append(" SignsIssues.draftUnit, SignsIssues.transmissionUnit,DocType.tilex,");
            strSql.Append(" SignsIssues.datex, SignsIssues.condition,ArchivesX.id as FileId, ArchivesX.name as ArchivesXName ");
            strSql.Append(" FROM .SignsIssues INNER JOIN");
            strSql.Append(" ArchivesX ON .SignsIssues.docId = ArchivesX.id INNER JOIN ");
            strSql.Append(" DocType ON .ArchivesX.type = DocType.id");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.QueryBySql(strSql.ToString());
        }
        #endregion
    }
}