removedal.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.Remove
{
   public class RemoveDal
    {
       /// <summary>
       /// 添加调拨申请单
       /// </summary>
       /// <param name="remove_id"></param>
       /// <param name="remove_pname"></param>
       /// <param name="remove_go"></param>
       /// <param name="remove_to"></param>
       /// <param name="remove_time"></param>
       /// <param name="remove_assessor"></param>
       /// <param name="remove_advice"></param>
       /// <param name="remove_state"></param>
       /// <param name="remove_allsum"></param>
       /// <returns></returns>
       public int Insetremove(string remove_id, string remove_pname, string remove_go, string remove_to, DateTime remove_time, string remove_assessor, string remove_advice, string remove_state, int remove_allsum)
       {
           string commandtext = "RemoveAdd";
           SqlParameter xremove_id = new SqlParameter("@remove_id",SqlDbType.Char,20);
           SqlParameter xremove_pname = new SqlParameter("@remove_pname",SqlDbType.Char,20);
           SqlParameter xremove_go = new SqlParameter("@remove_go",SqlDbType.Char,5);
           SqlParameter xremove_to = new SqlParameter("@remove_to",SqlDbType.Char,5);
           SqlParameter xremove_time = new SqlParameter("@remove_time",SqlDbType.DateTime);
           SqlParameter xremove_assessor = new SqlParameter("@remove_assessor",SqlDbType.VarChar,10);
           SqlParameter xremove_advice = new SqlParameter("@remove_advice",SqlDbType.Text);
           SqlParameter xremove_state = new SqlParameter("@remove_state",SqlDbType.VarChar,10);
           SqlParameter xremove_allsum = new SqlParameter("@remove_allsum",SqlDbType.Int);
           xremove_id.Value = remove_id;
           xremove_pname.Value = remove_pname;
           xremove_go.Value = remove_go;
           xremove_to.Value = remove_to;
           xremove_time.Value = remove_time;
           xremove_assessor.Value = remove_assessor;
           xremove_advice.Value = remove_advice;
           xremove_state.Value = remove_state;
           xremove_allsum.Value = remove_allsum;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xremove_id, xremove_pname, xremove_go, xremove_to, xremove_time, xremove_assessor, xremove_advice, xremove_state, xremove_allsum });
       }
       /// <summary>
       /// 添加调拨申请单(明细)
       /// </summary>
       /// <param name="remove_id"></param>
       /// <param name="product_id"></param>
       /// <param name="remove_list_color"></param>
       /// <param name="remove_list_size1"></param>
       /// <param name="remove_list_size2"></param>
       /// <param name="remove_list_size3"></param>
       /// <param name="remove_list_size4"></param>
       /// <param name="remove_list_size5"></param>
       /// <param name="remove_list_size6"></param>
       /// <param name="remove_list_size7"></param>
       /// <param name="remove_list_sum"></param>
       /// <returns></returns>
       public int InsetremoveList(string remove_id, string product_id, string remove_list_color, int remove_list_size1, int remove_list_size2, int remove_list_size3, int remove_list_size4, int remove_list_size5, int remove_list_size6, int remove_list_size7, int remove_list_sum)
       {
           string commandtext = "RemoveAddList";
           SqlParameter xremove_id = new SqlParameter("@remove_id", SqlDbType.Char, 20);
           SqlParameter xproduct_id = new SqlParameter("@Product_id", SqlDbType.Char, 20);
           SqlParameter xremove_list_color = new SqlParameter("@remove_list_color", SqlDbType.Char, 10);
           SqlParameter xremove_list_size1 = new SqlParameter("@remove_list_size1",SqlDbType.Int);
           SqlParameter xremove_list_size2 = new SqlParameter("@remove_list_size2", SqlDbType.Int);
           SqlParameter xremove_list_size3 = new SqlParameter("@remove_list_size3", SqlDbType.Int);
           SqlParameter xremove_list_size4 = new SqlParameter("@remove_list_size4", SqlDbType.Int);
           SqlParameter xremove_list_size5 = new SqlParameter("@remove_list_size5", SqlDbType.Int);
           SqlParameter xremove_list_size6 = new SqlParameter("@remove_list_size6", SqlDbType.Int);
           SqlParameter xremove_list_size7 = new SqlParameter("@remove_list_size7", SqlDbType.Int);
           SqlParameter xremove_list_sum = new SqlParameter("@remove_list_sum", SqlDbType.Int);
           xremove_id.Value = remove_id;
           xproduct_id.Value = product_id;
           xremove_list_color.Value = remove_list_color;
           xremove_list_size1.Value = remove_list_size1;
           xremove_list_size2.Value = remove_list_size2;
           xremove_list_size3.Value = remove_list_size3;
           xremove_list_size4.Value = remove_list_size4;
           xremove_list_size5.Value = remove_list_size5;
           xremove_list_size6.Value = remove_list_size6;
           xremove_list_size7.Value = remove_list_size7;
           xremove_list_sum.Value = remove_list_sum;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xremove_id, xproduct_id, xremove_list_color, xremove_list_size1, xremove_list_size2, xremove_list_size3, xremove_list_size4, xremove_list_size5, xremove_list_size6, xremove_list_size7, xremove_list_sum });
       }
       /// <summary>
       /// 获得调拨未通过申请单
       /// </summary>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> SelectRemoveID()
       {
           string commandtext = "RemoveInsetDDL";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_id = dr["remove_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 获得调拨通过申请单
       /// </summary>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> SelectRemoveIDok()
       {
           string commandtext = "RemoveInsetDDLok";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_id = dr["remove_id"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 获得调拨申请单部分信息
       /// </summary>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> SelectRemove(string remove_id)
       {
           string commandtext = "RemoveSelec";
           SqlParameter xremove_id = new SqlParameter("@remove_id",SqlDbType.Char,20);
           xremove_id.Value = remove_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xremove_id });
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow dr in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel inf = new Model.Remove.RemoveModel();
               inf.remove_pname = dr["remove_pname"].ToString();
               inf.remove_time = (DateTime)dr["remove_time"];
               inf.remove_go = dr["remove_go"].ToString();
               inf.remove_to = dr["remove_to"].ToString();
               li.Add(inf);
           }
           return li;
       }
       /// <summary>
       /// 获得调拨申请单详细（调拨单ID）
       /// </summary>
       /// <param name="remove_id"></param>
       /// <returns></returns>
       public List<Model.Remove.RemoveModel> SelectRemoveList(string remove_id)
       {
           string commandtext = "RemoveSelectList";
           SqlParameter xremove_id = new SqlParameter("@remove_id",SqlDbType.Char,20);
           xremove_id.Value = remove_id;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xremove_id });
           List<Model.Remove.RemoveModel> li = new List<Model.Remove.RemoveModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Remove.RemoveModel mo = new Model.Remove.RemoveModel();
               mo.Product_id = item["Product_id"].ToString();
               mo.remove_list_color = item["remove_list_color"].ToString();
               mo.remove_list_size1 = (int)item["remove_list_size1"];
               mo.remove_list_size2 = (int)item["remove_list_size2"];
               mo.remove_list_size3 = (int)item["remove_list_size3"];
               mo.remove_list_size4 = (int)item["remove_list_size4"];