作业本送货 加上客户单位 完成 订单状态默认未送货 完成

username@email.com

2025-09-23 389b4da5feedfc0b49d7c6540bc836267d7bbee0

作业本送货   加上客户单位  完成
订单状态默认未送货      完成

就是已送货未送货   全部  完成

查询条件订单编号  硬件名称查询删除  完成

四川省档案学校 作为例子 完成
作业本送货里边  操作里边  新增送货   库存盘点  完成

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[CoreCmsPlanOrderFahuo]    Script Date: 2025/9/19 12:26:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CoreCmsPlanOrderFahuo](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [orderId] [int] NOT NULL,
 [name] [varchar](255) NOT NULL,
 [specification] [varchar](255) NOT NULL,
 [nums] [int] NOT NULL,
 [createTime] [datetime] NULL,
 [upDataTime] [datetime] NULL,
 [createBy] [varchar](255) NULL,
 [upDataBy] [varchar](255) NULL,
 CONSTRAINT [PK_CoreCmsPlanOrderFahuo_id] PRIMARY KEY CLUSTERED
(
 [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 CY_ECommercePlatform/AbstractFactory/Factory.cs

@@ -273,6 +273,7 @@
            OBJECT_PATH.Add(DALInterface.IOA_ShiJuanBiaoQianDAL, "OA_ShiJuanBiaoQianDAL");
            OBJECT_PATH.Add(DALInterface.IAdm_tongxunluDAL, "Adm_tongxunluDAL");
            OBJECT_PATH.Add(DALInterface.IAdm_zhanghaomimaDAL, "Adm_zhanghaomimaDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderFahuoDAL, "CoreCmsPlanOrderFahuoDAL");
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewDAL, "OA_KaipiaonewDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderDAL, "CoreCmsPlanOrderDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderItemDAL, "CoreCmsPlanOrderItemDAL");
@@ -954,6 +955,11 @@
        /// </summary>
        IAdm_zhanghaomimaDAL = 1945,

        /// <summary>
        /// 账号密码
        /// </summary>
        ICoreCmsPlanOrderFahuoDAL = 1946,


        /// <summary>
        /// 开票申请

 CY_ECommercePlatform/CY.BLL/CY.BLL.csproj

@@ -156,6 +156,7 @@
    <Compile Include="OA\Adm_tongxunluBLL.cs" />
    <Compile Include="OA\Adm_zhanghaomimaBLL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderBLL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderFahuoBLL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItemBLL.cs" />
    <Compile Include="OA\OA_BaozhengjinBLL.cs" />
    <Compile Include="OA\OA_BaozhengjincuishouBLL.cs" />

 CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs

@@ -92,9 +92,9 @@
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates)
        public IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates, string BuyerName)
        {
            return _eC_OrderBasicDAL.SelectModelPageWorkBook(pagination, _MemberID, txtBeginDate, txtEndDate, txtOrderId, txtSearchyjname, selCustormerManager, selBusinessManager, selOrderStates);
            return _eC_OrderBasicDAL.SelectModelPageWorkBook(pagination, _MemberID, txtBeginDate, txtEndDate, txtOrderId, txtSearchyjname, selCustormerManager, selBusinessManager, selOrderStates, BuyerName);
        }

        /// <summary>

 CY_ECommercePlatform/CY.BLL/OA/CoreCmsPlanOrderFahuoBLL.cs

New file
@@ -0,0 +1,106 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using CY.Model;
using AbstractFactory;
using CY.IBaseDAL;
using CY.Infrastructure.DESEncrypt;
using CY.Infrastructure.Query;

namespace CY.BLL
{
    public class CoreCmsPlanOrderFahuoBLL
    {
        ICoreCmsPlanOrderFahuoDAL _ICoreCmsPlanOrderFahuoDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public CoreCmsPlanOrderFahuoBLL()
        {
            //获取CoreCmsPlanOrderFahuo DAL实现
            _ICoreCmsPlanOrderFahuoDAL = Factory.GetDALByInterfaceName(DALInterface.ICoreCmsPlanOrderFahuoDAL) as ICoreCmsPlanOrderFahuoDAL;


        }

        /// <summary>
        /// 新增送货安排
        /// </summary>
        /// <param name="rType"></param>
        /// <param name="m_OA_CustomerCommunications"></param>
        /// <param name="m_EC_AcceptWayByCustomers"></param>
        /// <returns></returns>
        public bool InsertModel(CY.Model.CoreCmsPlanOrderFahuo m_CoreCmsPlanOrderFahuo)
        {
            try
            {

                return _ICoreCmsPlanOrderFahuoDAL.InserModel(m_CoreCmsPlanOrderFahuo);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 修改送货安排
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool UpdateModel(CY.Model.CoreCmsPlanOrderFahuo m_CoreCmsPlanOrderFahuo)
        {
            try
            {
                return _ICoreCmsPlanOrderFahuoDAL.UpdateModel(m_CoreCmsPlanOrderFahuo);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public IEnumerable<CoreCmsPlanOrderFahuo> GetModelList()
        {
            Query query = new Query();
            return _ICoreCmsPlanOrderFahuoDAL.SelectAllModel(query);
        }


        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="orderid">主键id</param>
        /// <returns></returns>
        public IEnumerable<CoreCmsPlanOrderFahuo> GetModelsByOrderid(int orderid)
        {
            Query query = new Query();
            return _ICoreCmsPlanOrderFahuoDAL.GetModelsByOrderid(orderid);
        }

        
 

        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public CoreCmsPlanOrderFahuo GetModelByKeyid(int keyid)
        {

            return _ICoreCmsPlanOrderFahuoDAL.getCoreCmsPlanOrderFahuo(keyid);
        }

       

    }
}

 CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj

@@ -159,6 +159,7 @@
    <Compile Include="OA\IAdm_tongxunluDAL.cs" />
    <Compile Include="OA\IAdm_zhanghaomimaDAL.cs" />
    <Compile Include="OA\ICoreCmsPlanOrderDAL.cs" />
    <Compile Include="OA\ICoreCmsPlanOrderFahuoDAL.cs" />
    <Compile Include="OA\ICoreCmsPlanOrderItemDAL.cs" />
    <Compile Include="OA\IOA_BaozhengjincuishouDAL.cs" />
    <Compile Include="OA\IOA_BaozhengjinDAL.cs" />

 CY_ECommercePlatform/CY.IDAL/EC/IEC_OrderBasicDAL.cs

@@ -77,7 +77,7 @@
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates);
        IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates, string BuyerName);


        /// <summary>

 CY_ECommercePlatform/CY.IDAL/OA/ICoreCmsPlanOrderFahuoDAL.cs

New file
@@ -0,0 +1,32 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using CY.IBaseDAL;
using CY.Model;

namespace CY.IDAL
{
    public interface ICoreCmsPlanOrderFahuoDAL : ICommonDAL, IPaging<CoreCmsPlanOrderFahuo>, IGetAllModel<CoreCmsPlanOrderFahuo>
    {
        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        CoreCmsPlanOrderFahuo getCoreCmsPlanOrderFahuo(int keyid);

        /// <summary>
        /// 根据orderid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        IEnumerable<CoreCmsPlanOrderFahuo> GetModelsByOrderid(int orderid);


        

    }
}

 CY_ECommercePlatform/CY.Model/CY.Model.csproj

@@ -202,6 +202,7 @@
    <Compile Include="OA\Adm_tongxunlu.cs" />
    <Compile Include="OA\Adm_zhanghaomima.cs" />
    <Compile Include="OA\CoreCmsPlanOrder.cs" />
    <Compile Include="OA\CoreCmsPlanOrderFahuo.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItem.cs" />
    <Compile Include="OA\CoreDeliverOrderItem.cs" />
    <Compile Include="OA\EC_OrderLiuyang.cs" />

 CY_ECommercePlatform/CY.Model/OA/CoreCmsPlanOrderFahuo.cs

New file
@@ -0,0 +1,155 @@
using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;

namespace CY.Model
{

    /// <summary>
    /// 计划订单发货表
    /// </summary>
    [Serializable]
    public partial class CoreCmsPlanOrderFahuo : IAggregateRoot
    {

        public CoreCmsPlanOrderFahuo()
        {
        }

        #region Model

        /// <summary>
        /// 序号
        /// </summary>
        public System.Int32 id { get; set; }
        /// <summary>
        /// 订单ID 关联order.id
        /// </summary>
        public System.Int32 orderId { get; set; }


        /// <summary>
        /// 商品名称
        /// </summary>
        public System.String name { get; set; }


        /// <summary>
        /// biaoge
        /// </summary>
        public System.String biaoge { get; set; }
        


        /// <summary>
        /// 商品规格
        /// </summary>
        public System.String specification { get; set; }


        


        /// <summary>
        /// 数量
        /// </summary>
        public System.Int32 nums { get; set; }
        
        


        /// <summary>
        /// 建立时间
        /// </summary>		
        public DateTime? createTime { get; set; }

        /// <summary>
        /// 修改时间
        /// </summary>		
        public DateTime? upDataTime { get; set; }

        /// <summary>
        /// 创建人
        /// </summary>		
        public string createBy { get; set; }

        /// <summary>
        /// 修改人
        /// </summary>		
        public string upDataBy { get; set; }
       

        #endregion Model

        #region Visiter

        /// <summary>
        /// 属性访问器
        /// </summary>
        /// <param name="name">属性名</param>
        /// <param name="index">索引</param>
        /// <param name="isChange">是否将指定属性设置为传入值</param>
        /// <param name="value">需要赋予的值</param>
        /// <returns>与名称对应的属性值</returns>
        public object Visiter(string name, int? index = -1, bool isChange = false, object value = null)
        {
            object theValue = null;


            if ("id".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 1)
            {
                this.id = isChange ? MyConvert.ConvertToInt32(value).Value : id;
                theValue = this.id;
            }
            else if ("orderId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.orderId = isChange ? MyConvert.ConvertToInt32(value).Value : orderId;
                theValue = this.orderId;
            }
            else if ("name".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.name = isChange ? MyConvert.ConvertToString(value) : name;
                theValue = this.name;
            }
            else if ("specification".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.specification = isChange ? MyConvert.ConvertToString(value) : specification;
                theValue = this.specification;
            }

 
            else if ("nums".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 6)
            {
                this.nums = isChange ? MyConvert.ConvertToInt32(value).Value : nums;
                theValue = this.nums;
            }
 
 
            else if ("createTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 18)
            {
                this.createTime = isChange ? MyConvert.ConvertToDateTime(value) : createTime;
                theValue = this.createTime;
            }
            else if ("upDataTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 19)
            {
                this.upDataTime = isChange ? MyConvert.ConvertToDateTime(value) : upDataTime;
                theValue = this.upDataTime;
            }
            else if ("createBy".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 20)
            {
                this.createBy = isChange ? MyConvert.ConvertToString(value) : createBy;
                theValue = this.createBy;
            }
            else if ("upDataBy".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 21)
            {
                this.upDataBy = isChange ? MyConvert.ConvertToString(value) : upDataBy;
                theValue = this.upDataBy;
            }
            

            return theValue;
        }

        #endregion
    }
}

 CY_ECommercePlatform/CY.Model/OA/CoreCmsPlanOrderItem.cs

@@ -98,6 +98,33 @@
        /// </summary>
        public System.String neiye { get; set; }


        /// <summary>
        /// 发货数量
        /// </summary>
        public System.Int32 fahuonums { get; set; }

        /// <summary>
        /// 未发货数量
        /// </summary>
        public System.Int32 weifahuonums { get; set; }

        /// <summary>
        /// 送货数量
        /// </summary>
        public System.Int32 songhuonums { get; set; }

        /// <summary>
        /// 库存数量
        /// </summary>
        public System.Int32 kucunnums { get; set; }

        /// <summary>
        /// 未送货数量
        /// </summary>
        public System.Int32 weisonghuonums { get; set; }


        #endregion Model

        #region Visiter

 CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj

@@ -172,6 +172,7 @@
    <Compile Include="OA\Adm_tongxunluDAL.cs" />
    <Compile Include="OA\Adm_zhanghaomimaDAL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderDAL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderFahuoDAL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItemDAL.cs" />
    <Compile Include="OA\OA_BaozhengjincuishouDAL.cs" />
    <Compile Include="OA\OA_BaozhengjinDAL.cs" />

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs

@@ -1339,7 +1339,7 @@
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates)
        public IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates, string BuyerName)
        {
            try
            {
@@ -1364,6 +1364,9 @@
                if (!string.IsNullOrEmpty(txtSearchyjname))
                    condition += " and ob.DocumentName like '%" + txtSearchyjname + "%'";

                if (!string.IsNullOrEmpty(BuyerName))
                    condition += " and ob.BuyerName like '%" + BuyerName + "%'";

                if (!string.IsNullOrEmpty(selCustormerManager))
                    condition += " and oe.CustomerManagerId = '" + selCustormerManager + "'";

@@ -1371,7 +1374,17 @@
                    condition += " and oe.BusinessManagerId = '" + selBusinessManager + "'";

                if (!string.IsNullOrEmpty(selOrderStates))
                    condition += " and ob.OrderState = '" + selOrderStates + "'";
                {
                    if(selOrderStates == "0")
                    {
                        condition += " and ob.OrderState  in (1,2,3,4)";
                    }
                    else if (selOrderStates == "1")
                    {
                        condition += " and ob.OrderState in ( 5,6,-1)";
                    }
                }
                   

 


 CY_ECommercePlatform/CY.SQLDAL/OA/CoreCmsPlanOrderFahuoDAL.cs

New file
@@ -0,0 +1,221 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using System.Data.SqlClient;
using System.Data;
using CY.Model;
using System.Transactions;


namespace CY.SQLDAL
{
    public class CoreCmsPlanOrderFahuoDAL: ICoreCmsPlanOrderFahuoDAL
    {
        private Database _dataBase = null;
        #region 常量
        /// <summary>
        /// 查询目标 
        /// </summary>
        const string SELECTTARGET = " ";
        /// <summary>
        /// 查询来源
        /// </summary>
        const string FROMSOUCEBEFORE = " ";
        const string FROMSOUCEEND = "  ";
        /// <summary>
        /// 分页默认排序字段
        /// </summary>
        const string ORDERBY = " SellerOrderId desc  ";
        #endregion
        public CoreCmsPlanOrderFahuoDAL()
        {
            _dataBase = new Database();
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.CoreCmsPlanOrderFahuo trueModel = model as Model.CoreCmsPlanOrderFahuo;
            if (trueModel == null)
            {
                return false;
            }



            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {

                    new SqlParameter("@orderId",trueModel.orderId),
                    new SqlParameter("@name",trueModel.name),
                     new SqlParameter("@specification",trueModel.specification),
                   
                    new SqlParameter("@nums",trueModel.nums),
                       
                             new SqlParameter("@createTime",trueModel.createTime),
                              new SqlParameter("@upDataTime",trueModel.upDataTime),
                                 new SqlParameter("@upDataBy",trueModel.upDataBy),
                                new SqlParameter("@createBy",trueModel.createBy),
                                 

            };
            string sql = "Insert Into CoreCmsPlanOrderFahuo ([orderId],[name],[specification] , [nums] , [createTime],[upDataTime], [upDataBy],[createBy] )"
                                             + " Values ( @orderId,@name,@specification,   @nums , @createTime, @upDataTime, @upDataBy,@createBy )";
            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.CoreCmsPlanOrderFahuo trueModel = model as Model.CoreCmsPlanOrderFahuo;
            if (trueModel == null)
            {
                return false;
            }


            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {

                 new SqlParameter("@id",trueModel.id),
                    new SqlParameter("@orderId",trueModel.orderId),
                    new SqlParameter("@name",trueModel.name),
                     new SqlParameter("@specification",trueModel.specification),
                    
                    new SqlParameter("@nums",trueModel.nums),
                       
                              new SqlParameter("@upDataTime",trueModel.upDataTime),
                                new SqlParameter("@upDataBy",trueModel.upDataBy),
                                  

            };
            string sql = "Update CoreCmsPlanOrderFahuo Set [orderId]=@orderId,[name]=@name,[specification]=@specification , [nums]=@nums , [upDataTime]=@upDataTime,[upDataBy]=@upDataBy   where [id] =@id ";

            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public CoreCmsPlanOrderFahuo getCoreCmsPlanOrderFahuo(int keyid)
        {
            try
            {
                string condition = "  ";
                if (!keyid.Equals(Guid.Empty))
                {
                    condition = " id='" + keyid + "'";
                }
                else
                {
                    return null;
                }

                //  return null;//错误数据返会空 

                IList<CoreCmsPlanOrderFahuo> result = _dataBase.SelectModel<CoreCmsPlanOrderFahuo>("*", "CoreCmsPlanOrderFahuo", condition) as IList<CoreCmsPlanOrderFahuo>;//执行查询

                return (null == result || result.Count == 0) ? null : result[0];//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.CoreCmsPlanOrderFahuo> SelectAllModel(Infrastructure.Query.Query query)
        {
            return _dataBase.SelectModel<Model.CoreCmsPlanOrderFahuo>(" * ", " CoreCmsPlanOrderFahuo ") as IList<Model.CoreCmsPlanOrderFahuo>;//执行查询
        }

        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.CoreCmsPlanOrderFahuo> GetModelsByOrderid(int orderid)
        {
            return _dataBase.SelectModel<Model.CoreCmsPlanOrderFahuo>(" * ", " CoreCmsPlanOrderFahuo ", " orderId = " + orderid + "") as IList<Model.CoreCmsPlanOrderFahuo>;//执行查询
        }
         

        


        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.CoreCmsPlanOrderFahuo> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {

            return null;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.CoreCmsPlanOrderItem trueModel = model as Model.CoreCmsPlanOrderItem;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@Keyid",trueModel.id)
            };
            string sql = "Delete [CoreCmsPlanOrderFahuo] Where [id] = @Keyid ";


            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }
    }
}

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs

@@ -412,6 +412,16 @@
                if (EndPlanStartTime.HasValue)
                    condition += string.Format(" and CAST(a.PlanStartTime AS DATE) <='{0}'", EndPlanStartTime);


                decimal heji1 = 0;
                var ssss = _dataBase.SelectModel<Model.OA_WorkPlan>("  sum(a.[PlanMoney]) as PlanMoney ", " OA_WorkPlan AS a    ", condition);
                if (ssss.Count > 0)
                {
                    var aaaaa = ssss.First();
                    heji1 += (aaaaa.PlanMoney.HasValue ? aaaaa.PlanMoney.Value : 0);
                }
                pagination.heji1 = heji1;

                return _dataBase.SelectModelPage<Model.OA_WorkPlan>(pagination, " a.*,b.Name as SentStaffName,c.Name as ReciveStaffName,d.Name as ApprovalStaffName,e.Name as EvaluationStaff,f.Name as PlanDataTypeName ", " OA_WorkPlan AS a LEFT JOIN dbo.EC_MemberBasic AS b ON a.SentStaffId  = b.MemberId LEFT JOIN dbo.EC_MemberBasic AS c ON a.ReciveStaffId = c.MemberId LEFT JOIN dbo.EC_MemberBasic AS d ON a.ApprovalStaffId  = d.MemberId LEFT JOIN dbo.EC_MemberBasic AS e ON a.EvaluationStaffId = e.MemberId LEFT JOIN dbo.Sys_Dictionary AS f ON a.PlanDataType = f.MeanValue AND f.DicType='工作计划性质'  ", " a.PlanStartTime desc", " PlanStartTime desc ", condition);
            }
            catch (Exception ex)

 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -1903,6 +1903,9 @@
    <Content Include="Pages\business\DeliverPlanLishiPrint.aspx" />
    <Content Include="Pages\business\DeliverPlanPaicheZhuyishixiang.aspx" />
    <Content Include="Pages\business\DeliverPlanTimeEdit.aspx" />
    <Content Include="Pages\business\DeliverWorkBookPandian.aspx" />
    <Content Include="Pages\business\DeliverWorkBookFahuo.aspx" />
    <Content Include="Pages\business\DeliverWorkBookfahuoqingkuang.aspx" />
    <Content Include="Pages\business\ShejiOrderDeatil.aspx" />
    <Content Include="Pages\business\ShejiOrderList.aspx" />
    <Content Include="Pages\business\SHejiOrderEdit.aspx" />
@@ -3491,6 +3494,27 @@
    <Compile Include="Pages\business\DeliverPlanTimeEdit.aspx.designer.cs">
      <DependentUpon>DeliverPlanTimeEdit.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookPandian.aspx.cs">
      <DependentUpon>DeliverWorkBookPandian.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookPandian.aspx.designer.cs">
      <DependentUpon>DeliverWorkBookPandian.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookFahuo.aspx.cs">
      <DependentUpon>DeliverWorkBookFahuo.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookFahuo.aspx.designer.cs">
      <DependentUpon>DeliverWorkBookFahuo.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookfahuoqingkuang.aspx.cs">
      <DependentUpon>DeliverWorkBookfahuoqingkuang.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\DeliverWorkBookfahuoqingkuang.aspx.designer.cs">
      <DependentUpon>DeliverWorkBookfahuoqingkuang.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\FileUploadHandler.ashx.cs">
      <DependentUpon>FileUploadHandler.ashx</DependentUpon>
    </Compile>

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookFahuo.aspx

New file
@@ -0,0 +1,184 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DeliverWorkBookFahuo.aspx.cs" Inherits="CY.WebForm.Pages.business.DeliverWorkBookFahuo" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>车辆管理</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        //违章
        function onViewCarViolation(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarViolationList.aspx?carid=" + keyid, Title: "违章管理", Width: 1000, Height: 660 });
        }

        //保养
        function onViewCarMaintenance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarMaintenanceList.aspx?carid=" + keyid, Title: "保养管理", Width: 1000, Height: 660 });
        }
        //维修
        function onViewCarrepair(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarrepairList.aspx?carid=" + keyid, Title: "维修管理", Width: 1000, Height: 660 });
        }

        //年检
        function onViewCarExamined(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarExaminedList.aspx?carid=" + keyid, Title: "年检管理", Width: 1000, Height: 660 });
        }

        //保险
        function onViewCarInsurance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarInsuranceList.aspx?carid=" + keyid, Title: "保险管理", Width: 1000, Height: 660 });
        }

        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx?keyid=" + keyid, Title: "车辆信息", Width: 1000, Height: 660 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx", Title: "新增车辆", Width: 1000, Height: 660});
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要删除该记录吗？", function () {
                window.location = "/Pages/business/DeliverWorkBookFahuo.aspx?delete=" + keyid;
            });
        }

        //批量删除
        function onAllDelete() {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
                top.Dialog.alert("请选择要删除的记录", function () {
                });
                return;
            }
            else {
                deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
                top.Dialog.confirm("确定要删除所选记录吗？", function () {
                    window.location = "/Pages/business/DeliverWorkBookFahuo.aspx?deleteKeyIds=" + deleteKeyIds;
                });
            }
        }
        $(function () {
            $(".AlreadyReply").remove();
        });
    </script>
    <style type="text/css">
        .AlreadyReply { display: none; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent">
        <div class="box1" paneltitle="功能面板" roller="false">
            <table class="TableNewStyle">
                <tr>
                     
                    <td class="ali03">
                        客户单位：
                    </td>
                    <td>
                        <span id="spanBuyerName" runat="server"  ></span>
                        <input type="hidden" id="hideOrderId" runat="server" />
                    </td>
                     
                      
                     
                    
                      
                  <%--  <td colspan="8">
                        <asp:Button ID="btn_Submit" Text="查询" runat="server" OnClick="btn_Search_Click" />&nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />
                         <input type="hidden" runat="server" id="hideOrderId" />
                    </td>--%>
                </tr>
            </table>
        </div>
        
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th   style="text-align: center">
                                品种
                            </th>
                            <th style="text-align: center">
                                订单数量
                            </th>
                            <th style="text-align: center">
                                发货数量
                            </th>
                              <th style="text-align: center">
                                未发货数量
                            </th>
                              <th style="text-align: center">
                                已送货数量
                            </th>
                              <th style="text-align: center">
                                库存数量
                            </th>
                              <th style="text-align: center">
                                未送货数量
                            </th>
                             <th style="text-align: center">
                                新增发货
                            </th>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        
                        <td style="text-align: center">
                            <%#Eval("specification")%>  <%#Eval("name")%> 
                            <input type="hidden" name="hidspecification" value="<%#Eval("specification")%>"  />
                            <input type="hidden" name="hidname" value="<%#Eval("name")%>"  />
                            <input type="hidden" name="hidweifahuonums" value="<%#Eval("weifahuonums")%>"  />
                        </td>
                        <td style="text-align: center">
                         <%#Eval("nums")%>
                        </td>
                        <td style="text-align: center">
                           <%#Eval("fahuonums")%> 
                        </td>
                           <td style="text-align: center">
                           <%#Eval("weifahuonums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("songhuonums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("kucunnums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("weisonghuonums")%> 
                        </td>
                          <td style="text-align: center">
                          <input type="text"   name="fahuoCount"    style="height: 15px; line-height: 15px; width:80px;" class="validateInt req" defaultValue="0" value="0"/>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                     <tr>
            <td colspan="8" align="center">
                <asp:Button ID="btn_submit" runat="server" Text="提交" OnClick="btn_Submit_form"  />
            </td>
        </tr>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookFahuo.aspx.cs

New file
@@ -0,0 +1,264 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.BLL.Sys;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.EC;
using CY.Model.Inquiry;

namespace CY.WebForm.Pages.business
{
    //吴辉
    //行政管理
    public partial class DeliverWorkBookFahuo : BasePage
    {
        CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null;
        CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null;
        CoreCmsPlanOrderFahuoBLL bll_coreCmsPlanOrderFahuoBLL = null;
        EC_OrderBasicBLL _eC_OrderBasicBLL = null;
        EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null;



        //初始化
        public DeliverWorkBookFahuo()
        {
            bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL();
            bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
            bll_coreCmsPlanOrderFahuoBLL = new CoreCmsPlanOrderFahuoBLL();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            _eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            
            if (!IsPostBack)
            {
                 

                BindList();
            }
             
        }

        //绑定数据
        private void BindList()
        {
            string orderIdStr = Request["orderId"];
            this.hideOrderId.Value = orderIdStr;


            var eC_OrderBasic = _eC_OrderBasicBLL.SelectModelById(orderIdStr.ToInt32().Value);
            if (eC_OrderBasic != null)
            {
                spanBuyerName.InnerText = eC_OrderBasic.BuyerName;
            }

           // var cmsPlanOrderItems = bll_CoreCmsPlanOrderItemBLL.GetModelsByZongOrderid(orderIdStr.ToInt32().Value);

            var coreDeliverOrderItems = bll_CoreCmsPlanOrderItemBLL.GetDeliverModelsByZongOrderid(orderIdStr.ToInt32().Value).Where(x=>x.OrderState == 2);

            var coreCmsPlanOrderFahuos = bll_coreCmsPlanOrderFahuoBLL.GetModelsByOrderid(orderIdStr.ToInt32().Value);


            ////订单数量统计
            //var cmsPlanOrderItemsgroup = cmsPlanOrderItems.GroupBy(p => new { p.name, p.specification }) // 多个字段作为匿名类型分组键
            //.Select(g => new CoreCmsPlanOrderItem
            //{
            //    // 分组字段
            //    name = g.Key.name,
            //    specification = g.Key.specification,
            //    // 统计结果
            //    //Count = g.Count(), // 每组人数
            //    //AverageSalary = g.Average(p => p.Salary), // 平均工资
            //    nums = g.Sum(p => p.nums) // 工资总和
            //}).ToList();

            EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(orderIdStr.ToInt32().Value);
            InquiryCommonModel _inquiryCommonModel = null;
            if (null == _eC_OrderPrintParameter)
            {
                _inquiryCommonModel = new InquiryCommonModel();
            }
            else
            {
                _inquiryCommonModel = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), _eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel;

            }
            var inquiryWorkBookModels = _inquiryCommonModel.InquiryWorkBookList.OrderBy(x => x.WorkBookNameTxt).ThenBy(x => x.WorkBookSizeTxt);

            var cmsPlanOrderItemsgroup = new List<CoreCmsPlanOrderItem>();
            foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
            {
                var coreCmsPlanOrder = new CoreCmsPlanOrderItem();
                // biaotou += " <th style=\"text-align:center\"> " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " </th> ";

                coreCmsPlanOrder.name = inquiryWorkBookModel.WorkBookNameTxt;
                coreCmsPlanOrder.specification = inquiryWorkBookModel.WorkBookSizeTxt;
                var sss = inquiryWorkBookModel.WorkBookCount.ToInt32();
                coreCmsPlanOrder.nums = sss.HasValue ? sss.Value : 0;
                cmsPlanOrderItemsgroup.Add(coreCmsPlanOrder);

            }


            //发货数量统计
            var coreCmsPlanOrderFahuosgroup = coreCmsPlanOrderFahuos.GroupBy(p => new { p.name, p.specification }) // 多个字段作为匿名类型分组键
            .Select(g => new CoreCmsPlanOrderFahuo
            {
                // 分组字段
                name = g.Key.name,
                specification = g.Key.specification,
                // 统计结果
                //Count = g.Count(), // 每组人数
                //AverageSalary = g.Average(p => p.Salary), // 平均工资
                nums = g.Sum(p => p.nums) // 工资总和
            }).ToList();


            //送货数量统计
            var coreDeliverOrderItemsgroup = coreDeliverOrderItems.GroupBy(p => new { p.ZYBName, p.ZYBSpecification }) // 多个字段作为匿名类型分组键
            .Select(g => new CoreDeliverOrderItem
            {
                // 分组字段
                ZYBName = g.Key.ZYBName,
                ZYBSpecification = g.Key.ZYBSpecification,
                // 统计结果
                //Count = g.Count(), // 每组人数
                //AverageSalary = g.Average(p => p.Salary), // 平均工资
                Number = g.Sum(p => p.Number) // 工资总和
            }).ToList();




            foreach(var cmsPlanOrderItem in cmsPlanOrderItemsgroup)
            {
                var coreCmsPlanOrderFahuo = coreCmsPlanOrderFahuosgroup.FirstOrDefault(x => x.name == cmsPlanOrderItem.name && x.specification == cmsPlanOrderItem.specification);
                if (coreCmsPlanOrderFahuo != null)
                {
                    cmsPlanOrderItem.fahuonums = coreCmsPlanOrderFahuo.nums;
                }
                cmsPlanOrderItem.weifahuonums = cmsPlanOrderItem.nums - cmsPlanOrderItem.fahuonums;

                var coreDeliverOrderItem = coreDeliverOrderItemsgroup.FirstOrDefault(x => x.ZYBName == cmsPlanOrderItem.name && x.ZYBSpecification == cmsPlanOrderItem.specification);
                if (coreDeliverOrderItem != null)
                {
                    cmsPlanOrderItem.songhuonums = coreDeliverOrderItem.Number;
                }
                    
              
                cmsPlanOrderItem.kucunnums = cmsPlanOrderItem.fahuonums - cmsPlanOrderItem.songhuonums;


                cmsPlanOrderItem.weisonghuonums = cmsPlanOrderItem.nums - cmsPlanOrderItem.songhuonums;
            }









            this.RepClientList.DataSource = cmsPlanOrderItemsgroup;
            this.RepClientList.DataBind();
            
        }
 

        //查询事件
        protected void btn_Search_Click(object src, EventArgs e)
        {
            BindList();
        }


        //提交事件
        protected void btn_Submit_form(object sender, EventArgs e)
        {
            try
            {

              var orderIdStr =  this.hideOrderId.Value ;

              var hidspecification = Request["hidspecification"];
                var hidname = Request["hidname"];
                var fahuoCount = Request["fahuoCount"];
                var hidweifahuonums = Request["hidweifahuonums"]; 

                var fahuos = fahuoCount.Split(',');
                var names = hidname.Split(',');
                var specifications = hidspecification.Split(',');
                var weifahuonumss = hidweifahuonums.Split(',');

                bool yanzheng = false;

                for (int i = 0; i < fahuos.Length; i++)
                {
                    var fahuo = fahuos[i].ToInt32();
                    if (fahuo.HasValue && fahuo.Value > 0)
                    {
                        yanzheng = true;
                    }
                    var weifahuonums = weifahuonumss[i].ToInt32();
                    if(fahuo.Value > weifahuonums.Value)
                    {
                        JavaScript.MessageBox((i+1)+"行发货数量大于未发货数量", this);
                        return;
                    }

                }

                if (!yanzheng)
                {
                    JavaScript.MessageBox( "没有填写发货数量", this);
                    return;
                }
                var ssss = false;
                for (int i = 0; i < fahuos.Length; i++)
                {
                    var coreCmsPlanOrder = new CoreCmsPlanOrderFahuo();
                    coreCmsPlanOrder.orderId = orderIdStr.ToInt32().Value;
                    coreCmsPlanOrder.name = names[i];
                    coreCmsPlanOrder.specification = specifications[i];
                    coreCmsPlanOrder.nums = fahuos[i].ToInt32().Value;
                    coreCmsPlanOrder.createTime = DateTime.Now;
                    coreCmsPlanOrder.upDataTime = coreCmsPlanOrder.createTime;
                    coreCmsPlanOrder.createBy = CurrentUser.ShortName;
                    coreCmsPlanOrder.upDataBy = CurrentUser.ShortName;
                    ssss= bll_coreCmsPlanOrderFahuoBLL.InsertModel(coreCmsPlanOrder);
                }

             

                //bll_EC_SpecialOrdersBLL.AddSpecialForums(m_EC_OrderOperate, m_EC_SpecialOrders, m_OA_OrderWorkListRelation, m_EC_SpecialForumsList, m_OA_InventoryList, m_OA_OutOfStorageList)
                if (ssss)
                    {
                        JavaScript.MessageBox("操作成功", this,true,false);

                    }
                    else
                    {
                       
                        JavaScript.MessageBox("提交失败", this);
                    }
               
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("提交失败", this);
            }
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookFahuo.aspx.designer.cs

New file
@@ -0,0 +1,71 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class DeliverWorkBookFahuo
    {

        /// <summary>
        /// Head1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlHead Head1;

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// spanBuyerName 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanBuyerName;

        /// <summary>
        /// hideOrderId 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden hideOrderId;

        /// <summary>
        /// RepClientList 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepClientList;
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookList.aspx

@@ -10,7 +10,10 @@
        function onViewCarViolation(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarViolationList.aspx?carid=" + keyid, Title: "违章管理", Width: 1000, Height: 660 });
        }

        //查看客户资料
        function View(personId) {
            top.Dialog.open({ URL: "/Pages/business/CorporateClientsDetail.aspx?keyid=" + personId, Title: "查看客户", Width: 900, Height: 580 });
        }
        //保养
        function onViewCarMaintenance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarMaintenanceList.aspx?carid=" + keyid, Title: "保养管理", Width: 1000, Height: 660 });
@@ -29,10 +32,23 @@
        function onViewCarInsurance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookSonghuo.aspx?orderId=" + keyid, Title: "查看送货情况", Width: 1500, Height: 900 });
        }
        //保险
        function onViewfahuo(keyid) {
            top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookfahuoqingkuang.aspx?orderId=" + keyid, Title: "查看发货情况",  Width: 1500, Height: 900 });
        }
        

        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookDetail.aspx?orderId=" + keyid, Title: "查看明细", Width: 1500, Height: 900 });
        }
        //新增发货
        function onViewXinzengsonghuo(keyid) {
            top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookFahuo.aspx?orderId=" + keyid, Title: "新增发货", Width: 1500, Height: 900 });
        }
        //库存盘点
        function onViewKucunpandian(keyid) {
            top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookPandian.aspx?orderId=" + keyid, Title: "库存盘点", Width: 1500, Height: 900 });
        }

        //添加
@@ -87,7 +103,7 @@
                    <td style="width: 215px">
                        <input id="txtBeginDate" type="text" runat="server" class='date w80px' maxlength='10' />-<input id="txtEndDate" type="text" runat="server" class='date w80px' maxlength='10' />
                    </td>
                    <td class="ali03">
                   <%-- <td class="ali03">
                        订单编号：
                    </td>
                    <td>
@@ -98,6 +114,12 @@
                    </td>
                    <td>
                        <input id='txtSearchyjname' runat="server" maxlength='50' />
                    </td>--%>
                    <td class="ali03">
                        客户名称：
                    </td>
                    <td>
                        <input id='txtBuyerName' runat="server" maxlength='100' />
                    </td>
                      <td class="ali03">
                        客户经理：
@@ -120,6 +142,9 @@
                    </td>
                    <td>
                        <select keepdefaultstyle='true' id='selOrderStates' runat="server" datatextfield="Name" datavaluefield="MeanValue">
                            <option value="">全部</option>
                            <option value="0" selected="selected">未送货</option>
                            <option value="1">已送货</option>
                        </select>
                    </td>
                    <td colspan="8">
@@ -139,6 +164,9 @@
                            </th>
                            <th style="text-align: center">
                                订单号
                            </th>
                             <th style="text-align: center">
                                客户名称
                            </th>
                            <th style="text-align: center">
                                印件名称
@@ -169,6 +197,11 @@
                        <td style="text-align: center">
                         <%#Eval("SellerOrderId")%>
                        </td>
                           <td style="text-align: center;">
                                 <div style="word-wrap: break-word; text-align:justify;">
                                    <a href='javascript:void(0)' title='<%#Eval("BuyerName").ToString()%>' class='a_under' onclick='View("<%#Eval("BuyerId")%>")'><%#Eval("BuyerName").ToString().Length > 22 ? (Eval("BuyerName").ToString().Substring(0, 22) + "..") : Eval("BuyerName").ToString()%></a>
                                        </div>
                                </td>
                        <td style="text-align: center">
                           <%#Eval("DocumentName")%>
                        </td>
@@ -187,6 +220,11 @@
                            <span  onclick="onEdit('<%#Eval("Keyid")%>')">查看明细</span>
                            <span   onclick="onDele('<%#Eval("Keyid")%>')">打印送货单</span>
                             <span   onclick="onViewCarInsurance('<%#Eval("Keyid")%>')">查看送货情况</span>

                             <span  menu_member_case_id="case_Xinzengsonghuo" menu_member_case_name="新增发货 "   onclick="onViewXinzengsonghuo('<%#Eval("Keyid")%>')">新增发货 </span>
                             <span   menu_member_case_id="case_Kucunpandian" menu_member_case_name="库存盘点"  onclick="onViewKucunpandian('<%#Eval("Keyid")%>')">库存盘点</span>
                             <span   onclick="onViewfahuo('<%#Eval("Keyid")%>')">查看发货情况</span>
                           
                        </td>
                    </tr>
                </ItemTemplate>

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookList.aspx.cs

@@ -50,9 +50,9 @@
                this.selBusinessManager.DataBind();
                this.selBusinessManager.Items.Insert(0, new ListItem("全部", ""));

                this.selOrderStates.DataSource = bll_Sys_DictionaryBLL.GetDataByType("EC_订单状态").Where(p => p.MeanValue.Value != -5 && p.MeanValue.Value != -4);
                this.selOrderStates.DataBind();
                this.selOrderStates.Items.Insert(0, new ListItem("全部", ""));
                //this.selOrderStates.DataSource = bll_Sys_DictionaryBLL.GetDataByType("EC_订单状态").Where(p => p.MeanValue.Value != -5 && p.MeanValue.Value != -4);
                //this.selOrderStates.DataBind();
                //this.selOrderStates.Items.Insert(0, new ListItem("全部", ""));

                BindList();
            }
@@ -66,7 +66,7 @@
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;

            var eC_OrderBasics = bll_EC_OrderBasicBLL.SelectModelPageWorkBook(pa, CurrentUser.MemberId, this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim(), this.txtOrderId.Value.Trim(), this.txtSearchyjname.Value.Trim(), this.selCustormerManager.Value, this.selBusinessManager.Value, this.selOrderStates.Value);
            var eC_OrderBasics = bll_EC_OrderBasicBLL.SelectModelPageWorkBook(pa, CurrentUser.MemberId, this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim(),"","", this.selCustormerManager.Value, this.selBusinessManager.Value, this.selOrderStates.Value,this.txtBuyerName.Value.Trim());
            foreach (var orderBasic in eC_OrderBasics)
            {
                EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(orderBasic.Keyid.Value);

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookList.aspx.designer.cs

@@ -60,22 +60,13 @@
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtEndDate;

        /// <summary>
        /// txtOrderId 控件。
        /// txtBuyerName 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtOrderId;

        /// <summary>
        /// txtSearchyjname 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtSearchyjname;
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtBuyerName;

        /// <summary>
        /// selCustormerManager 控件。

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookPandian.aspx

New file
@@ -0,0 +1,171 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DeliverWorkBookPandian.aspx.cs" Inherits="CY.WebForm.Pages.business.DeliverWorkBookPandian" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>车辆管理</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        //违章
        function onViewCarViolation(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarViolationList.aspx?carid=" + keyid, Title: "违章管理", Width: 1000, Height: 660 });
        }

        //保养
        function onViewCarMaintenance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarMaintenanceList.aspx?carid=" + keyid, Title: "保养管理", Width: 1000, Height: 660 });
        }
        //维修
        function onViewCarrepair(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarrepairList.aspx?carid=" + keyid, Title: "维修管理", Width: 1000, Height: 660 });
        }

        //年检
        function onViewCarExamined(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarExaminedList.aspx?carid=" + keyid, Title: "年检管理", Width: 1000, Height: 660 });
        }

        //保险
        function onViewCarInsurance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarInsuranceList.aspx?carid=" + keyid, Title: "保险管理", Width: 1000, Height: 660 });
        }

        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx?keyid=" + keyid, Title: "车辆信息", Width: 1000, Height: 660 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx", Title: "新增车辆", Width: 1000, Height: 660});
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要删除该记录吗？", function () {
                window.location = "/Pages/business/DeliverWorkBookPandian.aspx?delete=" + keyid;
            });
        }

        //批量删除
        function onAllDelete() {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
                top.Dialog.alert("请选择要删除的记录", function () {
                });
                return;
            }
            else {
                deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
                top.Dialog.confirm("确定要删除所选记录吗？", function () {
                    window.location = "/Pages/business/DeliverWorkBookPandian.aspx?deleteKeyIds=" + deleteKeyIds;
                });
            }
        }
        $(function () {
            $(".AlreadyReply").remove();
        });
    </script>
    <style type="text/css">
        .AlreadyReply { display: none; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent">
        <div class="box1" paneltitle="功能面板" roller="false">
            <table class="TableNewStyle">
                <tr>
                     
                    <td class="ali03">
                        客户单位：
                    </td>
                    <td>
                        <span id="spanBuyerName" runat="server"  ></span>
                        <input type="hidden" id="hideOrderId" runat="server" />
                    </td>
                     
                      
                     
                    
                      
                  <%--  <td colspan="8">
                        <asp:Button ID="btn_Submit" Text="查询" runat="server" OnClick="btn_Search_Click" />&nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />
                         <input type="hidden" runat="server" id="hideOrderId" />
                    </td>--%>
                </tr>
            </table>
        </div>
        
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th   style="text-align: center">
                                品种
                            </th>
                            <th style="text-align: center">
                                订单数量
                            </th>
                            <th style="text-align: center">
                                发货数量
                            </th>
                              <th style="text-align: center">
                                未发货数量
                            </th>
                              <th style="text-align: center">
                                已送货数量
                            </th>
                              <th style="text-align: center">
                                库存数量
                            </th>
                              <th style="text-align: center">
                                未送货数量
                            </th>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        
                        <td style="text-align: center">
                            <%#Eval("specification")%>  <%#Eval("name")%> 
                        </td>
                        <td style="text-align: center">
                         <%#Eval("nums")%>
                        </td>
                        <td style="text-align: center">
                           <%#Eval("fahuonums")%> 
                        </td>
                           <td style="text-align: center">
                           <%#Eval("weifahuonums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("songhuonums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("kucunnums")%> 
                        </td>
                         <td style="text-align: center">
                           <%#Eval("weisonghuonums")%> 
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                 
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookPandian.aspx.cs

New file
@@ -0,0 +1,186 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.BLL.Sys;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.EC;
using CY.Model.Inquiry;

namespace CY.WebForm.Pages.business
{
    //吴辉
    //行政管理
    public partial class DeliverWorkBookPandian : BasePage
    {
        CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null;
        CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null;
        CoreCmsPlanOrderFahuoBLL bll_coreCmsPlanOrderFahuoBLL = null;
        EC_OrderBasicBLL _eC_OrderBasicBLL = null;
        EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null;



        //初始化
        public DeliverWorkBookPandian()
        {
            bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL();
            bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
            bll_coreCmsPlanOrderFahuoBLL = new CoreCmsPlanOrderFahuoBLL();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            _eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            
            if (!IsPostBack)
            {
                 

                BindList();
            }
             
        }

        //绑定数据
        private void BindList()
        {
            string orderIdStr = Request["orderId"];
            this.hideOrderId.Value = orderIdStr;


            var eC_OrderBasic = _eC_OrderBasicBLL.SelectModelById(orderIdStr.ToInt32().Value);
            if (eC_OrderBasic != null)
            {
                spanBuyerName.InnerText = eC_OrderBasic.BuyerName;
            }

            //var cmsPlanOrderItems = bll_CoreCmsPlanOrderItemBLL.GetModelsByZongOrderid(orderIdStr.ToInt32().Value);

            var coreDeliverOrderItems = bll_CoreCmsPlanOrderItemBLL.GetDeliverModelsByZongOrderid(orderIdStr.ToInt32().Value).Where(x=>x.OrderState == 2);

            var coreCmsPlanOrderFahuos = bll_coreCmsPlanOrderFahuoBLL.GetModelsByOrderid(orderIdStr.ToInt32().Value);


            ////订单数量统计
            //var cmsPlanOrderItemsgroup = cmsPlanOrderItems.GroupBy(p => new { p.name, p.specification }) // 多个字段作为匿名类型分组键
            //.Select(g => new CoreCmsPlanOrderItem
            //{
            //    // 分组字段
            //    name = g.Key.name,
            //    specification = g.Key.specification,
            //    // 统计结果
            //    //Count = g.Count(), // 每组人数
            //    //AverageSalary = g.Average(p => p.Salary), // 平均工资
            //    nums = g.Sum(p => p.nums) // 工资总和
            //}).ToList();


            EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(orderIdStr.ToInt32().Value);
            InquiryCommonModel _inquiryCommonModel = null;
            if (null == _eC_OrderPrintParameter)
            {
                _inquiryCommonModel = new InquiryCommonModel();
            }
            else
            {
                _inquiryCommonModel = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), _eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel;

            }
            var inquiryWorkBookModels = _inquiryCommonModel.InquiryWorkBookList.OrderBy(x => x.WorkBookNameTxt).ThenBy(x => x.WorkBookSizeTxt);

            var cmsPlanOrderItemsgroup = new List<CoreCmsPlanOrderItem>();
            foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
            {
                var coreCmsPlanOrder = new CoreCmsPlanOrderItem();
               // biaotou += " <th style=\"text-align:center\"> " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " </th> ";

                coreCmsPlanOrder.name = inquiryWorkBookModel.WorkBookNameTxt;
                coreCmsPlanOrder.specification = inquiryWorkBookModel.WorkBookSizeTxt;
                var sss = inquiryWorkBookModel.WorkBookCount.ToInt32();
                coreCmsPlanOrder.nums = sss.HasValue ? sss.Value : 0;
                cmsPlanOrderItemsgroup.Add(coreCmsPlanOrder);

            }



            //发货数量统计
            var coreCmsPlanOrderFahuosgroup = coreCmsPlanOrderFahuos.GroupBy(p => new { p.name, p.specification }) // 多个字段作为匿名类型分组键
            .Select(g => new CoreCmsPlanOrderFahuo
            {
                // 分组字段
                name = g.Key.name,
                specification = g.Key.specification,
                // 统计结果
                //Count = g.Count(), // 每组人数
                //AverageSalary = g.Average(p => p.Salary), // 平均工资
                nums = g.Sum(p => p.nums) // 工资总和
            }).ToList();


            //送货数量统计
            var coreDeliverOrderItemsgroup = coreDeliverOrderItems.GroupBy(p => new { p.ZYBName, p.ZYBSpecification }) // 多个字段作为匿名类型分组键
            .Select(g => new CoreDeliverOrderItem
            {
                // 分组字段
                ZYBName = g.Key.ZYBName,
                ZYBSpecification = g.Key.ZYBSpecification,
                // 统计结果
                //Count = g.Count(), // 每组人数
                //AverageSalary = g.Average(p => p.Salary), // 平均工资
                Number = g.Sum(p => p.Number) // 工资总和
            }).ToList();




            foreach(var cmsPlanOrderItem in cmsPlanOrderItemsgroup)
            {
                var coreCmsPlanOrderFahuo = coreCmsPlanOrderFahuosgroup.FirstOrDefault(x => x.name == cmsPlanOrderItem.name && x.specification == cmsPlanOrderItem.specification);
                if (coreCmsPlanOrderFahuo != null)
                {
                    cmsPlanOrderItem.fahuonums = coreCmsPlanOrderFahuo.nums;
                }
                cmsPlanOrderItem.weifahuonums = cmsPlanOrderItem.nums - cmsPlanOrderItem.fahuonums;

                var coreDeliverOrderItem = coreDeliverOrderItemsgroup.FirstOrDefault(x => x.ZYBName == cmsPlanOrderItem.name && x.ZYBSpecification == cmsPlanOrderItem.specification);
                if (coreDeliverOrderItem != null)
                {
                    cmsPlanOrderItem.songhuonums = coreDeliverOrderItem.Number;
                }
                    
              
                cmsPlanOrderItem.kucunnums = cmsPlanOrderItem.fahuonums - cmsPlanOrderItem.songhuonums;


                cmsPlanOrderItem.weisonghuonums = cmsPlanOrderItem.nums - cmsPlanOrderItem.songhuonums;
            }









            this.RepClientList.DataSource = cmsPlanOrderItemsgroup;
            this.RepClientList.DataBind();
            
        }
 

      


      
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookPandian.aspx.designer.cs

New file
@@ -0,0 +1,71 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class DeliverWorkBookPandian
    {

        /// <summary>
        /// Head1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlHead Head1;

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// spanBuyerName 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanBuyerName;

        /// <summary>
        /// hideOrderId 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden hideOrderId;

        /// <summary>
        /// RepClientList 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepClientList;
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookfahuoqingkuang.aspx

New file
@@ -0,0 +1,166 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DeliverWorkBookfahuoqingkuang.aspx.cs" Inherits="CY.WebForm.Pages.business.DeliverWorkBookfahuoqingkuang" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>车辆管理</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        //违章
        function onViewCarViolation(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarViolationList.aspx?carid=" + keyid, Title: "违章管理", Width: 1000, Height: 660 });
        }

        //保养
        function onViewCarMaintenance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarMaintenanceList.aspx?carid=" + keyid, Title: "保养管理", Width: 1000, Height: 660 });
        }
        //维修
        function onViewCarrepair(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarrepairList.aspx?carid=" + keyid, Title: "维修管理", Width: 1000, Height: 660 });
        }

        //年检
        function onViewCarExamined(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarExaminedList.aspx?carid=" + keyid, Title: "年检管理", Width: 1000, Height: 660 });
        }

        //保险
        function onViewCarInsurance(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarInsuranceList.aspx?carid=" + keyid, Title: "保险管理", Width: 1000, Height: 660 });
        }

        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx?keyid=" + keyid, Title: "车辆信息", Width: 1000, Height: 660 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx", Title: "新增车辆", Width: 1000, Height: 660});
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要删除该记录吗？", function () {
                window.location = "/Pages/business/DeliverWorkBookfahuoqingkuang.aspx?delete=" + keyid;
            });
        }

        //批量删除
        function onAllDelete() {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
                top.Dialog.alert("请选择要删除的记录", function () {
                });
                return;
            }
            else {
                deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
                top.Dialog.confirm("确定要删除所选记录吗？", function () {
                    window.location = "/Pages/business/DeliverWorkBookfahuoqingkuang.aspx?deleteKeyIds=" + deleteKeyIds;
                });
            }
        }
        $(function () {
            $(".AlreadyReply").remove();
        });
    </script>
    <style type="text/css">
        .AlreadyReply { display: none; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent">
        <div class="box1" paneltitle="功能面板" roller="false">
            <table class="TableNewStyle">
                <tr>
                     
                    <td class="ali03">
                        发货时间：
                    </td>
                    <td>
                       <input id="txtBeginDate" type="text" runat="server" class='date w80px' maxlength='10' />-<input id="txtEndDate" type="text" runat="server" class='date w80px' maxlength='10' />
                    </td>
                   <%--  <td class="ali03">
                        学校：
                    </td>
                    <td>
                        <input id='txtxuexiao' runat="server" maxlength='50' />
                    </td>
                      
                      <td class="ali03 " style="padding-left: 20px">
                    送货状态：
                </td>
                <td>
                     <select id="selstatus" keepdefaultstyle='true' runat="server" >
                            <option selected="selected" value="">全部</option>
                            <option value="0">未配送</option>
                            <option value="1">配送中</option>
                            <option value="2">已配送</option>
                        </select>
                </td>--%>
                    
                      
                    <td colspan="8">
                        <asp:Button ID="btn_Submit" Text="查询" runat="server" OnClick="btn_Search_Click" />&nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />
                         <input type="hidden" runat="server" id="hideOrderId" />
                    </td>
                </tr>
            </table>
        </div>
        
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th width="30" style="text-align: center" >
                                编号
                            </th>
                            <th style="text-align: center" >
                                发货日期
                            </th>
                            <th style="text-align: center" >
                                客户单位
                            </th>
                             <%=biaotou %>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1%>
                        </td>
                        <td style="text-align: center">
                         <%#Eval("createTime","{0:yyyy-MM-dd}")%> 
                        </td>
                        <td style="text-align: center">
                           <%#Eval("name")%>
                        </td>
                          <%#Eval("biaoge")%>
                         
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                      <tr>
                      <%=biaowei %>
                            </tr>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookfahuoqingkuang.aspx.cs

New file
@@ -0,0 +1,187 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.BLL.Sys;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.EC;
using CY.Model.Inquiry;

namespace CY.WebForm.Pages.business
{
    //吴辉
    //行政管理
    public partial class DeliverWorkBookfahuoqingkuang : BasePage
    {
        CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null;
       // CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null;
        EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null;
        CoreCmsPlanOrderFahuoBLL bll_coreCmsPlanOrderFahuoBLL = null;
        EC_OrderBasicBLL _eC_OrderBasicBLL = null;
        public string biaotou = "";
        public string biaowei = "";


        //初始化
        public DeliverWorkBookfahuoqingkuang()
        {
            bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL();
           // bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
            _eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
            bll_coreCmsPlanOrderFahuoBLL = new CoreCmsPlanOrderFahuoBLL();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            
            if (!IsPostBack)
            {
                 

                BindList();
            }
             
        }

        //绑定数据
        private void BindList()
        {
            string orderIdStr = Request["orderId"];
            this.hideOrderId.Value = orderIdStr;

            //var coreCmsPlanOrders = bll_CoreCmsPlanOrderBLL.GetModelByorderid(orderIdStr.ToInt32().Value);

            

            var coreCmsPlanOrderFahuos = bll_coreCmsPlanOrderFahuoBLL.GetModelsByOrderid(orderIdStr.ToInt32().Value);
            var BeginDate = this.txtBeginDate.Value.Trim();
            if (!string.IsNullOrEmpty(BeginDate))
            {
                var sss = BeginDate.ToDateTime2().Value;
                coreCmsPlanOrderFahuos = coreCmsPlanOrderFahuos.Where(x => x.createTime >= sss);
            }
            var EndDate = this.txtEndDate.Value.Trim();
            if (!string.IsNullOrEmpty(EndDate))
            {
                var sss = EndDate.ToDateTime2().Value.AddDays(1);
                coreCmsPlanOrderFahuos = coreCmsPlanOrderFahuos.Where(x => x.createTime <= sss);
            }


            var corname = "";

            var eC_OrderBasic = _eC_OrderBasicBLL.SelectModelById(orderIdStr.ToInt32().Value);
            if (eC_OrderBasic != null)
            {
                corname = eC_OrderBasic.BuyerName;
            }





            EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(orderIdStr.ToInt32().Value);
            InquiryCommonModel _inquiryCommonModel = null;
            if (null == _eC_OrderPrintParameter)
            {
                _inquiryCommonModel = new InquiryCommonModel();
            }
            else
            {
                _inquiryCommonModel = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), _eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel;

            }
           var inquiryWorkBookModels  = _inquiryCommonModel.InquiryWorkBookList.OrderBy(x=>x.WorkBookNameTxt).ThenBy(x=>x.WorkBookSizeTxt);
          
            if (string.IsNullOrEmpty(biaotou))
            {
                string biaotou2 = " <th style=\"text-align:center\" >  </th> <th style=\"text-align:center\" >  </th> <th style=\"text-align:center\" >  </th>";
                foreach (var inquiryWorkBookModel  in inquiryWorkBookModels)
                {
                    biaotou += " <th style=\"text-align:center\" colspan=\"2\"> " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " </th> ";
                    biaotou2+= " <th style=\"text-align:center\" > 已发 </th> <th style=\"text-align:center\" > 未发 </th> ";


                }
                biaotou +="</tr><tr>"+ biaotou2+ "</tr>";
            }
            biaowei = "   <td style=\"text-align:center\"> 合计 </td><td style=\"text-align:center\">  </td> <td style=\"text-align:center\">  </td> ";

            foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
            {
                var nums = coreCmsPlanOrderFahuos.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x => x.nums);

                var ssss = 0;

                int.TryParse(inquiryWorkBookModel.WorkBookCount, out ssss);

                biaowei += " <td style=\"text-align:center\"> " + nums + " </td>  <td style=\"text-align:center\">  <span style=\"color:red;\" >" + (ssss - nums) + " </span></td>";

            }




          var  cmsPlanOrderFahuos  =  coreCmsPlanOrderFahuos.GroupBy(p => new { p.createTime.Value.Date }).Select(g => new CoreCmsPlanOrderFahuo
            {
                // 分组字段
                createTime = g.Key.Date,
                
            }).OrderByDescending(x=>x.createTime).ToList();

            foreach (var cmsPlanOrderFahuo  in cmsPlanOrderFahuos)
            {

                cmsPlanOrderFahuo.name = corname;

                var cmsPlanOrderFahuos1 = coreCmsPlanOrderFahuos.Where(x => x.createTime.Value.Date == cmsPlanOrderFahuo.createTime);
                foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
                {
                    var nums = cmsPlanOrderFahuos1.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x=>x.nums);

                    var ssss = 0;

                    int.TryParse(inquiryWorkBookModel.WorkBookCount, out ssss);
                    cmsPlanOrderFahuo.biaoge += " <td style=\"text-align:center\"> " + nums + " </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (ssss - nums) + " </span></td>";

                    //if (cmsPlanOrderItem != null)
                    //{
                    //    var coreDeliverOrderItems1 = coreDeliverOrderItems.Where(x =>x.PlanOrderId == coreCmsPlanOrder.id && x.ZYBName == inquiryWorkBookModel.WorkBookNameTxt && x.ZYBSpecification == inquiryWorkBookModel.WorkBookSizeTxt);

                    //    var Number = coreDeliverOrderItems1.Sum(x => x.Number);
                    //    var LessNumber = coreDeliverOrderItems1.Sum(x => x.LessNumber);


                    //}
                    //else
                    //{
                    //    coreCmsPlanOrder.biaoge += " <td style=\"text-align:center\"> 0 </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >0</span></td> ";
                    //}

                }

            }

             


            this.RepClientList.DataSource = cmsPlanOrderFahuos;
            this.RepClientList.DataBind();
            
        }
 

        //查询事件
        protected void btn_Search_Click(object src, EventArgs e)
        {
            BindList();
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookfahuoqingkuang.aspx.designer.cs

New file
@@ -0,0 +1,89 @@
//------------------------------------------------------------------------------
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class DeliverWorkBookfahuoqingkuang
    {

        /// <summary>
        /// Head1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlHead Head1;

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;

        /// <summary>
        /// form1 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// txtBeginDate 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtBeginDate;

        /// <summary>
        /// txtEndDate 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtEndDate;

        /// <summary>
        /// btn_Submit 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button btn_Submit;

        /// <summary>
        /// hideOrderId 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden hideOrderId;

        /// <summary>
        /// RepClientList 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepClientList;
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/business/Waixiefukuanweikaipiao.aspx.cs

@@ -461,8 +461,8 @@

 

                this.txtSQBeginDate.Value = DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd");
                this.txtSQEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
                //this.txtSQBeginDate.Value = DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd");
                //this.txtSQEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
                
                //初次数据加载
                btn_Search_Click(btn_Search, new EventArgs());

 CY_ECommercePlatform/CY.WebForm/Pages/work/BaoxiaoReplyList.aspx

@@ -222,12 +222,20 @@
            </asp:Repeater>
             <tr class="StatisticsMoney">
                    <td colspan="8" class="ali03">
                        合计：
                        当前页统计：
                    </td>
                    <td colspan="5" class="ali01">
                        <span id="NowMoney" runat="server" ></span>
                    </td>
                </tr>
                    <tr class="StatisticsMoney">
                    <td colspan="8" class="ali03">
                        查询项统计：
                    </td>
                    <td colspan="5" class="ali01">
                       <span id="AllMoney" runat="server"></span>
                    </td>
                </tr>
                    </table>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />

 CY_ECommercePlatform/CY.WebForm/Pages/work/BaoxiaoReplyList.aspx.cs

@@ -214,7 +214,7 @@


            }

            this.AllMoney.InnerText = pa.heji1.Value.ToString("0.00");
          
            this.NowMoney.InnerText = oA_WorkPlans.Sum(x => x.PlanMoney).Value.ToString("F2");
            this.RepClientList.DataSource = oA_WorkPlans;

 CY_ECommercePlatform/CY.WebForm/Pages/work/BaoxiaoReplyList.aspx.designer.cs

@@ -123,6 +123,15 @@
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl NowMoney;

        /// <summary>
        /// AllMoney 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl AllMoney;

        /// <summary>
        /// UCPager1 控件。
        /// </summary>
        /// <remarks>

 CY_ECommercePlatform/CY.WebForm/Pages/work/RequestReplyList.aspx

@@ -166,7 +166,26 @@
                        </td>
                    </tr>
                </ItemTemplate>
                 
                <FooterTemplate>
                    <tr class="StatisticsMoney">
                    <td colspan="5" class="ali03">
                        当前页统计：
                    </td>
                    <td colspan="3" class="ali01">
                       <%-- <span id="NowMoney" runat="server"  ></span>--%>
                        <%=NowMoney %>
                    </td>
                </tr>
                    <tr class="StatisticsMoney">
                    <td colspan="5" class="ali03">
                        查询项统计：
                    </td>
                    <td colspan="3" class="ali01">
                      <%--<span id="AllMoney" runat="server"  ></span>--%>
                        <%=AllMoney %>
                    </td>
                </tr>
                    </table>
                </FooterTemplate>
            </asp:Repeater>

 CY_ECommercePlatform/CY.WebForm/Pages/work/RequestReplyList.aspx.cs

@@ -18,6 +18,9 @@
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_WorkPlanBll bll_OA_WorkPlanBll = null;
        public string NowMoney = "";
        public string AllMoney = "";
        

        //初始化
        public RequestReplyList()
@@ -44,7 +47,10 @@
            DateTime? endTime = null;
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            this.RepClientList.DataSource = bll_OA_WorkPlanBll.SelectModelPage(pa, CurrentUser.MemberId, Guid.Empty, Guid.Empty, 3, this.selRemenderType.Value.ToInt32(), "", null, null, string.IsNullOrEmpty(this.txtRegTimeStart.Value) ? beginTime : Convert.ToDateTime(this.txtRegTimeStart.Value), string.IsNullOrEmpty(this.txtRegTimeEnd.Value) ? endTime : Convert.ToDateTime(this.txtRegTimeEnd.Value),this.txtPlanPeople.Value.Trim(), this.selPlanStatus.Value.ToInt32(), this.selApprovalStatus.Value.ToInt32(), null, null);
            var oA_WorkPlans = bll_OA_WorkPlanBll.SelectModelPage(pa, CurrentUser.MemberId, Guid.Empty, Guid.Empty, 3, this.selRemenderType.Value.ToInt32(), "", null, null, string.IsNullOrEmpty(this.txtRegTimeStart.Value) ? beginTime : Convert.ToDateTime(this.txtRegTimeStart.Value), string.IsNullOrEmpty(this.txtRegTimeEnd.Value) ? endTime : Convert.ToDateTime(this.txtRegTimeEnd.Value), this.txtPlanPeople.Value.Trim(), this.selPlanStatus.Value.ToInt32(), this.selApprovalStatus.Value.ToInt32(), null, null);
            AllMoney = pa.heji1.Value.ToString("0.00");
            NowMoney = oA_WorkPlans.Sum(x => x.PlanMoney).Value.ToString("F2");
            this.RepClientList.DataSource = oA_WorkPlans;
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }