Hl.DataDalSql/BizBaseInfo_Service/BizServiceInfoOperate.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 BizServiceInfoOperate:Hl.DataDalInterface.BizServiceInfoOperate
    {
        #region "访问"

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

        #endregion

        #region "操作"

        /// <summary>
        /// 业务操作-维修总检
        /// </summary>
        public DataModel.MsgModel Operate_FinalCheck(int serviceId, string finalCheckUserNo, int dispatchReportFlag, string dispatchReportNote)
        {
            DataModel.MsgModel msg = new DataModel.MsgModel();
            #region "开始处理"

            SqlParameter[] paramlist = new SqlParameter[]
            { 
                new SqlParameter("@serviceId", SqlDbType.Int, 4),
                new SqlParameter("@FinalCheckUserNo", SqlDbType.NVarChar,50),
                new SqlParameter("@DispatchReportFlag", SqlDbType.Int, 4),
                new SqlParameter("@DispatchReportNote", SqlDbType.NVarChar),
                new SqlParameter("@msgType", SqlDbType.NVarChar,50),
                new SqlParameter("@msgInfo", SqlDbType.NVarChar,4000)
            };
            paramlist[0].Value = serviceId;
            paramlist[1].Value = finalCheckUserNo;
            paramlist[2].Value = dispatchReportFlag;
            paramlist[3].Value = dispatchReportNote;
            paramlist[4].Direction = ParameterDirection.Output;
            paramlist[5].Direction = ParameterDirection.Output;
            DbHelper.ExecuteNonQuery(DbHelper.ConnectionStr("", true), CommandType.StoredProcedure, "维修业务操作_总检", paramlist);
            msg.MsgType = paramlist[4].Value.ToString();
            msg.MsgInfo = paramlist[5].Value.ToString();
            #endregion
            return msg;
        }

        /// <summary>
        /// 业务操作-预结算审核
        /// </summary>
        public DataModel.MsgModel Operate_PreSettleEnsure(int serviceId)
        {
            DataModel.MsgModel msg = new DataModel.MsgModel();
            #region "开始处理"