请示类别要增加 维修申请 维修付款申请

username@email.com

2025-10-09 b63e4e9f97aba58867a01b85e7d128b6eb738a0a

请示类别要增加  维修申请   维修付款申请

维修申请的时候可以同步申请费用

维修申请  审批的时候要加上追责  责任人  金额

分类  办公设备、生产设备、车辆、其他

菜单  设备管理   14     =》设备管理 01  =》  设备分类   /Pages/Property/ShebeiCateList.aspx   04    一堆用例

                                                          =》设备管理 /Pages/Property/ShebeimanageList.aspx  02 一堆用例
                                                          =>  维修管理  /Pages/Property/ShebeiWeixiuList.aspx  03 一堆用例

字典表   工作计划性质   18   设备维修申请     19 维修付款申请  完成

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiCate]    Script Date: 2025/9/28 9:02:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiCate](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [Name] [varchar](50) NULL,
 [Status] [int] NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [varchar](20) NULL,
 [Remark] [varchar](200) NULL,
 CONSTRAINT [PK_OA_ShebeiCate] PRIMARY KEY CLUSTERED
(
 [Keyid] 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

 USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiManage]    Script Date: 2025/9/28 9:45:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiManage](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [CateId] [int] NULL,
 [Name] [nvarchar](50) NULL,
 [Price] [money] NULL,
 [Anzhuangdidian] [nvarchar](20) NULL,
 [QiyongTime] [datetime] NULL,
 [Status] [int] NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [nvarchar](20) NULL,
 [Remark] [nvarchar](500) NULL,
 CONSTRAINT [PK_OA_ShebeiManage] PRIMARY KEY CLUSTERED
(
 [Keyid] 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

 USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_ShebeiWeixiu]    Script Date: 2025/9/28 9:45:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_ShebeiWeixiu](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [ShebeiId] [int] NULL,
 [WeixiuTime] [datetime] NULL,
 [CateId] [int] NULL,
 [Anzhuangdidian] [nvarchar](20) NULL,
 [Name] [nvarchar](50) NULL,
 [Remark] [nvarchar](500) NULL,
 [WeixiuPrice] [money] NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [DanzePrice] [money] NULL,

 [WeixiuShebeiId] [int] NULL,
 [FukuanShebeiId] [int] NULL,
 [FukuanshenqingId] [int] NULL,
 [Shifoufufei] [int] NULL,
 [CreateTime] [datetime] NULL,
 [Creator] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [nvarchar](20) NULL,

 CONSTRAINT [PK_OA_ShebeiWeixiu] PRIMARY KEY CLUSTERED
(
 [Keyid] 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

update   [OA_Kaipiaoshenqing] set Huikuanmoney = Kehumoney  where  [Shenqingleixing]='预付款开票';

-- 表结构：employees(id, dept_id, salary, dept_avg_salary)  where  a.KaipiaoshenqingId =
UPDATE [OA_Kaipiaoshenqing]
SET  Huikuanmoney = aaa.PayedMoney

from  (

select eoe.KaipiaoshenqingId ,sum(pt.PayedMoney) PayedMoney  from  [EC_OrderExtend] eoe inner join Pay_TradingSingle pt    on    eoe.Keyid = pt.OrderId  GROUP BY eoe.KaipiaoshenqingId

) as aaa   where [OA_Kaipiaoshenqing].Keyid = aaa.KaipiaoshenqingId and     [OA_Kaipiaoshenqing].[Shenqingleixing]='订单开票';

 CY_ECommercePlatform/AbstractFactory/Factory.cs

@@ -274,6 +274,9 @@
            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_ShebeiCateDAL, "OA_ShebeiCateDAL");
            OBJECT_PATH.Add(DALInterface.IOA_ShebeiManageDAL, "OA_ShebeiManageDAL");
            OBJECT_PATH.Add(DALInterface.IOA_ShebeiWeixiuDAL, "OA_ShebeiWeixiuDAL"); 
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewDAL, "OA_KaipiaonewDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderDAL, "CoreCmsPlanOrderDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderItemDAL, "CoreCmsPlanOrderItemDAL");
@@ -960,6 +963,20 @@
        /// </summary>
        ICoreCmsPlanOrderFahuoDAL = 1946,

        /// <summary>
        /// Shebei分类数据访问接口
        /// </summary>
        IOA_ShebeiCateDAL = 1947,
        /// <summary>
        /// Shebei管理数据访问接口
        /// </summary>
        IOA_ShebeiManageDAL = 1948,

        /// <summary>
        /// Shebei管理数据访问接口
        /// </summary>
        IOA_ShebeiWeixiuDAL = 1949,


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

 CY_ECommercePlatform/CY.BLL/CY.BLL.csproj

@@ -183,7 +183,10 @@
    <Compile Include="OA\OA_KaipiaonewcuishouBLL.cs" />
    <Compile Include="OA\OA_KaipiaonewhuikuanBLL.cs" />
    <Compile Include="OA\OA_KaipiaoshenqingBLL.cs" />
    <Compile Include="OA\OA_ShebeiCateBLL.cs" />
    <Compile Include="OA\OA_PropertyCateBLL.cs" />
    <Compile Include="OA\OA_ShebeiWeixiuBLL.cs" />
    <Compile Include="OA\OA_ShebeiManageBLL.cs" />
    <Compile Include="OA\OA_PropertyManageBLL.cs" />
    <Compile Include="OA\OA_PropertyRecordBLL.cs" />
    <Compile Include="OA\OA_ShejijijianBLL.cs" />

 CY_ECommercePlatform/CY.BLL/OA/OA_ShebeiCateBLL.cs

New file
@@ -0,0 +1,87 @@
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 OA_ShebeiCateBLL
    {
        IOA_ShebeiCateDAL iOA_ShebeiCateDAL = null;

        public OA_ShebeiCateBLL()
        {
            iOA_ShebeiCateDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShebeiCateDAL) as IOA_ShebeiCateDAL;
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertModel(Model.OA_ShebeiCate model)
        {
            return iOA_ShebeiCateDAL.InserModel(model);
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Model.OA_ShebeiCate model)
        {

            return iOA_ShebeiCateDAL.UpdateModel(model);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Model.OA_ShebeiCate model)
        {

            return iOA_ShebeiCateDAL.DeleteModel(model);
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiCate GetModelByKeyid(int? Keyid)
        {
            return iOA_ShebeiCateDAL.GetModelByKeyid(Keyid);
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> SelectModelPage(Infrastructure.Query.Pagination pagination,Guid _MemberId,string _Name,int? _Status,DateTime? _BeginLastUpdateTime,DateTime? _EndLastUpdateTime,string _Operator,string _Remark)
        {
            return iOA_ShebeiCateDAL.SelectModelPage(pagination, _MemberId, _Name, _Status,_BeginLastUpdateTime,_EndLastUpdateTime, _Operator, _Remark);
        }

        /// <summary>
        /// 检测物品分类是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public int IsExitsName(string Name, Guid MemberId, string Keyid)
        {
           return  iOA_ShebeiCateDAL.IsExitsName(Name,MemberId,Keyid);
        }
    }
}

 CY_ECommercePlatform/CY.BLL/OA/OA_ShebeiManageBLL.cs

New file
@@ -0,0 +1,129 @@
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 OA_ShebeiManageBLL
    {
        IOA_ShebeiManageDAL iOA_ShebeiManageDAL = null;

        public OA_ShebeiManageBLL()
        {
            iOA_ShebeiManageDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShebeiManageDAL) as IOA_ShebeiManageDAL;
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertModel(Model.OA_ShebeiManage model)
        {
            return iOA_ShebeiManageDAL.InserModel(model);
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Model.OA_ShebeiManage model)
        {

            return iOA_ShebeiManageDAL.UpdateModel(model);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Model.OA_ShebeiManage model)
        {

            return iOA_ShebeiManageDAL.DeleteModel(model);
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiManage GetModelByKeyid(int? Keyid)
        {
            return iOA_ShebeiManageDAL.GetModelByKeyid(Keyid);
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name, int? _Status, string Anzhuangdidian, int? Zerenren)
        {
            return iOA_ShebeiManageDAL.SelectModelPage(pagination, _MemberId, _CateId, _Name, _Status, Anzhuangdidian, Zerenren);
        }


        /// <summary>
        /// 查询全部
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> SelectAllModel(Query query)
        {
            return iOA_ShebeiManageDAL.SelectAllModel( query);
        }

        /// <summary>
        /// 检测物品是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public int IsExitsName(string Name, Guid MemberId, string Keyid)
        {
            return iOA_ShebeiManageDAL.IsExitsName(Name,MemberId,Keyid);
        }

        /// <summary>
        /// 获取物品分类
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> GetDataByType(Guid _MemberId)
        {
            return iOA_ShebeiManageDAL.GetDataByType(_MemberId);
        }

        /// <summary>
        /// 根据分类获取物品列表
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <param name="_CateId"></param>
        /// <param name="IsSearch"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> GetDataByCate(Guid _MemberId, int? _CateId, bool IsSearch)
        {
            return iOA_ShebeiManageDAL.GetDataByCate(_MemberId,_CateId,IsSearch);
        }
        /// <summary>
        /// 根据客户编号获取客户
        /// </summary>
        /// <param name="Keyid">客户编号</param>
        /// <returns></returns>
        public IEnumerable<OA_ShebeiManage> SelectListListByCustomId(string Keyid, Guid MemberId)
        {
            return iOA_ShebeiManageDAL.SelectListListByCustomId(Keyid, MemberId);
        }
    }
}

 CY_ECommercePlatform/CY.BLL/OA/OA_ShebeiWeixiuBLL.cs

New file
@@ -0,0 +1,99 @@
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 OA_ShebeiWeixiuBLL
    {
        IOA_ShebeiWeixiuDAL iOA_ShebeiWeixiuDAL = null;

        public OA_ShebeiWeixiuBLL()
        {
            iOA_ShebeiWeixiuDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShebeiWeixiuDAL) as IOA_ShebeiWeixiuDAL;
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertModel(Model.OA_ShebeiWeixiu model)
        {
            return iOA_ShebeiWeixiuDAL.InserModel(model);
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Model.OA_ShebeiWeixiu model)
        {

            return iOA_ShebeiWeixiuDAL.UpdateModel(model);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Model.OA_ShebeiWeixiu model)
        {

            return iOA_ShebeiWeixiuDAL.DeleteModel(model);
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiWeixiu GetModelByKeyid(int? Keyid)
        {
            return iOA_ShebeiWeixiuDAL.GetModelByKeyid(Keyid);
        }


        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiWeixiu GetModelBytiaojian(int? WeixiuShebeiId,int? FukuanShebeiId,int? FukuanshenqingId)
        {
            return iOA_ShebeiWeixiuDAL.GetModelBytiaojian(WeixiuShebeiId, FukuanShebeiId, FukuanshenqingId);
        }


        /// <summary>
        /// 获取机器的当年当月费用
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public Model.OA_ShebeiWeixiu GetModelBytiaojian(int ShebeiId)
        {
            return iOA_ShebeiWeixiuDAL.GetModelBytiaojian(ShebeiId);
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiWeixiu> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name, int? _Status, string Anzhuangdidian, int? Zerenren,int? Shifouzhifu)
        {
            return iOA_ShebeiWeixiuDAL.SelectModelPage(pagination, _MemberId, _CateId, _Name, _Status, Anzhuangdidian, Zerenren, Shifouzhifu);
        }

         
    }
}

 CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj

@@ -173,6 +173,9 @@
    <Compile Include="OA\IOA_KaipiaonewcuishouDAL.cs" />
    <Compile Include="OA\IOA_KaipiaonewDAL.cs" />
    <Compile Include="OA\IOA_KipiaoshenqingDAL.cs" />
    <Compile Include="OA\IOA_ShebeiCateDAL.cs" />
    <Compile Include="OA\IOA_ShebeiWeixiuDAL.cs" />
    <Compile Include="OA\IOA_ShebeiManageDAL.cs" />
    <Compile Include="OA\IOA_ShejijijianDAL.cs" />
    <Compile Include="OA\IOA_ShiJuanBiaoQianDAL.cs" />
    <Compile Include="OA\IOA_WageAwardPunishDAL.cs" />

 CY_ECommercePlatform/CY.IDAL/OA/IOA_ShebeiCateDAL.cs

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

namespace CY.IDAL
{
    /// <summary>
    ///行政物品分类-数据库操作接口
    /// </summary>
    public interface IOA_ShebeiCateDAL : ICommonDAL, IPaging<OA_ShebeiCate>, IGetAllModel<OA_ShebeiCate>
    {
        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_ShebeiCate GetModelByKeyid(int? Keyid);

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_ShebeiCate> SelectModelPage(Infrastructure.Query.Pagination pagination,Guid _MemberId,string _Name,int? _Status,DateTime? _BeginLastUpdateTime,DateTime? _EndLastUpdateTime,string _Operator,string _Remark);

        /// <summary>
        /// 检测物品分类是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        int IsExitsName(string Name, Guid MemberId, string Keyid);
    }
}

 CY_ECommercePlatform/CY.IDAL/OA/IOA_ShebeiManageDAL.cs

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

namespace CY.IDAL
{
    /// <summary>
    ///行政物品管理-数据库操作接口
    /// </summary>
    public interface IOA_ShebeiManageDAL : ICommonDAL, IPaging<OA_ShebeiManage>, IGetAllModel<OA_ShebeiManage>
    {
        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_ShebeiManage GetModelByKeyid(int? Keyid);

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_ShebeiManage> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name, int? _Status, string Anzhuangdidian, int? Zerenren);

        /// <summary>
        /// 检测物品是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        int IsExitsName(string Name, Guid MemberId, string Keyid);

        /// <summary>
        /// 获取物品分类
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_ShebeiCate> GetDataByType(Guid _MemberId);

        /// <summary>
        /// 根据分类获取物品列表
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <param name="_CateId"></param>
        /// <param name="IsSearch"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_ShebeiManage> GetDataByCate(Guid _MemberId, int? _CateId, bool IsSearch);

        /// <summary>
        /// 根据客户编号获取客户
        /// </summary>
        /// <param name="Keyid">客户编号</param>
        /// <returns></returns>
        IEnumerable<OA_ShebeiManage> SelectListListByCustomId(string Keyid, Guid MemberId);
    }
}

 CY_ECommercePlatform/CY.IDAL/OA/IOA_ShebeiWeixiuDAL.cs

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

namespace CY.IDAL
{
    /// <summary>
    ///行政物品管理-数据库操作接口
    /// </summary>
    public interface IOA_ShebeiWeixiuDAL : ICommonDAL, IPaging<OA_ShebeiWeixiu>, IGetAllModel<OA_ShebeiWeixiu>
    {
        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_ShebeiWeixiu GetModelByKeyid(int? Keyid);

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_ShebeiWeixiu> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name, int? _Status, string Anzhuangdidian, int? Zerenren,int? Shifoufufei);


        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_ShebeiWeixiu GetModelBytiaojian(int? WeixiuShebeiId, int? FukuanShebeiId, int? FukuanshenqingId);


        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        Model.OA_ShebeiWeixiu GetModelBytiaojian(int ShebeiId);

    }
}

 CY_ECommercePlatform/CY.Model/CY.Model.csproj

@@ -253,10 +253,13 @@
    <Compile Include="OA\OA_OrderWorkListRelation.cs" />
    <Compile Include="OA\OA_OutOfStorage.cs" />
    <Compile Include="OA\OA_Procurement.cs" />
    <Compile Include="OA\OA_ShebeiCate.cs" />
    <Compile Include="OA\OA_PropertyCate.cs" />
    <Compile Include="OA\OA_ShebeiManage.cs" />
    <Compile Include="OA\OA_PropertyManage.cs" />
    <Compile Include="OA\OA_PropertyRecord.cs" />
    <Compile Include="OA\OA_RemittanceAdvice.cs" />
    <Compile Include="OA\OA_ShebeiWeixiu.cs" />
    <Compile Include="OA\OA_Shejijijian.cs" />
    <Compile Include="OA\OA_ShiJuanBiaoQian.cs" />
    <Compile Include="OA\OA_Specification.cs" />

 CY_ECommercePlatform/CY.Model/OA/OA_ShebeiCate.cs

New file
@@ -0,0 +1,131 @@
using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;
namespace CY.Model{
        /// <summary>
     ///行政物品分类
     /// </summary>
        [Serializable]
    public partial class OA_ShebeiCate : IAggregateRoot
    {
         public OA_ShebeiCate()
        { }
         #region Model
                   private int? _keyid;    
                private Guid _memberid;    
                private string _name;    
                private int? _status;    
                private DateTime? _lastupdatetime;    
                private string _operator;    
                private string _remark;    
				
          /// <summary>
        /// 主键
        /// </summary>		
        public int? Keyid
        {
            get{ return _keyid; }
            set{ _keyid = value; }
        }        
        /// <summary>
        /// 会员编号
        /// </summary>		
        public Guid MemberId
        {
            get{ return _memberid; }
            set{ _memberid = value; }
        }        
        /// <summary>
        /// 名称
        /// </summary>		
        public string Name
        {
            get{ return _name; }
            set{ _name = value; }
        }        
        /// <summary>
        /// 状态
        /// </summary>		
        public int? Status
        {
            get{ return _status; }
            set{ _status = value; }
        }        
        /// <summary>
        /// 最后修改时间
        /// </summary>		
        public DateTime? LastUpdateTime
        {
            get{ return _lastupdatetime; }
            set{ _lastupdatetime = value; }
        }        
        /// <summary>
        /// 操作人
        /// </summary>		
        public string Operator
        {
            get{ return _operator; }
            set{ _operator = value; }
        }        
        /// <summary>
        /// 备注
        /// </summary>		
        public string Remark
        {
            get{ return _remark; }
            set{ _remark = value; }
        }        
                #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 ("Keyid".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 1)
            { 
                this.Keyid = isChange ? MyConvert.ConvertToInt(value) : Keyid;
                theValue = this.Keyid;
            }       
         else if ("MemberId".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 2)
            { 
                this.MemberId = isChange ? MyConvert.ConvertToGuid(value) : MemberId;
                theValue = this.MemberId;
            }       
         else if ("Name".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 3)
            { 
                this.Name = isChange ? MyConvert.ConvertToString(value) : Name;
                theValue = this.Name;
            }       
         else if ("Status".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 4)
            { 
                this.Status = isChange ? MyConvert.ConvertToInt(value) : Status;
                theValue = this.Status;
            }       
         else if ("LastUpdateTime".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 5)
            { 
                this.LastUpdateTime = isChange ? MyConvert.ConvertToDateTime(value) : LastUpdateTime;
                theValue = this.LastUpdateTime;
            }       
         else if ("Operator".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 6)
            { 
                this.Operator = isChange ? MyConvert.ConvertToString(value) : Operator;
                theValue = this.Operator;
            }       
         else if ("Remark".Equals(name,StringComparison.CurrentCultureIgnoreCase) || index == 7)
            { 
                this.Remark = isChange ? MyConvert.ConvertToString(value) : Remark;
                theValue = this.Remark;
            }       
                    return theValue;
        }
        #endregion Visiter
}
}

 CY_ECommercePlatform/CY.Model/OA/OA_ShebeiManage.cs

New file
@@ -0,0 +1,289 @@
using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;
namespace CY.Model
{
    /// <summary>
    ///行政物品管理
    /// </summary>
    [Serializable]
    public partial class OA_ShebeiManage : IAggregateRoot
    {
        public OA_ShebeiManage()
        {
        }
        #region Model
        private int? _keyid;
        private Guid _memberid;
        private int? _cateid;
        private string _name;
        private decimal? _price;
        private int? _status;
       
        private DateTime? _lastupdatetime;
        private string _operator;
        private string _remark;
        private int? _havenum;


        public string Anzhuangdidian { get; set; }

        public DateTime? QiyongTime { get; set; }

        public int? Zerenren { get; set; }

        public string ZerenrenName { get; set; }

        public decimal? Yueprice { get; set; }

        public decimal? Nianprice { get; set; }

        /// <summary>
        /// 主键
        /// </summary>		
        public int? Keyid
        {
            get
            {
                return _keyid;
            }
            set
            {
                _keyid = value;
            }
        }
        /// <summary>
        /// 会员编号
        /// </summary>		
        public Guid MemberId
        {
            get
            {
                return _memberid;
            }
            set
            {
                _memberid = value;
            }
        }
        /// <summary>
        /// 分类Id
        /// </summary>		
        public int? CateId
        {
            get
            {
                return _cateid;
            }
            set
            {
                _cateid = value;
            }
        }
        /// <summary>
        /// 名称
        /// </summary>		
        public string Name
        {
            get
            {
                return _name;
            }
            set
            {
                _name = value;
            }
        }
        /// <summary>
        /// 价格
        /// </summary>		
        public decimal? Price
        {
            get
            {
                return _price;
            }
            set
            {
                _price = value;
            }
        }
        /// <summary>
        /// 状态/启用1,禁用2
        /// </summary>		
        public int? Status
        {
            get
            {
                return _status;
            }
            set
            {
                _status = value;
            }
        }
       
        /// <summary>
        /// 最后修改时间
        /// </summary>		
        public DateTime? LastUpdateTime
        {
            get
            {
                return _lastupdatetime;
            }
            set
            {
                _lastupdatetime = value;
            }
        }
        /// <summary>
        /// 操作人
        /// </summary>		
        public string Operator
        {
            get
            {
                return _operator;
            }
            set
            {
                _operator = value;
            }
        }
        /// <summary>
        /// 备注
        /// </summary>		
        public string Remark
        {
            get
            {
                return _remark;
            }
            set
            {
                _remark = value;
            }
        }

        /// <summary>
        /// 分类名称
        /// </summary>
        public string CateName
        {
            get;
            set;
        }
        /// <summary>
        /// 总数量
        /// </summary>		
        public int? havenum
        {
            get
            {
                return _havenum;
            }
            set
            {
                _havenum = value;
            }
        }
        #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 ("Keyid".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 1)
            {
                this.Keyid = isChange ? MyConvert.ConvertToInt(value) : Keyid;
                theValue = this.Keyid;
            }
            else if ("MemberId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.MemberId = isChange ? MyConvert.ConvertToGuid(value) : MemberId;
                theValue = this.MemberId;
            }
            else if ("CateId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.CateId = isChange ? MyConvert.ConvertToInt(value) : CateId;
                theValue = this.CateId;
            }
            else if ("Name".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.Name = isChange ? MyConvert.ConvertToString(value) : Name;
                theValue = this.Name;
            }
            else if ("Price".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 5)
            {
                this.Price = isChange ? MyConvert.ConvertToDecimal(value) : Price;
                theValue = this.Price;
            }
            else if ("Status".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 6)
            {
                this.Status = isChange ? MyConvert.ConvertToInt(value) : Status;
                theValue = this.Status;
            }
          
            else if ("LastUpdateTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 9)
            {
                this.LastUpdateTime = isChange ? MyConvert.ConvertToDateTime(value) : LastUpdateTime;
                theValue = this.LastUpdateTime;
            }
            else if ("Operator".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 10)
            {
                this.Operator = isChange ? MyConvert.ConvertToString(value) : Operator;
                theValue = this.Operator;
            }
            else if ("Remark".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 11)
            {
                this.Remark = isChange ? MyConvert.ConvertToString(value) : Remark;
                theValue = this.Remark;
            }
            else if ("CateName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 12)
            {
                this.CateName = isChange ? MyConvert.ConvertToString(value) : CateName;
                theValue = this.CateName;
            }
            else if ("havenum".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 13)
            {
                this.havenum = isChange ? MyConvert.ConvertToInt(value) : havenum;
                theValue = this.havenum;
            }
            else if ("Anzhuangdidian".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 14)
            {
                this.Anzhuangdidian = isChange ? MyConvert.ConvertToString(value) : Anzhuangdidian;
                theValue = this.Anzhuangdidian;
            }

            else if ("QiyongTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 15)
            {
                this.QiyongTime = isChange ? MyConvert.ConvertToDateTime(value) : QiyongTime;
                theValue = this.QiyongTime;
            }

            else if ("Zerenren".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 16)
            {
                this.Zerenren = isChange ? MyConvert.ConvertToInt(value) : Zerenren;
                theValue = this.Zerenren;
            }


            else if ("ZerenrenName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 17)
            {
                this.ZerenrenName = isChange ? MyConvert.ConvertToString(value) : ZerenrenName;
                theValue = this.ZerenrenName;
            }
            return theValue;
        }
        #endregion Visiter
    }
}

 CY_ECommercePlatform/CY.Model/OA/OA_ShebeiWeixiu.cs

New file
@@ -0,0 +1,297 @@
using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;
namespace CY.Model
{
    /// <summary>
    ///行政物品管理
    /// </summary>
    [Serializable]
    public partial class OA_ShebeiWeixiu : IAggregateRoot
    {
        public OA_ShebeiWeixiu()
        {
        }
        #region Model
        private int? _keyid;
        private Guid _memberid;
        public int? ShebeiId { get; set; }
        public DateTime? WeixiuTime { get; set; }
        private int? _cateid;
        public string Anzhuangdidian { get; set; }
        private string _name;
        private string _remark;
        public decimal? WeixiuPrice { get; set; }
        public int? Zerenren { get; set; }
        public string ZerenrenName { get; set; }
        public decimal? DanzePrice { get; set; }

        public int? WeixiuShebeiId { get; set; }

        public int? FukuanShebeiId { get; set; }

        public int? FukuanshenqingId { get; set; }

        //是否付费  1是2否
        public int? Shifoufufei { get; set; }
        

        public DateTime? CreateTime { get; set; }
        public string Creator{ get; set; }



        private DateTime? _lastupdatetime;
        private string _operator;


        public string Caozuo { get; set; }






        /// <summary>
        /// 主键
        /// </summary>		
        public int? Keyid
        {
            get
            {
                return _keyid;
            }
            set
            {
                _keyid = value;
            }
        }
        /// <summary>
        /// 会员编号
        /// </summary>		
        public Guid MemberId
        {
            get
            {
                return _memberid;
            }
            set
            {
                _memberid = value;
            }
        }
        /// <summary>
        /// 分类Id
        /// </summary>		
        public int? CateId
        {
            get
            {
                return _cateid;
            }
            set
            {
                _cateid = value;
            }
        }
        /// <summary>
        /// 名称
        /// </summary>		
        public string Name
        {
            get
            {
                return _name;
            }
            set
            {
                _name = value;
            }
        }
      
        
        /// <summary>
        /// 最后修改时间
        /// </summary>		
        public DateTime? LastUpdateTime
        {
            get
            {
                return _lastupdatetime;
            }
            set
            {
                _lastupdatetime = value;
            }
        }
        /// <summary>
        /// 操作人
        /// </summary>		
        public string Operator
        {
            get
            {
                return _operator;
            }
            set
            {
                _operator = value;
            }
        }
        /// <summary>
        /// 备注
        /// </summary>		
        public string Remark
        {
            get
            {
                return _remark;
            }
            set
            {
                _remark = value;
            }
        }

        /// <summary>
        /// 分类名称
        /// </summary>
        public string CateName
        {
            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 ("Keyid".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 1)
            {
                this.Keyid = isChange ? MyConvert.ConvertToInt(value) : Keyid;
                theValue = this.Keyid;
            }
            else if ("MemberId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.MemberId = isChange ? MyConvert.ConvertToGuid(value) : MemberId;
                theValue = this.MemberId;
            }
            else if ("ShebeiId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.ShebeiId = isChange ? MyConvert.ConvertToInt(value) : ShebeiId;
                theValue = this.ShebeiId;
            }
            else if ("WeixiuTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.WeixiuTime = isChange ? MyConvert.ConvertToDateTime(value) : WeixiuTime;
                theValue = this.WeixiuTime;
            }
            else if ("CateId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 5)
            {
                this.CateId = isChange ? MyConvert.ConvertToInt(value) : CateId;
                theValue = this.CateId;
            }
            else if ("Anzhuangdidian".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 6)
            {
                this.Anzhuangdidian = isChange ? MyConvert.ConvertToString(value) : Anzhuangdidian;
                theValue = this.Anzhuangdidian;
            }
            else if ("Name".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 7)
            {
                this.Name = isChange ? MyConvert.ConvertToString(value) : Name;
                theValue = this.Name;
            }
            else if ("Remark".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 8)
            {
                this.Remark = isChange ? MyConvert.ConvertToString(value) : Remark;
                theValue = this.Remark;
            }
            else if ("WeixiuPrice".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 9)
            {
                this.WeixiuPrice = isChange ? MyConvert.ConvertToDecimal(value) : WeixiuPrice;
                theValue = this.WeixiuPrice;
            }
            else if ("Zerenren".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 10)
            {
                this.Zerenren = isChange ? MyConvert.ConvertToInt(value) : Zerenren;
                theValue = this.Zerenren;
            }


            else if ("ZerenrenName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 11)
            {
                this.ZerenrenName = isChange ? MyConvert.ConvertToString(value) : ZerenrenName;
                theValue = this.ZerenrenName;
            }
            else if ("DanzePrice".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 12)
            {
                this.DanzePrice = isChange ? MyConvert.ConvertToDecimal(value) : DanzePrice;
                theValue = this.DanzePrice;
            }

            else if ("WeixiuShebeiId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 13)
            {
                this.WeixiuShebeiId = isChange ? MyConvert.ConvertToInt32(value) : WeixiuShebeiId;
                theValue = this.WeixiuShebeiId;
            }
            else if ("FukuanshenqingId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 14)
            {
                this.FukuanshenqingId = isChange ? MyConvert.ConvertToInt32(value) : FukuanshenqingId;
                theValue = this.FukuanshenqingId;
            }
            else if ("FukuanShebeiId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 15)
            {
                this.FukuanShebeiId = isChange ? MyConvert.ConvertToInt32(value) : FukuanShebeiId;
                theValue = this.FukuanShebeiId;
            }


            else if ("CreateTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 16)
            {
                this.CreateTime = isChange ? MyConvert.ConvertToDateTime(value) : CreateTime;
                theValue = this.CreateTime;
            }
            else if ("Creator".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 17)
            {
                this.Creator = isChange ? MyConvert.ConvertToString(value) : Creator;
                theValue = this.Creator;
            }

            else if ("LastUpdateTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 18)
            {
                this.LastUpdateTime = isChange ? MyConvert.ConvertToDateTime(value) : LastUpdateTime;
                theValue = this.LastUpdateTime;
            }
            else if ("Operator".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 19)
            {
                this.Operator = isChange ? MyConvert.ConvertToString(value) : Operator;
                theValue = this.Operator;
            }
            else if ("Shifoufufei".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 20)
            {
                this.Shifoufufei = isChange ? MyConvert.ConvertToInt32(value) : Shifoufufei;
                theValue = this.Shifoufufei;
            }
            else if ("CateName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 21)
            {
                this.CateName = isChange ? MyConvert.ConvertToString(value) : CateName;
                theValue = this.CateName;
            }

            

            return theValue;
        }
        #endregion Visiter
    }
}

 CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj

@@ -198,7 +198,10 @@
    <Compile Include="OA\OA_KaipiaonewDAL.cs" />
    <Compile Include="OA\OA_KaipiaonewhuikuanDAL.cs" />
    <Compile Include="OA\OA_KipiaoshenqingDAL.cs" />
    <Compile Include="OA\OA_ShebeiCateDAL.cs" />
    <Compile Include="OA\OA_PropertyCateDAL.cs" />
    <Compile Include="OA\OA_ShebeiWeixiuDAL.cs" />
    <Compile Include="OA\OA_ShebeiManageDAL.cs" />
    <Compile Include="OA\OA_PropertyManageDAL.cs" />
    <Compile Include="OA\OA_PropertyRecordDAL.cs" />
    <Compile Include="OA\OA_ShejijijianDAL.cs" />

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShebeiCateDAL.cs

New file
@@ -0,0 +1,232 @@
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 OA_ShebeiCateDAL:IOA_ShebeiCateDAL
    {
         private Database _dataBase = null;

        public OA_ShebeiCateDAL()
        {
            _dataBase = new Database();
        }
        
        public OA_ShebeiCateDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }
	
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_ShebeiCate trueModel = model as Model.OA_ShebeiCate;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@MemberId", trueModel.MemberId) ,            
                            new SqlParameter("@Name", trueModel.Name) ,            
                            new SqlParameter("@Status", trueModel.Status) ,            
                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                            new SqlParameter("@Operator", trueModel.Operator) ,            
                            new SqlParameter("@Remark", trueModel.Remark)             
                     };
            string sql = "Insert Into OA_ShebeiCate ([MemberId],[Name],[Status],[LastUpdateTime], [Operator])"
                                             + " Values (@MemberId,@Name,@Status, @LastUpdateTime, @Operator )";

            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.OA_ShebeiCate trueModel = model as Model.OA_ShebeiCate;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@Keyid", trueModel.Keyid) ,            
                            new SqlParameter("@MemberId", trueModel.MemberId) ,            
                            new SqlParameter("@Name", trueModel.Name) ,            
                            new SqlParameter("@Status", trueModel.Status) ,            
                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                            new SqlParameter("@Operator", trueModel.Operator) ,            
                            new SqlParameter("@Remark", trueModel.Remark)             
                     };
            string sql = "Update OA_ShebeiCate Set [MemberId]=@MemberId,[Name]=@Name,[Status]=@Status, [LastUpdateTime]=@LastUpdateTime, [Operator]=@Operator,[Remark]=@Remark  where [Keyid] =@Keyid ";

            try
            {
                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }
		
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_ShebeiCate trueModel = model as Model.OA_ShebeiCate;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {
                    new SqlParameter("@Keyid",trueModel.Keyid)
                };
            string sql = "Delete OA_ShebeiCate Where [Keyid] = @Keyid ";


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

            return true;
        }
         
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiCate GetModelByKeyid(int? Keyid)
        {
            try
            {
                if (Keyid == null || Keyid < 0)
                    return null;//错误数据返会空 

                IList<OA_ShebeiCate> result = _dataBase.SelectModel<OA_ShebeiCate>(" * ", " OA_ShebeiCate ", string.Format(" Keyid='{0}'", Keyid)) as IList<OA_ShebeiCate>;//执行查询

                return (null == result || result.Count == 0) ? null : result[0];//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> SelectModelPage(Infrastructure.Query.Pagination pagination,Guid _MemberId,string _Name,int? _Status,DateTime? _BeginLastUpdateTime,DateTime? _EndLastUpdateTime,string _Operator,string _Remark)
        {
            try
            {
                string condition = " 1=1 ";
                 
                        if (_MemberId != Guid.Empty)
                        condition += " and MemberId = '" + _MemberId + "'";
             
                        if (!string.IsNullOrEmpty(_Name))
                        condition += " and Name = '" + _Name + "'";
             
                        if (_Status.HasValue)
                        condition += " and Status = '" + _Status + "'";
             
                            if (_BeginLastUpdateTime.HasValue)
                    condition += string.Format(" and CAST(LastUpdateTime AS DATE) >='{0}'", _BeginLastUpdateTime);

                if (_EndLastUpdateTime.HasValue)
                    condition += string.Format(" and CAST(LastUpdateTime AS DATE) <='{0}'", _EndLastUpdateTime);
             
                        if (!string.IsNullOrEmpty(_Operator))
                        condition += " and Operator = '" + _Operator + "'";
             
                        if (!string.IsNullOrEmpty(_Remark))
                        condition += " and Remark = '" + _Remark + "'";
            
                return _dataBase.SelectModelPage<Model.OA_ShebeiCate>(pagination, " * ", " OA_ShebeiCate ", " Keyid desc", " Keyid desc ", condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 检测物品分类是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public int IsExitsName(string Name, Guid MemberId, string Keyid)
        {
            try
            {
                IList<OA_CarManage> result = _dataBase.SelectModel<OA_CarManage>("*", "OA_ShebeiCate", " Name = '" + Name + "' and MemberId ='" + MemberId + "' and Keyid <> '" + Keyid + "'") as IList<OA_CarManage>;//执行查询
                if (null == result || result.Count == 0)
                    return 0;
                else
                    return 1;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShebeiManageDAL.cs

New file
@@ -0,0 +1,347 @@
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 OA_ShebeiManageDAL : IOA_ShebeiManageDAL
    {
        private Database _dataBase = null;

        public OA_ShebeiManageDAL()
        {
            _dataBase = new Database();
        }

        public OA_ShebeiManageDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_ShebeiManage trueModel = model as Model.OA_ShebeiManage;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter QiyongTime = null;
            if (trueModel.QiyongTime.HasValue)
            {
                QiyongTime = new SqlParameter("@QiyongTime", trueModel.QiyongTime.Value);
            }
            else
            {
                QiyongTime = new SqlParameter("@QiyongTime", DBNull.Value);
            }

            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@MemberId", trueModel.MemberId) ,            
                            new SqlParameter("@CateId", trueModel.CateId) ,            
                            new SqlParameter("@Name", trueModel.Name) ,            
                            new SqlParameter("@Price", trueModel.Price.HasValue?trueModel.Price.Value:0) ,

                                new SqlParameter("@Anzhuangdidian", string.IsNullOrEmpty(trueModel.Anzhuangdidian)?"":trueModel.Anzhuangdidian) ,
                                  QiyongTime,
                                        new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0 ) ,
                                            new SqlParameter("@ZerenrenName", string.IsNullOrEmpty(trueModel.ZerenrenName)?"":trueModel.ZerenrenName) ,
 


                            new SqlParameter("@Status", trueModel.Status) ,            
                        	      
                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                            new SqlParameter("@Operator", trueModel.Operator) ,            
                            new SqlParameter("@Remark",string.IsNullOrEmpty(trueModel.Remark)?"":trueModel.Remark )             
                     };
            string sql = "Insert Into OA_ShebeiManage ([MemberId],[CateId],[Name],[Price], [Status],[Anzhuangdidian],[QiyongTime],[Zerenren],[ZerenrenName],[LastUpdateTime],[Operator],[Remark])"
                                            + " Values (@MemberId,@CateId,@Name, @Price, @Status,@Anzhuangdidian,@QiyongTime,@Zerenren,@ZerenrenName,@LastUpdateTime,@Operator,@Remark )";

            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.OA_ShebeiManage trueModel = model as Model.OA_ShebeiManage;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter QiyongTime = null;
            if (trueModel.QiyongTime.HasValue)
            {
                QiyongTime = new SqlParameter("@QiyongTime", trueModel.QiyongTime.Value);
            }
            else
            {
                QiyongTime = new SqlParameter("@QiyongTime", DBNull.Value);
            }


            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@Keyid", trueModel.Keyid) ,            
                            new SqlParameter("@MemberId", trueModel.MemberId) ,            
                            new SqlParameter("@CateId", trueModel.CateId) ,            
                            new SqlParameter("@Name", trueModel.Name) ,
                           new SqlParameter("@Price", trueModel.Price.HasValue?trueModel.Price.Value:0) ,

                                new SqlParameter("@Anzhuangdidian", string.IsNullOrEmpty(trueModel.Anzhuangdidian)?"":trueModel.Anzhuangdidian) ,
                                  QiyongTime,
                                        new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0 ) ,
                                            new SqlParameter("@ZerenrenName", string.IsNullOrEmpty(trueModel.ZerenrenName)?"":trueModel.ZerenrenName) ,



                            new SqlParameter("@Status", trueModel.Status) ,

                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,
                            new SqlParameter("@Operator", trueModel.Operator) ,
                            new SqlParameter("@Remark",string.IsNullOrEmpty(trueModel.Remark)?"":trueModel.Remark )
                     };
            string sql = "Update OA_ShebeiManage Set [MemberId]=@MemberId,[CateId]=@CateId,[Name]=@Name,[Price]=@Price,[Status]=@Status,[Anzhuangdidian]=@Anzhuangdidian,[QiyongTime]=@QiyongTime,[Zerenren]=@Zerenren,[ZerenrenName]=@ZerenrenName, [LastUpdateTime]=@LastUpdateTime, [Operator]=@Operator,[Remark]=@Remark  where [Keyid] =@Keyid ";

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

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


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

            return true;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

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

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiManage GetModelByKeyid(int? Keyid)
        {
            try
            {
                if (Keyid == null || Keyid < 0)
                    return null;//错误数据返会空 

                IList<OA_ShebeiManage> result = _dataBase.SelectModel<OA_ShebeiManage>(" * ", " OA_ShebeiManage ", string.Format(" Keyid='{0}'", Keyid)) as IList<OA_ShebeiManage>;//执行查询

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

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name,  int? _Status, string Anzhuangdidian, int? Zerenren)
        {
            try
            {
                string condition = " 1=1 ";

                if (_MemberId != Guid.Empty)
                    condition += " and a.MemberId = '" + _MemberId + "'";

                if (_CateId.HasValue)
                    condition += " and a.CateId = '" + _CateId + "'";

                if (!string.IsNullOrEmpty(_Name))
                    condition += " and a.Name = '" + _Name + "'";

                if (!string.IsNullOrEmpty(Anzhuangdidian))
                    condition += " and a.Anzhuangdidian = '" + Anzhuangdidian + "'";

                if (_Status.HasValue)
                    condition += " and a.Status = '" + _Status + "'";

                if (Zerenren.HasValue)
                    condition += " and a.Zerenren = '" + Zerenren + "'";

              

                return _dataBase.SelectModelPage<Model.OA_ShebeiManage>(pagination, " a.*,b.Name as CateName ", " OA_ShebeiManage as a left join OA_ShebeiCate as b on a.CateId = b.Keyid ", " a.CateId ASC,a.Keyid DESC", " Keyid desc ", condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 检测物品是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public int IsExitsName(string Name, Guid MemberId, string Keyid)
        {
            try
            {
                IList<OA_CarManage> result = _dataBase.SelectModel<OA_CarManage>("*", "OA_ShebeiManage", " Name = '" + Name + "' and MemberId ='" + MemberId + "' and Keyid <> '" + Keyid + "'") as IList<OA_CarManage>;//执行查询
                if (null == result || result.Count == 0)
                    return 0;
                else
                    return 1;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取物品分类
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiCate> GetDataByType(Guid _MemberId)
        {
            try
            {
                string condition = " 1=1 ";

                if (_MemberId != Guid.Empty)
                    condition += " and MemberId = '" + _MemberId + "'";

                return _dataBase.SelectModel<Model.OA_ShebeiCate>(" * ", " OA_ShebeiCate ", condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据分类获取物品列表
        /// </summary>
        /// <param name="_MemberId"></param>
        /// <param name="_CateId"></param>
        /// <param name="IsSearch"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiManage> GetDataByCate(Guid _MemberId,int? _CateId,bool IsSearch)
        {
            try
            {
                string condition = " 1=1 ";

                if (_MemberId != Guid.Empty)
                    condition += " and MemberId = '" + _MemberId + "'";

                if (_CateId>0)
                    condition += " and CateId = '" + _CateId + "'";

                if (!IsSearch)
                    condition += " and AllNum > ReceiveNum and Status = '1' ";

                return _dataBase.SelectModel<Model.OA_ShebeiManage>(" * ", " OA_ShebeiManage ", condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据客户编号获取客户
        /// </summary>
        /// <param name="CustomId">客户编号</param>
        /// <returns></returns>
        public IEnumerable<OA_ShebeiManage> SelectListListByCustomId(string CustomId, Guid MemberId)
        {
            if (string.IsNullOrEmpty(CustomId))
                return null;//错误数据返会空

            try
            {
                IList<OA_ShebeiManage> result = _dataBase.SelectModel<OA_ShebeiManage>(" a.*,a.AllNum-a.ReceiveNum as havenum,b.Name as CateName", "OA_ShebeiManage as a left join OA_ShebeiCate as b on a.CateId = b.Keyid", string.Format(" a.Keyid in ({0}) and a.MemberId ='{1}' order by b.Name ASC", CustomId, MemberId)) as IList<OA_ShebeiManage>;//执行查询
                return result;//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShebeiWeixiuDAL.cs

New file
@@ -0,0 +1,332 @@
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 OA_ShebeiWeixiuDAL : IOA_ShebeiWeixiuDAL
    {
        private Database _dataBase = null;

        public OA_ShebeiWeixiuDAL()
        {
            _dataBase = new Database();
        }

        public OA_ShebeiWeixiuDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_ShebeiWeixiu trueModel = model as Model.OA_ShebeiWeixiu;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter WeixiuTime = null;
            if (trueModel.WeixiuTime.HasValue)
            {
                WeixiuTime = new SqlParameter("@WeixiuTime", trueModel.WeixiuTime.Value);
            }
            else
            {
                WeixiuTime = new SqlParameter("@WeixiuTime", DBNull.Value);
            }

            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@MemberId", trueModel.MemberId) ,
            new SqlParameter("@ShebeiId", trueModel.ShebeiId) ,
            WeixiuTime,
            new SqlParameter("@CateId", trueModel.CateId) ,
              new SqlParameter("@Anzhuangdidian", string.IsNullOrEmpty(trueModel.Anzhuangdidian)?"":trueModel.Anzhuangdidian) ,
              new SqlParameter("@Name", trueModel.Name) ,
              new SqlParameter("@Remark",string.IsNullOrEmpty(trueModel.Remark)?"":trueModel.Remark ),
                 new SqlParameter("@WeixiuPrice", trueModel.WeixiuPrice.HasValue?trueModel.WeixiuPrice.Value:0) ,
                  new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0 ) ,
                                            new SqlParameter("@ZerenrenName", string.IsNullOrEmpty(trueModel.ZerenrenName)?"":trueModel.ZerenrenName) ,
 new SqlParameter("@DanzePrice", trueModel.DanzePrice.HasValue?trueModel.DanzePrice.Value:0) ,

                                  new SqlParameter("@WeixiuShebeiId", trueModel.WeixiuShebeiId.HasValue?trueModel.WeixiuShebeiId.Value:0) ,
                                    new SqlParameter("@FukuanShebeiId", trueModel.FukuanShebeiId.HasValue?trueModel.FukuanShebeiId.Value:0) ,
                                      new SqlParameter("@FukuanshenqingId", trueModel.FukuanshenqingId.HasValue?trueModel.FukuanshenqingId.Value:0) ,
                                        new SqlParameter("@Shifoufufei", trueModel.Shifoufufei.HasValue?trueModel.Shifoufufei.Value:0) ,


                                      new SqlParameter("@CreateTime", trueModel.CreateTime) ,
                            new SqlParameter("@Creator", trueModel.Creator) ,
                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                            new SqlParameter("@Operator", trueModel.Operator) ,            
                        	        
                     };
            string sql = "Insert Into OA_ShebeiWeixiu ([MemberId],[ShebeiId],[WeixiuTime],[CateId],[Name],[Anzhuangdidian],[Remark],[WeixiuPrice],[Zerenren],[ZerenrenName],[DanzePrice],[WeixiuShebeiId],[FukuanShebeiId],[FukuanshenqingId],[Shifoufufei],[CreateTime],[Creator],[LastUpdateTime],[Operator])"
                                            + " Values (@MemberId,@ShebeiId,@WeixiuTime,@CateId,@Name,@Anzhuangdidian,@Remark ,@WeixiuPrice,@Zerenren,@ZerenrenName,@DanzePrice,@WeixiuShebeiId,@FukuanShebeiId,@FukuanshenqingId,@Shifoufufei,@CreateTime,@Creator,@LastUpdateTime,@Operator)";

            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.OA_ShebeiWeixiu trueModel = model as Model.OA_ShebeiWeixiu;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter WeixiuTime = null;
            if (trueModel.WeixiuTime.HasValue)
            {
                WeixiuTime = new SqlParameter("@WeixiuTime", trueModel.WeixiuTime.Value);
            }
            else
            {
                WeixiuTime = new SqlParameter("@WeixiuTime", DBNull.Value);
            }


            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {                new SqlParameter("@Keyid", trueModel.Keyid) ,
                               new SqlParameter("@MemberId", trueModel.MemberId) ,
            new SqlParameter("@ShebeiId", trueModel.ShebeiId) ,
            WeixiuTime,
            new SqlParameter("@CateId", trueModel.CateId) ,
              new SqlParameter("@Anzhuangdidian", string.IsNullOrEmpty(trueModel.Anzhuangdidian)?"":trueModel.Anzhuangdidian) ,
              new SqlParameter("@Name", trueModel.Name) ,
              new SqlParameter("@Remark",string.IsNullOrEmpty(trueModel.Remark)?"":trueModel.Remark ),
                 new SqlParameter("@WeixiuPrice", trueModel.WeixiuPrice.HasValue?trueModel.WeixiuPrice.Value:0) ,
                  new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0 ) ,
                                            new SqlParameter("@ZerenrenName", string.IsNullOrEmpty(trueModel.ZerenrenName)?"":trueModel.ZerenrenName) ,
 new SqlParameter("@DanzePrice", trueModel.DanzePrice.HasValue?trueModel.DanzePrice.Value:0) ,

                                  new SqlParameter("@WeixiuShebeiId", trueModel.WeixiuShebeiId.HasValue?trueModel.WeixiuShebeiId.Value:0) ,
                                    new SqlParameter("@FukuanShebeiId", trueModel.FukuanShebeiId.HasValue?trueModel.FukuanShebeiId.Value:0) ,
                                      new SqlParameter("@FukuanshenqingId", trueModel.FukuanshenqingId.HasValue?trueModel.FukuanshenqingId.Value:0) ,
                                        new SqlParameter("@Shifoufufei", trueModel.Shifoufufei.HasValue?trueModel.Shifoufufei.Value:0) ,

                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,
                            new SqlParameter("@Operator", trueModel.Operator) ,
                     };
            string sql = "Update OA_ShebeiWeixiu Set [MemberId]=@MemberId,[ShebeiId]=@ShebeiId,[WeixiuTime]=@WeixiuTime,[CateId]=@CateId,[Name]=@Name,[Anzhuangdidian]=@Anzhuangdidian,[Remark]=@Remark,[WeixiuPrice]=@WeixiuPrice,[Zerenren]=@Zerenren,[ZerenrenName]=@ZerenrenName,[DanzePrice]=@DanzePrice, [WeixiuShebeiId]=@WeixiuShebeiId,[FukuanShebeiId]=@FukuanShebeiId,[FukuanshenqingId]=@FukuanshenqingId,[Shifoufufei]=@Shifoufufei,[LastUpdateTime]=@LastUpdateTime, [Operator]=@Operator  where [Keyid] =@Keyid ";

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

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


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

            return true;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiWeixiu> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

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

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiWeixiu GetModelByKeyid(int? Keyid)
        {
            try
            {
                if (Keyid == null || Keyid < 0)
                    return null;//错误数据返会空 

                IList<OA_ShebeiWeixiu> result = _dataBase.SelectModel<OA_ShebeiWeixiu>(" * ", " OA_ShebeiWeixiu ", string.Format(" Keyid='{0}'", Keyid)) as IList<OA_ShebeiWeixiu>;//执行查询

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



        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_ShebeiWeixiu GetModelBytiaojian(int? WeixiuShebeiId, int? FukuanShebeiId, int? FukuanshenqingId)
        {
            try
            {
                string tiaojian = "";
                if (WeixiuShebeiId.HasValue)
                {
                    tiaojian += "WeixiuShebeiId=" + WeixiuShebeiId.Value;
                }
                else if (FukuanShebeiId.HasValue)
                {
                    tiaojian += "FukuanShebeiId=" + FukuanShebeiId.Value;
                }
                else if (FukuanshenqingId.HasValue)
                {
                    tiaojian += "FukuanshenqingId=" + FukuanshenqingId.Value;
                }


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

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


        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public Model.OA_ShebeiWeixiu GetModelBytiaojian(int ShebeiId)
        {
            try
            {


                string from = "( SELECT  sum(WeixiuPrice) WeixiuPrice,0 as DanzePrice  FROM OA_ShebeiWeixiu  where  ShebeiId="+ ShebeiId + " and Shifoufufei = 1 and DATEDIFF(MONTH,'"+DateTime.Now.ToString("yyyy-MM-dd")+"',WeixiuTime) =0   "
                    + " UNION ALL "
                    + "   SELECT 0 as  WeixiuPrice,sum(WeixiuPrice)  DanzePrice  FROM OA_ShebeiWeixiu  where  ShebeiId=" + ShebeiId + " and Shifoufufei = 1 and DATEDIFF(YEAR,'" + DateTime.Now.ToString("yyyy-MM-dd") + "',WeixiuTime) =0   "
                    + " ) AS subquery ";

                IList<OA_ShebeiWeixiu> result = _dataBase.SelectModel<OA_ShebeiWeixiu>(" sum(WeixiuPrice) WeixiuPrice,sum(DanzePrice)  DanzePrice  ", from) as IList<OA_ShebeiWeixiu>;//执行查询

               

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

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShebeiWeixiu> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid _MemberId, int? _CateId, string _Name,  int? _Status, string Anzhuangdidian, int? Zerenren, int? Shifoufufei)
        {
            try
            {
                string condition = " 1=1 ";

                if (_MemberId != Guid.Empty)
                    condition += " and a.MemberId = '" + _MemberId + "'";

                if (_CateId.HasValue)
                    condition += " and a.CateId = '" + _CateId + "'";

                if (!string.IsNullOrEmpty(_Name))
                    condition += " and a.Name = '" + _Name + "'";

                if (!string.IsNullOrEmpty(Anzhuangdidian))
                    condition += " and a.Anzhuangdidian = '" + Anzhuangdidian + "'";

                if (_Status.HasValue)
                    condition += " and a.Status = '" + _Status + "'";

                if (Zerenren.HasValue)
                    condition += " and a.Zerenren = '" + Zerenren + "'";

                if (Shifoufufei.HasValue)
                    condition += " and a.Shifoufufei = '" + Shifoufufei + "'";


                return _dataBase.SelectModelPage<Model.OA_ShebeiWeixiu>(pagination, " a.*,b.Name as CateName ", " OA_ShebeiWeixiu as a left join OA_ShebeiCate as b on a.CateId = b.Keyid ", " a.WeixiuTime DESC", " Keyid desc ", condition);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        
         
       

        
    }
}

 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -2221,7 +2221,13 @@
    <Content Include="Pages\procurement\OutOfStorageListHTML.aspx" />
    <Content Include="Pages\procurement\OutOfStorageListPrint.aspx" />
    <Content Include="Pages\Property\PrintCheckTable.aspx" />
    <Content Include="Pages\Property\ShebeimanageEdit.aspx" />
    <Content Include="Pages\Property\ShebeiWeixiuFukuanAdd.aspx" />
    <Content Include="Pages\Property\ShebeiWeixiuList.aspx" />
    <Content Include="Pages\Property\ShebeimanageList.aspx" />
    <Content Include="Pages\Property\ShebeiCateEdit.aspx" />
    <Content Include="Pages\Property\PropertyCateEdit.aspx" />
    <Content Include="Pages\Property\ShebeiCateList.aspx" />
    <Content Include="Pages\Property\PropertyCateList.aspx" />
    <Content Include="Pages\Property\PropertyEdit.aspx" />
    <Content Include="Pages\Property\PropertyList.aspx" />
@@ -2231,6 +2237,7 @@
    <Content Include="Pages\Property\PropertyRecordDetail.aspx" />
    <Content Include="Pages\Property\PropertyRecordEdit.aspx" />
    <Content Include="Pages\Property\PropertyRecordList.aspx" />
    <Content Include="Pages\Property\ShebeiWeixiuAdd.aspx" />
    <Content Include="Pages\Soft\ClientAdd.aspx" />
    <Content Include="Pages\Soft\ClientDetail.aspx" />
    <Content Include="Pages\Soft\ClientList.aspx" />
@@ -5723,12 +5730,54 @@
    <Compile Include="Pages\Property\PrintCheckTable.aspx.designer.cs">
      <DependentUpon>PrintCheckTable.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeimanageEdit.aspx.cs">
      <DependentUpon>ShebeimanageEdit.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeimanageEdit.aspx.designer.cs">
      <DependentUpon>ShebeimanageEdit.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuFukuanAdd.aspx.cs">
      <DependentUpon>ShebeiWeixiuFukuanAdd.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuFukuanAdd.aspx.designer.cs">
      <DependentUpon>ShebeiWeixiuFukuanAdd.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuList.aspx.cs">
      <DependentUpon>ShebeiWeixiuList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuList.aspx.designer.cs">
      <DependentUpon>ShebeiWeixiuList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeimanageList.aspx.cs">
      <DependentUpon>ShebeimanageList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeimanageList.aspx.designer.cs">
      <DependentUpon>ShebeimanageList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeiCateEdit.aspx.cs">
      <DependentUpon>ShebeiCateEdit.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeiCateEdit.aspx.designer.cs">
      <DependentUpon>ShebeiCateEdit.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\PropertyCateEdit.aspx.cs">
      <DependentUpon>PropertyCateEdit.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\PropertyCateEdit.aspx.designer.cs">
      <DependentUpon>PropertyCateEdit.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeiCateList.aspx.cs">
      <DependentUpon>ShebeiCateList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeiCateList.aspx.designer.cs">
      <DependentUpon>ShebeiCateList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\PropertyCateList.aspx.cs">
      <DependentUpon>PropertyCateList.aspx</DependentUpon>
@@ -5793,6 +5842,13 @@
    <Compile Include="Pages\Property\PropertyRecordList.aspx.designer.cs">
      <DependentUpon>PropertyRecordList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuAdd.aspx.cs">
      <DependentUpon>ShebeiWeixiuAdd.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\Property\ShebeiWeixiuAdd.aspx.designer.cs">
      <DependentUpon>ShebeiWeixiuAdd.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\Soft\ClientAdd.aspx.cs">
      <DependentUpon>ClientAdd.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateEdit.aspx

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

<!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 CheckStaff() {
            var IsCanSubmit = undefined;
            var Name = $.trim($("#txtCarNumber").val());
            if (Name != "") {
                $.ajax({
                    url: "/Pages/common/CommonAjax.aspx",
                    type: "POST",
                    dataType: "html",
                    data: { dateType: "Shebeicheckname", name: Name, keyid: '<%=Request["keyid"] %>' },
                    global: false,
                    cache: false,
                    async: false,
                    success: function (data) {
                        if (data == "1") {
                            IsCanSubmit = false;
                        } else {
                            IsCanSubmit = true;
                        }
                    }
                });
                if (!IsCanSubmit) {
                    alertMsg("此分类已存在，如有相同，请注意区分添加");
                    return false;
                }
            } else {
                alertMsg("请填写分类名称");
                return false;
            }
            return true;
        }

        $(function () {
            $("#txtCarNumber").blur(function () {
                CheckStaff();
            });
        });
    </script>
</head>
<body>
    <form id="form1" class="form2" runat="server">
    <div>
        <table class="tableStyle" style="margin: 10px auto; line-height:40px;" cellpadding="0" cellspacing="0">
            <tr>
                <td class="ali03">
                    分类名称：
                </td>
                <td>
                    <input id="txtCarNumber" style="width: 100px;" type="text" runat="server" />
                </td>
            </tr>
            <tr>
                <td colspan="2" style="text-align: center;">
                    <asp:Button ID="btn_submit" runat="server" OnClick="btn_submit_form" OnClientClick="if(CheckStaff())return true;else return false; " Text="提交" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateEdit.aspx.cs

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

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //行政物品分类
    public partial class ShebeiCateEdit : BasePage
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ShebeiCateBLL oA_WorkReminderBll = null;

        public ShebeiCateEdit()
        {
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            oA_WorkReminderBll = new OA_ShebeiCateBLL();
        }

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

        //数据加载
        public void InitData()
        {
            OA_ShebeiCate m_OA_ShebeiCate = oA_WorkReminderBll.GetModelByKeyid(Request["keyid"].ToInt32());
            if (m_OA_ShebeiCate != null)
            {
                this.txtCarNumber.Value = m_OA_ShebeiCate.Name;
            }
        }

        //表单提交
        protected void btn_submit_form(object sender, EventArgs e)
        {
            try
            {
                DateTime nowTime = DateTime.Now;
                OA_ShebeiCate m_OA_ShebeiCate = oA_WorkReminderBll.GetModelByKeyid(Request["keyid"].ToInt32());
                if (m_OA_ShebeiCate == null)
                {
                    m_OA_ShebeiCate = new OA_ShebeiCate();
                    m_OA_ShebeiCate.MemberId = CurrentUser.MemberId;
                    m_OA_ShebeiCate.Status = 1;
                    m_OA_ShebeiCate.Remark = "";
                }
                m_OA_ShebeiCate.Name = this.txtCarNumber.Value;
                m_OA_ShebeiCate.Operator = CurrentUser.ShortName;
                m_OA_ShebeiCate.LastUpdateTime = nowTime;

                if (Request["keyid"].ToInt32() > 0)
                {
                    if (oA_WorkReminderBll.UpdateModel(m_OA_ShebeiCate))
                        JavaScript.MessageBox("更新成功", this, true, true);
                    else
                        JavaScript.MessageBox("更新失败", this);
                }
                else
                {
                    if (oA_WorkReminderBll.InsertModel(m_OA_ShebeiCate))
                    {
                        txtCarNumber.Value = "";
                        JavaScript.MessageBox("新增成功", this, false, true);
                    }
                    else
                    {
                        JavaScript.MessageBox("操作失败", this);
                    }
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("操作失败", this);
            }
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateEdit.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeiCateEdit
    {

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateList.aspx

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

<!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 runat="server">
    <title>设备分类管理</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/Property/ShebeiCateEdit.aspx?keyid=" + keyid, Title: "设备分类修改", Width: 350, Height: 190 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/Property/ShebeiCateEdit.aspx", Title: "新增设备分类", Width: 350, Height: 190 });
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要删除该设备分类吗？", function () {
                window.location = "/Pages/Property/ShebeiCateList.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/Property/ShebeiCateList.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="box_tool_min ">
            <div class="center">
                <div class="left">
                    <div class="right">
                        <div class="padding_top5 padding_left10">
                            <a href="javascript:;" onclick="addModel()" class="aaddModel" menu_member_case_id="case_addModel" menu_member_case_name="新增分类"><span class="icon_add">新增分类</span></a>
                            <div class="box_tool_line">
                            </div>
                            <a href="javascript:;" onclick="onAllDelete()" menu_member_case_id="case_onAllDeleteList" menu_member_case_name="批量删除"><span class="icon_delete">批量删除</span></a>
                            <div class="clear">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="clear">
            </div>
        </div>
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th width="25">
                            </th>
                            <th width="30" 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>
                            <input type="checkbox" value='<%#Eval("Keyid")%>' />
                        </td>
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1+ this.UCPager1.PageSize * (this.UCPager1.PageIndex - 1)%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("Name")%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("LastUpdateTime")%>
                        </td>
                        <td class="Operate " style="text-align: center">
                            <span menu_member_case_id="case_CarEdit" menu_member_case_name="修改" onclick="onEdit('<%#Eval("Keyid")%>')">修改</span>
                            <span menu_member_case_id="case_CarDele" menu_member_case_name="删除" onclick="onDele('<%#Eval("Keyid")%>')">删除</span>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />
            </div>
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateList.aspx.cs

New file
@@ -0,0 +1,94 @@
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;

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //行政物品分类管理
    public partial class ShebeiCateList : BasePage
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ShebeiCateBLL bll_OA_ShebeiCateBLL = null;

        //初始化
        public ShebeiCateList()
        {
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_ShebeiCateBLL = new OA_ShebeiCateBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                BindList();
            }
            if (Request["delete"] != null)
            {
                OA_ShebeiCate model = bll_OA_ShebeiCateBLL.GetModelByKeyid(Request["delete"].ToInt32());
                if (model != null && model.Keyid != null)
                {
                    bll_OA_ShebeiCateBLL.DeleteModel(model);
                    JavaScript.MessageBox("删除成功", this);
                    Response.Redirect("/Pages/Property/ShebeiCateList.aspx");
                }
                else
                    JavaScript.MessageBox("删除失败", this);
            }

            if (Request["deleteKeyIds"] != null)
            {
                List<int> deleteKeyIdList = new List<int>();
                string deleteKeyIds = Request["deleteKeyIds"].ToString().Trim(',');
                string[] keyIdArry = deleteKeyIds.Split(',');
                foreach (string keyId in keyIdArry)
                {
                    OA_ShebeiCate model = bll_OA_ShebeiCateBLL.GetModelByKeyid(keyId.ToInt32());
                    if (model.Keyid != null && model != null)
                        bll_OA_ShebeiCateBLL.DeleteModel(model);
                    else
                    {
                        JavaScript.MessageBox("删除失败", this);
                        return;
                    }
                }
                JavaScript.MessageBox("删除成功", this);
                Response.Redirect("/Pages/Property/ShebeiCateList.aspx");
            }
        }

        //绑定数据
        private void BindList()
        {
            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            this.RepClientList.DataSource = bll_OA_ShebeiCateBLL.SelectModelPage(pa, CurrentUser.MemberId, "",null,null,null,"","");
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }

        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiCateList.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeiCateList
    {

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuAdd.aspx

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

<!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 runat="server">
        <uc:CMSHead ID="CMSHead1" runat="server" />
    </head>
    <body style="padding:10px">
        <form runat="server">
            <table class="tableStyle" >
                
                 <tr>
                    <td class="ali03">设备名称：</td>
                    <td> <select keepdefaultstyle='true' id='selShebei' runat="server"  datatextfield='Name' datavaluefield='Keyid'   class='Sreq' sign="" selinputhtml="True"  style=" width:183px;"  >
                        </select>
                    </td>
                </tr>

                 <tr>
                <td class="ali03">
                    故障原因：
                </td>
                <td colspan="3">
                    <textarea id="txtPlanRemark" runat="server" style="width: 390px; height: 50px;" MaxLength="100" class='req' ></textarea>
                </td>
            </tr>
                 <tr>
                <td class="ali03">
                    维修日期：
                </td>
                <td>
                   <input type="text" id='txtWeixiuTime'  class='date req' runat="server" />
                </td>
            </tr>

                 <tr>
                    <td class="ali03">申请费用：</td>
                    <td> <input id='txtWeixiuPrice' runat="server" maxlength='18' onblur="validateAmount(event)" placeholder="请输入金额"     /></td>
                </tr>
  <tr>
                 
                   <td class="ali03">是否申请付款：</td>
                    <td> <select keepdefaultstyle='true' id='selShifoufukuan' runat="server"      class='Sreq'   >
                        <option value='2'>否</option>
                        <option value='1'>是</option>
                        </select>
                    </td>
                   </tr>
                <tr>
                    <td colspan="2"></td>
                </tr>
                 <tr id="trbtn" runat="server">
                    <td class="ali02" colspan="2">
                        <asp:Button ID="btn_Submit" Text="提交申请" runat="server" OnClick="btn_Submit_form" />
                        <span style="margin-left:10px"></span>
                        <input type="button" value="取消 " onclick="top.Dialog.close()" />
                    </td>
                </tr>
            </table>
        </form>
    </body>
    <script type="text/javascript" language="javascript">
        function custormerChange(sel) {

          


            window.submitUrl = '/Pages/Property/ShebeiWeixiuAdd.aspx';

            CallServer({ Target: "GetSuplier", id: sel.value }, function (data, textStatus) {
                var jobj = false;
                try {
                    jobj = eval('[' + data + ']')[0];
                } catch (ex) {
                    global.DealDataException(ex); return;
                }
                if (jobj != '-2') {
                    document.getElementById('txtBank').value = jobj.Bank;
                    document.getElementById('txtAccountID').value = jobj.AccountID;
                    if (jobj.Huming == "") {
                        document.getElementById('txtHuming').value = jobj.Name;
                    } else {
                        document.getElementById('txtHuming').value = jobj.Huming;
                    }
                   
                } else {
                    document.getElementById('txtBank').value = "";
                    document.getElementById('txtAccountID').value = "";
                    document.getElementById('txtHuming').value = "";
                }
               
                  
               
            });
        }

        ///新增客户
        function showCustomer() {
            top.Dialog.open({ URL: "/Pages/procurement/SuppliersEdit.aspx?Keyid='0'&&flasss=ddfffff", Title: "新增供应商", Width: 950, Height: 650 });
        }


        //为Select新增过滤功能
        function SelectAddSearch() {
            $("select[SelInputHtml='True']").each(function (i, v) {
                $(this).unbind("blur");
                var old = $(this).html();
                var oldObject = $(this).clone();
                var sign = "selectS" + i;
                $(v).attr("sign", sign);

                var inputClass = "input_" + sign;
                var html = "<span style='margin-left:10px'>过滤：</span><input type='text' class='" + inputClass + "' style='width:80px;height:18px;line-height:18px;'/>";
                $(v).after(html);
                $("." + inputClass).blur(function () {
                    var nowval = $(this).val().trim();
                    var output = "";
                    if (nowval == "" || nowval == null) {
                        output = old;
                    } else {
                        output += "<option value=''>请选择</option>";
                        var valueArr = new Array();
                        oldObject.find("option").each(function (ii, vv) {

                            var value = $.trim($(vv).attr("value"));
                            var text = $.trim($(vv).text());

                            if (text.indexOf(nowval) >= 0)
                                valueArr.push(value + "|||" + text);
                        });
                        for (var ss in valueArr) {
                            var s = valueArr[ss];
                            if (s.split("|||").length == 2) {
                                var value1 = s.split("|||")[0];
                                var text1 = s.split("|||")[1];
                                output += "<option value='" + value1 + "'>" + text1 + "</option>";
                            }
                        }
                    }
                    $(v).html(output);
                });
            });
        }

        $(function () {
            SelectAddSearch();
        });

        function validateAmount(event) {
            var input = event.target;
            var value = input.value;
            var regex = /^\d+(\.\d+)?$/;

            if (!regex.test(value)) {
                // 输入无效，重置值并将焦点设回文本框
                input.value = '0';
                input.focus();
                alert('请输入有效的正负金额，例如  45.67');
            }
        }



        //查看
        function checkSelFile() {
 
                var oFile = document.getElementById('file1');
                if (oFile.value == "") {
                    alertMsg('没有选择文件');
                    return;

                }



                var formData = new FormData();
                formData.append('file', oFile.files[0]); // this.files[0]是文件对象


                $.ajax({
                    url: '/Pages/Property/FileUploadHandler.ashx', // 替换为你的服务器端点
                    type: 'POST',
                    data: formData,
                    contentType: false,
                    processData: false,
                    async: false,        // 设置为同步
                    success: function (response) {
                        console.log('File uploaded successfully:', response);
                        if (response.code == 1) {

                            $(".AddTab").last().after($(".AddTab").last().clone(true));
                            $(".AddTab").last().show();
                            $("input[name='HideKeyidFapiao']").last().val("");
                            $("input[name='HideAttachmentFapiao']").last().val(response.data);
                            $('a[name="HrefAttachmentFapiao"]').last().attr("href", response.data);
                            $('a[name="HrefAttachmentFapiao"]').last().html('<img src="' + response.data+'" width="20" height="20" />');
                            alertMsg('上传成功');
                        } else {
                            alertMsg(response.message);
                        }


                    },
                    error: function (xhr, status, error) {
                        console.error('File upload failed:', status, error);
                        alertMsg('上传失败');
                    }
                });


           
             




        }




        function deletefujian(obj) {
            if (confirm("是否删除选中数据？")) {
                $(obj).parent().parent().remove()
            }
        }
    </script>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuAdd.aspx.cs

New file
@@ -0,0 +1,331 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL.EC;
using CY.Model;
using CY.Infrastructure.Common;
using CY.BLL.Integrity;
using CY.BLL;
using System.Threading.Tasks;
using System.Transactions;
using CY.BLL.OA;

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //卖家评价
    public partial class ShebeiWeixiuAdd : BasePage
    {
        EC_OrderBasicBLL bll_EC_OrderBasicBLL = null;
        
        OA_FukuanshenqingBLL _oA_FukuanshenqingBLL = null;
       
        OA_StaffBLL bll_OA_StaffBLL = null;
        OA_WorkPlanBll oA_WorkReminderBll = null;
        OA_ShebeiManageBLL oA_ShebeiManageBLL = null;
        OA_ShebeiWeixiuBLL oA_ShebeiWeixiuBLL = null;




        //初始化
        public ShebeiWeixiuAdd()
        {
            bll_EC_OrderBasicBLL = new EC_OrderBasicBLL();
          
            _oA_FukuanshenqingBLL = new OA_FukuanshenqingBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            oA_WorkReminderBll = new OA_WorkPlanBll();
            oA_ShebeiManageBLL = new OA_ShebeiManageBLL();
            oA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();


        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                switch (Request["Target"])
                {
                    case "GetSuplier":
                        LoadCommunication();
                        break;

                    default:
                        if (!IsPostBack)
                        {
                            InitData();
                        }
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                //Response.Write("-1");
                Response.Write(ex.Message);
            }
            Response.End();
          
        }

        //绑定数据
        public void InitData()
        {
 
           
                //供应商
                this.selShebei.DataSource = oA_ShebeiManageBLL.SelectAllModel(null).Where(x=>x.Status == 2);
                this.selShebei.DataBind();
            //this.selShebei.Items.Insert(0, new ListItem("全部", ""));

            this.txtWeixiuTime.Value = DateTime.Now.ToString("yyyy-MM-dd");


        }


        /// <summary>
        /// 加载供应商
        /// </summary>
        private void LoadCommunication()
        {
            //Response.Clear();
            //string id = Request["id"];
            //if (string.IsNullOrEmpty(id))
            //{
            //    Response.Write("-2");
            //    return;
            //}

            //var oA_Suppliers = _OA_SuppliersBLL.getSingleSupplier(id);

          
            //Response.Write(null == oA_Suppliers ? "" : JsonHelper.GetJsonStringByObject(oA_Suppliers));
        }

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

        /// <summary>
        /// 批量开票申请
        /// </summary>
        public void AcceptAll3()
        {

            if (string.IsNullOrEmpty(this.selShebei.Value))
            {
                JavaScript.MessageBox("请选择维修设备！", this);
                return;
            }

            if (this.selShifoufukuan.Value == "1" && string.IsNullOrEmpty(this.txtWeixiuPrice.Value))
            {
                JavaScript.MessageBox("请输入申请金额！", this);
                return;
            }




            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
       new TransactionOptions
       {
           IsolationLevel = IsolationLevel.ReadCommitted,
           Timeout = TransactionManager.MaximumTimeout
       }
       )
                )
            {

                try
                {
                    bool result = false;


                    DateTime nowTime = DateTime.Now;


                    var oA_ShebeiWeixiu = new OA_ShebeiWeixiu();
                    oA_ShebeiWeixiu.MemberId = CurrentUser.MemberId;
                    oA_ShebeiWeixiu.ShebeiId = this.selShebei.Value.ToInt32();
                    oA_ShebeiWeixiu.WeixiuTime = this.txtWeixiuTime.Value.ToDateTime2();
                    var shebeiManage = oA_ShebeiManageBLL.GetModelByKeyid(oA_ShebeiWeixiu.ShebeiId);
                    if (shebeiManage != null)
                    {
                        oA_ShebeiWeixiu.CateId = shebeiManage.CateId;
                        oA_ShebeiWeixiu.Anzhuangdidian = shebeiManage.Anzhuangdidian;
                        oA_ShebeiWeixiu.Name = shebeiManage.Name;
                    }
                    oA_ShebeiWeixiu.Remark = this.txtPlanRemark.Value;
                    oA_ShebeiWeixiu.WeixiuPrice = this.txtWeixiuPrice.Value.ToDecimal2();
                    oA_ShebeiWeixiu.Zerenren = 0;
                    oA_ShebeiWeixiu.ZerenrenName = "";
                    oA_ShebeiWeixiu.DanzePrice = 0;
                    oA_ShebeiWeixiu.Shifoufufei = 2;
                    oA_ShebeiWeixiu.CreateTime = nowTime;
                    oA_ShebeiWeixiu.Creator = CurrentUser.ShortName;
                    oA_ShebeiWeixiu.LastUpdateTime = nowTime;
                    oA_ShebeiWeixiu.Operator = CurrentUser.ShortName;

                    //需要添加审批信息

                    OA_WorkPlan m_OA_WorkPlan = new OA_WorkPlan();
                   

                    if (this.selShifoufukuan.Value == "1" )
                    {
                        OA_Fukuanshenqing oA_Fukuanshenqing = new OA_Fukuanshenqing();



                        oA_Fukuanshenqing.FirmId = CurrentUser.MemberId;
                        oA_Fukuanshenqing.SupplierId = "0";
                        oA_Fukuanshenqing.Fukuanshenqingstatus = 0;
                        oA_Fukuanshenqing.ApprovalStatus = 0;

                        oA_Fukuanshenqing.Molingmoney = 0;

                        oA_Fukuanshenqing.Fukuanmoney = this.txtWeixiuPrice.Value.ToDecimal2();
                        oA_Fukuanshenqing.Bank = "";
                        oA_Fukuanshenqing.Huming = "";
                        oA_Fukuanshenqing.AccountID = "";
                        oA_Fukuanshenqing.Yishoumoney = 0;
                        oA_Fukuanshenqing.Youwufapiao = 0;
                        oA_Fukuanshenqing.Fukuanyongtu = "设备维修费";
                        oA_Fukuanshenqing.FukuanStatus = 1;
                        oA_Fukuanshenqing.remark = "";
                        oA_Fukuanshenqing.DindanId = "";

                       


                        oA_Fukuanshenqing.Creater = CurrentUser.ShortName;
                        oA_Fukuanshenqing.CreateTime = nowTime;
                        oA_Fukuanshenqing.Updater = CurrentUser.ShortName;
                        oA_Fukuanshenqing.LastUpdateTime = nowTime;
                        //var oA_Suppliers = _OA_SuppliersBLL.getSingleSupplier(this.selSuppliers.Value);
                        //var _SupplierName = "";
                        //if (oA_Suppliers != null)
                        //{
                        //    _SupplierName = oA_Suppliers.Name;
                        //}

                        var _SupplierName = oA_ShebeiWeixiu.Name + "维修";
                        oA_Fukuanshenqing.SupplierName = _SupplierName;
                        var id = _oA_FukuanshenqingBLL.InsertModel(oA_Fukuanshenqing);

                        oA_ShebeiWeixiu.FukuanshenqingId = id;
                        m_OA_WorkPlan.PlanComplany = id.ToString();
                    }
                    else
                    {
                        m_OA_WorkPlan.PlanComplany = "";
                    }


                      
                    m_OA_WorkPlan.ApprovalContent = "";
                    m_OA_WorkPlan.ApprovalStaffId = Guid.Empty;
                    m_OA_WorkPlan.ApprovalStaffName = "";
                    m_OA_WorkPlan.ApprovalStatus = 0;
                    m_OA_WorkPlan.ApprovalTime = nowTime;
                    m_OA_WorkPlan.EvaluationContent = "";
                    m_OA_WorkPlan.EvaluationStaff = "";
                    m_OA_WorkPlan.EvaluationStaffId = Guid.Empty;
                    m_OA_WorkPlan.EvaluationStatus = 0;
                    m_OA_WorkPlan.EvaluationTime = nowTime;
                    m_OA_WorkPlan.RewardContent = "";
                    m_OA_WorkPlan.RewardMoney = 0;
                    m_OA_WorkPlan.RewardResult = "";
                    m_OA_WorkPlan.RewardType = 0;

                    m_OA_WorkPlan.PlanStartTime = nowTime;
                    m_OA_WorkPlan.PlanStatus = 1;
                    m_OA_WorkPlan.SentStaffId = CurrentUser.TrueMemberId;
                    m_OA_WorkPlan.MemberId = CurrentUser.MemberId;

                    OA_Staff m_OA_Staff = bll_OA_StaffBLL.GetModelByMemberId(CurrentUser.TrueMemberId);
                    if (m_OA_Staff != null)
                        m_OA_WorkPlan.DepartId = m_OA_Staff.DepartmentId;
                    else
                        m_OA_WorkPlan.DepartId = 0;

                    m_OA_WorkPlan.PlanPeople = CurrentUser.TrueName;
                    m_OA_WorkPlan.ReciveStaffId = CurrentUser.TrueMemberId;

                    m_OA_WorkPlan.Operator = CurrentUser.ShortName;
                   
                    m_OA_WorkPlan.PlanContent = oA_ShebeiWeixiu.Name+"维修申请";
                    m_OA_WorkPlan.PlanDataType = 18;
                    m_OA_WorkPlan.PlanMoney = this.txtWeixiuPrice.Value.ToDecimal2();
                    m_OA_WorkPlan.RewardMoney = 0;
                    m_OA_WorkPlan.PlanRemark = "";
                    m_OA_WorkPlan.PlanRunTime = DateTime.Now;
                    m_OA_WorkPlan.PlanTitle =  this.txtPlanRemark.Value+ ".维修日期:"+ this.txtWeixiuTime.Value;
                    m_OA_WorkPlan.PlanType = 3;
                    m_OA_WorkPlan.LastUpdateTime = nowTime;
                    var workid = oA_WorkReminderBll.InserModelAndGetId(m_OA_WorkPlan);
                    m_OA_WorkPlan.Keyid = workid;
                    if (workid > 0)
                    {


                        oA_ShebeiWeixiu.WeixiuShebeiId = workid;


                        if (this.selShifoufukuan.Value == "1")
                        {
                            oA_ShebeiWeixiu.FukuanShebeiId = workid;
                        }


                     var ssss =   oA_ShebeiWeixiuBLL.InsertModel(oA_ShebeiWeixiu);
                    }



                    result = true;









                    if (!result)
                    {
                        return;
                    }
                    //}
                    scope.Complete();
                }
                catch (Exception ex)
                {
                    // 回滚事务
                }
                finally
                {
                    // 释放资源
                    scope.Dispose();
                }
            }
            //JavaScript.MessageBox("提交成功", this);

            //操作成功
            JavaScript.MessageBox("提交成功", this, true, true);
        }
        
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuAdd.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeiWeixiuAdd
    {

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

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuFukuanAdd.aspx

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

<!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 runat="server">
        <uc:CMSHead ID="CMSHead1" runat="server" />
    </head>
    <body style="padding:10px">
        <form runat="server">
            <table class="tableStyle" >
                
                 <tr>
                    <td class="ali03">设备名称：</td>
                    <td>  
                        <span id="ShebeiName"  runat="server"></span>
                    </td>
                </tr>

                 <tr>
                <td class="ali03">
                    故障原因：
                </td>
                <td colspan="3">
                    <textarea id="txtPlanRemark" runat="server" style="width: 390px; height: 50px;" MaxLength="100" class='req' readonly="readonly" ></textarea>
                </td>
            </tr>
                 <tr>
                <td class="ali03">
                    维修日期：
                </td>
                <td>
                   <input type="text" id='txtWeixiuTime'   runat="server" readonly="readonly" />
                </td>
            </tr>

                 <tr>
                    <td class="ali03">申请费用：</td>
                    <td> <input id='txtWeixiuPrice' runat="server" maxlength='18' onblur="validateAmount(event)" placeholder="请输入金额"     /></td>
                </tr>
  
                <tr>
                    <td colspan="2"></td>
                </tr>
                 <tr id="trbtn" runat="server">
                    <td class="ali02" colspan="2">
                        <asp:Button ID="btn_Submit" Text="提交申请" runat="server" OnClick="btn_Submit_form" />
                        <span style="margin-left:10px"></span>
                        <input type="button" value="取消 " onclick="top.Dialog.close()" />
                    </td>
                </tr>
            </table>
        </form>
    </body>
    <script type="text/javascript" language="javascript">
        function custormerChange(sel) {

          


            window.submitUrl = '/Pages/Property/ShebeiWeixiuFukuanAdd.aspx';

            CallServer({ Target: "GetSuplier", id: sel.value }, function (data, textStatus) {
                var jobj = false;
                try {
                    jobj = eval('[' + data + ']')[0];
                } catch (ex) {
                    global.DealDataException(ex); return;
                }
                if (jobj != '-2') {
                    document.getElementById('txtBank').value = jobj.Bank;
                    document.getElementById('txtAccountID').value = jobj.AccountID;
                    if (jobj.Huming == "") {
                        document.getElementById('txtHuming').value = jobj.Name;
                    } else {
                        document.getElementById('txtHuming').value = jobj.Huming;
                    }
                   
                } else {
                    document.getElementById('txtBank').value = "";
                    document.getElementById('txtAccountID').value = "";
                    document.getElementById('txtHuming').value = "";
                }
               
                  
               
            });
        }

        ///新增客户
        function showCustomer() {
            top.Dialog.open({ URL: "/Pages/procurement/SuppliersEdit.aspx?Keyid='0'&&flasss=ddfffff", Title: "新增供应商", Width: 950, Height: 650 });
        }


        //为Select新增过滤功能
        function SelectAddSearch() {
            $("select[SelInputHtml='True']").each(function (i, v) {
                $(this).unbind("blur");
                var old = $(this).html();
                var oldObject = $(this).clone();
                var sign = "selectS" + i;
                $(v).attr("sign", sign);

                var inputClass = "input_" + sign;
                var html = "<span style='margin-left:10px'>过滤：</span><input type='text' class='" + inputClass + "' style='width:80px;height:18px;line-height:18px;'/>";
                $(v).after(html);
                $("." + inputClass).blur(function () {
                    var nowval = $(this).val().trim();
                    var output = "";
                    if (nowval == "" || nowval == null) {
                        output = old;
                    } else {
                        output += "<option value=''>请选择</option>";
                        var valueArr = new Array();
                        oldObject.find("option").each(function (ii, vv) {

                            var value = $.trim($(vv).attr("value"));
                            var text = $.trim($(vv).text());

                            if (text.indexOf(nowval) >= 0)
                                valueArr.push(value + "|||" + text);
                        });
                        for (var ss in valueArr) {
                            var s = valueArr[ss];
                            if (s.split("|||").length == 2) {
                                var value1 = s.split("|||")[0];
                                var text1 = s.split("|||")[1];
                                output += "<option value='" + value1 + "'>" + text1 + "</option>";
                            }
                        }
                    }
                    $(v).html(output);
                });
            });
        }

        $(function () {
            SelectAddSearch();
        });

        function validateAmount(event) {
            var input = event.target;
            var value = input.value;
            var regex = /^\d+(\.\d+)?$/;

            if (!regex.test(value)) {
                // 输入无效，重置值并将焦点设回文本框
                input.value = '0';
                input.focus();
                alert('请输入有效的正负金额，例如  45.67');
            }
        }



        //查看
        function checkSelFile() {
 
                var oFile = document.getElementById('file1');
                if (oFile.value == "") {
                    alertMsg('没有选择文件');
                    return;

                }



                var formData = new FormData();
                formData.append('file', oFile.files[0]); // this.files[0]是文件对象


                $.ajax({
                    url: '/Pages/Property/FileUploadHandler.ashx', // 替换为你的服务器端点
                    type: 'POST',
                    data: formData,
                    contentType: false,
                    processData: false,
                    async: false,        // 设置为同步
                    success: function (response) {
                        console.log('File uploaded successfully:', response);
                        if (response.code == 1) {

                            $(".AddTab").last().after($(".AddTab").last().clone(true));
                            $(".AddTab").last().show();
                            $("input[name='HideKeyidFapiao']").last().val("");
                            $("input[name='HideAttachmentFapiao']").last().val(response.data);
                            $('a[name="HrefAttachmentFapiao"]').last().attr("href", response.data);
                            $('a[name="HrefAttachmentFapiao"]').last().html('<img src="' + response.data+'" width="20" height="20" />');
                            alertMsg('上传成功');
                        } else {
                            alertMsg(response.message);
                        }


                    },
                    error: function (xhr, status, error) {
                        console.error('File upload failed:', status, error);
                        alertMsg('上传失败');
                    }
                });


           
             




        }




        function deletefujian(obj) {
            if (confirm("是否删除选中数据？")) {
                $(obj).parent().parent().remove()
            }
        }
    </script>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuFukuanAdd.aspx.cs

New file
@@ -0,0 +1,308 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL.EC;
using CY.Model;
using CY.Infrastructure.Common;
using CY.BLL.Integrity;
using CY.BLL;
using System.Threading.Tasks;
using System.Transactions;
using CY.BLL.OA;

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //卖家评价
    public partial class ShebeiWeixiuFukuanAdd : BasePage
    {
        EC_OrderBasicBLL bll_EC_OrderBasicBLL = null;
        
        OA_FukuanshenqingBLL _oA_FukuanshenqingBLL = null;
       
        OA_StaffBLL bll_OA_StaffBLL = null;
        OA_WorkPlanBll oA_WorkReminderBll = null;
        OA_ShebeiManageBLL oA_ShebeiManageBLL = null;
        OA_ShebeiWeixiuBLL oA_ShebeiWeixiuBLL = null;




        //初始化
        public ShebeiWeixiuFukuanAdd()
        {
            bll_EC_OrderBasicBLL = new EC_OrderBasicBLL();
          
            _oA_FukuanshenqingBLL = new OA_FukuanshenqingBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            oA_WorkReminderBll = new OA_WorkPlanBll();
            oA_ShebeiManageBLL = new OA_ShebeiManageBLL();
            oA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();


        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                switch (Request["Target"])
                {
                    case "GetSuplier":
                        LoadCommunication();
                        break;

                    default:
                        if (!IsPostBack)
                        {
                            InitData();
                        }
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                //Response.Write("-1");
                Response.Write(ex.Message);
            }
            Response.End();
          
        }

        //绑定数据
        public void InitData()
        {
 
           
               

            this.txtWeixiuTime.Value = DateTime.Now.ToString("yyyy-MM-dd");

             var keyid = Request["keyid"];
             var oA_ShebeiWeixiu  =oA_ShebeiWeixiuBLL.GetModelByKeyid(keyid.ToInt32());
            if (oA_ShebeiWeixiu!=null)
            {
                this.ShebeiName.InnerText = oA_ShebeiWeixiu.Name;
                this.txtPlanRemark.InnerText = oA_ShebeiWeixiu.Remark;
                this.txtWeixiuTime.Value = oA_ShebeiWeixiu.WeixiuTime.HasValue ? oA_ShebeiWeixiu.WeixiuTime.Value.ToString("yyyy-MM-dd") : "";
                this.txtWeixiuPrice.Value = oA_ShebeiWeixiu.WeixiuPrice.Value.ToString("F2");
            }


        }


        /// <summary>
        /// 加载供应商
        /// </summary>
        private void LoadCommunication()
        {
            //Response.Clear();
            //string id = Request["id"];
            //if (string.IsNullOrEmpty(id))
            //{
            //    Response.Write("-2");
            //    return;
            //}

            //var oA_Suppliers = _OA_SuppliersBLL.getSingleSupplier(id);

          
            //Response.Write(null == oA_Suppliers ? "" : JsonHelper.GetJsonStringByObject(oA_Suppliers));
        }

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

        /// <summary>
        /// 批量开票申请
        /// </summary>
        public void AcceptAll3()
        {

             

            if ( string.IsNullOrEmpty(this.txtWeixiuPrice.Value))
            {
                JavaScript.MessageBox("请输入申请金额！", this);
                return;
            }

            var keyid = Request["keyid"];
            var oA_ShebeiWeixiu = oA_ShebeiWeixiuBLL.GetModelByKeyid(keyid.ToInt32());
            if (oA_ShebeiWeixiu.FukuanShebeiId.HasValue && oA_ShebeiWeixiu.FukuanShebeiId.Value>0)
            {
                JavaScript.MessageBox("已经申请付款！", this);
                return;
            }


            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
       new TransactionOptions
       {
           IsolationLevel = IsolationLevel.ReadCommitted,
           Timeout = TransactionManager.MaximumTimeout
       }
       )
                )
            {

                try
                {
                    bool result = false;


                    DateTime nowTime = DateTime.Now;

                  
                  
                    oA_ShebeiWeixiu.WeixiuPrice = this.txtWeixiuPrice.Value.ToDecimal2();
                    oA_ShebeiWeixiu.LastUpdateTime = nowTime;
                    oA_ShebeiWeixiu.Operator = CurrentUser.ShortName;

                    //需要添加审批信息

                    OA_WorkPlan m_OA_WorkPlan = new OA_WorkPlan();



                    OA_Fukuanshenqing oA_Fukuanshenqing = new OA_Fukuanshenqing();



                    oA_Fukuanshenqing.FirmId = CurrentUser.MemberId;
                    oA_Fukuanshenqing.SupplierId = "0";
                    oA_Fukuanshenqing.Fukuanshenqingstatus = 0;
                    oA_Fukuanshenqing.ApprovalStatus = 0;

                    oA_Fukuanshenqing.Molingmoney = 0;

                    oA_Fukuanshenqing.Fukuanmoney = this.txtWeixiuPrice.Value.ToDecimal2();
                    oA_Fukuanshenqing.Bank = "";
                    oA_Fukuanshenqing.Huming = "";
                    oA_Fukuanshenqing.AccountID = "";
                    oA_Fukuanshenqing.Yishoumoney = 0;
                    oA_Fukuanshenqing.Youwufapiao = 0;
                    oA_Fukuanshenqing.Fukuanyongtu = "设备维修费";
                    oA_Fukuanshenqing.FukuanStatus = 1;
                    oA_Fukuanshenqing.remark = "";
                    oA_Fukuanshenqing.DindanId = "";




                    oA_Fukuanshenqing.Creater = CurrentUser.ShortName;
                    oA_Fukuanshenqing.CreateTime = nowTime;
                    oA_Fukuanshenqing.Updater = CurrentUser.ShortName;
                    oA_Fukuanshenqing.LastUpdateTime = nowTime;
                    //var oA_Suppliers = _OA_SuppliersBLL.getSingleSupplier(this.selSuppliers.Value);
                    //var _SupplierName = "";
                    //if (oA_Suppliers != null)
                    //{
                    //    _SupplierName = oA_Suppliers.Name;
                    //}

                    var _SupplierName = oA_ShebeiWeixiu.Name + "维修";
                    oA_Fukuanshenqing.SupplierName = _SupplierName;
                    var id = _oA_FukuanshenqingBLL.InsertModel(oA_Fukuanshenqing);

                    oA_ShebeiWeixiu.FukuanshenqingId = id;
                    m_OA_WorkPlan.PlanComplany = id.ToString();




                    m_OA_WorkPlan.ApprovalContent = "";
                    m_OA_WorkPlan.ApprovalStaffId = Guid.Empty;
                    m_OA_WorkPlan.ApprovalStaffName = "";
                    m_OA_WorkPlan.ApprovalStatus = 0;
                    m_OA_WorkPlan.ApprovalTime = nowTime;
                    m_OA_WorkPlan.EvaluationContent = "";
                    m_OA_WorkPlan.EvaluationStaff = "";
                    m_OA_WorkPlan.EvaluationStaffId = Guid.Empty;
                    m_OA_WorkPlan.EvaluationStatus = 0;
                    m_OA_WorkPlan.EvaluationTime = nowTime;
                    m_OA_WorkPlan.RewardContent = "";
                    m_OA_WorkPlan.RewardMoney = 0;
                    m_OA_WorkPlan.RewardResult = "";
                    m_OA_WorkPlan.RewardType = 0;

                    m_OA_WorkPlan.PlanStartTime = nowTime;
                    m_OA_WorkPlan.PlanStatus = 1;
                    m_OA_WorkPlan.SentStaffId = CurrentUser.TrueMemberId;
                    m_OA_WorkPlan.MemberId = CurrentUser.MemberId;

                    OA_Staff m_OA_Staff = bll_OA_StaffBLL.GetModelByMemberId(CurrentUser.TrueMemberId);
                    if (m_OA_Staff != null)
                        m_OA_WorkPlan.DepartId = m_OA_Staff.DepartmentId;
                    else
                        m_OA_WorkPlan.DepartId = 0;

                    m_OA_WorkPlan.PlanPeople = CurrentUser.TrueName;
                    m_OA_WorkPlan.ReciveStaffId = CurrentUser.TrueMemberId;

                    m_OA_WorkPlan.Operator = CurrentUser.ShortName;
                   
                    m_OA_WorkPlan.PlanContent = oA_ShebeiWeixiu.Name+ "维修付款申请";
                    m_OA_WorkPlan.PlanDataType = 19;
                    m_OA_WorkPlan.PlanMoney = this.txtWeixiuPrice.Value.ToDecimal2();
                    m_OA_WorkPlan.RewardMoney = 0;
                    m_OA_WorkPlan.PlanRemark = "";
                    m_OA_WorkPlan.PlanRunTime = DateTime.Now;
                    m_OA_WorkPlan.PlanTitle =  this.txtPlanRemark.Value+ ".维修日期:"+ this.txtWeixiuTime.Value;
                    m_OA_WorkPlan.PlanType = 3;
                    m_OA_WorkPlan.LastUpdateTime = nowTime;
                    var workid = oA_WorkReminderBll.InserModelAndGetId(m_OA_WorkPlan);
                    m_OA_WorkPlan.Keyid = workid;
                    if (workid > 0)
                    {
                        oA_ShebeiWeixiu.FukuanShebeiId = workid;
                        var ssss = oA_ShebeiWeixiuBLL.UpdateModel(oA_ShebeiWeixiu);
                    }



                    result = true;









                    if (!result)
                    {
                        return;
                    }
                    //}
                    scope.Complete();
                }
                catch (Exception ex)
                {
                    // 回滚事务
                }
                finally
                {
                    // 释放资源
                    scope.Dispose();
                }
            }
            //JavaScript.MessageBox("提交成功", this);

            //操作成功
            JavaScript.MessageBox("提交成功", this, true, true);
        }
        
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuFukuanAdd.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeiWeixiuFukuanAdd
    {

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuList.aspx

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

<!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 onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/Property/ShebeiWeixiuFukuanAdd.aspx?keyid=" + keyid, Title: "维修付款申请", Width: 500, Height: 430 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/Property/ShebeiWeixiuAdd.aspx", Title: "维修申请", Width: 500, Height: 430 });
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要报废该设备吗？", function () {
                window.location = "/Pages/Property/ShebeiWeixiuList.aspx?delete=" + keyid;
            });
        }
        //打印盘点表
        function PrintCorATable() {
            var keyid = "";
            $(".SelectCheck:checked").each(function (ii, vv) {
                keyid = keyid + "," + $(vv).attr("value_cid");
            });
            if (keyid == "")
                alertMsg("未选中任何设备");
            else {
                openWindowTransferData("/Pages/Property/PrintCheckTable.aspx", "Keyid", 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/Property/ShebeiWeixiuList.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>
                        <select id="selAnzhuangdidian" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                              <option value="一车间">一车间</option>
                              <option value="二车间">二车间</option>
                              <option value="三车间">三车间</option>
                              <option value="智能车间">智能车间</option>
                              <option value="公司汽车">公司汽车</option>
                              <option value="成都公司">成都公司</option>
                                    <option value="其他车间">其他车间</option>
                        </select>
                    </td>
                     <td class="ali03">
                        故障责任人：
                    </td>
                    <td>
                        <select id="selZerenren" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                        </select>
                    </td>
                    <td class="ali03">
                        设备类型：
                    </td>
                    <td>
                        <select id="selCateId" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                        </select>
                    </td>
                    <td class="ali03">
                        名称：
                    </td>
                    <td>
                        <input type="text" id="txtName" runat="server" />
                    </td>
                   
                    <td class="ali03">
                        是否付费：
                    </td>
                    <td>
                        <select keepdefaultstyle="true" runat="server" id="selStatus">
                            <option value="">全部</option>
                              <option value="2" selected="selected">未付费</option>
                            <option value="1"  >已付费</option>
                          
                        </select>
                    </td>
                    <td>
                        <asp:Button ID="btn_Submit" Text="查询" runat="server" OnClick="btn_Search_Click" />
                    </td>
                </tr>
            </table>
        </div>
        <div class="box_tool_min ">
            <div class="center">
                <div class="left">
                    <div class="right">
                        <div class="padding_top5 padding_left10">
                            <a href="javascript:;" onclick="addModel()" class="aaddModel" menu_member_case_id="case_addModel" menu_member_case_name="新增维修"><span class="icon_add">新增维修</span></a>
                           <%-- <div class="box_tool_line">
                            </div>
                            <a href="javascript:;" onclick="onAllDelete()" menu_member_case_id="case_onAllDeleteList" menu_member_case_name="批量删除"><span class="icon_delete">批量删除</span></a>
                            <div class="box_tool_line">
                            </div>
                            <a href="javascript:;" onclick="PrintCorATable()"><span class="icon_reply">打印盘点表</span></a>--%>
                            <div class="clear">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="clear">
            </div>
        </div>
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th width="25">
                            </th>

                            <th width="30" 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>
                          
                            <th style="text-align: center">
                                操作
                            </th>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td>
                            <input type="checkbox" class="SelectCheck" value='<%#Eval("Keyid")%>' value_cid="<%#Eval("Keyid")%>"/>
                        </td>
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1+ this.UCPager1.PageSize * (this.UCPager1.PageIndex - 1)%>
                        </td>
                         <td style="text-align: center">
                            <%#Eval("WeixiuTime","{0:yyyy-MM-dd}") %> 
                        </td>
                        <td style="text-align: center">
                            <%#Eval("CateName")%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("Name")%>
                        </td>
                          <td style="text-align: center">
                            <%#Eval("Anzhuangdidian")%>
                        </td>
                        <td style="text-align: center"> 
                            <%#Eval("WeixiuPrice","{0:F2}")%>
                        </td>
                       
                        <td style="text-align: center">
                            <%#Eval("ZerenrenName")%>
                        </td>
                           <td style="text-align: center"> 
                            <%#Eval("DanzePrice","{0:F2}")%> 
                        </td>
                        <td class="Operate " style="text-align: center">
                            

                             <%#Eval("Caozuo")%>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />
            </div>
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuList.aspx.cs

New file
@@ -0,0 +1,110 @@
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;

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //行政物品管理
    public partial class ShebeiWeixiuList : BasePage
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ShebeiWeixiuBLL bll_OA_ShebeiWeixiuBLL = null;
        OA_ShebeiManageBLL bll_OA_ShebeiManageBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;

        //初始化
        public ShebeiWeixiuList()
        {
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            bll_OA_ShebeiManageBLL = new OA_ShebeiManageBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                InitData();
                BindList();
            }
           
        }

        //绑定分类
        private void InitData()
        {
            this.selCateId.DataSource = bll_OA_ShebeiManageBLL.GetDataByType(CurrentUser.MemberId);
            this.selCateId.DataTextField = "Name";
            this.selCateId.DataValueField = "Keyid";
            this.selCateId.DataBind();
            this.selCateId.Items.Insert(0, new ListItem("全部", ""));
            this.selCateId.Value = "";


            this.selZerenren.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId,null, null);
            this.selZerenren.DataTextField = "Name";
            this.selZerenren.DataValueField = "Keyid";
            this.selZerenren.DataBind();
            this.selZerenren.Items.Insert(0, new ListItem("全部", ""));
            this.selZerenren.Value = "";
            
        }

        //绑定数据
        private void BindList()
        {
            Pagination pa = new Pagination();
            pa.PageSize = 50;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            var  shebeiWeixius  = bll_OA_ShebeiWeixiuBLL.SelectModelPage(pa, CurrentUser.MemberId, this.selCateId.Value.ToInt32(), this.txtName.Value, null, this.selAnzhuangdidian.Value, this.selZerenren.Value.ToInt32(), this.selStatus.Value.ToInt32());
            foreach(var oA_ShebeiWeixiu in shebeiWeixius)
            {
                if(oA_ShebeiWeixiu.FukuanShebeiId.HasValue && oA_ShebeiWeixiu.FukuanShebeiId.Value > 0)
                {
                    if(oA_ShebeiWeixiu.Shifoufufei.HasValue && oA_ShebeiWeixiu.FukuanShebeiId.Value == 1)
                    {
                        oA_ShebeiWeixiu.Caozuo = "已付款";
                    }
                    else
                    {
                        oA_ShebeiWeixiu.Caozuo = "已申请付款";
                    }
                   

                }
                else
                {
                    oA_ShebeiWeixiu.Caozuo = "<span menu_member_case_id=\"case_Fukuan\" menu_member_case_name=\"维修付款申请\" onclick=\"onEdit('" + oA_ShebeiWeixiu.Keyid + "')\">维修付款申请</span>";
                }
            }
            
            this.RepClientList.DataSource = shebeiWeixius;
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }

        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeiWeixiuList.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeiWeixiuList
    {

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

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageEdit.aspx

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

<!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 CheckStaff() {
            var IsCanSubmit = undefined;
            var Name = $.trim($("#txtCarNumber").val());
            if (Name != "") {
                $.ajax({
                    url: "/Pages/common/CommonAjax.aspx",
                    type: "POST",
                    dataType: "html",
                    data: { dateType: "shebeiNamecheckname", name: Name, keyid: '<%=Request["keyid"] %>' },
                    global: false,
                    cache: false,
                    async: false,
                    success: function (data) {
                        if (data == "1") {
                            IsCanSubmit = false;
                        } else {
                            IsCanSubmit = true;
                        }
                    }
                });
                if (!IsCanSubmit) {
                    alertMsg("此设备名称已存在，如有相同，请注意区分添加");
                    return false;
                }
            } else {
                alertMsg("请填写设备名称");
                return false;
            }
            return true;
        }

        $(function () {
            $("#txtCarNumber").blur(function () {
                CheckStaff();
            });
        });
    </script>
</head>
<body>
    <form id="form1" class="form2" runat="server">
    <div>
        <table class="tableStyle" style="margin: 10px auto;" cellpadding="0" cellspacing="0">
            <tr>
                <td class="ali03">
                    设备类型：
                </td>
                <td>
                    <select id="selCateId" runat="server" keepdefaultstyle="true">
                        <option value="">请选择</option>
                    </select>
                </td>
            </tr>
            <tr>
                <td class="ali03">
                    设备名称：
                </td>
                <td>
                    <input id="txtCarNumber" style="width: 100px;" type="text" runat="server" class="req" maxlength="50" />
                </td>
            </tr>
            <tr>
                <td class="ali03">
                    设备价值：
                </td>
                <td>
                    <input id="txtPrice" class="float req" style="width: 100px;" type="text" runat="server" />
                </td>
            </tr>
         
             <tr>
                <td class="ali03">
                    安装地点：
                </td>
                <td>
                     <select id="selAnzhuangdidian" runat="server" keepdefaultstyle="true">
                              <option value="一车间">一车间</option>
                              <option value="二车间">二车间</option>
                              <option value="三车间">三车间</option>
                              <option value="智能车间">智能车间</option>
                              <option value="公司汽车">公司汽车</option>
                              <option value="成都公司">成都公司</option>
                                    <option value="其他车间">其他车间</option>
                        </select>
                </td>
            </tr>
                <tr>
                <td class="ali03">
                    启用日期：
                </td>
                <td>
                   <input id='txtQiyongTime' class='date req' runat="server" />
                </td>
            </tr>
            <tr>
                <td class="ali03">
                    责任人：
                </td>
                <td >
                    <select id="selZerenren" runat="server" keepdefaultstyle="true">
                        <option value="">请选择</option>
                    </select>
                </td>
            </tr>
            <tr>
                <td colspan="2" style="text-align: center;">
                    <asp:Button ID="btn_submit" runat="server" OnClick="btn_submit_form" OnClientClick="if(CheckStaff())return true;else return false; " Text="提交" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageEdit.aspx.cs

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

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //行政物品
    public partial class ShebeimanageEdit : BasePage
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ShebeiManageBLL bll_OA_ShebeiManageBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;

        public ShebeimanageEdit()
        {
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_ShebeiManageBLL = new OA_ShebeiManageBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.selCateId.DataSource = bll_OA_ShebeiManageBLL.GetDataByType(CurrentUser.MemberId);
                this.selCateId.DataTextField = "Name";
                this.selCateId.DataValueField = "Keyid";
                this.selCateId.DataBind();
                //this.selCateId.Items.Insert(0, new ListItem("请选择", ""));
                //this.selCateId.Value = "";


                this.selZerenren.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, null, null);
                this.selZerenren.DataTextField = "Name";
                this.selZerenren.DataValueField = "Keyid";
                this.selZerenren.DataBind();
                //this.selZerenren.Items.Insert(0, new ListItem("全部", ""));
                //this.selZerenren.Value = "";

                InitData();
            }
        }

        //数据加载
        public void InitData()
        {
            OA_ShebeiManage m_OA_ShebeiManage = bll_OA_ShebeiManageBLL.GetModelByKeyid(Request["keyid"].ToInt32());
            if (m_OA_ShebeiManage != null)
            {
                this.selCateId.Value = m_OA_ShebeiManage.CateId.ToString2();
                this.txtCarNumber.Value = m_OA_ShebeiManage.Name;
                this.txtPrice.Value = m_OA_ShebeiManage.Price.Value.ToString("0.00");
                this.selAnzhuangdidian.Value = m_OA_ShebeiManage.Anzhuangdidian;
                this.txtQiyongTime.Value = m_OA_ShebeiManage.QiyongTime.HasValue? m_OA_ShebeiManage.QiyongTime.Value.ToString("yyyy-MM-dd"):"";
                this.selZerenren.Value = m_OA_ShebeiManage.Zerenren.HasValue? m_OA_ShebeiManage.Zerenren.ToString():"";
            }
        }

        //表单提交
        protected void btn_submit_form(object sender, EventArgs e)
        {
            try
            {
                //if (string.IsNullOrEmpty(this.txtAllNum.Value) || string.IsNullOrEmpty(this.txtReceiveNum.Value))
                //{
                //    JavaScript.MessageBox("物品总数量和已领取数量均不能为空", this);
                //    return;
                //}

                //if (this.txtAllNum.Value.ToInt32() < this.txtReceiveNum.Value.ToInt32())
                //{
                //    JavaScript.MessageBox("已领取数量不能大于总数量",this);
                //    return;
                //}

                DateTime nowTime = DateTime.Now;
                OA_ShebeiManage m_OA_ShebeiManage = bll_OA_ShebeiManageBLL.GetModelByKeyid(Request["keyid"].ToInt32());
                if (m_OA_ShebeiManage == null)
                {
                    m_OA_ShebeiManage = new OA_ShebeiManage();
                    m_OA_ShebeiManage.MemberId = CurrentUser.MemberId;
                  
                  
                }
                m_OA_ShebeiManage.CateId = this.selCateId.Value.ToInt32();
                m_OA_ShebeiManage.Name = this.txtCarNumber.Value;
                m_OA_ShebeiManage.Price = this.txtPrice.Value.ToDecimal2();
                m_OA_ShebeiManage.Anzhuangdidian = this.selAnzhuangdidian.Value;

                m_OA_ShebeiManage.QiyongTime = this.txtQiyongTime.Value.ToDateTime2();

                m_OA_ShebeiManage.Zerenren = this.selZerenren.Value.ToInt32();
                var a_Staff = bll_OA_StaffBLL.GetModelByKeyid(m_OA_ShebeiManage.Zerenren);
                if (a_Staff != null)
                {
                    m_OA_ShebeiManage.ZerenrenName = a_Staff.Name;
                }
                else
                {
                    m_OA_ShebeiManage.ZerenrenName = "";
                }
                m_OA_ShebeiManage.Remark = "";
                m_OA_ShebeiManage.Operator = CurrentUser.ShortName;
                m_OA_ShebeiManage.LastUpdateTime = nowTime;
                m_OA_ShebeiManage.Status = 2;

                if (Request["keyid"].ToInt32() > 0)
                {
                    if (bll_OA_ShebeiManageBLL.UpdateModel(m_OA_ShebeiManage))
                    {
                        JavaScript.MessageBox("更新成功", this, true, true);
                    }
                       
                    else
                        JavaScript.MessageBox("更新失败", this);
                }
                else
                {
                    if (bll_OA_ShebeiManageBLL.InsertModel(m_OA_ShebeiManage))
                    {
                        this.txtCarNumber.Value = "";
                        this.txtPrice.Value="";
                        this.selAnzhuangdidian.Value = "";

                        this.txtQiyongTime.Value = "";
                        JavaScript.MessageBox("新增成功", this, false, true);
                    }
                       
                    else
                        JavaScript.MessageBox("操作失败", this);
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("操作失败", this);
            }
        }
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageEdit.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeimanageEdit
    {

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageList.aspx

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

<!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 onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/Property/ShebeimanageEdit.aspx?keyid=" + keyid, Title: "设备修改", Width: 500, Height: 430 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/Property/ShebeimanageEdit.aspx", Title: "设备物品", Width: 500, Height: 430 });
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要报废该设备吗？", function () {
                window.location = "/Pages/Property/ShebeimanageList.aspx?delete=" + keyid;
            });
        }
        //打印盘点表
        function PrintCorATable() {
            var keyid = "";
            $(".SelectCheck:checked").each(function (ii, vv) {
                keyid = keyid + "," + $(vv).attr("value_cid");
            });
            if (keyid == "")
                alertMsg("未选中任何设备");
            else {
                openWindowTransferData("/Pages/Property/PrintCheckTable.aspx", "Keyid", 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/Property/ShebeimanageList.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>
                        <select id="selAnzhuangdidian" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                              <option value="一车间">一车间</option>
                              <option value="二车间">二车间</option>
                              <option value="三车间">三车间</option>
                              <option value="智能车间">智能车间</option>
                              <option value="公司汽车">公司汽车</option>
                              <option value="成都公司">成都公司</option>
                                    <option value="其他车间">其他车间</option>
                        </select>
                    </td>
                     <td class="ali03">
                        责任人：
                    </td>
                    <td>
                        <select id="selZerenren" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                        </select>
                    </td>
                    <td class="ali03">
                        设备类型：
                    </td>
                    <td>
                        <select id="selCateId" runat="server" keepdefaultstyle="true">
                            <option value="">全部</option>
                        </select>
                    </td>
                    <td class="ali03">
                        名称：
                    </td>
                    <td>
                        <input type="text" id="txtName" runat="server" />
                    </td>
                   
                    <td class="ali03">
                        是否报废：
                    </td>
                    <td>
                        <select keepdefaultstyle="true" runat="server" id="selStatus">
                            <option value="">全部</option>
                              <option value="2" selected="selected">未报废</option>
                            <option value="1"  >已报废</option>
                          
                        </select>
                    </td>
                    <td>
                        <asp:Button ID="btn_Submit" Text="查询" runat="server" OnClick="btn_Search_Click" />
                    </td>
                </tr>
            </table>
        </div>
        <div class="box_tool_min ">
            <div class="center">
                <div class="left">
                    <div class="right">
                        <div class="padding_top5 padding_left10">
                            <a href="javascript:;" onclick="addModel()" class="aaddModel" menu_member_case_id="case_addModel" menu_member_case_name="新增设备"><span class="icon_add">新增设备</span></a>
                            <div class="box_tool_line">
                            </div>
                            <a href="javascript:;" onclick="onAllDelete()" menu_member_case_id="case_onAllDeleteList" menu_member_case_name="批量删除"><span class="icon_delete">批量删除</span></a>
                           <%-- <div class="box_tool_line">
                            </div>
                            <a href="javascript:;" onclick="PrintCorATable()"><span class="icon_reply">打印盘点表</span></a>--%>
                            <div class="clear">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="clear">
            </div>
        </div>
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th width="25">
                            </th>
                            <th width="30" 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>
                            <th style="text-align: center">
                                本月维修费
                            </th>
                          
                            <th style="text-align: center">
                                操作
                            </th>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td>
                            <input type="checkbox" class="SelectCheck" value='<%#Eval("Keyid")%>' value_cid="<%#Eval("Keyid")%>"/>
                        </td>
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1+ this.UCPager1.PageSize * (this.UCPager1.PageIndex - 1)%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("CateName")%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("Name")%>
                        </td>
                          <td style="text-align: center">
                            <%#Eval("Anzhuangdidian")%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("Price","{0:F2}")%>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("QiyongTime","{0:yyyy-MM-dd}") %>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("ZerenrenName")%>
                        </td>
                          <td style="text-align: center">
                         <%#Eval("Nianprice")%>
                        </td>
                        <td style="text-align: center">
                           <%#Eval("Yueprice")%>
                        </td>
                        <td class="Operate " style="text-align: center">
                             <span menu_member_case_id="case_CarEdit" menu_member_case_name="修改" onclick="onEdit('<%#Eval("Keyid")%>')">修改</span>

                           <%#Eval("Status").ToString()=="1"?"已报废":"<span menu_member_case_id=\"case_Baofei\" menu_member_case_name=\"设备报废\" onclick=\"onDele('"+Eval("keyid") +"')\">设备报废</span>"%>
                        </td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />
            </div>
        </div>
    </div>
    </form>
</body>
</html>

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageList.aspx.cs

New file
@@ -0,0 +1,132 @@
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;

namespace CY.WebForm.Pages.Property
{
    //吴辉
    //行政物品管理
    public partial class ShebeimanageList : BasePage
    {
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;
        OA_ShebeiManageBLL bll_OA_ShebeiManageBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;
        OA_ShebeiWeixiuBLL bll_OA_ShebeiWeixiuBLL = null;
        //初始化
        public ShebeimanageList()
        {
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_OA_ShebeiManageBLL = new OA_ShebeiManageBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            bll_OA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                InitData();
                BindList();
            }
            if (Request["delete"] != null)
            {
                OA_ShebeiManage model = bll_OA_ShebeiManageBLL.GetModelByKeyid(Request["delete"].ToInt32());
                if (model != null && model.Keyid != null)
                {
                    model.Status = 1;
                    model.Operator = CurrentUser.ShortName;
                    model.LastUpdateTime = DateTime.Now;
                    bll_OA_ShebeiManageBLL.UpdateModel(model);
                    JavaScript.MessageBox("删除成功", this);
                    Response.Redirect("/Pages/Property/ShebeiManageList.aspx");
                }
                else
                    JavaScript.MessageBox("删除失败", this);
            }

            if (Request["deleteKeyIds"] != null)
            {
                List<int> deleteKeyIdList = new List<int>();
                string deleteKeyIds = Request["deleteKeyIds"].ToString().Trim(',');
                string[] keyIdArry = deleteKeyIds.Split(',');
                foreach (string keyId in keyIdArry)
                {
                    OA_ShebeiManage model = bll_OA_ShebeiManageBLL.GetModelByKeyid(keyId.ToInt32());
                    if (model.Keyid != null && model != null)
                        bll_OA_ShebeiManageBLL.DeleteModel(model);
                    else
                    {
                        JavaScript.MessageBox("删除失败", this);
                        return;
                    }
                }
                JavaScript.MessageBox("删除成功", this);
                Response.Redirect("/Pages/Property/ShebeiManageList.aspx");
            }
        }

        //绑定分类
        private void InitData()
        {
            this.selCateId.DataSource = bll_OA_ShebeiManageBLL.GetDataByType(CurrentUser.MemberId);
            this.selCateId.DataTextField = "Name";
            this.selCateId.DataValueField = "Keyid";
            this.selCateId.DataBind();
            this.selCateId.Items.Insert(0, new ListItem("全部", ""));
            this.selCateId.Value = "";


            this.selZerenren.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId,null, null);
            this.selZerenren.DataTextField = "Name";
            this.selZerenren.DataValueField = "Keyid";
            this.selZerenren.DataBind();
            this.selZerenren.Items.Insert(0, new ListItem("全部", ""));
            this.selZerenren.Value = "";
            
        }

        //绑定数据
        private void BindList()
        {
            Pagination pa = new Pagination();
            pa.PageSize = 50;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            var shebeiManages = bll_OA_ShebeiManageBLL.SelectModelPage(pa, CurrentUser.MemberId, this.selCateId.Value.ToInt32(), this.txtName.Value, this.selStatus.Value.ToInt32(), this.selAnzhuangdidian.Value, this.selZerenren.Value.ToInt32());
            foreach (var shebeiManage in shebeiManages)
            {
               var shebeiWeixiu  = bll_OA_ShebeiWeixiuBLL.GetModelBytiaojian(shebeiManage.Keyid.Value);
                if (shebeiWeixiu != null)
                {
                    shebeiManage.Yueprice = shebeiWeixiu.WeixiuPrice;
                    shebeiManage.Nianprice = shebeiWeixiu.DanzePrice;
                }
            }
            
            this.RepClientList.DataSource = shebeiManages;
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }

        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

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

 CY_ECommercePlatform/CY.WebForm/Pages/Property/ShebeimanageList.aspx.designer.cs

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

namespace CY.WebForm.Pages.Property
{


    public partial class ShebeimanageList
    {

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

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

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

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

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

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

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

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

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

@@ -80,7 +80,7 @@
                    <td class="ali03 w100px">客户名称：</td>
                    <td  class="w300px" >
                       
                            <input id="txtCompanyName" type="text" runat="server" class="req customcompany"  style=" width:280px;"  maxlength="20"  AUTOCOMPLETE="OFF" /><span  style="color:red;">*</span>
                            <input id="txtCompanyName" type="text" runat="server" class="req"  style=" width:280px;"  maxlength="100"  AUTOCOMPLETE="OFF" /><span  style="color:red;">*</span>
                            <input id="txtHideMemberId" type="hidden" runat="server"/>
                            <input id="txtHideMemberType" type="hidden" runat="server"/>
                       

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

@@ -90,11 +90,11 @@
            bool isWin = false;
            OA_Kaipiaoshenqing oA_Kaipiaoshenqing = oA_KaipiaoshenqingBLL.GetModelByKeyid(orderIds.ToGuid2());

            if(oA_Kaipiaoshenqing.kpmoney - (oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value : 0) < this.txtHuikuanJIne.Value.ToDecimal2())
            {
                JavaScript.MessageBox("回款金额大于剩余回款金额！", this);
                return;
            }
            //if(oA_Kaipiaoshenqing.kpmoney - (oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value : 0) < this.txtHuikuanJIne.Value.ToDecimal2())
            //{
            //    JavaScript.MessageBox("回款金额大于剩余回款金额！", this);
            //    return;
            //}


            //oA_Kaipiaoshenqing.Kaipiaoshenqing = 3;
@@ -103,9 +103,9 @@
            //oA_Kaipiaoshenqing.Fapiaohao = this.txtFapiaohao.Value.Trim();


            oA_Kaipiaoshenqing.Huikuanmoney = (oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value : 0) + this.txtHuikuanJIne.Value.ToDecimal2();
            //oA_Kaipiaoshenqing.Huikuanmoney = (oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value : 0) + this.txtHuikuanJIne.Value.ToDecimal2();

            isWin = oA_KaipiaoshenqingBLL.UpdateModel(oA_Kaipiaoshenqing);
            //isWin = oA_KaipiaoshenqingBLL.UpdateModel(oA_Kaipiaoshenqing);


            

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

@@ -147,7 +147,7 @@
        }
        //查看
        function onView(keyid, yongtu) {
            if (yongtu != "其他付款" && yongtu != "外协加工费") {
            if (yongtu != "其他付款" && yongtu != "外协加工费" && yongtu != "设备维修费" ) {
                top.Dialog.open({ URL: "/Pages/procurement/SuppliersDetail.aspx?Keyid=" + keyid, Title: "查看供应商", Width: 950, Height: 650 });
            }
          
@@ -213,6 +213,8 @@
                         <select keepdefaultstyle='true' id='selFukuanyongtu' runat="server" >
                           <option value="">全部</option>
                            <option value="外协加工费">外协加工费</option>
                             <option value="采购付款">采购付款</option>
                               <option value="设备维修费">设备维修费</option>
                            <option value="其他付款">其他付款</option>
                        </select>
                    </td>
@@ -371,7 +373,7 @@
                                
                                <td>
                                    
                                  <%#Eval("Fukuanyongtu").ToString().Equals("其他付款")?"":"<a href='javascript:void(0)' title='查看订单' class='a_under' onclick='Viewkaipiao(\""+Eval("Keyid") +"\",\""+Eval("DindanId")+"\",\""+Eval("Fukuanyongtu")+"\",\""+Eval("SupplierId")+"\")'>  查看订单   </a>" %>     <%--<a href='javascript:void(0)' title='查看订单' class='a_under' onclick='Viewkaipiao("<%#Eval("Keyid")%>","<%#Eval("DindanId")%>")'>  查看订单   </a>--%>
                                  <%#Eval("Fukuanyongtu").ToString().Equals("其他付款") || Eval("Fukuanyongtu").ToString().Equals("设备维修费")?"":"<a href='javascript:void(0)' title='查看订单' class='a_under' onclick='Viewkaipiao(\""+Eval("Keyid") +"\",\""+Eval("DindanId")+"\",\""+Eval("Fukuanyongtu")+"\",\""+Eval("SupplierId")+"\")'>  查看订单   </a>" %>     <%--<a href='javascript:void(0)' title='查看订单' class='a_under' onclick='Viewkaipiao("<%#Eval("Keyid")%>","<%#Eval("DindanId")%>")'>  查看订单   </a>--%>
                                    
                                  
                                </td>

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

@@ -463,8 +463,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");
                this.selPayStates.Value = "1";
                //初次数据加载
                btn_Search_Click(btn_Search, new EventArgs());
@@ -562,7 +562,7 @@
            IEnumerable<OA_Fukuanshenqing> result = oA_FukuanshenqingBLL.SelectModelPage(pagination, CurrentUser.MemberId, this.txtSQBeginDate.Value, this.txtSQEndDate.Value, this.txtCreatorName.Value, this.txtCustormerName.Value,this.selPayStates.Value, this.selFukuanyongtu.Value);
            foreach(var oA_Fukuanshenqing in result)
            {
               if(oA_Fukuanshenqing.Fukuanyongtu == "外协加工费" || oA_Fukuanshenqing.Fukuanyongtu == "采购付款")
               if(oA_Fukuanshenqing.Fukuanyongtu == "外协加工费" || oA_Fukuanshenqing.Fukuanyongtu == "采购付款" || oA_Fukuanshenqing.Fukuanyongtu == "设备维修费")
                {
                    var workPlan  =  _WorkPlanBll.GetModelByFukuanshenqid(oA_Fukuanshenqing.Keyid.ToString(),"");
                    if (workPlan != null)

 CY_ECommercePlatform/CY.WebForm/Pages/common/CommonAjax.aspx.cs

@@ -48,6 +48,7 @@
        OA_CarManageBll bll_OA_CarManageBll = null;
        OA_PropertyCateBLL bll_OA_PropertyCateBLL = null;
        OA_PropertyManageBLL bll_OA_PropertyManageBLL = null;
        OA_ShebeiManageBLL bll_OA_ShebeiManageBLL = null;
        OA_StaffPostBLL bll_OA_StaffPostBLL = null;
        OA_StaffResumeBLL bll_OA_StaffResumeBLL = null;
        OA_StaffPostLogBLL bll_OA_StaffPostLogBLL = null;
@@ -90,6 +91,7 @@
            bll_OA_CarManageBll = new OA_CarManageBll();
            bll_OA_PropertyCateBLL = new OA_PropertyCateBLL();
            bll_OA_PropertyManageBLL = new OA_PropertyManageBLL();
            bll_OA_ShebeiManageBLL = new OA_ShebeiManageBLL();
            bll_OA_StaffPostBLL = new OA_StaffPostBLL();
            bll_OA_StaffResumeBLL = new OA_StaffResumeBLL();
            bll_OA_StaffPostLogBLL = new OA_StaffPostLogBLL();
@@ -241,6 +243,10 @@
            else if (Request["dateType"] == "propertyNamecheckname")
            {
                Response.Write(IsExitsPropertyNameCateName(Request["name"], Request["keyid"]));
            }
            else if (Request["dateType"] == "shebeiNamecheckname")
            {
                Response.Write(IsExitsShebeiNameCateName(Request["name"], Request["keyid"]));
            }
            else if (Request["dateType"] == "resumeCateChange")
            {
@@ -1424,6 +1430,22 @@

        #endregion


        #region 检测行政物品是否重复

        /// <summary>
        /// 检测行政物品是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public int IsExitsShebeiNameCateName(string Name, string Keyid)
        {
            return bll_OA_ShebeiManageBLL.IsExitsName(Name, CurrentUser.MemberId, Keyid);
        }

        #endregion

        #region 根据职位类别获取全部职位

        public string GetPostListByCateId(int? cateId, int? Num)

 CY_ECommercePlatform/CY.WebForm/Pages/financial/DepositsCustomerFapiao.aspx.cs

@@ -175,7 +175,8 @@
                    m_OA_AdvanceMoneyRecord.Remark = this.txtRemark.Value.ToString2();

                    kaipiaoshenqing.Kehumoney = Kehumoney + money.Value;
                      var sss =  oA_KaipiaoshenqingBLL.UpdateModel(kaipiaoshenqing);
                    kaipiaoshenqing.Huikuanmoney = (kaipiaoshenqing.Huikuanmoney.HasValue ? kaipiaoshenqing.Huikuanmoney.Value : 0) + money.Value;
                    var sss =  oA_KaipiaoshenqingBLL.UpdateModel(kaipiaoshenqing);
                    if (bll_OA_AdvanceMoneyRecordBLL.DepositsMoney(m_OA_FirmAccount, m_OA_CorporateClients, m_OA_FirmAccountRecord, m_OA_AdvanceMoneyRecord))
                    {
                        BindList();

 CY_ECommercePlatform/CY.WebForm/Pages/financial/DepositsCustomershouruqueren.aspx.cs

@@ -222,6 +222,7 @@
                            m_OA_AdvanceMoneyRecord.Remark = "";

                            kaipiaoshenqing.Kehumoney = Kehumoney + money.Value;
                            kaipiaoshenqing.Huikuanmoney = (kaipiaoshenqing.Huikuanmoney.HasValue ? kaipiaoshenqing.Huikuanmoney.Value : 0) + money.Value;
                            isWin = oA_KaipiaoshenqingBLL.UpdateModel(kaipiaoshenqing);

                            isWin = bll_OA_CorporateClientsBLL.UpdateModel(m_OA_CorporateClients);

 CY_ECommercePlatform/CY.WebForm/Pages/financial/InvoicingShoukuan.aspx.cs

@@ -267,9 +267,17 @@
                        }
                    }

                    OA_Kaipiaoshenqing oA_Kaipiaoshenqing = oA_KaipiaoshenqingBLL.GetModelByKeyid(id.ToGuid2());
                    if (oA_Kaipiaoshenqing != null)
                    {
                        oA_Kaipiaoshenqing.Huikuanmoney = (oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value : 0) + this.txtReceiveMoney.Value.ToDecimal2();
                        isWin = oA_KaipiaoshenqingBLL.UpdateModel(oA_Kaipiaoshenqing);
                    }
                  
                    

                 
                   

                    scope.Complete();
                }
                catch (Exception ex)

 CY_ECommercePlatform/CY.WebForm/Pages/financial/InvoicingShouruqueren.aspx.cs

@@ -265,11 +265,15 @@
                        }

                    }
               

                    
                    if (a_Kaipiaoshenqing != null)
                    {
                        a_Kaipiaoshenqing.Huikuanmoney = (a_Kaipiaoshenqing.Huikuanmoney.HasValue ? a_Kaipiaoshenqing.Huikuanmoney.Value : 0) + this.txtReceiveMoney.Value.ToDecimal2();
                        isWin = oA_KaipiaoshenqingBLL.UpdateModel(a_Kaipiaoshenqing);
                    }

                 


                    scope.Complete();
                }
                catch (Exception ex)

 CY_ECommercePlatform/CY.WebForm/Pages/financial/WaixieExpenses.aspx.cs

@@ -25,6 +25,7 @@
        OA_SuppliersBLL oA_SuppliersBLL = null;
        OA_StaffBLL staffBLL = null;
        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        OA_ShebeiWeixiuBLL oA_ShebeiWeixiuBLL = null;

        public WaixieExpenses()
        {
@@ -38,6 +39,7 @@
            oA_SuppliersBLL = new OA_SuppliersBLL();
            staffBLL = new OA_StaffBLL();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
            oA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();
        }

        protected void Page_Load(object sender, EventArgs e)
@@ -169,6 +171,13 @@
                    if (money >= (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                    {
                        fukuanshenqing.FukuanStatus = 2;
                        if(fukuanshenqing.Fukuanyongtu == "设备维修费")
                        {
                            var shebeiWeixiu = oA_ShebeiWeixiuBLL.GetModelBytiaojian(null, null, fukuanshenqing.Keyid);
                            shebeiWeixiu.Shifoufufei = 1;
                            oA_ShebeiWeixiuBLL.UpdateModel(shebeiWeixiu);
                        }
                      
                    }

                    if (molingmoney.HasValue && molingmoney.Value > 0)
@@ -176,6 +185,12 @@
                        if ((money + molingmoney.Value) >= (fukuanshenqing.Fukuanmoney - fukuanshenqing.Yishoumoney))
                        {
                            fukuanshenqing.FukuanStatus = 2;
                            if (fukuanshenqing.Fukuanyongtu == "设备维修费")
                            {
                                var shebeiWeixiu = oA_ShebeiWeixiuBLL.GetModelBytiaojian(null, null, fukuanshenqing.Keyid);
                                shebeiWeixiu.Shifoufufei = 1;
                                oA_ShebeiWeixiuBLL.UpdateModel(shebeiWeixiu);
                            }
                        }
                    }

@@ -209,7 +224,7 @@
                        if (!string.IsNullOrEmpty(this.selSubject.Value))
                        {
                            var oA_SubjectSet = _OA_SubjectSetBLL.getSingleSubject(firmAccountRecord.SubjectId);
                            if (oA_SubjectSet.SubjectName.IndexOf("投标保证金") >= 0 || oA_SubjectSet.SubjectName.IndexOf("履约保证金") >= 0)
                            if (fukuanshenqing.Fukuanyongtu == "其他付款" && (oA_SubjectSet.SubjectName.IndexOf("投标保证金") >= 0 || oA_SubjectSet.SubjectName.IndexOf("履约保证金") >= 0))
                            {
                                //如果选择科目是保证金，插入以条保证金数据
                                OA_Baozhengjin oA_Baozhengjin = new OA_Baozhengjin();

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

@@ -95,6 +95,18 @@
                           </asp:Repeater>
                    </td>
                </tr>

                   <tr   style='<%=planDataType=="18"?"":"display:none;"  %>'>
                <td   colspan="6">
                   是否申请付款：
                 
                    <span id="spanShifoushenqingfukuan" runat="server"></span>&nbsp;&nbsp;&nbsp;&nbsp;
               
                        故障责任人： <span id="spanZerenren" runat="server"></span>&nbsp;&nbsp;&nbsp;&nbsp;
                    担责费用： <span id="spanDanzefeiyong" runat="server"></span>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                   
                    
            </tr>
            </table>
        </fieldset>
        <fieldset>

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

@@ -64,6 +64,19 @@
                    this.RepClientList.DataSource = oA_WorkPlan_AttachmentBLL.GetModelByKaipiaoIdandType(Request["keyid"].ToInt32().Value, 15);
                    this.RepClientList.DataBind();
                }
                else if(m_OA_WorkPlan.PlanDataType == 18)
                {
                    if (string.IsNullOrEmpty(m_OA_WorkPlan.PlanComplany))
                    {
                        this.spanShifoushenqingfukuan.InnerText = "否";
                    }
                    else
                    {
                        this.spanShifoushenqingfukuan.InnerText = "是";
                    }
                    this.spanZerenren.InnerText = m_OA_WorkPlan.RewardResult;
                    this.spanDanzefeiyong.InnerText = m_OA_WorkPlan.RewardContent;
                }

               


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

@@ -123,6 +123,33 @@
        protected global::System.Web.UI.WebControls.Repeater RepClientList;

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

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

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

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

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

@@ -85,8 +85,10 @@
                            <option value="11">客户联谊</option>
                            <option value="13">开票申请</option>
                            <option value="14">外协付款申请</option>
                             <option value="15">付款申请</option>
                              <option value="16">采购付款申请</option>
                            <option value="15">付款申请</option>
                            <option value="16">采购付款申请</option>
                            <option value="18">设备维修申请</option>
                            <option value="19">维修付款申请</option>
                            <option value="12">其他</option>
                        </select>
                    </td>
@@ -170,7 +172,7 @@
                <ItemTemplate>
                    <tr>
                        <td>
                            <input type="checkbox" value='<%#Eval("Keyid")%>' class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3" || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14"|| Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>' />
                            <input type="checkbox" value='<%#Eval("Keyid")%>' class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3" || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14"|| Eval("PlanDataType").ToString()=="18"|| Eval("PlanDataType").ToString()=="19"|| Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>' />
                        </td>
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1+ this.UCPager1.PageSize * (this.UCPager1.PageIndex - 1)%>
@@ -195,8 +197,8 @@
                        </td>
                        <td class="Operate " style="text-align: center">
                            <span menu_member_case_id="case_PlanView" menu_member_case_name="查看" onclick="onView('<%#Eval("Keyid")%>')">查看</span> 
                            <span menu_member_case_id="case_PlanEdit" menu_member_case_name="修改" onclick="onEdit('<%#Eval("Keyid")%>')"  class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3" || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14" || Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>'>修改</span>
                            <span menu_member_case_id="case_PlanDele" menu_member_case_name="删除" onclick="onDele('<%#Eval("Keyid")%>')" class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3"  || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14"|| Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>'>删除</span>
                            <span menu_member_case_id="case_PlanEdit" menu_member_case_name="修改" onclick="onEdit('<%#Eval("Keyid")%>')"  class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3" || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14" || Eval("PlanDataType").ToString()=="18"|| Eval("PlanDataType").ToString()=="19"|| Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>'>修改</span>
                            <span menu_member_case_id="case_PlanDele" menu_member_case_name="删除" onclick="onDele('<%#Eval("Keyid")%>')" class='<%#(Eval("ApprovalStatus").ToString()=="1" || Eval("ApprovalStatus").ToString()=="3"  || Eval("PlanDataType").ToString()=="13" || Eval("PlanDataType").ToString()=="14" || Eval("PlanDataType").ToString()=="18"|| Eval("PlanDataType").ToString()=="19"|| Eval("PlanDataType").ToString()=="16")?"AlreadyReply":""%>'>删除</span>
                        </td>
                    </tr>
                </ItemTemplate>

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

@@ -97,6 +97,20 @@
                           </asp:Repeater>
                    </td>
                </tr>

                 <tr   style='<%=planDataType=="18"?"":"display:none;"  %>'>
                <td   colspan="6">
                   是否申请付款：
                 
                    <span id="spanShifoushenqingfukuan" runat="server"></span>&nbsp;&nbsp;&nbsp;&nbsp;
               
                        故障责任人： <select keepDefaultStyle="true" runat="server" id="selZerenren" class="wx100px" >
                       
                    </select>
                     &nbsp;&nbsp;&nbsp;&nbsp;担责费用：<input id='txtDanzePrice' runat="server" maxlength='18'  class="float"   /></td>
                   
                    
            </tr>
            </table>
        </fieldset>
        <fieldset>

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

@@ -27,6 +27,8 @@
        EC_MemberBasicBLL _eC_MemberBasicBLL = null;
        public string planDataType = "";
        OA_WorkPlan_attachmentBLL oA_WorkPlan_AttachmentBLL = null;
        OA_StaffBLL oA_StaffBLL = null;
        OA_ShebeiWeixiuBLL oA_ShebeiWeixiuBLL = null;
        public RequestReplyAdd()
        {
            oA_WorkReminderBll = new OA_WorkPlanBll();
@@ -35,6 +37,8 @@
            _oA_FukuanshenqingBLL = new OA_FukuanshenqingBLL();
            _eC_MemberBasicBLL = new EC_MemberBasicBLL();
            oA_WorkPlan_AttachmentBLL = new OA_WorkPlan_attachmentBLL();
            oA_StaffBLL = new OA_StaffBLL();
            oA_ShebeiWeixiuBLL = new OA_ShebeiWeixiuBLL();
        }

        //页面加载
@@ -76,6 +80,23 @@
                {
                    this.RepClientList.DataSource = oA_WorkPlan_AttachmentBLL.GetModelByKaipiaoIdandType(Request["keyid"].ToInt32().Value, 15);
                    this.RepClientList.DataBind();
                }
                else if(m_OA_WorkPlan.PlanDataType == 18)
                {
                    if (string.IsNullOrEmpty(m_OA_WorkPlan.PlanComplany))
                    {
                        this.spanShifoushenqingfukuan.InnerText = "否";
                    }
                    else
                    {
                        this.spanShifoushenqingfukuan.InnerText = "是";
                    }
                    this.selZerenren.DataSource = oA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, null, null);
                    this.selZerenren.DataTextField = "Name";
                    this.selZerenren.DataValueField = "Keyid";
                    this.selZerenren.DataBind();
                    this.selZerenren.Items.Insert(0, new ListItem("全部", ""));
                    this.selZerenren.Value = "";
                }
            }
        }
@@ -124,6 +145,43 @@
                }


                if (m_OA_WorkPlan.ApprovalStatus == 1 && (m_OA_WorkPlan.PlanDataType == 18 || m_OA_WorkPlan.PlanDataType == 19))
                {//批准反写
                    if (!string.IsNullOrEmpty(m_OA_WorkPlan.PlanComplany))
                    {
                        var fukuanshenqing = _oA_FukuanshenqingBLL.GetModelByKeyid(m_OA_WorkPlan.PlanComplany.ToInt32().Value);
                        fukuanshenqing.ApprovalStatus = 1;
                        _oA_FukuanshenqingBLL.UpdateModel(fukuanshenqing);
                    }
                  
                   
                    if(m_OA_WorkPlan.PlanDataType == 18)
                    {
                        m_OA_WorkPlan.RewardContent = this.txtDanzePrice.Value;
                        
                        var oA_ShebeiWeixiu = oA_ShebeiWeixiuBLL.GetModelBytiaojian(m_OA_WorkPlan.Keyid, null, null);
                        if (!string.IsNullOrEmpty(this.selZerenren.Value))
                        {
                            var staff = oA_StaffBLL.GetModelByKeyid(this.selZerenren.Value.ToInt32());
                            if (staff != null)
                            {
                                m_OA_WorkPlan.RewardResult = staff.Name;
                                oA_ShebeiWeixiu.ZerenrenName = staff.Name;
                            }
                        }
                        if (oA_ShebeiWeixiu != null)
                        {
                            oA_ShebeiWeixiu.Zerenren = this.selZerenren.Value.ToInt32();
                          
                            oA_ShebeiWeixiu.DanzePrice = this.txtDanzePrice.Value.ToDecimal2();
                            oA_ShebeiWeixiuBLL.UpdateModel(oA_ShebeiWeixiu);
                        }
                    }

                    
                }


                if (m_OA_WorkPlan.ApprovalStatus == 1 && m_OA_WorkPlan.PlanDataType == 15)
                {//批准新增付款申请
                    OA_Fukuanshenqing oA_Fukuanshenqing = new OA_Fukuanshenqing();

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

@@ -123,6 +123,33 @@
        protected global::System.Web.UI.WebControls.Repeater RepClientList;

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

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

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

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

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

@@ -61,6 +61,8 @@
                             <option value="14">外协付款申请</option>
                             <option value="15">付款申请</option>
                             <option value="16">采购付款申请</option>
                             <option value="18">设备维修申请</option>
                            <option value="19">维修付款申请</option>
                            <option value="12">其他</option>
                        </select>
                    </td>