invoicedal.cs

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

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

namespace DAL.Invoice
{
   public class InvoiceDal
    {
       /// <summary>
       /// 添加发货单据（总单）
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <param name="invoice_type_name"></param>
       /// <param name="Employee_Name"></param>
       /// <param name="invoice_go"></param>
       /// <param name="invoice_tos"></param>
       /// <param name="invoice_time"></param>
       /// <param name="invoice_advice"></param>
       /// <param name="invoice_state"></param>
       /// <param name="invoice_allsum"></param>
       /// <returns></returns>
       public int InvoiceAdd(string invoice_id, string invoice_type_name, string Employee_Name, string Employee_NameCheck, DateTime invoice_time, string invoice_advice, string invoice_state, int invoice_allsum)
        {
            string commandtext = "InvoiceAdd";
            SqlParameter xinvoice_id = new SqlParameter("@invoice_id", SqlDbType.Char, 20);
            SqlParameter xinvoice_type_name = new SqlParameter("@invoice_type_name", SqlDbType.VarChar, 10);
            SqlParameter xEmployee_Name = new SqlParameter("@Employee_Name", SqlDbType.Char, 20);
            SqlParameter xEmployee_NameCheck = new SqlParameter("@Employee_NameCheck", SqlDbType.Char, 20);
            SqlParameter xinvoice_time = new SqlParameter("@invoice_time", SqlDbType.DateTime);
            SqlParameter xinvoice_advice = new SqlParameter("@invoice_advice", SqlDbType.Text);
            SqlParameter xinvoice_state = new SqlParameter("@invoice_state", SqlDbType.VarChar, 10);
            SqlParameter xinvoice_allsum = new SqlParameter("@invoice_allsum", SqlDbType.Int);
            xinvoice_id.Value = invoice_id;
            xinvoice_type_name.Value = invoice_type_name;
            xEmployee_Name.Value = Employee_Name;
            xEmployee_NameCheck.Value = Employee_NameCheck;
            xinvoice_time.Value = invoice_time;
            xinvoice_advice.Value = invoice_advice;
            xinvoice_state.Value = invoice_state;
            xinvoice_allsum.Value = invoice_allsum;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xinvoice_id,xinvoice_type_name,xEmployee_Name,xEmployee_NameCheck,xinvoice_time,xinvoice_advice,xinvoice_state,xinvoice_allsum });
        }
       /// <summary>
       /// 添加发货单据（详细）
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <param name="invoice_list_product_id"></param>
       /// <param name="invoice_list_color"></param>
       /// <param name="invoice_lis_size1"></param>
       /// <param name="invoice_lis_size2"></param>
       /// <param name="invoice_lis_size3"></param>
       /// <param name="invoice_lis_size4"></param>
       /// <param name="invoice_lis_size5"></param>
       /// <param name="invoice_lis_size6"></param>
       /// <param name="invoice_lis_size7"></param>
       /// <param name="invoice_lis_sum"></param>
       /// <param name="invoice_store"></param>
       /// <returns></returns>
       public int InvoiceAddList(string invoice_id, string invoice_list_product_id, string invoice_list_color, int invoice_lis_size1, int invoice_lis_size2, int invoice_lis_size3, int invoice_lis_size4, int invoice_lis_size5, int invoice_lis_size6, int invoice_lis_size7, int invoice_lis_sum, int invoice_store, int invoice_storeto)
        {
            string commandtext = "InvoiceAddList";
            SqlParameter xinvoice_id = new SqlParameter("@invoice_id", SqlDbType.Char, 20);
            SqlParameter xinvoice_list_product_id = new SqlParameter("@invoice_list_product_id", SqlDbType.Char, 20);
            SqlParameter xinvoice_list_color = new SqlParameter("@invoice_list_color", SqlDbType.VarChar, 10);
            SqlParameter xinvoice_lis_size1 = new SqlParameter("@invoice_lis_size1", SqlDbType.Int);
            SqlParameter xinvoice_lis_size2 = new SqlParameter("@invoice_lis_size2", SqlDbType.Int);
            SqlParameter xinvoice_lis_size3 = new SqlParameter("@invoice_lis_size3", SqlDbType.Int);
            SqlParameter xinvoice_lis_size4 = new SqlParameter("@invoice_lis_size4", SqlDbType.Int);
            SqlParameter xinvoice_lis_size5 = new SqlParameter("@invoice_lis_size5", SqlDbType.Int);
            SqlParameter xinvoice_lis_size6 = new SqlParameter("@invoice_lis_size6", SqlDbType.Int);
            SqlParameter xinvoice_lis_size7 = new SqlParameter("@invoice_lis_size7", SqlDbType.Int);
            SqlParameter xinvoice_lis_sum = new SqlParameter("@invoice_lis_sum", SqlDbType.Int);
            SqlParameter xinvoice_store = new SqlParameter("@invoice_store",SqlDbType.Int);
            SqlParameter xinvoice_storeto = new SqlParameter("@invoice_storeto", SqlDbType.Int);
            xinvoice_id.Value = invoice_id;
            xinvoice_list_product_id.Value = invoice_list_product_id;
            xinvoice_list_color.Value = invoice_list_color;
            xinvoice_lis_size1.Value = invoice_lis_size1;
            xinvoice_lis_size2.Value = invoice_lis_size2;
            xinvoice_lis_size3.Value = invoice_lis_size3;
            xinvoice_lis_size4.Value = invoice_lis_size4;
            xinvoice_lis_size5.Value = invoice_lis_size5;
            xinvoice_lis_size6.Value = invoice_lis_size6;
            xinvoice_lis_size7.Value = invoice_lis_size7;
            xinvoice_lis_sum.Value = invoice_lis_sum;
            xinvoice_store.Value = invoice_store;
            xinvoice_storeto.Value = invoice_storeto;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xinvoice_id, xinvoice_list_product_id, xinvoice_list_color, xinvoice_lis_size1, xinvoice_lis_size2, xinvoice_lis_size3, xinvoice_lis_size4, xinvoice_lis_size5, xinvoice_lis_size6, xinvoice_lis_size7, xinvoice_lis_sum, xinvoice_store, xinvoice_storeto });
        }
       /// <summary>
       /// 获取单据类型名称
       /// </summary>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceTypeSelect()
       {
           string commandtext = "InvoiceTypeSelect";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_type_name = dr["invoice_type_name"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 获取总部发（退）货"未通过"状态的单据
       /// </summary>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceInsetDDL()
       {
           string commandtext = "InvoiceInsetDDL";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_id = dr["invoice_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 获取总部发（退）货"通过"状态的单据
       /// </summary>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceInsetDDLOK()
       {
           string commandtext = "InvoiceInsetDDLOK";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_id = dr["invoice_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 审批—获取单据的类型和时间
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceTimeType(string invoice_id)
       {
           string commandtext = "InvoiceSelect";
           SqlParameter xinvoice_id = new SqlParameter("@invoice_id",SqlDbType.Char,20);
           xinvoice_id.Value = invoice_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xinvoice_id });
           List<Model.Invoice.InvoiceModel> li = new List<Model.Invoice.InvoiceModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Invoice.InvoiceModel inf = new Model.Invoice.InvoiceModel();
               inf.invoice_type_name = dr["invoice_type_name"].ToString();
               inf.invoice_time = (DateTime)dr["invoice_time"];
               inf.Employee_Name = dr["Employee_Name"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 通过单据ID，获取单据详细
       /// </summary>
       /// <param name="invoice_id"></param>
       /// <returns></returns>
       public List<Model.Invoice.InvoiceModel> InvoiceSelectList(string invoice_id)
       {
           string commandtext = "InvoiceSelectList";
           SqlParameter xinvoice_id = new SqlParameter("@invoice_id", SqlDbType.Char, 20);
           xinvoice_id.Value = invoice_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xinvoice_id });