venditiondal.cs

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

           {
               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> SelectBranchSaleShopname(string shop_name)
       {
           string commandtext = "Select_BranchSale_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)
           {
               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.info_price = (decimal)item["info_price"];
               SelectBranch.info_allprice = (decimal)item["info_allprice"];
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 分店明细销售通过商品名称查询
       /// <summary>
       /// 分店销售通过商品名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchsaleproductnames(string info_name)
       {
           string commandtext = "Branch_productname_Select";
           SqlParameter infoname = new SqlParameter("@info_name", SqlDbType.VarChar, 30);
           infoname.Value = info_name;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { infoname });
           List<Model.Branch.VenditionModel> BranchReturns = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel SelectBranchs = new Model.Branch.VenditionModel();
               SelectBranchs.Shop_name = item["Shop_name"].ToString();
               SelectBranchs.info_productID = item["info_productID"].ToString();
               SelectBranchs.info_name = item["info_name"].ToString();
               SelectBranchs.vendition_id = item["vendition_id"].ToString();
               SelectBranchs.info_size1 = (int)item["info_size1"];
               SelectBranchs.info_size2 = (int)item["info_size2"];
               SelectBranchs.info_size3 = (int)item["info_size3"];
               SelectBranchs.info_size4 = (int)item["info_size4"];
               SelectBranchs.info_size5 = (int)item["info_size5"];
               SelectBranchs.info_size6 = (int)item["info_size6"];
               SelectBranchs.info_size7 = (int)item["info_size7"];
               SelectBranchs.info_color = item["info_color"].ToString();
               SelectBranchs.Employee_ID = item["Employee_ID"].ToString();
               SelectBranchs.info_sum = (int)item["info_sum"];
               SelectBranchs.vendition_time = (DateTime)item["vendition_time"];
               SelectBranchs.info_price = (decimal)item["info_price"];
               SelectBranchs.info_allprice = (decimal)item["info_allprice"];
               BranchReturns.Add(SelectBranchs);
           }
           return BranchReturns;
       }
       #endregion

       #region 顾客退货通过分店名称查询
       /// <summary>
       /// 顾客退货通过分店名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectMemberBranchShopname(string shop_name)
       {
           string commandtext = "Select_MemberBranchreturn_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)
           {
               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.info_price = (decimal)item["info_price"];
               SelectBranch.info_allprice = (decimal)item["info_allprice"];
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 顾客退货通过商品名称查询
       /// <summary>
       /// 顾客退货通过商品名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectMemberBranchsaleproductnames(string info_name)
       {
           string commandtext = "MemberBranch_productname_Select";
           SqlParameter infoname = new SqlParameter("@info_name", SqlDbType.VarChar, 30);
           infoname.Value = info_name;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { infoname });
           List<Model.Branch.VenditionModel> BranchReturns = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel SelectBranchs = new Model.Branch.VenditionModel();
               SelectBranchs.Shop_name = item["Shop_name"].ToString();
               SelectBranchs.info_productID = item["info_productID"].ToString();
               SelectBranchs.info_name = item["info_name"].ToString();
               SelectBranchs.vendition_id = item["vendition_id"].ToString();
               SelectBranchs.info_size1 = (int)item["info_size1"];
               SelectBranchs.info_size2 = (int)item["info_size2"];
               SelectBranchs.info_size3 = (int)item["info_size3"];
               SelectBranchs.info_size4 = (int)item["info_size4"];
               SelectBranchs.info_size5 = (int)item["info_size5"];
               SelectBranchs.info_size6 = (int)item["info_size6"];
               SelectBranchs.info_size7 = (int)item["info_size7"];
               SelectBranchs.info_color = item["info_color"].ToString();
               SelectBranchs.Employee_ID = item["Employee_ID"].ToString();
               SelectBranchs.info_sum = (int)item["info_sum"];
               SelectBranchs.vendition_time = (DateTime)item["vendition_time"];
               SelectBranchs.info_price = (decimal)item["info_price"];
               SelectBranchs.info_allprice = (decimal)item["info_allprice"];
               BranchReturns.Add(SelectBranchs);
           }
           return BranchReturns;
       }
       #endregion

       #region 分店退货通过商品名称查询
       /// <summary>
       /// 分店退货通过商品名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchproductnames(string info_name)
       {
           string commandtext = "Select_Branch_productname";
           SqlParameter infoname = new SqlParameter("@info_name", SqlDbType.VarChar, 30);
           infoname.Value = info_name;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { infoname });
           List<Model.Branch.VenditionModel> BranchReturns = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel SelectBranchs = new Model.Branch.VenditionModel();
               SelectBranchs.Shop_name = item["Shop_name"].ToString();
               SelectBranchs.info_productID = item["info_productID"].ToString();
               SelectBranchs.info_name = item["info_name"].ToString();
               SelectBranchs.vendition_id = item["vendition_id"].ToString();
               SelectBranchs.info_size1 = (int)item["info_size1"];
               SelectBranchs.info_size2 = (int)item["info_size2"];
               SelectBranchs.info_size3 = (int)item["info_size3"];
               SelectBranchs.info_size4 = (int)item["info_size4"];
               SelectBranchs.info_size5 = (int)item["info_size5"];
               SelectBranchs.info_size6 = (int)item["info_size6"];
               SelectBranchs.info_size7 = (int)item["info_size7"];
               SelectBranchs.info_color = item["info_color"].ToString();
               SelectBranchs.Employee_ID = item["Employee_ID"].ToString();
               SelectBranchs.info_sum = (int)item["info_sum"];
               SelectBranchs.vendition_time = (DateTime)item["vendition_time"];
               SelectBranchs.vendition_chck_id = item["vendition_chck_id"].ToString();
               SelectBranchs.vendition_ok = item["vendition_ok"].ToString();
               BranchReturns.Add(SelectBranchs);
           }
           return BranchReturns;
       }
       #endregion

       #region 分店销售明细显示
       /// <summary>
       /// 分店销售明细显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchSale()
       {
           string commandtext = "Select_BranchSale";
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           List<Model.Branch.VenditionModel> BranchSale = new List<Model.Branch.VenditionModel>();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               Model.Branch.VenditionModel SelectSale = new Model.Branch.VenditionModel();
               SelectSale.Shop_name = item["Shop_name"].ToString();
               SelectSale.info_productID = item["info_productID"].ToString();
               SelectSale.info_name = item["info_name"].ToString();
               SelectSale.vendition_id = item["vendition_id"].ToString();
               SelectSale.info_size1 = (int)item["info_size1"];
               SelectSale.info_size2 = (int)item["info_size2"];
               SelectSale.info_size3 = (int)item["info_size3"];
               SelectSale.info_size4 = (int)item["info_size4"];
               SelectSale.info_size5 = (int)item["info_size5"];
               SelectSale.info_size6 = (int)item["info_size6"];
               SelectSale.info_size7 = (int)item["info_size7"];
               SelectSale.info_color = item["info_color"].ToString();
               SelectSale.Employee_ID = item["Employee_ID"].ToString();
               SelectSale.info_sum = (int)item["info_sum"];
               SelectSale.info_price = (decimal)item["info_price"];
               SelectSale.info_allprice = (decimal)item["info_allprice"];
               SelectSale.vendition_time = (DateTime)item["vendition_time"];
               BranchSale.Add(SelectSale);
           }
           return BranchSale;
       }
       #endregion

       #region 分店销售显示
       /// <summary>
       /// 分店销售显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectBranchSaleDatil()
       {
           string commandtext = "BranchSale_Select";