bigclientdal.cs

c#三层架构项目开发的全过程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using System.Data;
using System.Data.SqlClient;

namespace DAL.BigCustomers
{
   public class bigclientDal
    {
        #region 添加大客户销售单据
       /// <summary>
        /// 添加大客户销售单据
       /// </summary>
       /// <param name="bigclient_id">大客户编号</param>
       /// <param name="Employee_ID">填单人</param>
       /// <param name="bigclient_type_id">大客户类型编号</param>
        /// <param name="bigclient_price">大客户销售总金额</param>
       /// <param name="bigclient_sum">大客户销售总数量</param>
       /// <param name="bigclient_time">销售时间</param>
       /// <param name="bigclient_client">大客户编号</param>
       /// <param name="bigclient_state">审核状态</param>
       /// <returns>添加大客户销售单据影响的行数</returns>
       public int AddBigSell(string bigclient_id, string Employee_ID, string bigclient_type_id,decimal bigclient_price, int bigclient_sum, DateTime bigclient_time, string bigclient_client, string bigclient_state)
        {
            string commandtext = "bigclient_Add";
            SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
            SqlParameter askid = new SqlParameter("@Employee_ID", SqlDbType.Char, 10);
            SqlParameter typeid = new SqlParameter("@bigclient_type_id", SqlDbType.Char,20);
            SqlParameter price = new SqlParameter("@bigclient_price", SqlDbType.Decimal);

            SqlParameter sum = new SqlParameter("@bigclient_sum", SqlDbType.Int);
            SqlParameter time = new SqlParameter("@bigclient_time", SqlDbType.DateTime);
            SqlParameter client = new SqlParameter("@bigclient_client", SqlDbType.VarChar,10);
            SqlParameter state = new SqlParameter("@bigclient_state", SqlDbType.VarChar, 10);

            id.Value = bigclient_id;
            askid.Value = Employee_ID;
            typeid.Value = bigclient_type_id;
            price.Value = bigclient_price;
            sum.Value = bigclient_sum;
            time.Value = bigclient_time;
            client.Value = bigclient_client;
            state.Value = bigclient_state;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, askid, typeid,price, sum, time, client,state });
        }
        #endregion

       #region 查询大客户编号
      /// <summary>
       /// 查询大客户编号
      /// </summary>
      /// <param name="membersex">性别</param>
      /// <returns></returns>
       public List<Model.Members.Memberb> SelectBigClientID(string membersex)
       {
           List<Model.Members.Memberb> li = new List<Model.Members.Memberb>();
           SqlParameter sex = new SqlParameter("@Member_Sex",SqlDbType.VarChar,4);
           sex.Value = membersex;
           string commandtext = "BigClientID_Select";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { sex });
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Members.Memberb md = new Model.Members.Memberb();
               md.Member_ID = item["Member_ID"].ToString();
               li.Add(md);
           }
           return li;
       }
       #endregion

       #region 通过大客户销售单据编号查找销售单据信息
       /// <summary>
       /// 通过大客户销售单据编号查找销售单据信息
       /// </summary>
       /// <param name="bigclient_id">大客户销售单据编号</param>
       /// <returns></returns>
       public Model.BigCustomers.bigclientModel bigclienrSelectByID(string bigclient_id)
       {
           string commandtext = "bigclientByIDO_Select";
           SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
           id.Value = bigclient_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
           Model.BigCustomers.bigclientModel inf = new Model.BigCustomers.bigclientModel();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               inf.Employee_ID = item["Employee_ID"].ToString ().Trim();
               inf.bigclient_time = (DateTime)item["bigclient_time"];
               inf.bigclient_price = (decimal)item["bigclient_price"];
           }
           return inf;
       }
       #endregion

       #region 获取大客户销售单据ID
       /// <summary>
       ///  获取大客户销售单据ID
       /// </summary>
       /// <param name="bigclient_state">大客户销售单据状态</param>
       /// <returns></returns>
       public List<Model.BigCustomers.bigclientModel> SelectbigclientID(string bigclient_state)
       {
           List<Model.BigCustomers.bigclientModel> li = new List<Model.BigCustomers.bigclientModel>();
           string commandtext = "bigclientIDByState_Select";
           DataSet ds = new DataSet();
           SqlParameter state = new SqlParameter("@bigclient_state", SqlDbType.VarChar, 10);
           state.Value = bigclient_state;
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { state });
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.BigCustomers.bigclientModel inf = new Model.BigCustomers.bigclientModel();
               inf.bigclient_id = dr["bigclient_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 修改大客户销售单据
       /// <summary>
       ///  修改大客户销售单据
       /// </summary>
       /// <param name="bigclient_id">大客户销售单据</param>
       /// <param name="bigclient_assessor">单据审核人</param>
       /// <param name="bigclient_state">单据状态</param>
       /// <returns></returns>
       public List<Model.BigCustomers.bigclientModel> bigclientUpdate(string bigclient_id, string bigclient_assessor, string bigclient_state)
       {
           List<Model.BigCustomers.bigclientModel> list = new List<Model.BigCustomers.bigclientModel>();
           string commandtext = "bigclient_Update";
           SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
           SqlParameter cid = new SqlParameter("@bigclient_assessor", SqlDbType.VarChar, 10);
           SqlParameter ok = new SqlParameter("@bigclient_state", SqlDbType.VarChar, 10);
           id.Value = bigclient_id;
           cid.Value = bigclient_assessor;
           ok.Value = bigclient_state;
           SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, cid, ok });
           return list;
       }
       #endregion

       #region 查询已出库的大客户销售单据编号
       /// <summary>
       /// 查询已出库的大客户销售单据编号
       /// </summary>
       /// <param name="bigclient_state">审核状态</param>
       /// <returns></returns>
       public List<Model.BigCustomers.bigclient_listModel> bigclientSelectByOK(string bigclient_state)
       {
           List<Model.BigCustomers.bigclient_listModel> list = new List<Model.BigCustomers.bigclient_listModel>();
           string commandtext = "bigclientByOK_Select";
           SqlParameter ok = new SqlParameter("@bigclient_state", SqlDbType.Char, 10);
           ok.Value = bigclient_state;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { ok });
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.BigCustomers.bigclient_listModel inf = new Model.BigCustomers.bigclient_listModel();
               inf.bigclient_id = item["bigclient_id"].ToString().Trim();
               inf.Product_id = item["Product_id"].ToString();
               inf.bigclient_lis_size1 = (int)item["bigclient_lis_size1"];
               inf.bigclient_lis_size2 = (int)item["bigclient_lis_size2"];
               inf.bigclient_lis_size3 = (int)item["bigclient_lis_size3"];
               inf.bigclient_lis_size4 = (int)item["bigclient_lis_size4"];
               inf.bigclient_lis_size5 = (int)item["bigclient_lis_size5"];
               inf.bigclient_lis_size6 = (int)item["bigclient_lis_size6"];
               inf.bigclient_lis_size7 = (int)item["bigclient_lis_size7"];
               inf.bigclient_list_price = (decimal)item["bigclient_list_price"];
               inf.bigclient_list_color = item["bigclient_list_color"].ToString();
               list.Add(inf);
           }
           return list;
       }
       #endregion

       #region 查询大客户销售单据ID
       /// <summary>
       ///  查询大客户销售单据ID
       /// </summary>
       /// <returns></returns>
       public List<Model.BigCustomers.bigclientModel> Selectbigclient_id()
       {
           List<Model.BigCustomers.bigclientModel> li = new List<Model.BigCustomers.bigclientModel>();
           string commandtext = "bigclient_id_Select";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.BigCustomers.bigclientModel inf = new Model.BigCustomers.bigclientModel();
               inf.bigclient_id = dr["bigclient_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 大客户销售单据信息
       /// <summary>
       /// 大客户销售单据信息
       /// </summary>
       /// <returns></returns>
       public List<Model.BigCustomers.bigclientModel> bigclientSelectByWhere()
       {
           List<Model.BigCustomers.bigclientModel> li = new List<Model.BigCustomers.bigclientModel>();
           string commandtext = "bigclient_Select";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.BigCustomers.bigclientModel inf = new Model.BigCustomers.bigclientModel();
               inf.bigclient_id = item["bigclient_id"].ToString().Trim();
               inf.Employee_ID = item["Employee_ID"].ToString().Trim();
               inf.bigclient_type_id = item["bigclient_type_id"].ToString();
               inf.bigclient_type_name = item["bigclient_type_name"].ToString();
               inf.bigclient_price = (decimal )item["bigclient_price"];
               inf.bigclient_sum = (int)item["bigclient_sum"];
               inf.bigclient_time = (DateTime)item["bigclient_time"];
               inf.bigclient_client = item["bigclient_client"].ToString ();
               inf.bigclient_assessor = item["bigclient_assessor"].ToString ();
               inf.bigclient_advice=item["bigclient_advice"].ToString();
               inf.bigclient_state=item["bigclient_state"].ToString ();
               li.Add(inf);
           }
           return li;
       }
       #endregion

       #region 删除未通过审核的销售单据
       /// <summary>
       /// 删除未通过审核的销售单据
       /// </summary>
       /// <param name="stockformid">采购单据编号</param>
       /// <param name="stockstatus">采购状态</param>
       /// <returns>返回删除大客户销售单据影响的行数</returns>
       public int bigclientDelete(string bigclient_id, string bigclient_state)
       {
           string com = "bigclient_Delete";
           SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
           SqlParameter status = new SqlParameter("@bigclient_state", SqlDbType.VarChar, 10);
           id.Value = bigclient_id;
           status.Value = bigclient_state;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id, status });
       }
       #endregion
    }
}