stockformdal.cs

来自「c#三层架构项目开发的全过程」· CS 代码 · 共 235 行

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

namespace DAL.Stock
{
    public class StockFormDal
    {
        #region 添加采购单据
        /// <summary>
        /// 添加采购单据
        /// </summary>
        /// <param name="stockform_id">采购单据编号</param>
        /// <param name="stockask_roleid">采购人ID</param>
        /// <param name="stock_type_id">采购类型ID</param>
        /// <param name="stockform_totalnum">采购总数量</param>
        /// <param name="stockform_tradeprice">采购交易价格</param>
        /// <param name="stockform_oktext">采购审核</param>
        /// <param name="stockform_time">采购时间</param>
        /// <returns>返回添加采购单据影响的行数</returns>
        public int AddStockForm(string stockform_id, string employee_ID, int stock_type_id, int stockform_totalnum, decimal stockform_tradeprice, string stockform_oktext, DateTime stockform_time)
        {
            string commandtext = "StockForm_Add";
            SqlParameter id = new SqlParameter("@StockForm_id", SqlDbType.VarChar, 50);
            SqlParameter askid = new SqlParameter("@Employee_ID", SqlDbType.Char,10);
            //SqlParameter checkroleid = new SqlParameter("@StockCheck_role_ID", SqlDbType.Int);
            SqlParameter typeid = new SqlParameter("@Stock_Type_id", SqlDbType.Int);
            SqlParameter totalnum = new SqlParameter("@StockForm_TotalNum", SqlDbType.Int);
            SqlParameter trandeprice = new SqlParameter("@StockForm_TradePrice", SqlDbType.Decimal);
            SqlParameter oktext = new SqlParameter("@StockForm_OKText", SqlDbType.Char, 10);
            SqlParameter time = new SqlParameter("@StockForm_time", SqlDbType.DateTime);
            id.Value = stockform_id;
            askid.Value = employee_ID.Trim ();
            //checkroleid.Value = stockcheck_role_id;
            typeid.Value = stock_type_id;
            totalnum.Value = stockform_totalnum;
            trandeprice.Value = stockform_tradeprice;
            oktext.Value = stockform_oktext;
            time.Value = stockform_time;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, askid, typeid, totalnum, trandeprice, oktext, time });
        }
        #endregion

        #region 保存数据（查找采购类型ID，采购人ID）
        /// <summary>
        /// 保存数据（查找采购类型ID，采购人ID）
        /// </summary>
        /// <param name="stockrolename">采购人角色</param>
        /// <param name="stocktypename">采购类型名称</param>
        /// <returns></returns>
        public Model.Stock.StockFormModel StockFormSelect(string stocktypename)
        {
            string commandtext = "FormOther_Select";
            //SqlParameter rolename = new SqlParameter("@Employee_Name", SqlDbType.VarChar, 10);
            SqlParameter typename = new SqlParameter("@Stock_Type_Name", SqlDbType.Char, 10);
            //rolename.Value = epmid;
            typename.Value = stocktypename;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] {  typename });
            Model.Stock.StockFormModel inf = new Model.Stock.StockFormModel();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                inf.stockform_id = item["StockForm_id"].ToString().Trim();
                inf.askemployee_ID = item["Employee_ID"].ToString();
                inf.stock_type_id = (int)item["Stock_Type_id"];
                inf.stockform_totalnum = (int)item["StockForm_TotalNum"];
                inf.stockform_tradeprice = (decimal)item["StockForm_TradePrice"];
                inf.stockform_oktext =item["StockForm_OKText"].ToString();
                inf.stockform_time = (DateTime)item["StockForm_time"];
            }
            return inf;
        }
        #endregion 

        #region 通过采购单据编号查找采购单据信息
        /// <summary>
        /// 通过采购单据编号查找采购单据信息
        /// </summary>
        /// <param name="stockformid">采购单据编号</param>
        /// <returns></returns>
        public Model.Stock.StockFormModel StockFormSelectByID(string stockformid)
        {
            string commandtext = "StockFormByID_Select";
            SqlParameter id = new SqlParameter("@StockForm_id", SqlDbType.Char, 20);
            id.Value = stockformid.Trim ();
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
            Model.Stock.StockFormModel inf = new Model.Stock.StockFormModel();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                inf.askemployee_ID = item["Employee_ID"].ToString().Trim();
                inf.stockform_time = (DateTime)item["StockForm_time"];
                inf.stockform_tradeprice = (decimal)item["StockForm_TradePrice"];
            }
            return inf;
        }
        #endregion

        #region 修改采购单据
       /// <summary>
       /// 修改采购单据
       /// </summary>
       /// <param name="stockid">采购单据编号</param>
       /// <param name="checkid">采购审核人编号</param>
       /// <param name="oktext">会计审核</param>
       /// <returns>返回修改信息影响的行数</returns>
        public List<Model.Stock.StockFormModel> StockFormUpdate(string stockid, string checkid, string oktext)
        {
            List<Model.Stock.StockFormModel> list = new List<Model.Stock.StockFormModel>();
            string commandtext = "StockForm_Update";
            SqlParameter sid = new SqlParameter("@StockForm_id", SqlDbType.Char, 20);
            SqlParameter cid = new SqlParameter("@StockCheck_ID", SqlDbType.VarChar ,50);
            SqlParameter ok = new SqlParameter("@StockForm_OKText", SqlDbType.Char, 10);
            sid.Value = stockid;
            cid.Value = checkid;
            ok.Value = oktext;
            SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { sid, cid, ok });
            return list;
        }
        #endregion

        #region 采购单据信息
        /// <summary>
        /// 采购单据信息
        /// </summary>
        /// <returns></returns>
        public List<Model.Stock.StockFormModel> StockFormSelectByWhere()
        {
            List<Model.Stock.StockFormModel> li = new List<Model.Stock.StockFormModel>();
            string commandtext = "StockForm_Select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { },null);
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Stock.StockFormModel inf = new Model.Stock.StockFormModel();
                inf.stockform_id = item["StockForm_id"].ToString().Trim ();
                inf.stock_type_name = item["Stock_Type_Name"].ToString();
                inf.askemployee_ID = item["Employee_ID"].ToString().Trim ();
                inf.roleemployee_ID = item["StockCheck_ID"].ToString().Trim ();
                inf.stockform_totalnum = (int)item["StockForm_TotalNum"];
                inf.stockform_tradeprice = (decimal)item["StockForm_TradePrice"];
                inf.stockform_oktext = item["StockForm_OKText"].ToString().Trim ();
                inf.stockform_time = (DateTime)item["StockForm_time"];
                li.Add(inf);
            }
            return li;
        }
        #endregion

        #region 删除未通过审核的采购单据
        /// <summary>
        /// 删除未通过审核的采购单据
        /// </summary>
        /// <param name="stockformid">采购单据编号</param>
        /// <param name="stockstatus">采购状态</param>
        /// <returns>返回删除采购单据影响的行数</returns>
        public int StockFormDelete(string stockformid,string stockstatus)
        {
            string com = "StockForm_Delete";
            SqlParameter id = new SqlParameter("@StockForm_id", SqlDbType.VarChar,20);
            SqlParameter status = new SqlParameter("@StockForm_OKText", SqlDbType.Char, 10);
            id.Value = stockformid;
            status.Value = stockstatus;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id, status });
        }
        #endregion

        #region 查询已入库的采购单据编号
        /// <summary>
        /// 查询已入库的采购单据编号
        /// </summary>
        /// <param name="stockformok">审核状态</param>
        /// <returns></returns>
        public List<Model.Stock.Stock_SetailsModel> StockFormSelectByOK(string stockformok)
        {
            List<Model.Stock.Stock_SetailsModel> list = new List<Model.Stock.Stock_SetailsModel>();
            string commandtext = "StockFormByOK_Select";
            SqlParameter ok = new SqlParameter("@StockForm_OKText", SqlDbType.Char, 10);
            ok.Value = stockformok;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { ok });
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Stock.Stock_SetailsModel inf = new Model.Stock.Stock_SetailsModel();
                inf.stockform_id = item["StockForm_id"].ToString().Trim();
                inf.product_id = item["Product_id"].ToString();
                inf.stock_setails_s1 = (int)item["Stock_Setails_s1"];
                inf.stock_setails_s2 = (int)item["Stock_Setails_s2"];
                inf.stock_setails_s3 = (int)item["Stock_Setails_s3"];
                inf.stock_setails_s4 = (int)item["Stock_Setails_s4"];
                inf.stock_setails_s5 = (int)item["Stock_Setails_s5"];
                inf.stock_setails_s6 = (int)item["Stock_Setails_s6"];
                inf.stock_setails_s7 = (int)item["Stock_Setails_s7"];
                inf.stock_setails_tradeprice = (decimal)item["Stock_Setails_TradePrice"];
                inf.stock_setails_color = item["Stock_Setails_color"].ToString();
                inf.stock_setails_brand = item["Stock_Setails_brand"].ToString();
                inf.stock_setails_sum = (int)item["Stock_Setails_sum"];
                list.Add(inf);
            }
            return list;
        }
        #endregion

        #region 修改采购单据(退货)
        /// <summary>
        /// 修改采购单据（退货）
        /// </summary>
        /// <param name="stockid">采购单据编号</param>
        /// <param name="typeid">采购类型</param>
        /// <param name="oktext">会计审核</param>
        /// <returns>返回修改信息影响的行数</returns>
        public List<Model.Stock.StockFormModel> StockFormReturnUpdate(string stockid, int typeid, string oktext)
        {
            List<Model.Stock.StockFormModel> list = new List<Model.Stock.StockFormModel>();
            string commandtext = "StockFormReturn_Update";
            SqlParameter sid = new SqlParameter("@StockForm_id", SqlDbType.Char, 20);

            SqlParameter cid = new SqlParameter("@Stock_Type_id", SqlDbType.Int);
            SqlParameter ok = new SqlParameter("@StockForm_OKText", SqlDbType.Char, 10);
            sid.Value = stockid;
          
            cid.Value = typeid;
            ok.Value = oktext;
            SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { sid,cid, ok });
            return list;
        }
        #endregion
        
    }
}