计划订单相关功能

username@email.com

2024-11-15 f47da9571d16108fcab2bf6d55279a08ce2e7cbf

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_CarManageDAL.cs

@@ -36,6 +36,37 @@
            {
                return false;
            }
            SqlParameter InsuranceEndTime = null;
            if(trueModel.InsuranceEndTime.HasValue)
            {
                InsuranceEndTime = new SqlParameter("@InsuranceEndTime", trueModel.InsuranceEndTime);
            }
            else
            {
                InsuranceEndTime = new SqlParameter("@InsuranceEndTime", DBNull.Value);
            }

            SqlParameter MaintenanceNextTime = null;
            if (trueModel.MaintenanceNextTime.HasValue)
            {
                MaintenanceNextTime = new SqlParameter("@MaintenanceNextTime", trueModel.MaintenanceNextTime);
            }
            else
            {
                MaintenanceNextTime = new SqlParameter("@MaintenanceNextTime", DBNull.Value);
            }

            SqlParameter ExaminedNextTime = null;
            if (trueModel.ExaminedNextTime.HasValue)
            {
                ExaminedNextTime = new SqlParameter("@ExaminedNextTime", trueModel.ExaminedNextTime);
            }
            else
            {
                ExaminedNextTime = new SqlParameter("@ExaminedNextTime", DBNull.Value);
            }


            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
             new SqlParameter("@MemberID", trueModel.MemberID) ,            
@@ -46,7 +77,14 @@
                new SqlParameter("@CarCondition", trueModel.CarCondition) ,            
                new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                new SqlParameter("@Operator", trueModel.Operator) ,            
                new SqlParameter("@OrderNum", trueModel.OrderNum)             
                new SqlParameter("@OrderNum", trueModel.OrderNum),
                new SqlParameter("@StaffID", trueModel.StaffID),
                new SqlParameter("@InsuranceCompany", trueModel.InsuranceCompany),
                InsuranceEndTime,
                MaintenanceNextTime,
                ExaminedNextTime,
                  new SqlParameter("@InsuranceContent", trueModel.InsuranceContent),

            };
            try
            {
@@ -71,6 +109,35 @@
            {
                return false;
            }
            SqlParameter InsuranceEndTime = null;
            if (trueModel.InsuranceEndTime.HasValue)
            {
                InsuranceEndTime = new SqlParameter("@InsuranceEndTime", trueModel.InsuranceEndTime);
            }
            else
            {
                InsuranceEndTime = new SqlParameter("@InsuranceEndTime", DBNull.Value);
            }
            SqlParameter MaintenanceNextTime = null;
            if (trueModel.MaintenanceNextTime.HasValue)
            {
                MaintenanceNextTime = new SqlParameter("@MaintenanceNextTime", trueModel.MaintenanceNextTime);
            }
            else
            {
                MaintenanceNextTime = new SqlParameter("@MaintenanceNextTime", DBNull.Value);
            }

            SqlParameter ExaminedNextTime = null;
            if (trueModel.ExaminedNextTime.HasValue)
            {
                ExaminedNextTime = new SqlParameter("@ExaminedNextTime", trueModel.ExaminedNextTime);
            }
            else
            {
                ExaminedNextTime = new SqlParameter("@ExaminedNextTime", DBNull.Value);
            }

            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
             new SqlParameter("@Keyid", trueModel.Keyid) ,            
@@ -82,7 +149,13 @@
                new SqlParameter("@CarCondition", trueModel.CarCondition) ,            
                new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                new SqlParameter("@Operator", trueModel.Operator) ,            
                new SqlParameter("@OrderNum", trueModel.OrderNum)             
                new SqlParameter("@OrderNum", trueModel.OrderNum),
                new SqlParameter("@StaffID", trueModel.StaffID),
                new SqlParameter("@InsuranceCompany", trueModel.InsuranceCompany),
                   new SqlParameter("@InsuranceContent", trueModel.InsuranceContent),
                InsuranceEndTime,
                MaintenanceNextTime,
                ExaminedNextTime,
            };
            try
            {
@@ -207,7 +280,7 @@
                if (_OrderNum.HasValue)
                    condition += " and a.OrderNum = '" + _OrderNum + "'";

                return _dataBase.SelectModelPage<Model.OA_CarManage>(pagination, " a.*,f.Name as CarConditionName ", " OA_CarManage as a LEFT JOIN dbo.Sys_Dictionary AS f ON a.CarCondition = f.MeanValue AND f.DicType='车辆状态' ", " a.OrderNum ASC", " OrderNum ASC ", condition);
                return _dataBase.SelectModelPage<Model.OA_CarManage>(pagination, " a.*,f.Name as CarConditionName,g.Name as StaffName ", " OA_CarManage as a LEFT JOIN dbo.Sys_Dictionary AS f ON a.CarCondition = f.MeanValue AND f.DicType='车辆状态' LEFT JOIN dbo.[OA_Staff] AS g ON a.StaffID = g.Keyid    ", " a.OrderNum ASC", " OrderNum ASC ", condition);
            }
            catch (Exception ex)
            {