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

namespace DLOA.DAO
{
    /// <summary>
    /// MaterialTransmissionDAO 的摘要说明
    /// </summary>
    public class MaterialTransmissionDAO
    {
        public MaterialTransmissionDAO()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(DLOA.Model.MaterialTransmission model,ArrayList list)
        {
            StringBuilder strSql = null;
            Hashtable ht = new Hashtable();
            for (int i = 0; i < list.Count; i++)
            {
                strSql = new StringBuilder();
                strSql.Append("insert into MaterialTransmission(");
                strSql.Append("title,addressee,sendPersonnel,appendix,urgentDegree,note,condition)");
                strSql.Append(" values (");
                strSql.Append("@title,@addressee,@sendPersonnel,@appendix,@urgentDegree,@note,@condition)");
                SqlParameter[] parameters = {
					new SqlParameter("@title", SqlDbType.VarChar,500),
					new SqlParameter("@addressee", SqlDbType.Int,4),
					new SqlParameter("@sendPersonnel", SqlDbType.Int,4),
					new SqlParameter("@appendix", SqlDbType.VarChar,100),
					new SqlParameter("@urgentDegree", SqlDbType.Int,4),
					new SqlParameter("@note", SqlDbType.VarChar,500),
					new SqlParameter("@condition", SqlDbType.VarChar,10)};
                parameters[0].Value = model.title;
                parameters[1].Value = Convert.ToInt32(list[i].ToString());
                parameters[2].Value = model.sendPersonnel;
                parameters[3].Value = model.appendix;
                parameters[4].Value = model.urgentDegree;
                parameters[5].Value = model.note;
                parameters[6].Value = model.condition;
                ht.Add(strSql, parameters);

            } 
            DbHelperSQL.ExecuteSqlTran(ht);

        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete MaterialTransmission ");
            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 DataTable GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT MaterialTransmission.title, MaterialTransmission.id,");
            strSql.Append(" MaterialTransmission.Addressee, MaterialTransmission.appendix,");
            strSql.Append(" Personnel.name AS AddresseeName, MaterialTransmission.appendix, ");
            strSql.Append(" MaterialTransmission.SendPersonnel, ");
            strSql.Append(" MaterialTransmission.condition,SendPersonnel.Name AS SendName,");
            strSql.Append(" UrgentDegree.name as UrgentDegree");
            strSql.Append(" from MaterialTransmission");
            strSql.Append(" inner join Personnel on Personnel.id =  MaterialTransmission.addressee");
            strSql.Append(" inner join Personnel SendPersonnel on SendPersonnel.id = MaterialTransmission.SendPersonnel");
            strSql.Append(" inner join UrgentDegree ON MaterialTransmission.urgentDegree = UrgentDegree.id ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.QueryBySql(strSql.ToString());
        }

    }
}