venditiondal.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Model;
namespace DAL.Branch
{
   public class VenditionDal
   {
       #region 商品编号在DropDownList里显示
       /// <summary>
       /// 商品编号在DropDownList里显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectMemberID()
       {
           string commandtext = "Select_ProductID";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Branch.VenditionModel> memberid = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel member = new Model.Branch.VenditionModel();
               member.Product_id = item["Product_id"].ToString();
               memberid.Add(member);
           }
           return memberid;
       }
       #endregion

       #region 商品颜色在DropDownList里显示
       /// <summary>
       /// 商品颜色在DropDownList里显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectProductColor()
       {
           string commandtext = "Select_ProductColor";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Branch.VenditionModel> productcolor = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel color = new Model.Branch.VenditionModel();
               color.ProductType_color = item["ProductType_color"].ToString();
               productcolor.Add(color);
           }
           return productcolor;
       }
       #endregion

       #region 添加销售单据(总单)
       public int VenditionInsert(string vendition_id, int Shop_id,string member_id, string vendition_type_name, string Employee_ID, DateTime vendition_time, int vendition_sum, decimal vendition_sumprice, string vendition_chck_id, string vendition_ok)
       {
           string commandtext = "VenditionInsert";
           SqlParameter xvendition_id = new SqlParameter("@vendition_id",SqlDbType.Char,20);
           xvendition_id.Value = vendition_id;
           SqlParameter shopid = new SqlParameter("@Shop_id", SqlDbType.Int);
           shopid.Value = Shop_id;
           SqlParameter memberid = new SqlParameter("@Member_ID", SqlDbType.VarChar, 18);
           memberid.Value = member_id;
           SqlParameter venditiontypename=new SqlParameter("@vendition_type_name",SqlDbType.VarChar,10);
           venditiontypename.Value = vendition_type_name;
           SqlParameter EmployeeID = new SqlParameter("@Employee_ID", SqlDbType.VarChar, 20);
           EmployeeID.Value = Employee_ID;
           SqlParameter venditiontime = new SqlParameter("@vendition_time", SqlDbType.DateTime);
           venditiontime.Value = vendition_time;
           SqlParameter venditionsum = new SqlParameter("@vendition_sum", SqlDbType.Int);
           venditionsum.Value = vendition_sum;
           SqlParameter venditionsumprice = new SqlParameter("@vendition_sumprice", SqlDbType.Decimal);
           venditionsumprice.Value = vendition_sumprice;
           SqlParameter xvendition_chck_id = new SqlParameter("@vendition_chck_id",SqlDbType.VarChar,20);
           xvendition_chck_id.Value = vendition_chck_id;
           SqlParameter xvendition_ok = new SqlParameter("@vendition_ok",SqlDbType.VarChar,20);
           xvendition_ok.Value = vendition_ok;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xvendition_id, shopid,memberid, venditiontypename, EmployeeID, venditiontime, venditionsum, venditionsumprice, xvendition_chck_id, xvendition_ok });
       }
       #endregion

       #region 添加销售单据(详细)
       public int VenditionInsertList(string vendition_id, string info_productID, string info_color, int info_size1, int info_size2, int info_size3, int info_size4, int info_size5, int info_size6, int info_size7, int info_sum, string info_name, decimal info_price, decimal info_allprice)
       {
           string commandtext = "VenditionInsertList";
           SqlParameter xvendition_id = new SqlParameter("@vendition_id",SqlDbType.Char,20);
           xvendition_id.Value = vendition_id;
           SqlParameter xinfo_productID = new SqlParameter("@info_productID",SqlDbType.Char,20);
           xinfo_productID.Value = info_productID;
           SqlParameter xinfo_color = new SqlParameter("@info_color",SqlDbType.VarChar,10);
           xinfo_color.Value = info_color;
           SqlParameter xinfo_size1 = new SqlParameter("@info_size1",SqlDbType.Int);
           xinfo_size1.Value = info_size1;
           SqlParameter xinfo_size2 = new SqlParameter("@info_size2", SqlDbType.Int);
           xinfo_size2.Value = info_size2;
           SqlParameter xinfo_size3 = new SqlParameter("@info_size3", SqlDbType.Int);
           xinfo_size3.Value = info_size3;
           SqlParameter xinfo_size4 = new SqlParameter("@info_size4", SqlDbType.Int);
           xinfo_size4.Value = info_size4;
           SqlParameter xinfo_size5 = new SqlParameter("@info_size5", SqlDbType.Int);
           xinfo_size5.Value = info_size5;
           SqlParameter xinfo_size6 = new SqlParameter("@info_size6", SqlDbType.Int);
           xinfo_size6.Value = info_size6;
           SqlParameter xinfo_size7 = new SqlParameter("@info_size7", SqlDbType.Int);
           xinfo_size7.Value = info_size7;
           SqlParameter xinfo_sum = new SqlParameter("@info_sum",SqlDbType.Int);
           xinfo_sum.Value = info_sum;
           SqlParameter xinfo_name = new SqlParameter("@info_name",SqlDbType.VarChar,30);
           xinfo_name.Value = info_name;
           SqlParameter xinfo_price = new SqlParameter("@info_price",SqlDbType.Decimal);
           xinfo_price.Value = info_price;
           SqlParameter xinfo_allprice = new SqlParameter("@info_allprice",SqlDbType.Decimal);
           xinfo_allprice.Value = info_allprice;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xvendition_id, xinfo_productID, xinfo_color, xinfo_size1, xinfo_size2, xinfo_size3, xinfo_size4, xinfo_size5, xinfo_size6, xinfo_size7, xinfo_sum, xinfo_name, xinfo_price, xinfo_allprice });
       }
       #endregion

       #region 获取单据类型名称
       public List<Model.Branch.VenditionModel> VenditionSelectType()
       {
           
           string commandtext = "VenditionSelectType";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Branch.VenditionModel> typename = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel mo = new Model.Branch.VenditionModel();
               mo.vendition_type_id = item["vendition_type_name"].ToString();
               typename.Add(mo);
           }
           return typename;
       }
       #endregion

       #region 添加退货单据
       /// <summary>
       /// 添加退货单据
       /// </summary>
       /// <param name="vendition_id">单据编号</param>
       /// <param name="shop_id">店铺编号</param>
       /// <param name="vendition_type_name">类型</param>
       /// <param name="Employee_ID">操作人</param>
       /// <param name="vendition_time">操作时间</param>
       /// <param name="vendition_sum">总数量</param>
       /// <returns>返回添加退货单据影响的行数</returns>
       public int VenditionAdd(string vendition_id, int shop_id, string vendition_type_name, string Employee_ID, DateTime vendition_time, int vendition_sum, string vendition_ok)
       {
           string ven = "VenditionBack_Add";
           SqlParameter id = new SqlParameter("@vendition_id", SqlDbType.VarChar, 20);
           id.Value = vendition_id;
           SqlParameter sid = new SqlParameter("@Shop_id", SqlDbType.Int);
           sid.Value = shop_id;
           SqlParameter tid = new SqlParameter("@vendition_type_name", SqlDbType.VarChar, 10);
           tid.Value = vendition_type_name;
           SqlParameter na = new SqlParameter("@Employee_ID", SqlDbType.VarChar, 20);
           na.Value = Employee_ID;
           SqlParameter sna = new SqlParameter("@vendition_time", SqlDbType.DateTime);
           sna.Value = vendition_time;
           SqlParameter ti = new SqlParameter("@vendition_sum", SqlDbType.Int);
           ti.Value = vendition_sum;
           SqlParameter ok = new SqlParameter("@vendition_ok",SqlDbType.VarChar ,20);
           ok.Value = vendition_ok;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, ven, new SqlParameter[] { id, sid, tid, na, sna, ti,ok });
       }
       #endregion

       #region  查找“未通过”审核的分店退货单据编号
       /// <summary>
       /// 查找“未通过”审核的分店退货单据编号
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectvenditionID(string vendition_ok)
       {
           string commandtext = "venditionByState_Select";
           SqlParameter name = new SqlParameter("@vendition_ok", SqlDbType.VarChar, 20);
           name.Value = vendition_ok;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter []{name});
           List<Model.Branch.VenditionModel> memberid = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel member = new Model.Branch.VenditionModel();
               member.vendition_id = item["vendition_id"].ToString();
               memberid.Add(member);
           }
           return memberid;
       }
       #endregion

       #region 修改分店退货单据(审核)
       /// <summary>
       /// 修改分店退货单据(审核)
       /// </summary>
       /// <param name="vendition_id">单据编号</param>
       /// <param name="vendition_chck_id">审核人</param>
       /// <param name="vendition_ok">审核状态</param>
       /// <returns>返回修改退货单据影响的行数</returns>
       public List<Model.Branch.VenditionModel> venditionUpdate(string vendition_id, string vendition_chck_id, string vendition_ok)
       {
           List<Model.Branch.VenditionModel> list = new List<Model.Branch.VenditionModel>();
           string commandtext = "vendition_Update";
           SqlParameter sid = new SqlParameter("@vendition_id", SqlDbType.VarChar, 50);
           SqlParameter empid = new SqlParameter("@vendition_chck_id", SqlDbType.VarChar, 20);
           SqlParameter ok = new SqlParameter("@vendition_ok", SqlDbType.VarChar, 20);
           sid.Value = vendition_id;
           empid.Value = vendition_chck_id;
           ok.Value = vendition_ok;
           SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { sid, empid, ok });
           return list;
       }
       #endregion

       #region 分店向总部退货显示
       /// <summary>
       /// 分店向总部退货显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchReturn()
       {
           string commandtext = "Select_BranchReturn";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Branch.VenditionModel> BranchReturn = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel SelectBranch = new Model.Branch.VenditionModel();
               SelectBranch.Shop_name = item["Shop_name"].ToString();
               SelectBranch.info_productID = item["info_productID"].ToString();
               SelectBranch.info_name = item["info_name"].ToString();
               SelectBranch.vendition_id = item["vendition_id"].ToString();
               SelectBranch.info_size1 = (int)item["info_size1"];
               SelectBranch.info_size2 = (int)item["info_size2"];
               SelectBranch.info_size3 = (int)item["info_size3"];
               SelectBranch.info_size4 = (int)item["info_size4"];
               SelectBranch.info_size5 = (int)item["info_size5"];
               SelectBranch.info_size6 = (int)item["info_size6"];
               SelectBranch.info_size7 = (int)item["info_size7"];
               SelectBranch.info_color = item["info_color"].ToString();
               SelectBranch.Employee_ID = item["Employee_ID"].ToString();
               SelectBranch.info_sum = (int)item["info_sum"];
               SelectBranch.vendition_time = (DateTime)item["vendition_time"];
               SelectBranch.vendition_chck_id = item["vendition_chck_id"].ToString();
               SelectBranch.vendition_ok = item["vendition_ok"].ToString();
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 分店退货通过分店名称查询
       /// <summary>
       /// 分店退货通过分店名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchShopname(string shop_name)
       {
           string commandtext = "Select_Branch_Shopname";
           SqlParameter Shopname = new SqlParameter("@shop_name",SqlDbType.VarChar,20);
           Shopname.Value = shop_name;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { Shopname });
           List<Model.Branch.VenditionModel> BranchReturn = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)