Hl.DataDalSql/BizPartOrder/BizServicePartOrderOperate.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using Hl.Code;

namespace Hl.DataDalSql
{
    public class BizServicePartOrderOperate : Hl.DataDalInterface.BizServicePartOrderOperate
    {
        #region "访问"

        /// <summary>
        /// DbHelper
        /// </summary>
        private Hl.DataDbHelper.DbHelper DbHelper = Hl.DataDbHelper.DbUlitity.Instance();

        #endregion

        #region "方法"

        /// <summary>
        /// 采购入库单-确认入库
        /// </summary>
        public DataModel.MsgModel OrderPurchaseGoIntoEnsure(int id)
        {
            DataModel.MsgModel msg = new DataModel.MsgModel("right", "确认入库成功！");
            SqlParameter[] paramlist = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.Int, 4) };
            paramlist[0].Value = id;
            try
            {
                int number = DbHelper.ExecuteNonQuery(DbHelper.ConnectionStr("", true), CommandType.StoredProcedure, "配件出入库存_采购入库确认", paramlist);
                msg.MsgType = number > 0 ? "right" : "error";
                msg.MsgInfo = number > 0 ? "确认入库成功!" : "确认入库失败！";
            }
            catch (Exception ex) { throw new Exception(ex.Message); }
            return msg;
        }

        /// <summary>
        /// 采购退货单-确认退货
        /// </summary>
        public DataModel.MsgModel OrderPurchaseReturnEnsure(int id)
        {
            DataModel.MsgModel msg = new DataModel.MsgModel("right", "确认退货成功！");
            SqlParameter[] paramlist = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.Int, 4),new SqlParameter("@msgInfo", SqlDbType.NVarChar,4000) };
            paramlist[0].Value = id;
            paramlist[1].Direction=ParameterDirection.Output;
            try
            {
                DbHelper.ExecuteNonQuery(DbHelper.ConnectionStr("", true), CommandType.StoredProcedure, "配件出入库存_采购退货确认", paramlist);
                msg.MsgInfo = paramlist[1].Value.ToString();
                msg.MsgType = msg.MsgInfo == "" ? "right" : "error";
            }
            catch (Exception ex) { throw new Exception(ex.Message); }
            return msg;
        }

        /// <summary>