venditiondal.cs

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

           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.vendition_id = item["vendition_id"].ToString();
               SelectSale.Shop_name = item["Shop_name"].ToString();
               //SelectSale.info_productID = item["info_productID"].ToString();
               //SelectSale.info_name = item["info_name"].ToString();
               SelectSale.Employee_ID = item["Employee_ID"].ToString();
               SelectSale.vendition_sum = (int)item["vendition_sum"];
               //SelectSale.info_price = (decimal)item["info_price"];
               SelectSale.vendition_sumprice = (decimal)item["vendition_sumprice"];
               SelectSale.vendition_time = (DateTime)item["vendition_time"];
               BranchSale.Add(SelectSale);
           }
           return BranchSale;
       }
       #endregion

       #region 分店销售通过分店名称查询
       /// <summary>
       /// 分店销售通过分店名称查询
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> BranchSaleShopnameSelect(string shop_name)
       {
           string commandtext = "BranchSale_Shopname_Select";
           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.vendition_id = item["vendition_id"].ToString();
               SelectBranch.Shop_name = item["Shop_name"].ToString();
               //SelectSale.info_productID = item["info_productID"].ToString();
               //SelectSale.info_name = item["info_name"].ToString();
               SelectBranch.Employee_ID = item["Employee_ID"].ToString();
               SelectBranch.vendition_sum = (int)item["vendition_sum"];
               //SelectSale.info_price = (decimal)item["info_price"];
               SelectBranch.vendition_sumprice = (decimal)item["vendition_sumprice"];
               SelectBranch.vendition_time = (DateTime)item["vendition_time"];
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 顾客退货显示
       /// <summary>
       /// 顾客退货显示
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> SelectMemberReturn()
       {
           string commandtext = "Select_MemberReturn";
           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> venditionByIDSelect(string vid)
       {
           string commandtext = "venditionByID_Select";
           SqlParameter id = new SqlParameter("@vendition_id", SqlDbType.VarChar, 50);
           id.Value = vid;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
           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.vendition_id = item["vendition_id"].ToString();
               SelectBranch.info_productID = item["info_productID"].ToString();
               SelectBranch.Shop_id =(int)item["Shop_id"];
               SelectBranch.info_color = item["info_color"].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_sum = (int)item["info_sum"];
               SelectBranch.info_name = item["info_name"].ToString();
               SelectBranch.info_price = (decimal)item["info_price"];
               SelectBranch.info_allprice = (decimal)item["info_allprice"];
               SelectBranch.Member_ID = item["Member_ID"].ToString();
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 查选出“已出库”的会员退货单号
       /// <summary>
       /// 查选出“已出库”的会员退货单号
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> vendition_idByOKaType_Select( string type_name, string vendition_ok)
       {
           string commandtext = "vendition_idByOKaType_Select";
           SqlParameter type = new SqlParameter("@vendition_type_name", SqlDbType.VarChar, 10);
           type.Value = type_name;
           SqlParameter ok = new SqlParameter("@vendition_ok", SqlDbType.VarChar, 20);
           ok.Value = vendition_ok;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { type,ok });
           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.vendition_id = item["vendition_id"].ToString();
               BranchReturn.Add(SelectBranch);
           }
           return BranchReturn;
       }
       #endregion

       #region 修改分店退货单据(退货)
       public List<Model.Branch.VenditionModel> venditionbyidUpdate(string vendition_id, string vendition_type_name,DateTime vendition_time,int vendition_sum,decimal vendition_sumprice,string vendition_ok, string other)
       {
           List<Model.Branch.VenditionModel> list = new List<Model.Branch.VenditionModel>();
           string commandtext = "venditionByID_Update";
           SqlParameter sid = new SqlParameter("@vendition_id", SqlDbType.VarChar, 50);
           SqlParameter type = new SqlParameter("@vendition_type_name", SqlDbType.VarChar, 20);
           SqlParameter time = new SqlParameter("@vendition_time", SqlDbType.DateTime);
           SqlParameter sum = new SqlParameter("@vendition_sum", SqlDbType.Int);
           SqlParameter sumprice = new SqlParameter("@vendition_sumprice", SqlDbType.Decimal);
           SqlParameter ok = new SqlParameter("@vendition_ok", SqlDbType.VarChar, 20);
           SqlParameter oth = new SqlParameter("@other", SqlDbType.VarChar, 20);
           sid.Value = vendition_id;
           type.Value = vendition_type_name;
           time.Value = vendition_time;
           sum.Value = vendition_sum;
           sumprice.Value = vendition_sumprice;
           ok.Value = vendition_ok;
           oth.Value = other;
           SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { sid, type,time,sum,sumprice, ok, oth });
           return list;
       }
       #endregion

       #region 修改分店退货详细(退货)
       public List<Model.Branch.VenditionModel> vendition_infoByID_Update(string vendition_id, int info_size1, int info_size2, int info_size3, int info_size4, int info_size5, int info_size6, int info_size7, int info_sum, decimal info_allprice)
       {
           List<Model.Branch.VenditionModel> list = new List<Model.Branch.VenditionModel>();
           string commandtext = "vendition_infoByID_Update";
           SqlParameter sid = new SqlParameter("@vendition_id", SqlDbType.VarChar, 50);
           sid.Value = vendition_id;
           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_allprice = new SqlParameter("@info_allprice", SqlDbType.Decimal);
           xinfo_allprice.Value = info_allprice;
           SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { sid, xinfo_size1, xinfo_size2, xinfo_size3, xinfo_size4, xinfo_size5, xinfo_size6, xinfo_size7, xinfo_sum, xinfo_allprice });
           return list;
       }
       #endregion

       #region 查询分店退货单号
       /// <summary>
       ///  查询分店退货单号
       /// </summary>
       /// <returns></returns>
       public List<Model.Branch.VenditionModel> vendition_id_Select()
       {
           string commandtext = "vendition_id_Select";
          
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
           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.vendition_id = item["vendition_id"].ToString();
               BranchReturns.Add(SelectBranchs);
           }
           return BranchReturns;
       }
       #endregion

       #region 通过单号，店铺，会员编号，类型，状态查询销售总数量
       /// <summary>
       /// 通过单号，店铺，会员编号，类型，状态查询销售总数量
       /// </summary>
       /// <param name="vendition_id">单号</param>
       /// <param name="Shop_id">店铺</param>
       /// <param name="member_id"会员编号></param>
       /// <param name="vendition_type_name">类型</param>
       /// <param name="vendition_ok">状态</param>
       /// <returns></returns>
       public Model.Branch.VenditionModel venditionByMore_Select(string vendition_id, int Shop_id, string member_id, string vendition_type_name, string vendition_ok)
       {
           string commandtext = "venditionByMore_Select";
           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 xvendition_ok = new SqlParameter("@vendition_ok", SqlDbType.VarChar, 20);
           xvendition_ok.Value = vendition_ok;
           DataSet ds = new DataSet();
           SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xvendition_id, shopid, memberid, venditiontypename, xvendition_ok });
           Model.Branch.VenditionModel SelectBranchs = new Model.Branch.VenditionModel();
           foreach (DataRow item in ds.Tables[0].Rows)
           {
               SelectBranchs.vendition_sum = (int)item["vendition_sum"];
           }
           return SelectBranchs;
       }
       #endregion
   }
}