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

        private Hl.DataDbHelper.DbHelper DbHelper = Hl.DataDbHelper.DbUlitity.Instance();

        #endregion

        #region "方法"

        /// <summary>
        /// 查询维修列表
        /// </summary>
        public DataSet SelectBaoJia(int serviceId, string orderBy = "Serial ASC")
        {
            SqlParameter[] paramlist = new SqlParameter[]
            {
                new SqlParameter("@ServiceId",SqlDbType.Int,4),
                new SqlParameter("@orderby",SqlDbType.NVarChar,1000)
            };
            paramlist[0].Value = serviceId;
            paramlist[1].Value = orderBy;
            DataSet ds = DbHelper.ExecuteDataSet(DbHelper.ConnectionStr("", true), CommandType.StoredProcedure, "维修业务项目_查询报价列表", paramlist);
            #region "行处理"
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                row["维修状态"] = DataConvert.ToInt(row["当前类型"], 1) == 1 ? EnumHelper.ToItem<Enum.BizServiceInfoItemStatus>(DataConvert.ToInt(row["维修状态"], 0)).KeyTxt : EnumHelper.ToItem<Enum.BizServiceInfoPartStatus>(DataConvert.ToInt(row["维修状态"], 0)).KeyTxt;
                row["当前类型"] = DataConvert.ToInt(row["当前类型"], 1) == 1 ? "维修项目" : "维修配件";
                row["完工时间"] = DataConvert.ToInt(row["完工状态"], 1) == 1 ? DataConvert.ToDateTime(row["完工时间"], DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss") : "";
            }
            #endregion
            return ds;
        }

        /// <summary>
        /// 查询维修列表
        /// </summary>
        public DataSet SelectEnsure(int serviceId, string orderBy = "Serial ASC")
        {
            SqlParameter[] paramlist = new SqlParameter[]
            {
                new SqlParameter("@ServiceId",SqlDbType.Int,4),
                new SqlParameter("@orderby",SqlDbType.NVarChar,1000)
            };
            paramlist[0].Value = serviceId;
            paramlist[1].Value = orderBy;
            DataSet ds = DbHelper.ExecuteDataSet(DbHelper.ConnectionStr("", true), CommandType.StoredProcedure, "维修业务项目_查询维修列表", paramlist);
            #region "行处理"
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                row["维修状态"] = DataConvert.ToInt(row["当前类型"], 1) == 1 ? EnumHelper.ToItem<Enum.BizServiceInfoItemStatus>(DataConvert.ToInt(row["维修状态"], 0)).KeyTxt : EnumHelper.ToItem<Enum.BizServiceInfoPartStatus>(DataConvert.ToInt(row["维修状态"], 0)).KeyTxt;