保证金

username@email.com

2025-01-03 58758cab891e0a1cbe060f2ce8fda0805cdfc99a

保证金

 CY_ECommercePlatform/AbstractFactory/Factory.cs

@@ -263,6 +263,8 @@
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewhuikuanDAL, "OA_KaipiaonewhuikuanDAL");
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaoJineQuerenDAL, "OA_KaipiaoJineQuerenDAL");
            OBJECT_PATH.Add(DALInterface.IOA_FukuanshenqingDAL, "OA_FukuanshenqingDAL");
            OBJECT_PATH.Add(DALInterface.IOA_BaozhengjincuishouDAL, "OA_BaozhengjincuishouDAL");
            OBJECT_PATH.Add(DALInterface.IOA_BaozhengjinDAL, "OA_BaozhengjinDAL");
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewDAL, "OA_KaipiaonewDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderDAL, "CoreCmsPlanOrderDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderItemDAL, "CoreCmsPlanOrderItemDAL");
@@ -897,6 +899,16 @@
        /// <summary>
        /// 开票申请
        /// </summary>
        IOA_BaozhengjincuishouDAL = 1936,
        /// <summary>
        /// 开票申请
        /// </summary>
        IOA_BaozhengjinDAL = 1937,
        

        /// <summary>
        /// 开票申请
        /// </summary>
        IOA_KaipiaonewDAL = 1932,
        
        /// <summary>

 CY_ECommercePlatform/CY.BLL/CY.BLL.csproj

@@ -155,6 +155,8 @@
    <Compile Include="LF\LF_OrderFileBLL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderBLL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItemBLL.cs" />
    <Compile Include="OA\OA_BaozhengjinBLL.cs" />
    <Compile Include="OA\OA_BaozhengjincuishouBLL.cs" />
    <Compile Include="OA\OA_CarDictionaryBLL.cs" />
    <Compile Include="OA\OA_CarExaminedBLL.cs" />
    <Compile Include="OA\OA_CarInsuranceBLL.cs" />

 CY_ECommercePlatform/CY.BLL/OA/OA_BaozhengjinBLL.cs

New file
@@ -0,0 +1,214 @@

/**  
* OA_BaozhengjinBLL.cs
*
* 功 能： 合作客户业务逻辑类
* 类 名： OA_BaozhengjinBLL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-2 15:11       吴辉      初版
* V0.02  2013-5-29 17:43      吴崎均    增加转换在线会员为厂商客户方法 
*
*
*
*
*
*
*/
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_BaozhengjinBLL
    {
        IOA_BaozhengjinDAL _IOA_BaozhengjinDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_BaozhengjinBLL()
        {
            //获取OA_Baozhengjin DAL实现
            _IOA_BaozhengjinDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_BaozhengjinDAL) as IOA_BaozhengjinDAL;


        }

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

                return _IOA_BaozhengjinDAL.InserModel(m_OA_Baozhengjin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

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


        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjin> GetModelByformid(Guid formid)
        {

            return _IOA_BaozhengjinDAL.GetModelByformid(formid);
        }

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

            return _IOA_BaozhengjinDAL.GetModelByKeyid(keyid);
        }

        /// <summary>
        /// 删除合作客户
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool DeleteModel(CY.Model.OA_Baozhengjin rType)
        {
            try
            {
                _IOA_BaozhengjinDAL.DeleteModel(rType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Baozhengjin> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
   string Zhanghuleixing, string Fukuanzhanghu, string Shoukuandanwei, string remark, string TuikuanStatus)
        {
            string Condition = " and ok.FirmId ='" + FirmId + "'  ";

            if (!string.IsNullOrEmpty(CreateTimeStart))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeStart + "')<=0 ";

            if (!string.IsNullOrEmpty(CreateTimeEnd))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeEnd + "')>=0 ";

            if (!string.IsNullOrEmpty(Zhanghuleixing))
                Condition += " and  ok.ReceiveWay = '" + Zhanghuleixing + "'";

            if (!string.IsNullOrEmpty(Fukuanzhanghu))
                Condition += " and  ok.Account = " + Fukuanzhanghu + "    ";
            if (!string.IsNullOrEmpty(Shoukuandanwei))
                Condition += " and  ok.Shoukuandanwei like '%" + Shoukuandanwei + "%'    ";
            if (!string.IsNullOrEmpty(remark))
                Condition += " and  ok.remark   like '%" + remark + "%' ";
            if (!string.IsNullOrEmpty(TuikuanStatus))
                Condition += " and  ok.[TuikuanStatus] = '" + TuikuanStatus + "'";

            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),

                new Criterion("orderBy"," CreateTime desc   ")
            };
            query.Criteria = criterias;
            return _IOA_BaozhengjinDAL.SelectModelPage(query, pa);
        }


        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Baozhengjin> SelectModelPageweikaipiao(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
   string Creater, string SupplierName, string shifoufukuan, string selFukuanyongtu)
        {
            string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 and ok.Youwufapiao !=2 and ok.FukuanStatus = 2 ";

            if (!string.IsNullOrEmpty(CreateTimeStart))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeStart + "')<=0 ";

            if (!string.IsNullOrEmpty(CreateTimeEnd))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeEnd + "')>=0 ";

            if (!string.IsNullOrEmpty(Creater))
                Condition += " and  ok.Creater like '%" + Creater + "%'";

            if (!string.IsNullOrEmpty(SupplierName))
                Condition += " and  ok.SupplierName like '%" + SupplierName + "%'    ";
            if (!string.IsNullOrEmpty(shifoufukuan))
                Condition += " and  ok.FukuanStatus = '" + shifoufukuan + "'";
            if (!string.IsNullOrEmpty(selFukuanyongtu))
                Condition += " and  ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'";

            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),

                new Criterion("orderBy"," CreateTime desc   ")
            };
            query.Criteria = criterias;
            return _IOA_BaozhengjinDAL.SelectModelPage(query, pa);
        }

    }
}

 CY_ECommercePlatform/CY.BLL/OA/OA_BaozhengjincuishouBLL.cs

New file
@@ -0,0 +1,141 @@

/**  
* OA_BaozhengjincuishouBLL.cs
*
* 功 能： 合作客户业务逻辑类
* 类 名： OA_BaozhengjincuishouBLL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-2 15:11       吴辉      初版
* V0.02  2013-5-29 17:43      吴崎均    增加转换在线会员为厂商客户方法 
*
*
*
*
*
*
*/
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_BaozhengjincuishouBLL
    {
        IOA_BaozhengjincuishouDAL _IOA_BaozhengjincuishouDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        /// </summary>
        public OA_BaozhengjincuishouBLL()
        {
            //获取OA_Baozhengjincuishou DAL实现
            _IOA_BaozhengjincuishouDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_BaozhengjincuishouDAL) as IOA_BaozhengjincuishouDAL;


        }

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

                return _IOA_BaozhengjincuishouDAL.InserModel(m_OA_Baozhengjincuishou);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

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


        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="BaozhengjinId">编号</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjincuishou> GetModelByKaipiaoId(int BaozhengjinId)
        {

            return _IOA_BaozhengjincuishouDAL.GetModelByKaipiaoId(BaozhengjinId);
        }

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

            return _IOA_BaozhengjincuishouDAL.GetModelByKeyid(keyid);
        }

        /// <summary>
        /// 删除合作客户
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool DeleteModel(CY.Model.OA_Baozhengjincuishou rType)
        {
            try
            {
                _IOA_BaozhengjincuishouDAL.DeleteModel(rType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }



    }
}


 CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj

@@ -158,6 +158,8 @@
    <Compile Include="Integrity\IIntegrity_IntegrityCardDAL.cs" />
    <Compile Include="OA\ICoreCmsPlanOrderDAL.cs" />
    <Compile Include="OA\ICoreCmsPlanOrderItemDAL.cs" />
    <Compile Include="OA\IOA_BaozhengjincuishouDAL.cs" />
    <Compile Include="OA\IOA_BaozhengjinDAL.cs" />
    <Compile Include="OA\IOA_CarrepairDAL.cs" />
    <Compile Include="OA\IOA_CuikuanjiluDAL.cs" />
    <Compile Include="OA\IOA_DeliverPlanDAL.cs" />

 CY_ECommercePlatform/CY.IDAL/OA/IOA_BaozhengjinDAL.cs

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


namespace CY.IDAL
{
    public interface IOA_BaozhengjinDAL : ICommonDAL, IPaging<OA_Baozhengjin>, IGetAllModel<OA_Baozhengjin>
    {

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_Baozhengjin GetModelByKeyid(int keyid);

        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        IEnumerable<OA_Baozhengjin> GetModelByformid(Guid formid);


    }
}

 CY_ECommercePlatform/CY.IDAL/OA/IOA_BaozhengjincuishouDAL.cs

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


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

        /// <summary>
        /// 根据KaipiaoId获得信息
        /// </summary>
        /// <param name="BaozhengjinId">编号</param>
        /// <returns></returns>
        IEnumerable<OA_Baozhengjincuishou> GetModelByKaipiaoId(int BaozhengjinId);
    }
}

 CY_ECommercePlatform/CY.Model/CY.Model.csproj

@@ -202,6 +202,8 @@
    <Compile Include="OA\CoreCmsPlanOrder.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItem.cs" />
    <Compile Include="OA\CoreDeliverOrderItem.cs" />
    <Compile Include="OA\OA_Baozhengjin.cs" />
    <Compile Include="OA\OA_Baozhengjincuishou.cs" />
    <Compile Include="OA\OA_CarDictionary.cs" />
    <Compile Include="OA\OA_CarInsurance.cs" />
    <Compile Include="OA\OA_Carrepair.cs" />

 CY_ECommercePlatform/CY.Model/OA/OA_Baozhengjin.cs

New file
@@ -0,0 +1,311 @@
/**  
* OA_CorporateClients.cs
*
* 功 能： N/A
* 类 名： OA_CorporateClients
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-2 14:27:43   N/A    初版
*
*
*
*
*
*
*/

using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;

namespace CY.Model
{
    /// <summary>
    /// 印刷参数
    /// </summary>
    [Serializable]
    public partial class OA_Baozhengjin : IAggregateRoot
    {

        public OA_Baozhengjin()
        {
        }
        #region Model
        /// <summary>
        /// id
        /// </summary>
        public int Keyid { get; set; }
        /// <summary>
        ///  FirmId
        /// </summary>
        public Guid FirmId { get; set; }


        /// <summary>
        /// FukuanTime
        /// </summary>
        public DateTime? FukuanTime
        {
            get;
            set;
        }

        /// <summary>
        /// ReceiveWay
        /// </summary>
        public int? ReceiveWay { get; set; }

        /// <summary>
        /// Zhanghuleixing
        /// </summary>
        public string Zhanghuleixing { get; set; }

        /// <summary>
        /// ReceiveWay
        /// </summary>
        public int? Account { get; set; }

        /// <summary>
        /// Zhanghuleixing
        /// </summary>
        public string Fukuanzhanghu { get; set; }

        /// <summary>
        /// ReceiveWay
        /// </summary>
        public int? Subject { get; set; }

        /// <summary>
        /// Zhanghuleixing
        /// </summary>
        public string Fukuankemu { get; set; }

        public decimal? Fukuanmoney { get; set; }

        public string Shoukuandanwei { get; set; }

        /// <summary>
        /// 说明
        /// </summary>
        public string remark { get; set; }

        /// <summary>
        /// TuikuanTime
        /// </summary>
        public DateTime? TuikuanTime
        {
            get;
            set;
        }
        /// <summary>
        /// TuikuanStatus  2是1否
        /// </summary>	
        public int? TuikuanStatus { get; set; }



        


        public string TuikuanName
        {
            get
            {
                if (TuikuanStatus.HasValue && TuikuanStatus.Value == 2)
                {
                    return "已退款";
                }
                else
                {
                    return "未退款";
                }
            }
        }

     
       

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

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateTime
        {
            get;
            set;
        }
        /// <summary>
        /// 修改人
        /// </summary>
        public string Updater
        {
            get;
            set;
        }
        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime? LastUpdateTime
        {
            get;
            set;
        }

        /// <summary>
        ///  MemberId
        /// </summary>
        public int? MemberId { get; set; }

        /// <summary>
        ///  MemberName
        /// </summary>
        public string MemberName { 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.ConvertToInt32(value).Value : Keyid;
                theValue = this.Keyid;
            }
            else if ("FirmId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.FirmId = isChange ? MyConvert.ConvertToGuid(value) : FirmId;
                theValue = this.FirmId;
            }
            else if ("FukuanTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.FukuanTime = isChange ? MyConvert.ConvertToDateTime(value) : FukuanTime;
                theValue = this.FukuanTime;
            }
            else if ("ReceiveWay".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.ReceiveWay = isChange ? MyConvert.ConvertToInt32(value) : ReceiveWay;
                theValue = this.ReceiveWay;
            }

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







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

            else if ("Account".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 18)
            {
                this.Account = isChange ? MyConvert.ConvertToInt32(value) : Account;
                theValue = this.Account;
            }
            else if ("Fukuanmoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 19)
            {
                this.Fukuanmoney = isChange ? MyConvert.ConvertToDecimal(value) : Fukuanmoney;
                theValue = this.Fukuanmoney;
            }
            else if ("Fukuanzhanghu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 20)
            {
                this.Fukuanzhanghu = isChange ? MyConvert.ConvertToString(value) : Fukuanzhanghu;
                theValue = this.Fukuanzhanghu;
            }
            else if ("Subject".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 21)
            {
                this.Subject = isChange ? MyConvert.ConvertToInt32(value) : Subject;
                theValue = this.Subject;
            }
            else if ("Fukuankemu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 28)
            {
                this.Fukuankemu = isChange ? MyConvert.ConvertToString(value) : Fukuankemu;
                theValue = this.Fukuankemu;
            }

            else if ("Shoukuandanwei".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 22)
            {
                this.Shoukuandanwei = isChange ? MyConvert.ConvertToString(value) : Shoukuandanwei;
                theValue = this.Shoukuandanwei;
            }
            else if ("TuikuanTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 23)
            {
                this.TuikuanTime = isChange ? MyConvert.ConvertToDateTime(value) : TuikuanTime;
                theValue = this.TuikuanTime;
            }
            else if ("TuikuanStatus".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 24)
            {
                this.TuikuanStatus = isChange ? MyConvert.ConvertToInt32(value) : TuikuanStatus;
                theValue = this.TuikuanStatus;
            }

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

            else if ("MemberId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 27)
            {
                this.MemberId = isChange ? MyConvert.ConvertToInt32(value) : MemberId;
                theValue = this.MemberId;
            }
            else if ("MemberName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 28)
            {
                this.MemberName = isChange ? MyConvert.ConvertToString(value) : MemberName;
                theValue = this.MemberName;
            }
            
            return theValue;
        }

        #endregion
    }
}
 

 CY_ECommercePlatform/CY.Model/OA/OA_Baozhengjincuishou.cs

New file
@@ -0,0 +1,138 @@
/**  
*OA_CorporateClients.cs
*
*功 能： N / A
* 类 名： OA_CorporateClients
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-2 14:27:43   N / A    初版
  *
  *
  *
  *
  *
  *
  */

using System;
using CY.Infrastructure.Domain;
using CY.Infrastructure.Common;

namespace CY.Model
{
    /// <summary>
    /// 印刷参数
    /// </summary>
    [Serializable]
    public partial class OA_Baozhengjincuishou : IAggregateRoot
    {
        #region Model
        /// <summary>
        /// Keyid
        /// </summary>
        public int Keyid { get; set; }
        /// <summary>
        ///  BaozhengjinId
        /// </summary>
        public int BaozhengjinId { get; set; }



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


        /// <summary>
        /// 催收情况
        /// </summary>
        public string Cuikuanqingkuang
        {
            get;
            set;
        }


        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CreateTime
        {
            get;
            set;
        }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? CuishouTime
        {
            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.ConvertToInt32(value).Value : Keyid;
                theValue = this.Keyid;
            }
            else if ("BaozhengjinId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.BaozhengjinId = isChange ? MyConvert.ConvertToInt32(value).Value : BaozhengjinId;
                theValue = this.BaozhengjinId;
            }




            else if ("Creater".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.Creater = isChange ? MyConvert.ConvertToString(value) : Creater;
                theValue = this.Creater;
            }
            else if ("CreateTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.CreateTime = isChange ? MyConvert.ConvertToDateTime(value) : CreateTime;
                theValue = this.CreateTime;
            }
            else if ("CuishouTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 5)
            {
                this.CuishouTime = isChange ? MyConvert.ConvertToDateTime(value) : CuishouTime;
                theValue = this.CuishouTime;
            }
            else if ("Cuikuanqingkuang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 6)
            {
                this.Cuikuanqingkuang = isChange ? MyConvert.ConvertToString(value) : Cuikuanqingkuang;
                theValue = this.Cuikuanqingkuang;
            }


            return theValue;
        }

        #endregion
    }
}

 CY_ECommercePlatform/CY.Model/OA/OA_Kaipiaonewcuishou.cs

@@ -99,7 +99,7 @@
                this.Keyid = isChange ? MyConvert.ConvertToInt32(value).Value : Keyid;
                theValue = this.Keyid;
            }
            else if ("FirmId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            else if ("KaipiaoId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 2)
            {
                this.KaipiaoId = isChange ? MyConvert.ConvertToGuid(value) : KaipiaoId;
                theValue = this.KaipiaoId;

 CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj

@@ -171,6 +171,8 @@
    <Compile Include="LF\LF_SellerFileSpaceDAL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderDAL.cs" />
    <Compile Include="OA\CoreCmsPlanOrderItemDAL.cs" />
    <Compile Include="OA\OA_BaozhengjincuishouDAL.cs" />
    <Compile Include="OA\OA_BaozhengjinDAL.cs" />
    <Compile Include="OA\OA_CarDictionaryDAL.cs" />
    <Compile Include="OA\OA_CarExaminedDAL.cs" />
    <Compile Include="OA\OA_CarInsuranceDAL.cs" />

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_BaozhengjinDAL.cs

New file
@@ -0,0 +1,285 @@
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_BaozhengjinDAL : IOA_BaozhengjinDAL
    {

        private Database _dataBase = null;
        #region 常量
        /// <summary>
        /// 查询目标 
        /// </summary>
        const string SELECTTARGET = " t.* ";
        /// <summary>
        /// 查询来源
        /// </summary>
        const string FROMSOUCEBEFORE = " ( select distinct ok.* " +
          //"     oe.Name as SupplierName   " +
          " from [OA_Baozhengjin] ok  " +


        "   where 0=0  ";
        const string FROMSOUCEEND = ") as t  ";
        /// <summary>
        /// 分页默认排序字段
        /// </summary>
        const string ORDERBY = " CreateTime desc  ";
        #endregion
        public OA_BaozhengjinDAL()
        {
            _dataBase = new Database();
        }


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


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

                 
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@FukuanTime",trueModel.FukuanTime),
                     new SqlParameter("@ReceiveWay",trueModel.ReceiveWay.HasValue?trueModel.ReceiveWay.Value:0),
                      new SqlParameter("@Zhanghuleixing",trueModel.Zhanghuleixing),
                      new SqlParameter("@Account",trueModel.Account.HasValue?trueModel.Account.Value:0),
                      new SqlParameter("@Fukuanzhanghu",trueModel.Fukuanzhanghu),
                      new SqlParameter("@Subject",trueModel.Subject.HasValue?trueModel.Subject.Value:0),
                      new SqlParameter("@Fukuankemu",trueModel.Fukuankemu),
                       new SqlParameter("@Fukuanmoney",trueModel.Fukuanmoney.HasValue?trueModel.Fukuanmoney.Value:0),
                        new SqlParameter("@Shoukuandanwei",trueModel.Shoukuandanwei),
                          new SqlParameter("@remark",string.IsNullOrEmpty(trueModel.remark)?"":trueModel.remark),
                          TuikuanTime,
                           new SqlParameter("@TuikuanStatus",trueModel.TuikuanStatus.HasValue?trueModel.TuikuanStatus.Value:0),

                            new SqlParameter("@Creater",trueModel.Creater),
                              new SqlParameter("@CreateTime",trueModel.CreateTime),

                                new SqlParameter("@Updater",trueModel.Updater),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                                   new SqlParameter("@MemberId",trueModel.MemberId.HasValue?trueModel.MemberId.Value:0 ),
                                    new SqlParameter("@MemberName",trueModel.MemberName),





            };
            string sql = "Insert Into OA_Baozhengjin ([FirmId],[FukuanTime],[ReceiveWay],[Zhanghuleixing], [Account], [Fukuanzhanghu],[Subject], [Fukuankemu],[Fukuanmoney], [Creater],[CreateTime],[Updater],[LastUpdateTime],[Shoukuandanwei],remark,TuikuanStatus,TuikuanTime,MemberId,MemberName)"
                                             + " Values (@FirmId,@FukuanTime,@ReceiveWay, @Zhanghuleixing, @Account, @Fukuanzhanghu, @Subject, @Fukuankemu, @Fukuanmoney, @Creater,@CreateTime,@Updater,@LastUpdateTime,@Shoukuandanwei,@remark,@TuikuanStatus,@TuikuanTime,@MemberId,@MemberName )";

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


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

                new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@FukuanTime",trueModel.FukuanTime),
                     new SqlParameter("@ReceiveWay",trueModel.ReceiveWay.HasValue?trueModel.ReceiveWay.Value:0),
                      new SqlParameter("@Zhanghuleixing",trueModel.Zhanghuleixing),
                      new SqlParameter("@Account",trueModel.Account.HasValue?trueModel.Account.Value:0),
                      new SqlParameter("@Fukuanzhanghu",trueModel.Fukuanzhanghu),
                      new SqlParameter("@Subject",trueModel.Subject.HasValue?trueModel.Subject.Value:0),
                      new SqlParameter("@Fukuankemu",trueModel.Fukuankemu),
                       new SqlParameter("@Fukuanmoney",trueModel.Fukuanmoney.HasValue?trueModel.Fukuanmoney.Value:0),
                        new SqlParameter("@Shoukuandanwei",trueModel.Shoukuandanwei),
                          new SqlParameter("@remark",string.IsNullOrEmpty(trueModel.remark)?"":trueModel.remark),
                          TuikuanTime,
                           new SqlParameter("@TuikuanStatus",trueModel.TuikuanStatus.HasValue?trueModel.TuikuanStatus.Value:0),

                            new SqlParameter("@Creater",trueModel.Creater),
                              new SqlParameter("@CreateTime",trueModel.CreateTime),

                                new SqlParameter("@Updater",trueModel.Updater),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                                     new SqlParameter("@MemberId",trueModel.MemberId.HasValue?trueModel.MemberId.Value:0 ),
                                      new SqlParameter("@MemberName",trueModel.MemberName),
            };
            string sql = "Update OA_Baozhengjin Set [FirmId]=@FirmId,[FukuanTime]=@FukuanTime,[ReceiveWay]=@ReceiveWay,[Zhanghuleixing]=@Zhanghuleixing, [Account]=@Account, [Fukuanzhanghu]=@Fukuanzhanghu,[Subject]=@Subject, [Fukuankemu]=@Fukuankemu,[Fukuanmoney]=@Fukuanmoney, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime,Shoukuandanwei=@Shoukuandanwei,remark=@remark,TuikuanTime=@TuikuanTime,TuikuanStatus=@TuikuanStatus,MemberId=@MemberId,MemberName=@MemberName  where [Keyid] =@Keyid ";

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

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_Baozhengjin GetModelByKeyid(int keyid)
        {
            try
            {
                string condition = "  ";
                if (keyid > 0)
                {
                    condition = " Keyid=" + keyid + "";
                }
                else
                {
                    return null;
                }

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

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

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


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

        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjin> GetModelByformid(Guid FirmId)
        {
            return _dataBase.SelectModel<Model.OA_Baozhengjin>(" * ", " OA_Baozhengjin ", " FirmId = '" + FirmId + "'") as IList<Model.OA_Baozhengjin>;//执行查询
        }


        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjin> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            if (null == pagination || null == query || null == query.Criteria || 1 > query.Criteria.Count)
                return null;
            //query.Criteria 首个元素必须是排序字段，其值为结果排序字段

            int maxParamIndex = query.Criteria.Count - 1;//最大索引

            string[] orderbys = new string[] { ORDERBY };
            string resultOrderBy = "";//结果集排序方式

            if ("@orderBy".Equals(query.Criteria[maxParamIndex].PropertyName))
            {
                orderbys = string.Format("{0}", query.Criteria[maxParamIndex].Value).Split(',');
                resultOrderBy = query.Criteria[maxParamIndex].Value.ToString();//= 1 == orderbys.Length ? resultOrderBy : orderbys[1];
            }
            string fromSouce = string.Format("{0}{1}{2}", FROMSOUCEBEFORE, query.Criteria[0].Value, FROMSOUCEEND);//拼装条件
            return _dataBase.SelectModelPage<Model.OA_Baozhengjin>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
        }

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


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

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_BaozhengjincuishouDAL.cs

New file
@@ -0,0 +1,234 @@
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_BaozhengjincuishouDAL : IOA_BaozhengjincuishouDAL
    {
        private Database _dataBase = null;
        #region 常量
        /// <summary>
        /// 查询目标 
        /// </summary>
        const string SELECTTARGET = " t.* ";
        /// <summary>
        /// 查询来源
        /// </summary>
        const string FROMSOUCEBEFORE = " ( select distinct ok.*,d_kaipiaoshenqing.Name as KaipiaoshenqingName,d_fapiaoqianshou.Name as KehuqianshouName, " +
             "     oe.CompanyName as BuyerName,eo.shuliang,eo.jine, os.Name as BusinessManager  " +
          " from [OA_Baozhengjincuishou] ok inner join  [OA_CorporateClients] oe  on oe.Keyid = ok.[BuyerId] " +

             " left join (select  count(*) as shuliang,sum(eo.[SumPrice]) as jine,eoe.KaipiaoshenqingId  from  [EC_OrderBasic] eo  ,[EC_OrderExtend] eoe  where eoe.Keyid=eo.Keyid group by eoe.KaipiaoshenqingId  )   eo on ok.Keyid =eo.KaipiaoshenqingId " +
        " left join [OA_Staff] os on ok.BusinessManagerId = os.Keyid " +

        " Left Join Sys_Dictionary as d_kaipiaoshenqing On(d_kaipiaoshenqing.DicType= 'EC_开票申请' and ok.[Kaipiaoshenqing]= d_kaipiaoshenqing.MeanValue)    " +
        " Left Join Sys_Dictionary as d_fapiaoqianshou On(d_fapiaoqianshou.DicType= 'EC_发票签收' and ok.[Kehuqianshou]= d_fapiaoqianshou.MeanValue)  where 0=0  ";
        const string FROMSOUCEEND = ") as t  ";
        /// <summary>
        /// 分页默认排序字段
        /// </summary>
        const string ORDERBY = " SellerOrderId desc  ";
        #endregion

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

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


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


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

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

   new SqlParameter("@CuishouTime",trueModel.CuishouTime),
                                    new SqlParameter("@Creater",trueModel.Creater),
 new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang),

            };
            string sql = "Insert Into OA_Baozhengjincuishou ( [BaozhengjinId] , [Creater],[CreateTime],[CuishouTime],[Cuikuanqingkuang] )"
                                             + " Values (  @BaozhengjinId,  @Creater,@CreateTime,@CuishouTime,@Cuikuanqingkuang  )";
            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_Baozhengjincuishou trueModel = model as Model.OA_Baozhengjincuishou;
            if (trueModel == null)
            {
                return false;
            }


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

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


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

   new SqlParameter("@CuishouTime",trueModel.CuishouTime),
                                    new SqlParameter("@Creater",trueModel.Creater),
                                     new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang),
            };
            string sql = "Update OA_Baozhengjincuishou Set   [Creater]=@Creater,[CreateTime]=@CreateTime,[CuishouTime]=@CuishouTime,[Cuikuanqingkuang]=@Cuikuanqingkuang  where [Keyid] =@Keyid ";

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

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_Baozhengjincuishou GetModelByKeyid(int keyid)
        {
            try
            {
                string condition = "  ";
                if (keyid > 0)
                {
                    condition = " Keyid=" + keyid + "";
                }
                else
                {
                    return null;
                }

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

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

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


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

        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjincuishou> GetModelByKaipiaoId(int BaozhengjinId)
        {
            return _dataBase.SelectModel<Model.OA_Baozhengjincuishou>(" * ", " OA_Baozhengjincuishou ", " BaozhengjinId = '" + BaozhengjinId + "' order by CreateTime desc ") as IList<Model.OA_Baozhengjincuishou>;//执行查询
        }


        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjincuishou> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            if (null == pagination || null == query || null == query.Criteria || 1 > query.Criteria.Count)
                return null;
            //query.Criteria 首个元素必须是排序字段，其值为结果排序字段

            int maxParamIndex = query.Criteria.Count - 1;//最大索引

            string[] orderbys = new string[] { ORDERBY };
            string resultOrderBy = "";//结果集排序方式

            if ("@orderBy".Equals(query.Criteria[maxParamIndex].PropertyName))
            {
                orderbys = string.Format("{0}", query.Criteria[maxParamIndex].Value).Split(',');
                resultOrderBy = query.Criteria[maxParamIndex].Value.ToString();//= 1 == orderbys.Length ? resultOrderBy : orderbys[1];
            }
            string fromSouce = string.Format("{0}{1}{2}", FROMSOUCEBEFORE, query.Criteria[0].Value, FROMSOUCEEND);//拼装条件
            return _dataBase.SelectModelPage<Model.OA_Baozhengjincuishou>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
        }

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


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

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs

@@ -91,11 +91,21 @@
            {
                return false;
            }

            SqlParameter SuppliersId = null;
            if (trueModel.SuppliersId.HasValue)
            {
                SuppliersId = new SqlParameter("@SuppliersId", trueModel.SuppliersId);
            }
            else
            {
                SuppliersId = new SqlParameter("@SuppliersId", DBNull.Value);
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            { 
                    new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@SuppliersId",trueModel.SuppliersId),
                    SuppliersId,
                    new SqlParameter("@GoodsId",trueModel.GoodsId),
                    new SqlParameter("@ClearingStatusId",trueModel.ClearingStatusId),
                    new SqlParameter("@Price",trueModel.Price),

 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -1884,6 +1884,8 @@
    <Content Include="Pages\business\BargainPrice.aspx" />
    <Content Include="Pages\business\BargainPriceByFirm.aspx" />
    <Content Include="Pages\business\Caigoufukuanshenqing.aspx" />
    <Content Include="Pages\business\Baozhengjinfukuan.aspx" />
    <Content Include="Pages\business\BaozhengjinCuishou.aspx" />
    <Content Include="Pages\business\WaixieOrderPrint.aspx" />
    <Content Include="Pages\business\Waixiefukuanweikaipiao.aspx" />
    <Content Include="Pages\business\Waixiefukuanfukuan.aspx" />
@@ -2044,6 +2046,7 @@
    <Content Include="Pages\common\U_Login.ascx" />
    <Content Include="Pages\financial\DepositsCustomershouruqueren.aspx" />
    <Content Include="Pages\financial\DepositsCustomerFapiao.aspx" />
    <Content Include="Pages\financial\BaozhengjinIncome.aspx" />
    <Content Include="Pages\financial\NewWaixieExpenses.aspx" />
    <Content Include="Pages\financial\OutsourcePiliangPayMoney.aspx" />
    <Content Include="Pages\financial\CaigouPayEdit.aspx" />
@@ -3313,6 +3316,20 @@
    <Compile Include="Pages\business\Caigoufukuanshenqing.aspx.designer.cs">
      <DependentUpon>Caigoufukuanshenqing.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\Baozhengjinfukuan.aspx.cs">
      <DependentUpon>Baozhengjinfukuan.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\Baozhengjinfukuan.aspx.designer.cs">
      <DependentUpon>Baozhengjinfukuan.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\BaozhengjinCuishou.aspx.cs">
      <DependentUpon>BaozhengjinCuishou.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\BaozhengjinCuishou.aspx.designer.cs">
      <DependentUpon>BaozhengjinCuishou.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\WaixieOrderPrint.aspx.cs">
      <DependentUpon>WaixieOrderPrint.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
@@ -4433,6 +4450,13 @@
    <Compile Include="Pages\financial\DepositsCustomerFapiao.aspx.designer.cs">
      <DependentUpon>DepositsCustomerFapiao.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\financial\BaozhengjinIncome.aspx.cs">
      <DependentUpon>BaozhengjinIncome.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\financial\BaozhengjinIncome.aspx.designer.cs">
      <DependentUpon>BaozhengjinIncome.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\financial\NewWaixieExpenses.aspx.cs">
      <DependentUpon>NewWaixieExpenses.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

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

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

<!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" />
    <link href="../../Styles/ParticularWQJ.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
       
    </script>
</head>
<body style='margin: 0; padding: 0;'>
    <form id="form1" runat="server" onsubmit="if(false)return false;">
    
        <table class="table2" width="100%">
    
      
    
    <tr>
        <td   class='col_third' '>
            付款单位： 
            <label runat="server" id="txtBuyerName"></label>
           
        </td>
    </tr>
              
             <tr>
    
                   <td  class='col_third'  >
           金额： 
            <label runat="server" id="txtjine"></label>
           
        </td>
    </tr>
            <tr >
                    <td  class="contentLeft" colspan='2' >催款时间： <input type="text" id="txtStartTime" runat="server" class="date w150px" datefmt="yyyy-MM-dd HH:mm"  /></td>
                    
                </tr>
             <tr >
                  <td   class="contentLeft" colspan='2'> 催款情况： </td>
                    
                </tr>
             <tr >
                 
                    <td  class="contentLeft" colspan='2'  >  <textarea id="txtCuikuanqingkuang" runat="server" maxlength="250"  style=" width:570px; height:120px;"></textarea></td>
                    
                </tr>


     <tr>
        <td class="contentLeft" colspan='2'>
            &#12288;&#12288;&#12288;&#12288;&#12288;<input type="button" value="确认" runat="server"  id='btnSubmit' />
            <input type="hidden"  id="ids" runat="server"  />
        </td>
    </tr>
    </table>

             <table class="tableStyle tableStyleXS" useclick="false" usecheckbox="true" sortmode="false" id="test_table">
                <thead>
                    <tr>
                        <th width="25">
                            编号
                        </th>
                          <th style="text-align: center;" width="70">
                           催款时间
                        </th>
                         <th style="text-align: center;" width="200">
                           催收情况
                        </th>
                           <th style="text-align: center;" width="70">
                           催款人
                        </th>
                        
                        
                       
                      
                    </tr>
                </thead>
                <tbody>
                    <asp:repeater id="rptData" runat="server">
                        <itemtemplate>
                            <tr>
                                 
                               <td>
                                    <%#Container.ItemIndex +1 /*(UCPager1.PageSize *( UCPager1.PageIndex-1)+1)*/%>
                                </td>
                                <td>
                                   <%#Eval("CreateTime", "{0:MM-dd HH:mm}")%>
                                     
                                </td>
                                 <td style="text-align: center;">
                                        <%#Eval("Cuikuanqingkuang")%>

                                   
                                </td>
                                 <td style="text-align: center;">
                                        <%#Eval("Creater")%>

                                   
                                </td>
                                
                                 
                                 
                            </tr>
                        </itemtemplate>
                    </asp:repeater>
                </tbody>
            </table>
    </form>
</body>
</html>

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

New file
@@ -0,0 +1,170 @@
/**  
* OrderMoneyReceive.aspx.cs
*
* 功 能： 订单收款
* 类 名： OrderMoneyReceive
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-5-28 13:44      吴崎均    初版
* 
*/
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.Infrastructure.Common;
using CY.Model;
using CY.BLL.OA;
using CY.BLL.Sys;
using System.Text;
using CY.BLL;
using System.Transactions;
namespace CY.WebForm.Pages.business
{
    public partial class BaozhengjinCuishou : BasePage
    {
        private EC_OrderBLL _eC_OrderBLL = null;

        private OA_CorporateClientsBLL bll_OA_CorporateClientsBLL = null;
        private EC_OrderBasicBLL _eC_OrderBasicBLL = null; 


        private OA_StaffBLL _StaffBLL = null;
        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        OA_BaozhengjincuishouBLL oA_BaozhengjincuishouBLL = null;

        /// <summary>
        /// 初始化构造 
        /// </summary>
        public BaozhengjinCuishou()
        {
            bll_OA_CorporateClientsBLL = new OA_CorporateClientsBLL();
            _StaffBLL = new OA_StaffBLL();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
            oA_BaozhengjincuishouBLL = new OA_BaozhengjincuishouBLL();
        }
        /// <summary>
        /// 界面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            _eC_OrderBLL = new EC_OrderBLL();
            btnSubmit.ServerClick += new EventHandler(btnSubmit_ServerClick);

           
            if (IsPostBack || IsCallback)
                return;

            if (!IsPostBack && !IsCallback)
            {
                LoadOrder();
            }
        }

        /// <summary>
        /// 提交按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSubmit_ServerClick(object sender, EventArgs e)
        {
            string orderIds = Request["ids"];
            if (string.IsNullOrEmpty(this.txtStartTime.Value.Trim()))
            {
                JavaScript.MessageBox("请选择催款时间！", this);
                return;
            }

            bool isWin = false;
 




            

        

            


            var oA_Kaipiaonewcuishou = new OA_Baozhengjincuishou();
            oA_Kaipiaonewcuishou.BaozhengjinId = orderIds.ToInt32().Value;
            oA_Kaipiaonewcuishou.Creater = CurrentUser.ShortName;
            oA_Kaipiaonewcuishou.CreateTime = DateTime.Now;
            oA_Kaipiaonewcuishou.CuishouTime = this.txtStartTime.Value.ToDateTime2();
            oA_Kaipiaonewcuishou.Cuikuanqingkuang = this.txtCuikuanqingkuang.Value;
            isWin = oA_BaozhengjincuishouBLL.InsertModel(oA_Kaipiaonewcuishou);

            if (isWin)
            {
                JavaScript.MessageBox("操作成功", this, true, true);
            }
            else
            {
                JavaScript.MessageBox("操作失败", this);
            }
            //JavaScript.MessageBox(isWin ? "收款成功！" : "收款失败！", this, "top.frmright.ReLoad();top.Dialog.close();");
            // Request.RequestContext.RouteData.DataTokens.Add("IsWin", isWin ? "1" : "");



        }
 

        /// <summary>
        /// 加载订单
        /// </summary>
        private void LoadOrder()
        {
            try
            {
                string orderIds = Request["id"];
            if (string.IsNullOrEmpty(orderIds))
            {
                JavaScript.MessageBox("订单不存在！", this);
                return;
            }

            this.ids.Value = orderIds;
            OA_Baozhengjin oA_Kaipiaoshenqing = oA_BaozhengjinBLL.GetModelByKeyid(orderIds.ToInt32().Value);
            

            this.txtBuyerName.InnerText = oA_Kaipiaoshenqing.Shoukuandanwei;
           
           

                this.txtStartTime.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm");






                this.txtjine.InnerText = String.Format("{0:F}", oA_Kaipiaoshenqing.Fukuanmoney);
               var result = oA_BaozhengjincuishouBLL.GetModelByKaipiaoId(orderIds.ToInt32().Value);
                rptData.DataSource = result;
                rptData.DataBind();


            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("订单不存在！", this);
            }


        }
        
 

    }
}

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

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

namespace CY.WebForm.Pages.business
{


    public partial class BaozhengjinCuishou
    {

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

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

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

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

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

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

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

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

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


<!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 src="../../js/business/Order.js" type="text/javascript"></script>
    <script type="text/javascript">

        /*
  确认批量开票申请
  */
        //function ToBatchPayList() {

        //    var ids = '';
        //    var cks = $("input[name='ckId']:checked");
        //    if (cks.length == 0) { alertMsg('没有选中任何项！'); return; } else { }
        //    var isCan = true;
        //    var BuyerId = '';
        //    var SellerOrderIds = '';
        //    var bbbb = true;
        //    var cccc = true;
        //    cks.each(
        //        function () {
                   
        //            var ckVal = $(this).val();

        //            var ckValJson = eval('(' + ckVal + ')');
                   
        //            PayState = ckValJson.PayState;
        //            //剔除已经开票申请的单据
        //            if (BuyerId != '' && ckValJson.buyerId != BuyerId) {
        //                bbbb = false;

        //            } else {
        //                BuyerId = ckValJson.buyerId;
        //            }  
        //            if (ckValJson.Kaipiaoshenqing != 1) {
        //                cccc = false;
        //            }

        //            ids = ids + ',' + ckValJson.id;

                   
                    
        //        }
        //    );
 
        //    if (!bbbb) {
        //        alertMsg('必须是同一家客户！');
        //        return;
        //    }
        //    if (!cccc) {
        //        alertMsg('有状态不是开票已申请的订单！');
        //        return;
        //    }

        //    if (!isCan) {
        //        // alertMsg('请选择未受理的订单！');
        //    }
        //    else {
        //        if (ids != '') {
        //            ids = ids.substring(1);
        //            SellerOrderIds = SellerOrderIds.substring(1);

        //        } else {
        //            alertMsg('没有选中未支付订单！');
        //            return;
        //        }

        //        top.Dialog.open({ URL: '/Pages/business/BaozhengjinfukuanEdit.aspx?id=' + ids, Title: '批量确认发票', Height: 400, Width: 600 });
        //    }
        //}
        //查看客户资料
        function Viewkehuqianshou(Keyid, SellerOrderId) {
            top.Dialog.open({ URL: "/Pages/business/OrderKehuqianshou.aspx?id=" + Keyid + "&SellerOrderId=" + SellerOrderId, Title: "客户签收", Width: 400, Height: 600 });
        }


        //查看客户资料
        function Viewkehu(personId) {
            top.Dialog.open({ URL: "/Pages/business/BaozhengjinfukuanEdit.aspx?id=" + personId, Title: "确认发票", Width: 400, Height: 600 });
        }

        //催收
        function ViewCuishou(personId) {
            top.Dialog.open({ URL: "/Pages/business/BaozhengjinCuishou.aspx?id=" + personId, Title: "催款", Width: 600, Height: 800 });
        }
        //外协付款
        function ViewShoukuan(personId, yongtu, supplierId) {
           
                top.Dialog.open({ URL: "/Pages/financial/BaozhengjinIncome.aspx?id=" + personId, Title: "保证金收款", Width: 600, Height: 500 });
           
         
           
           
        }
        //收入确认
        function ViewShouru(personId, shenqingleixing) {
            if (shenqingleixing == "订单开票") {
                top.Dialog.open({ URL: "/Pages/financial/InvoicingShouruqueren.aspx?id=" + personId, Title: "订单确认收入", Width: 600, Height: 800 });
            } else {
                top.Dialog.open({ URL: "/Pages/financial/DepositsCustomershouruqueren.aspx?Keyid=" + personId, Title: "客户预付款确认收入", Width: 900, Height: 680 });
            }

        }
        
        
        //回款
        function ViewFukuan(personId) {
            top.Dialog.open({ URL: "/Pages/business/InvoicingHuikuan.aspx?id=" + personId, Title: "付款登记", Width: 400, Height: 600 });
        }

        
        //查看客户资料
        function Viewkaipiao(Keyid, SellerOrderId, yongtu, supplierId) {
            
            if (yongtu == "外协加工费") {
                if (supplierId.length > 10) {
                    top.Dialog.open({ URL: "/Pages/business/WaixieOrderPrint.aspx?Keyid=&SellerOrderId=" + SellerOrderId, Title: "查看外协订单", Width: 1080, Height: 650 });
                } else {
                    top.Dialog.open({ URL: "/Pages/business/InvoicingOrderPrint.aspx?Keyid=&SellerOrderId=" + SellerOrderId, Title: "查看订单", Width: 1080, Height: 650 });
                }

            } else if (yongtu == "采购付款"){
                top.Dialog.open({ URL: "/Pages/procurement/ProcurementListHTML.aspx?Keyid=" + SellerOrderId, Title: "查看采购订单", Width: 1080, Height: 650 });
            }
           
        }
        //查看
        function onView(keyid, yongtu) {
            if (yongtu != "其他付款" && yongtu != "外协加工费") {
                top.Dialog.open({ URL: "/Pages/procurement/SuppliersDetail.aspx?Keyid=" + keyid, Title: "查看供应商", Width: 950, Height: 650 });
            }
          
        }

 
    </script>
    <style type="text/css">
        .tableStyleXS th { padding: 1px 0 1px 3px; background-image:none; border-bottom:1px solid #CCC; }
        .tableStyleXS td { padding: 1px 0 1px 3px; }
        .TableNewStyle select { width: 80px; }
        .td_hide span { text-decoration: default; display: none; text-align: center; }
        span.hand_no { cursor: default; display: block; font-size: 12px; }
        span.hand_no:hover { text-decoration: none; }
        span.hand_yes { cursor: pointer; display: block; font-size: 12px; }
        .td_hide { cursor: pointer; }
        .auto-style1 {
            width: 39px;
        }
        .auto-style3 {
            width: 13px;
        }
        .auto-style4 {
            width: 55px;
        }
        .auto-style5 {
            width: 26px;
        }
        .auto-style6 {
            cursor: pointer;
            width: 26px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent" style="width: auto;">
        <div class="box1">
            <table class="TableNewStyle" style="width: 100%;">
                 <tr>
                    <td class="ali03">
                        操作时间：
                    </td>
                    <td style="width: 215px">
                        <input id="txtSQBeginDate" type="text" runat="server" class='date w80px' maxlength='10' />-<input id="txtSQEndDate" type="text" runat="server" class='date w80px' maxlength='10' />
                    </td>
                    <td class="ali03">
                        账户类型：
                    </td>
                    <td>

                        <asp:DropDownList runat="server" ID="dwAcoountType" AutoPostBack="true" keepDefaultStyle="true" OnSelectedIndexChanged="dwAcoountType_SelectedIndexChanged">
                        </asp:DropDownList>

                    </td>
                      <td class="ali03">
                       账户名称：
                    </td>
                    <td>
                       
                           <select id="selAccountName" runat="server" datatextfield="AccountName" datavaluefield="Keyid" keepdefaultstyle='true' class="Sreq w122px">
                        </select>
                    </td>
                       <td class="ali03">
                       收款单位：
                    </td>
                    <td>
                        <input id='Shoukuandanwei' runat="server" maxlength='50' />
                    </td>
                       <td class="ali03">
                       摘要：
                    </td>
                    <td>
                        <input id='remark' runat="server" maxlength='50' />
                    </td>


                    <td class="ali03">
                       是否退款：
                    </td>
                    <td>
                         <select keepdefaultstyle='true' id='TuikuanStatus' runat="server" >
                           <option value="">全部</option>
                            <option value="2">已退款</option>
                            <option value="1">未退款</option>
                        </select>
                    </td>
                   

                    
                 
                     
                     
                    <td  >
                        <asp:button id="btn_Search" text="查询" runat="server" />&nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />
                       
                    </td>
                </tr>
            </table>
        </div>
   <%--    <div class="box_tool_min">
            <div class="center" style=" margin-left:0px;">
                <div class="left">
                    <div class="right">
                        <div class="padding_top5 padding_left10">
                           
                            
                           
                           
                            <a href="javascript:;"   onclick="ToBatchPayList();"><span class="icon_edit">确认开票</span></a>
                            <div class="box_tool_line">
                            </div>
                            
                        </div>
                    </div>
                </div>
            </div>
            <div class="clear">
            </div>
        </div>--%>
        <div clear="fl" dir="ltr">
            <table class="tableStyle tableStyleXS" useclick="false" usecheckbox="true" sortmode="false" id="test_table">
                <thead>
                    <tr>
                        <th width="25">
                            编号
                        </th>
                          <th style="text-align: center;" width="70">
                           付款时间
                        </th>
                         <th style="text-align: center;" width="70">
                           账户类型
                        </th>
                        <th style="text-align: center;"width="150">
                            付款账户
                        </th>
                         <th style="text-align: center;" width="70">
                           金额
                        </th>
                         <th style="text-align: center;" width="150">
                           收款单位
                        </th>
                         <th style="text-align: center;" width="150">
                           摘要
                        </th>
                         <th style="text-align: center;" width="70">
                           退款时间
                        </th>
                         <th style="text-align: center;" width="70">
                           退款状态
                        </th>
                        
                          <th style="text-align: center;" width="70">
                           申请人
                        </th>
                        
                          <th width="70">
                            催款记录
                        </th>
                        
                         
                         <th width="70">
                          操作

                        </th>
                       
                      
                    </tr>
                </thead>
                <tbody>
                    <asp:repeater id="rptData" runat="server">
                        <itemtemplate>
                            <tr>
                                 
                               <td>
                                    <%#Container.ItemIndex +1 /*(UCPager1.PageSize *( UCPager1.PageIndex-1)+1)*/%>
                                </td>
                                <td>
                                   <%#Eval("FukuanTime", "{0:yyyy-MM-dd}")%>
                                     
                                </td>
                                  <td style="text-align: center;">
                                        <%#Eval("Zhanghuleixing")%>

                                   
                                </td>
                                 <td style="text-align: center;">
                                     
                                   <%#Eval("Fukuanzhanghu")%>
                                </td>
                                 <td style="text-align: center;">
                                     <%#Eval("Fukuanmoney", "{0:F}")%>    
                                   
                                </td>
                                 <td style="text-align: center;">
                                        <%#Eval("Shoukuandanwei")%>

                                   
                                </td>
                                 <td style="text-align: center;">
                                        <%#Eval("remark")%>

                                   
                                </td>
                                <td style="text-align: center;">
                                        <%#Eval("TuikuanTime", "{0:yyyy-MM-dd}")%>

                                   
                                </td>
                                 <td>
                                     <%#Eval("TuikuanName")%>
                                </td>
                                 <td>
                                     <%#Eval("MemberName")%>
                                </td>
                                
                                 
                                
                               <td>
                                                            
                             
                                <a href='javascript:void(0)' menu_member_case_id="case_cuikuan" menu_member_case_name="催款" title='催款' class='a_under' onclick='ViewCuishou("<%#Eval("Keyid")%>")'> 查看    </a>  
                                     </td>
                                 <td>
                                      
                                         
                                     <a href='javascript:void(0)' menu_member_case_id="case_shoukuan" menu_member_case_name="收款" title='收款' class='a_under' onclick='ViewShoukuan("<%#Eval("Keyid")%>")'> 收款    </a> 
                                     
                                </td>
                                
                            </tr>
                        </itemtemplate>
                    </asp:repeater>
                </tbody>
                  <tr>
                        <td colspan="4">
                           合计
                        </td>
                           
                        
                         <td >
                            <span id="heji" runat="server" ></span>
                        </td>
                     
                        <td colspan="6">
                           
                        </td>
                        
                       
                      
                    </tr>
            </table>
            <uc:ucpager id="UCPager1" runat="server" />
        </div>
    </div>
    </form>
</body>
  <script type="text/javascript" language="javascript">
     

  </script>
</html>

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

New file
@@ -0,0 +1,815 @@
/**  
* OrderList.aspx.cs
*
* 功 能： 订单列表
* 类 名： OrderList
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-5-6 9:16        吴崎均    初版
* V0.02  2013-5-6 18:02       吴崎均    完成分页查询  
* V0.03  2013-5-7 17:28       吴崎均    增加订单状态设置(置为：生产、完成)并加上以限制(如:线上订单不可置为完成)、
*                                       增加批量删除并予以限制(只能删除未受理的厂商新增订单)、
*                                       增加受理操作并加以限制(只有未受理的订单才能受理)
*
*
*
*
*/
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.BLL.Sys;
using CY.Infrastructure.Common;
using CY.BLL;
using CY.WebForm.Pages.common;
using System.Transactions;
using CY.BLL.OA;

namespace CY.WebForm.Pages.business
{
    public partial class Baozhengjinfukuan : BasePage
    {
        EC_OrderBasicBLL _eC_OrderBasicBLL = null;
        OA_StaffBLL bll_OA_StaffBLL = null;
        LF_OrderFileBLL _lF_OrderFileBLL = null;
        EC_OrderBLL _eC_OrderBLL = null;
        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        Sys_DictionaryBLL _Sys_DictionaryBLL = null;
        OA_FirmAccountBLL _OA_FirmAccountBLL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public Baozhengjinfukuan()
        {
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            bll_OA_StaffBLL = new OA_StaffBLL();
            _lF_OrderFileBLL = new LF_OrderFileBLL();
            _eC_OrderBLL = new EC_OrderBLL();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
            _Sys_DictionaryBLL = new Sys_DictionaryBLL();
            _OA_FirmAccountBLL = new OA_FirmAccountBLL();
        }

        /// <summary>
        /// 加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (Request["downId"] != null)
                {
                    int iDownId = Convert.ToInt32(Request["downId"]);
                    LF_OrderFile model = _lF_OrderFileBLL.GetModel(iDownId);
                    model.FileState = 1;
                    _lF_OrderFileBLL.UpdateModel(model);
                    string fileName = "";//客户端保存的文件名
                    string filePath = "";//路径
                    if (model != null)
                    {
                        fileName = model.FileName;//客户端保存的文件名
                        filePath = model.FilePath;//路径
                    }
                    else
                    {
                        JavaScript.MessageBox("文件不存在", this);
                        return;
                    }
                    System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath);
                    if (fileInfo.Exists == true)
                    {
                        const long ChunkSize = 102400;//100K 每次读取文件，只读取100K，这样可以缓解服务器的压力
                        byte[] buffer = new byte[ChunkSize];
                        Response.Clear();
                        System.IO.FileStream iStream = System.IO.File.OpenRead(filePath);
                        long dataLengthToRead = iStream.Length;//获取下载的文件总大小
                        Response.ContentType = "application/octet-stream";
                        Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName));
                        while (dataLengthToRead > 0 && Response.IsClientConnected)
                        {
                            int lengthRead = iStream.Read(buffer, 0, Convert.ToInt32(ChunkSize));//读取的大小
                            Response.OutputStream.Write(buffer, 0, lengthRead);
                            Response.Flush();
                            dataLengthToRead = dataLengthToRead - lengthRead;
                        }
                        Response.Close();
                    }
                    Response.Redirect("/Pages/business/OrderListBatchOperation.aspx");
                    return;
                }
                switch (Request["Target"])
                {
                    case "deleteOrderAll2":
                        AcceptAll2();
                        break;
                    case "deleteOrderAll3":
                        AcceptAll3();
                        break;
                    case "AcceptOrder":
                        Accept();
                        break;
                    case "AcceptOrderAll":
                        AcceptAll();
                        break;
                    case "ChangeState":
                        //ChangeOrderState();
                        break;
                    case "BatchDelete":
                        CY.WebForm.cs.WebUtil.DeleteData(_eC_OrderBasicBLL.DeleteDataByIds, CurrentUser.ShortName);//调用通用删除方法
                        break;
                    case "BatchToOver":
                        UpdataState(-1);//设置状态为完成(不能是1'未受理'或2'已受理')
                        break;
                    case "BatchToProduction":
                        //UpdataState(3);//设置状态为生产中(不能是1'未受理'或2'已受理')
                        break;
                    case "BatchToSend":
                        UpdataState(4);//设置状态为已完工 (不能是1'未受理'或2'已受理')
                        break;
                    case "ToAccountDelay":
                        Delay(1);//请求打款延期
                        break;
                    case "DeliveryDelay":
                        Delay(2);//请求交货延期
                        break;
                    case "OrderRepeal":
                        Delay(3);//请求撤单
                        break;
                    case "ReplyRequest"://答复订单请求
                        RequestReply();
                        break;
                    case "RetireOrderBySeller": //卖家直接撤单，或者
                        RetireOrderBySeller();
                        break;
                    case "CanPrintAwb":
                        CanPrintAwb();
                        break;
                    default:
                        Page_Load_Default();
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                //Response.Write("参数错误");
                Response.Write(ex.Message);
            }
            Response.End();
        }

        /// <summary>
        /// 判断是否可以批量打印送货单
        /// </summary>
        public void CanPrintAwb()
        {
            EC_AcceptWayByOrderBLL _AcceptWayByOrderBLL = new EC_AcceptWayByOrderBLL();
            string orderIds = Request["orderIds"].ToString();
            string[] orderIdArry = orderIds.Split(',');
            bool IsFirst = true;
            string firstAccepterAddress = string.Empty;
            string result = string.Empty;
            string jsonStr = "IsCan:'true'";
            string msg = "只有送货上门且送货地址相同的订单才能打印送货单";
            foreach (string orderIdStr in orderIdArry)
            {
                int orderId = orderIdStr.ToInt32().Value;
                EC_AcceptWayByOrder model = _AcceptWayByOrderBLL.GetModelByTargetId(orderId);
                if (model == null)
                    continue;
                if (IsFirst)
                {
                    firstAccepterAddress = model.AccepterAddress.Trim();
                }
                if (model.AcceptTypeId.Value != 106)
                {
                    jsonStr = "IsCan:'false',Msg:'" + msg + "'";
                    break;
                }
                if (model.AccepterAddress.Trim() != firstAccepterAddress)
                {
                    jsonStr = "IsCan:'false',Msg:'" + msg + "'";
                    break;
                }
                IsFirst = false;
            }
            result = "{" + jsonStr + "}";
            Response.Write(result);
        }

        /// <summary>
        /// 更新状态
        /// </summary>
        private void UpdataState(int stateId)
        {
            Response.Clear();
            if (1 == stateId || 2 == stateId)
            {
                HttpContext.Current.Response.Write(-2);
                return;
            }
            string paramValue = HttpContext.Current.Request["ids"];
            //string stateStr=HttpContext.Current.Request["state"];
            string remark = string.Format("{0}", Request["remark"]);
            int? tempId;
            //tempId = string.IsNullOrEmpty(stateStr)?null:MyConvert.ConvertToInt32(stateStr);
            if (string.IsNullOrEmpty(paramValue)/*||!tempId.HasValue*/)
            {
                HttpContext.Current.Response.Write(-2);
                return;
            }
            else
            {
            }

            //int stateId=tempId.Value;
            string[] splitResult = paramValue.Split(',');
            int i = -1;

            List<EC_OrderOperate> oprates = new List<EC_OrderOperate>();
            while (++i < splitResult.Length)
            {
                tempId = MyConvert.ConvertToInt32(splitResult[i]);
                if (!tempId.HasValue)
                {
                    HttpContext.Current.Response.Write(-2);
                    return;
                }
                else
                {
                }
                oprates.Add(new EC_OrderOperate()
                {
                    OperateType = stateId,
                    OrderId = tempId.Value,
                    Operator = CurrentUser.ShortName,
                    Remark = remark
                });
            }
            HttpContext.Current.Response.Write((_eC_OrderBasicBLL.UpdateOrderState(oprates.ToArray()) ? 1 : 0));
        }

        /// <summary>
        /// 受理订单(全部订单受理)
        /// </summary>
        private void Accept()
        {
            Response.Clear();
            PayAbout payAbout = new PayAbout();
            payAbout.LoadNewestPaymentAccount(true);
            double? commission = MyConvert.ConvertToDouble(CY.Config.WebInfo.Instance.FirmOrderAgencyFee);
            int? orderId = string.IsNullOrEmpty(Request["id"]) ? null : MyConvert.ConvertToInt32(Request["id"]);
            if (!orderId.HasValue || !commission.HasValue)
            {
                Response.Write("-2");
                return;
            }
            else
            {
            }
            Response.Write(_eC_OrderBasicBLL.AcceptOrder(orderId.Value, commission.Value) ? "1" : "0");
        }

        /// <summary>
        /// 批量受理订单
        /// </summary>
        public void AcceptAll()
        {
            Response.Clear();
            PayAbout payAbout = new PayAbout();
            payAbout.LoadNewestPaymentAccount(true);
            double? commission = MyConvert.ConvertToDouble(CY.Config.WebInfo.Instance.FirmOrderAgencyFee);
            string orderIds = string.Empty;
            ;
            if (Request["ids"] != null)
            {
                orderIds = Request["ids"].ToString();
            }
            if (string.IsNullOrEmpty(orderIds) || !commission.HasValue)
            {
                Response.Write("-2");
                return;
            }
            else
            {
            }
            Response.Write(_eC_OrderBasicBLL.AcceptOrderAll(orderIds, commission.Value) ? "1" : "0");
        }

        /// <summary>
        /// 改变订单状态(暂时不启用)
        /// </summary>
        private void ChangeOrderState()
        {
            Response.Clear();
            string idsStr = Request["ids"];
            string stateIdStr = Request["stateId"];
            string remark = string.Format("{0}", Request["remark"]);
            int? stateId = string.IsNullOrEmpty(stateIdStr) ? null : MyConvert.ConvertToInt32(stateIdStr);
            if (string.IsNullOrEmpty(idsStr) || !stateId.HasValue)
            {
                Response.Write("-2");
                return;
            }
            else
            {
            }
            string[] ids = idsStr.Split(',');

            int i = -1;
            int? tempId = null;
            List<EC_OrderOperate> operaters = new List<EC_OrderOperate>();
            while (++i < ids.Length)
            {
                tempId = string.IsNullOrEmpty(ids[i]) ? null : MyConvert.ConvertToInt32(ids[i]);
                if (!tempId.HasValue)
                {
                    operaters = null;
                    break;
                }
                else
                {
                }
                operaters.Add(new EC_OrderOperate()
                {
                    OrderId = tempId.Value,
                    Operator = CurrentUser.ShortName,
                    OperateType = stateId.Value,
                    Remark = remark
                });
            }
            if (null == operaters)
            {
                Response.Write("-2");
                return;
            }
            else
            {
            }
            Response.Write(_eC_OrderBasicBLL.UpdateOrderState(operaters.ToArray()) ? "1" : "0");
        }

        /// <summary>
        /// 卖家退单
        /// </summary>
        public void RetireOrderBySeller()
        {
            string orderidStr = Request["orderid"];
            string tovalueStr = Request["tovalue"];

            int orderId = orderidStr.ToInt32().Value;
            decimal retireMony = tovalueStr.ToDecimal2().Value;
            string operatorName = CurrentUser.ShortName;
            Response.Write(_eC_OrderBasicBLL.RetireOrderBySeller(orderId, retireMony, operatorName));
        }

        /// <summary>
        /// 请求延期
        /// </summary>
        /// <param name="typeId">请求类型</param>
        private void Delay(int typeId)
        {
            Response.Clear();
            string receiverStr = Request["receiver"];
            string orderidStr = Request["orderid"];
            string tovalueStr = Request["tovalue"];
            if (string.IsNullOrEmpty(receiverStr) || string.IsNullOrEmpty(orderidStr) || string.IsNullOrEmpty(tovalueStr))
            {
                Response.Write(0);
                return;
            }
            else
            {
            }

            int? orderid = MyConvert.ConvertToInt32(orderidStr);
            int? tovalue = MyConvert.ConvertToInt32(tovalueStr);
            Guid receiver = MyConvert.ConvertToGuid(receiverStr);
            if (Guid.Empty == receiver || !orderid.HasValue || !tovalue.HasValue)
            {
                Response.Write(0);
                return;
            }
            else
            {
            }
            EC_OrderDialogue _eC_OrderDialogue = new EC_OrderDialogue();
            _eC_OrderDialogue.ReceiverId = receiver;
            _eC_OrderDialogue.TargetOrder = orderid;
            _eC_OrderDialogue.TargetValue = tovalue;
            _eC_OrderDialogue.DialogueTypeId = typeId;
            _eC_OrderDialogue.InitiatorId = CurrentUser.MemberId;
            _eC_OrderDialogue.DialogueContent = string.Format("{0}", Request["dialoguecontent"]);
            //开始请求
            Response.Write(_eC_OrderBasicBLL.OrderPropertyChangeRequest(_eC_OrderDialogue));
        }

        /// <summary>
        /// 答复清单请求 
        /// </summary>
        private void RequestReply()
        {
            Response.Clear();
            string ridStr = Request["did"];
            string isAllowStr = Request["isAllow"];
            Guid rid = MyConvert.ConvertToGuid(ridStr);
            bool? isAllow = Convert.ToBoolean(isAllowStr);
            if (Guid.Empty == rid || !isAllow.HasValue)
            {
                Response.Write(0);
                return;
            }
            else
            {
            }
            Response.Write(_eC_OrderBasicBLL.OrderPropertyChangeReply(rid, CurrentUser.MemberId, isAllow.Value));
        }

        private void ToBatchRemove()
        {
            string orderidStr = Request["orderid"];
            string tovalueStr = Request["tovalue"];

            int orderId = orderidStr.ToInt32().Value;
            decimal retireMony = tovalueStr.ToDecimal2().Value;
            string operatorName = CurrentUser.ShortName;
            Response.Write(_eC_OrderBasicBLL.RetireOrderBySeller(orderId, retireMony, operatorName));
        }
        /// <summary>
        /// 默认执行方法
        /// </summary>
        private void Page_Load_Default()
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager_PageChanged;
            btn_Search.Click += btn_Search_Click;
            // txtCommission.Value = CY.Config.WebInfo.Instance.FirmOrderAgencyFee;
            List<EC_OrderDialogue> dialogues = _eC_OrderBasicBLL.SelectPropertyChangeRequest(CurrentUser.MemberId) as List<EC_OrderDialogue>;


            if (!IsPostBack && !IsCallback)
            {
                Sys_DictionaryBLL _sys_DictionaryBLL = new Sys_DictionaryBLL();//字典业务逻辑操作类对象
                SysInquiry_PrintingTypeBLL _sysInquiry_PrintingTypeBLL = new SysInquiry_PrintingTypeBLL();//印刷业务类型业务逻辑操作类对象



                ///账户类型
                dwAcoountType.DataSource = _Sys_DictionaryBLL.GetDataByType("账户类型");
                dwAcoountType.DataTextField = "Name";
                dwAcoountType.DataValueField = "Keyid";
                dwAcoountType.DataBind();
                dwAcoountType.Items.Insert(0, new ListItem("全部", ""));

                /////账户名称
                selAccountName.DataSource = _OA_FirmAccountBLL.getAllSubject(CurrentUser.MemberId, "");
                selAccountName.DataBind();
                selAccountName.Items.Insert(0, new ListItem("全部", ""));

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

        protected void dwAcoountType_SelectedIndexChanged(object sender, EventArgs e)
        {
            selAccountName.DataSource = _OA_FirmAccountBLL.getAllSubject(CurrentUser.MemberId, this.dwAcoountType.SelectedItem.Text);
            selAccountName.DataBind();
            selAccountName.Items.Insert(0, new ListItem("全部", ""));
        }

        #region 查询

        /// <summary>
        /// 搜索按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Search_Click(object sender, EventArgs e)
        {

            /* if (this.txtCustormerName.Value.Trim() == "")
            {
                Response.Write("客户名称不能为空，请输入客户名称再查询……");
                return;
            }*/
            //Dictionary<int, object> searchParam = new Dictionary<int, object>();

            //SetParamValue(searchParam, 1, CurrentUser.MemberId);
            //SetParamValue(searchParam, 2, "");
            //SetParamValue(searchParam, 3, this.txtCustormerName.Value.Trim());
            //SetParamValue(searchParam, 4, "");
            //SetParamValue(searchParam, 5, "");
            //SetParamValue(searchParam, 6, "");
            //SetParamValue(searchParam, 7, "");
            //SetParamValue(searchParam, 8, "");
            //SetParamValue(searchParam, 9, this.selPayStates.Value);
            //SetParamValue(searchParam, 10, "");
            //SetParamValue(searchParam, 11, "");
            //SetParamValue(searchParam, 12, "");
            //SetParamValue(searchParam, 13, this.selBusinessManager.Value);
            //SetParamValue(searchParam, 14, "");
            //SetParamValue(searchParam, 15, "");
            //SetParamValue(searchParam, 16, "");
            //SetParamValue(searchParam, 18, (CurrentUser.StaffId > 0 ? 1 : 0));
            //SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
            //SetParamValue(searchParam, 20, CurrentUser.StaffId);
            //SetParamValue(searchParam, 21, CurrentUser.TrueName);


            //SetParamValue(searchParam, 22, this.txtSQBeginDate.Value);
            //SetParamValue(searchParam, 23, this.txtSQEndDate.Value);
            //SetParamValue(searchParam, 24, this.selKaipiaoshenqing.Value);
            //SetParamValue(searchParam, 25, this.selKehuqianshou.Value);
            //SearchParam = searchParam;

            UCPager1.AspNetPager.CurrentPageIndex = 1;//重置页数
            //再次查询
            AspNetPager_PageChanged(UCPager1.AspNetPager, new EventArgs());
        }

        /// <summary>
        /// 设置查询参数方法
        /// </summary>
        /// <param name="target">设置目标</param>
        /// <param name="key">键</param>
        /// <param name="value">值</param>
        private static void SetParamValue(Dictionary<int, object> target, int key, object value)
        {
            if (string.IsNullOrEmpty(string.Format("{0}", value)))
                return;
            else
            {
            }

            if (target.ContainsKey(key))
            {
                target[key] = value;
            }
            else
            {
                target.Add(key, value);
            }
        }

        /// <summary>               
        /// 分页事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void AspNetPager_PageChanged(object sender, EventArgs e)
        {
            // UCPager1.AspNetPager.PageSize = 3;

            Infrastructure.Query.Pagination pagination = new Infrastructure.Query.Pagination()
            {
                PageSize = UCPager1.AspNetPager.PageSize,
                PageIndex = UCPager1.AspNetPager.CurrentPageIndex
            };
            IEnumerable<OA_Baozhengjin> result = oA_BaozhengjinBLL.SelectModelPage(pagination, CurrentUser.MemberId, this.txtSQBeginDate.Value, this.txtSQEndDate.Value, this.dwAcoountType.SelectedValue, this.selAccountName.Value,this.Shoukuandanwei.Value, this.remark.Value,this.TuikuanStatus.Value);
            rptData.DataSource = result;
            rptData.DataBind();

            heji.InnerText = String.Format("{0:F2}", result.Sum(x => x.Fukuanmoney));

            UCPager1.AspNetPager.RecordCount = pagination.RecordCount;
        }

        /// <summary>
        /// 查询参数
        /// </summary>
        private Dictionary<int, object> SearchParam
        {
            get
            {
                return ViewState["SearchParam"] as Dictionary<int, object>;
            }
            set
            {
                ViewState["SearchParam"] = value;
            }
        }

        /// <summary>
        /// 是否可以操作
        /// </summary>
        /// <param name="keyid"></param>
        /// <param name="orderState"></param>
        /// <param name="opType"></param>
        /// <returns></returns>
        public bool IsCanOpearte(object keyidObj, object orderStateObj, object outIdObj, object opTypeObj)
        {
            bool isCan = false;
            int keyid = (int)keyidObj;
            int orderState = (int)orderStateObj;
            string opType = (string)opTypeObj;
            int outId = (int)outIdObj;
            if (orderState == -2)
            {
                return false;
            }
            if (opType == "回访" || opType == "评价" || opType == "投诉")
            {
                if (orderState == 1)
                {
                    isCan = false;
                }
                else
                {
                    isCan = true;
                }
            }
            else
            {
                if (outId > 0)
                {
                    return false;
                }
                if (orderState == 0)
                {
                    isCan = false;
                }
                else if (orderState == -1)
                {
                    if (opType != "送货")
                    {
                        isCan = false;
                    }
                    else
                    {
                        isCan = true;
                    }
                }
                else
                {
                    if (opType == "受理")
                    {
                        if (orderState == 1)
                        {
                            isCan = true;
                        }
                    }
                    else
                    {
                        if (orderState == 1)
                        {
                            isCan = false;
                        }
                        else
                        {
                            if (opType == "撤单")
                            {
                                if (orderState == 4 || orderState == 5)
                                {
                                    isCan = false;
                                }
                                else
                                {
                                    isCan = true;
                                }
                            }
                            else
                            {
                                isCan = true;
                            }
                        }
                    }
                }
            }
            return isCan;
        }

        /// <summary>
        /// 是否已经操作
        /// </summary>
        /// <param name="keyid"></param>
        /// <param name="orderState"></param>
        /// <param name="opType"></param>
        /// <returns></returns>
        public bool IsOpearted(object keyidObj, object orderStateObj, object opTypeObj)
        {
            int keyid = (int)keyidObj;
            int orderState = (int)orderStateObj;
            string opType = (string)opTypeObj;
            return _eC_OrderBasicBLL.IsOpearted(keyid, orderState, opType);
        }

        /// <summary>
        /// 批量去除订单
        /// </summary>
        public void AcceptAll2()
        {
            Response.Clear();

            string ids = string.Empty;

            if (Request["ids"] != null)
            {
                ids = Request["ids"].ToString();
            }


            string[] idsArray = ids.Split(',');
            using (TransactionScope scope = new TransactionScope())
            {
                if (idsArray != null && idsArray.Length > 0)
                {
                    for (int i = 0; i < idsArray.Length; i++)
                    {
                        bool result = true;
                        EC_OrderExtend model = new EC_OrderExtend();
                        model.Keyid = idsArray[i].ToInt32();
                        model.QuchudingdanCreater = CurrentUser.TrueMemberId;
                        model.QuchudingdanTime = DateTime.Now;
                        model.Quchudingdan = 1;

                        result = _eC_OrderBLL.OldUpdateQuchudingdan(model);

                        if (!result)
                        {
                            //Page_Load_Default();
                            Response.Write("-2");
                            return;
                        }
                    }
                }

                scope.Complete();
            }


            // Page_Load_Default();
            Response.Write("1");



        }


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

            string ids = string.Empty;

            if (Request["ids"] != null)
            {
                ids = Request["ids"].ToString();
            }


            string[] idsArray = ids.Split(',');
            using (TransactionScope scope = new TransactionScope())
            {

                if (idsArray != null && idsArray.Length > 0)
                {
                    DateTime kaipiaoshenqing = DateTime.Now;
                    for (int i = 0; i < idsArray.Length; i++)
                    {
                        bool result = true;
                        EC_OrderExtend model = new EC_OrderExtend();
                        model.Keyid = idsArray[i].ToInt32();
                        model.KaipiaoshenqingCreater = CurrentUser.TrueMemberId;
                        model.KaipiaoshenqingTime = kaipiaoshenqing;
                        model.Kaipiaoshenqing = 1;

                        result = _eC_OrderBLL.OldUpdateKaipiaoshenqing(model);

                        if (!result)
                        {
                            //Page_Load_Default();
                            Response.Write("-2");
                            return;
                        }
                    }
                }

                scope.Complete();
            }


            // Page_Load_Default();
            Response.Write("1");



        }
        #endregion
    }
}

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

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

namespace CY.WebForm.Pages.business
{


    public partial class Baozhengjinfukuan
    {

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

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

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

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

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/financial/BaozhengjinIncome.aspx

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

<!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" />
    <link href="../../Styles/ParticularWQJ.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .table2 td{ text-align:left; padding:3px 2px;}
    </style>
    <script type="text/javascript">

        var accountsTypes = false;
        var accounts = false;

        $(function () {
            if ('1' == document.getElementById('txtResult').value) {
                CloseOpenWindow(true);
                return;
            } else;
            /*document.getElementById('txtReceiveDate').value = new Date().ToString("yyyy-MM-dd HH:mm");*/
            //document.getElementById('txtReceiveMoney').value = document.getElementById('txtReciveMoney').value;
           /* document.getElementById('txtReceiveMoney').focus();*/
            accountsTypes = '<%=Request.RequestContext.RouteData.DataTokens["accountsTypes"] %>';
            accounts = '<%=Request.RequestContext.RouteData.DataTokens["accounts"] %>';

            try {
                accountsTypes = eval(accountsTypes);
                accounts = eval(accounts)[0];
            } catch (e) {
                accountsTypes = 'object' == typeof (accountsTypes) ? accountsTypes : [];
                accounts = [];
            }

        });

        /*
        验证输入价格
        */
        function ValidateInputPrice(txt) {
            if (!ValidateDecimal(txt)) return; else;
            try {
                var inputPrice = parseFloat(txt.value);
                var unPayed = parseFloat(document.getElementById('txtReciveMoney').value);
                txt.value = isNaN(inputPrice) || isNaN(unPayed) ? 0 : txt.value;
                if (inputPrice > unPayed) { alertMsg(' 本次收款金额大于订单未付款!<br/>为了您的账务正确性请重新复查！'); }
            } catch (e) {

            }
        }
    </script>
</head>
<body style='margin: 0; padding: 0;'>
    <form id="form1" runat="server" onsubmit="if(false)return false;">
    <input type="hidden" id='txtResult' value='<%=Request.RequestContext.RouteData.DataTokens["IsWin"] %>'>
    <table class="tableStyle" style="margin: 5px 0;">
        
         
        
         <tr>
            <td class="ali03 ">
                收取金额：
            </td>
            <td >
                <asp:TextBox TextMode="SingleLine"  id="txtMoney" runat="server" class="req float" min="0" ReadOnly="true"   ></asp:TextBox>
                  <input type="hidden"  id="Keyid" runat="server" />
            </td>
        </tr>
       
            
           
            <tr>
               <%-- <td style=" text-align:right;">
                    付款方式：
                </td>
                <td colspan="5">
                    <input type="radio" name='rdoReceiveWay' id='rdoReceiveWay0' value='0' checked="checked" /><label for='rdoReceiveWay0'>预付款</label>
                    (剩余预付款：<span id="nowCustomMoney" runat="server" class="moneystyle"></span>)
                </td>--%>
                <td class="ali03 ">
                    账户类型：
                </td>
                <td>
                    <select class="Sreq" id="selAcoountType" runat="server" datatextfield="Name" datavaluefield="Name" onchange="ChangeThisType(this);" keepdefaultstyle="true" msg="请选择账户类型">
                    </select>
                </td>
                </tr>
            <tr>
                <td class="ali03 ">
                    账户名称：
                </td>
                <td>
                    <select class="Sreq" id="selAccountName" runat="server" datatextfield="AccountName" datavaluefield="Keyid" keepdefaultstyle="true" msg="请选择账户名称">
                        <option value="">请选择</option>
                    </select>
                </td>
                </tr>
            <tr>
                <td class="ali03 ">
                    科目名称：
                </td>
                <td>
                    <select id="selSubject" runat="server" datatextfield="SubjectName" datavaluefield="Keyid" keepdefaultstyle="true" msg="请选择科目名称">
                    </select>
                </td>
            </tr>
          <tr>
            <td class="ali03 ">
                交款单位：
            </td>
            <td >
                <asp:TextBox TextMode="SingleLine"  id="txtPaymentUnit" runat="server" class="req float" min="0" ReadOnly="true"   ></asp:TextBox>
            </td>
        </tr>
            
            <tr>
                <td style=" text-align:right;">
                    摘要：
                </td>
                <td   align="left">
                    <textarea id='txtOperationalMatters' runat="server" onblur='Restrict(this,200)' class='remark' style='height: 30px; width: 440px;'></textarea>
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td   align="left">
                <input type="button" value="确认付款" runat="server"   id='btnSubmit' /> 
                </td>
            </tr>
    </table>
    </form>
     <script language="javascript" type="text/javascript">
         function ChangeThisType(obj) {
             $("#selAccountName").html("<option value=''>请选择</option>");
             $.ajax({
                 url: "/Pages/financial/BaozhengjinIncome.aspx",
                 type: "POST",
                 dataType: "html",
                 data: { TypeName: $(obj).val(), DataType: "change" },
                 global: false,
                 cache: false,
                 success: function (data) {
                     var myobj = eval('(' + data + ')');
                     if (myobj != null && myobj.length > 0) {
                         for (var i = 0; i < myobj.length; i++) {
                             var city_keyid = myobj[i].Keyid;
                             var city_name = myobj[i].AccountName + "-" + myobj[i].UserName;
                             var option = "";
                             option = "<option value = '" + city_keyid + "'>" + city_name + "</option>";
                             $(option).appendTo($("#selAccountName"));
                         }
                     }
                 }
             });
         }
            
    </script>
    <script type="text/javascript">
        $(function () {
            ChangeThisType("#selAcoountType");
        });
    </script>
</body>
</html>

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

New file
@@ -0,0 +1,287 @@
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.Infrastructure.Common;
using CY.Model;
using CY.BLL.OA;
using CY.BLL.Sys;
using System.Text;
using CY.BLL;
using System.Data;
using System.Transactions;

namespace CY.WebForm.Pages.financial
{
    //吴辉
    //外协预付款
    public partial class BaozhengjinIncome : BasePage
    {
        private EC_OrderBasicBLL _eC_OrderBasicBLL = null;
        private OA_CorporateClientsBLL bll_OA_CorporateClientsBLL = null;
        OA_FirmAccountBLL _OA_FirmAccountBLL = null;
        OA_FirmAccountRecordBLL _OA_FirmAccountRecordBLL = null;
        OA_FirmAccountRecord firmAccountRecord = null;
        OA_FirmAccount firmAccount = null;
        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        string orderNo = string.Empty;

        decimal? AllMoney = 0;
        decimal? ReceiveMoney = 0;

        /// <summary>
        /// 初始化构造 
        /// </summary>
        public BaozhengjinIncome()
        {
            bll_OA_CorporateClientsBLL = new OA_CorporateClientsBLL();
            _OA_FirmAccountBLL = new OA_FirmAccountBLL();
            firmAccountRecord = new OA_FirmAccountRecord();
            _OA_FirmAccountRecordBLL = new OA_FirmAccountRecordBLL();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
        }

        /// <summary>
        /// 界面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            btnSubmit.ServerClick += new EventHandler(btnSubmit_ServerClick);
            try
            {
                switch (Request["DataType"])
                {
                    case "change":
                        Response.Write(reLoadAccountName(Request["TypeName"].ToString2()));
                        break;
                    default://一般情况不处理
                        if (IsPostBack || IsCallback)
                            return;
                        else
                        {
                            LoadOrder();
                            InitialData();
                        }
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                Response.Write("-1");
            }
            Response.End();
            InitPage();

        }
        protected void InitialData()
        {
            //科目名称
            Sys_DictionaryBLL _Sys_DictionaryBLL = new Sys_DictionaryBLL();
            OA_SubjectSetBLL _OA_SubjectSetBLL = new OA_SubjectSetBLL();
            OA_FirmAccountBLL oA_FirmAccountBLL = new OA_FirmAccountBLL();
            selSubject.DataSource = _OA_SubjectSetBLL.getAllSubject(CurrentUser.MemberId, "借");
            selSubject.DataBind();
            selSubject.Items.Insert(0, new ListItem("请选择", ""));

            ///账户类型
            
            selAcoountType.DataSource = _Sys_DictionaryBLL.GetDataByType("账户类型");   
           
            selAcoountType.DataBind();

            //selAcoountType_SelectedIndexChanged(null, null);

        }
        protected string reLoadAccountName(string selAcoountType)
        {
            return JsonHelper.GetJsonStringByObject(_OA_FirmAccountBLL.getAllSubject(CurrentUser.MemberId, selAcoountType));
        }
        /// <summary>
        /// 提交按钮点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSubmit_ServerClick(object sender, EventArgs e)
        {

            
            
            //_orderBasic = new EC_OrderBasic();
            _eC_OrderBasicBLL = new EC_OrderBasicBLL();
            //_orderBasic = _eC_OrderBasicBLL.SelectModelById(orderId.Value);
            //string orderno = "";
            //string sellerName = "";
            if(string.IsNullOrEmpty(Request["selAccountName"]))
            {
                JavaScript.MessageBox("请选择账户", this);
                return;
            }
            firmAccount = _OA_FirmAccountBLL.getSingleSubject(Request["selAccountName"].ToInt32());
            

            var ssss = false;

            var id = this.Keyid.Value.ToInt32().Value;
            var fukuanshenqing = oA_BaozhengjinBLL.GetModelByKeyid(id);
            
            if (fukuanshenqing.TuikuanStatus == 2 )
            {
                JavaScript.MessageBox("已经退款，无法重复退款！", this);
                return;
            }
           
            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
    new TransactionOptions
    {
        IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted,
        Timeout = TransactionManager.MaximumTimeout
    }
    ))
            {
                try
                {



                    fukuanshenqing.TuikuanStatus = 2;
                    fukuanshenqing.TuikuanTime = DateTime.Now;
                    
                    fukuanshenqing.Updater = CurrentUser.ShortName;
                    fukuanshenqing.LastUpdateTime = DateTime.Now;
                    ssss = oA_BaozhengjinBLL.UpdateModel(fukuanshenqing);
                    if(this.txtMoney.Text.ToDecimal2() > 0)
                    {
                        firmAccount = _OA_FirmAccountBLL.getSingleSubject(Request["selAccountName"].ToInt32());
                        OA_FirmAccountRecord firmAccountRecord = new OA_FirmAccountRecord() ;
                        firmAccountRecord.AccountId = Request["selAccountName"].ToInt32();
                        firmAccountRecord.LastUpdateTime = DateTime.Now;
                        firmAccountRecord.Money = txtMoney.Text.ToDecimal2();
                        firmAccountRecord.OperationalMatters = txtOperationalMatters.Value;
                        firmAccountRecord.Operator = CurrentUser.ShortName;
                        firmAccountRecord.PaymentUnit = txtPaymentUnit.Text;
                        firmAccountRecord.RecordTypeId = 1;//收入
                        firmAccountRecord.Remark = "";
                        firmAccountRecord.SubjectId = selSubject.Value.ToInt32();
                        firmAccountRecord.ResidualAmount = firmAccount.Balance + txtMoney.Text.ToDecimal2();
                        firmAccountRecord.Department = "";

                        firmAccount.AllIncome = txtMoney.Text.ToDecimal2() + firmAccount.AllIncome;
                        firmAccount.Balance = firmAccount.Balance + txtMoney.Text.ToDecimal2();

                        ssss = _OA_FirmAccountRecordBLL.AddModel(firmAccountRecord, firmAccount);
                    }


                 

                    

                    if (ssss)
                    {
                        
                        scope.Complete();
                        JavaScript.MessageBox("付款成功", this, "top.frmright.ReLoad();top.Dialog.close();");
                    }
                    else
                        JavaScript.MessageBox("添加失败", this);
                }
                catch (Exception ex)
                {
                    PAGEHandleException(ex);
                    JavaScript.MessageBox("添加失败", this);
                }
                finally
                {
                    scope.Dispose();
                }


            }





        }

        /// <summary>
        /// 加载页面数据
        /// </summary>
        private void InitPage()
        {
            try
            {
                Sys_DictionaryBLL _Sys_DictionaryBLL = new Sys_DictionaryBLL();
                //OA_SubjectSetBLL _OA_SubjectSetBLL = new OA_SubjectSetBLL();
                OA_FirmAccountBLL oA_FirmAccountBLL = new OA_FirmAccountBLL();               

                int i = -1;
                //账户类型
                List<Sys_Dictionary> accountsType = _Sys_DictionaryBLL.GetDataByType("账户类型") as List<Sys_Dictionary>;
                Request.RequestContext.RouteData.DataTokens.Add("accountsTypes", null == accountsType || accountsType.Count == 0 ? "[]" : JsonHelper.GetJsonStringByObject(accountsType));

                List<OA_FirmAccount> firmAccounts = oA_FirmAccountBLL.getAllSubject(CurrentUser.MemberId, "") as List<OA_FirmAccount>;

                const string ACCOUNTSJSONKEY = "accounts";
                if (null == firmAccounts)
                {
                    Request.RequestContext.RouteData.DataTokens.Add(ACCOUNTSJSONKEY, "[]");
                    return;
                }

                IEnumerable<IGrouping<string, OA_FirmAccount>> groupings = firmAccounts.GroupBy(fa => fa.AccountType);
                StringBuilder builder = new StringBuilder();

                foreach (IGrouping<string, OA_FirmAccount> groupitem in groupings)
                {
                    OA_FirmAccount[] items = groupitem.ToArray();
                    builder.AppendFormat("{0}\"{2}\":{3}{1}", ",", "", groupitem.Key, JsonHelper.GetJsonStringByObject(items));
                }
                builder.Append("}]");
                builder.Replace(",", "[{", 0, 1);

                Request.RequestContext.RouteData.DataTokens.Add(ACCOUNTSJSONKEY, null == firmAccounts ? "[]" : builder.ToString());

            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
            }
        }

        /// <summary>
        /// 加载订单
        /// </summary>
        private void LoadOrder()
        {
            var id = Request["id"];
            var fukuanshenqing = oA_BaozhengjinBLL.GetModelByKeyid(id.ToInt32().Value);
            if (fukuanshenqing != null)
            {
                this.Keyid.Value = id;


                

                this.txtMoney.Text = fukuanshenqing.Fukuanmoney.Value.ToString("0.00");
                this.txtPaymentUnit.Text = fukuanshenqing.Shoukuandanwei;
                this.txtOperationalMatters.Value = fukuanshenqing.remark;
            }
           

           
          
        }
        
        
  
    }
}

 CY_ECommercePlatform/CY.WebForm/Pages/financial/BaozhengjinIncome.aspx.designer.cs

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

namespace CY.WebForm.Pages.financial
{


    public partial class BaozhengjinIncome
    {

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

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/Pages/financial/FirmAccountExpensesEdit.aspx

@@ -34,9 +34,24 @@
                    科目名称：
                </td>
                <td>
                    <select id="selSubject" runat="server" datatextfield="SubjectName" datavaluefield="Keyid" keepdefaultstyle="true" msg="请选择科目名称">
                    <select id="selSubject" runat="server" datatextfield="SubjectName" datavaluefield="Keyid" keepdefaultstyle="true" msg="请选择科目名称" onchange="ChangeThisSubject(this);" >
                    </select>
                </td>
            </tr>
            <tr id="shenqingren" style="display:none;">
                <td class="ali03 ">
                    申请人：
                </td>
                <td>
                    <select id="selshenqingren" runat="server"  datavaluefield="Keyid" datatextfield='Name' keepdefaultstyle="true" msg="请选择申请人"   >
                    </select>
                </td>
            </tr>
            <tr id="shenqingrenss" style="display:none;">
                <td  colspan="2">
                   <span  style="color:red;">选择科目：投标保证金，履约保证金，将会产生一条保证金数据！</span>
                </td>
                
            </tr>
            <tr>
                <td class="ali03 ">
@@ -89,6 +104,22 @@
    </div>
    </form>
    <script language="javascript" type="text/javascript">


        function ChangeThisSubject(obj) {
            

            var selectedText = $(obj).find("option:selected").text();
            if (selectedText.indexOf("投标保证金") >= 0 || selectedText.indexOf("履约保证金") >= 0) {
                $("#shenqingren").show();
                $("#shenqingrenss").show();
            } else {
                $("#shenqingren").hide();
                $("#shenqingrenss").hide();
            }
        }


        function ChangeThisType(obj) {
            $("#selAccountName").html("<option value=''>请选择</option>");
            $.ajax({

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

@@ -8,6 +8,7 @@
using CY.Infrastructure.Common;
using CY.BLL.OA;
using CY.BLL.Sys;
using CY.BLL;

namespace CY.WebForm.Pages.financial
{
@@ -19,7 +20,8 @@
        OA_FirmAccountRecordBLL _OA_FirmAccountRecordBLL = null;
        OA_FirmAccountRecord firmAccountRecord = null;
        OA_FirmAccount firmAccount = null;

        OA_BaozhengjinBLL oA_BaozhengjinBLL = null;
        OA_StaffBLL staffBLL = null;
        public FirmAccountExpensesEdit()
        {
            firmAccount = new OA_FirmAccount();
@@ -28,6 +30,8 @@
            _OA_FirmAccountRecordBLL = new OA_FirmAccountRecordBLL();
            _OA_SubjectSetBLL = new OA_SubjectSetBLL();
            firmAccountRecord = new OA_FirmAccountRecord();
            oA_BaozhengjinBLL = new OA_BaozhengjinBLL();
            staffBLL = new OA_StaffBLL();
        }

        protected void Page_Load(object sender, EventArgs e)
@@ -68,6 +72,9 @@
            ///账户类型
            selAcoountType.DataSource = _Sys_DictionaryBLL.GetDataByType("账户类型");
            selAcoountType.DataBind();

            selshenqingren.DataSource =  staffBLL.SelectListByFirmId(CurrentUser.MemberId,null, null).Where(x => x.DepartmentId == 2);
            selshenqingren.DataBind();
        }

        protected string reLoadAccountName(string selAcoountType)
@@ -79,6 +86,8 @@
        {
            try
            {
               // selshenqingren

                firmAccount = _OA_FirmAccountBLL.getSingleSubject(Request["selAccountName"].ToInt32());

                firmAccountRecord.AccountId = Request["selAccountName"].ToInt32();
@@ -98,6 +107,53 @@

                if (_OA_FirmAccountRecordBLL.AddModel(firmAccountRecord, firmAccount))
                {
                    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)
                        {
                            //如果选择科目是保证金，插入以条保证金数据
                            OA_Baozhengjin oA_Baozhengjin = new OA_Baozhengjin();
                            oA_Baozhengjin.FirmId = CurrentUser.MemberId;
                            oA_Baozhengjin.FukuanTime = DateTime.Now;

                            oA_Baozhengjin.Zhanghuleixing = this.selAcoountType.Value;

                            var ss = _Sys_DictionaryBLL.GetDataByType("账户类型").FirstOrDefault(x => x.Name == oA_Baozhengjin.Zhanghuleixing);
                            if (ss != null)
                            {
                                oA_Baozhengjin.ReceiveWay = ss.Keyid;
                            }

                            oA_Baozhengjin.Account = Request["selAccountName"].ToInt32();
                            oA_Baozhengjin.Fukuanzhanghu = firmAccount.AccountName + "-" + firmAccount.UserName;
                            oA_Baozhengjin.Subject = firmAccountRecord.SubjectId;
                            oA_Baozhengjin.Fukuankemu = oA_SubjectSet.SubjectName;
                            oA_Baozhengjin.Fukuanmoney = firmAccountRecord.Money;
                            oA_Baozhengjin.Shoukuandanwei = firmAccountRecord.PaymentUnit;
                            oA_Baozhengjin.remark = firmAccountRecord.OperationalMatters;
                            oA_Baozhengjin.TuikuanTime = null;

                            oA_Baozhengjin.TuikuanStatus = 1;
                            oA_Baozhengjin.Creater = CurrentUser.ShortName;
                            oA_Baozhengjin.CreateTime = oA_Baozhengjin.FukuanTime;
                            oA_Baozhengjin.Updater = CurrentUser.ShortName;
                            oA_Baozhengjin.LastUpdateTime = oA_Baozhengjin.FukuanTime;
                            oA_Baozhengjin.MemberId = this.selshenqingren.Value.ToInt32();
                            if(oA_Baozhengjin.MemberId.HasValue && oA_Baozhengjin.MemberId.Value > 0)
                            {
                                var aaa = staffBLL.GetModelByKeyid(oA_Baozhengjin.MemberId);
                                if (aaa != null)
                                {
                                    oA_Baozhengjin.MemberName = aaa.Name;
                                }
                            }

                            var sss = oA_BaozhengjinBLL.InsertModel(oA_Baozhengjin);

                        }
                    }
                   
                    this.selSubject.Value = "";
                    this.txtMoney.Value = "";
                    this.txtDepartment.Value = "";

 CY_ECommercePlatform/CY.WebForm/Pages/financial/FirmAccountExpensesEdit.aspx.designer.cs

@@ -2,16 +2,18 @@
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能会导致不正确的行为，并且如果
//     重新生成代码，这些更改将会丢失。 
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.financial {
    
    
    public partial class FirmAccountExpensesEdit {
        
namespace CY.WebForm.Pages.financial
{


    public partial class FirmAccountExpensesEdit
    {

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
@@ -20,7 +22,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;
        

        /// <summary>
        /// form1 控件。
        /// </summary>
@@ -29,7 +31,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;
        

        /// <summary>
        /// selAcoountType 控件。
        /// </summary>
@@ -38,7 +40,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selAcoountType;
        

        /// <summary>
        /// selAccountName 控件。
        /// </summary>
@@ -47,7 +49,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selAccountName;
        

        /// <summary>
        /// selSubject 控件。
        /// </summary>
@@ -56,7 +58,16 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selSubject;
        

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

        /// <summary>
        /// txtMoney 控件。
        /// </summary>
@@ -65,7 +76,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtMoney;
        

        /// <summary>
        /// txtDepartment 控件。
        /// </summary>
@@ -74,7 +85,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtDepartment;
        

        /// <summary>
        /// txtPaymentUnit 控件。
        /// </summary>
@@ -83,7 +94,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtPaymentUnit;
        

        /// <summary>
        /// txtOperationalMatters 控件。
        /// </summary>
@@ -92,7 +103,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlTextArea txtOperationalMatters;
        

        /// <summary>
        /// txtRemark 控件。
        /// </summary>
@@ -101,7 +112,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlTextArea txtRemark;
        

        /// <summary>
        /// btn_Submit 控件。
        /// </summary>

 CY_ECommercePlatform/CY.WebForm/Pages/financial/FirmAccountExpensesList.aspx

@@ -8,7 +8,7 @@
    <script type="text/javascript">
        ///添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/financial/FirmAccountExpensesEdit.aspx?Keyid='0'", Title: "新增支出记录", Width: 420, Height: 270 });
            top.Dialog.open({ URL: "/Pages/financial/FirmAccountExpensesEdit.aspx?Keyid='0'", Title: "新增支出记录", Width: 420, Height: 370 });
        }
        //查看
        function onView(keyid) {

 CY_ECommercePlatform/CY.WebForm/Pages/financial/FirmAccountExpensesList.aspx.designer.cs

@@ -2,16 +2,18 @@
// <自动生成>
//     此代码由工具生成。
//
//     对此文件的更改可能会导致不正确的行为，并且如果
//     重新生成代码，这些更改将会丢失。 
//     对此文件的更改可能导致不正确的行为，如果
//     重新生成代码，则所做更改将丢失。
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.financial {
    
    
    public partial class FirmAccountExpensesList {
        
namespace CY.WebForm.Pages.financial
{


    public partial class FirmAccountExpensesList
    {

        /// <summary>
        /// CMSHead1 控件。
        /// </summary>
@@ -20,7 +22,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.CMSHead CMSHead1;
        

        /// <summary>
        /// form1 控件。
        /// </summary>
@@ -29,7 +31,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;
        

        /// <summary>
        /// txtRegTimeStart 控件。
        /// </summary>
@@ -38,7 +40,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtRegTimeStart;
        

        /// <summary>
        /// txtRegTimeEnd 控件。
        /// </summary>
@@ -47,7 +49,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtRegTimeEnd;
        

        /// <summary>
        /// dwAcountType 控件。
        /// </summary>
@@ -56,7 +58,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.DropDownList dwAcountType;
        

        /// <summary>
        /// selAccountName 控件。
        /// </summary>
@@ -65,7 +67,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selAccountName;
        

        /// <summary>
        /// selSubject 控件。
        /// </summary>
@@ -74,7 +76,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlSelect selSubject;
        

        /// <summary>
        /// txtOperationalMatters 控件。
        /// </summary>
@@ -83,7 +85,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtOperationalMatters;
        

        /// <summary>
        /// txtPaymentUnit 控件。
        /// </summary>
@@ -92,7 +94,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtPaymentUnit;
        

        /// <summary>
        /// txtOperater 控件。
        /// </summary>
@@ -101,7 +103,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtOperater;
        

        /// <summary>
        /// btn_Register 控件。
        /// </summary>
@@ -110,7 +112,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button btn_Register;
        

        /// <summary>
        /// RepFirmAccountIncomeList 控件。
        /// </summary>
@@ -119,7 +121,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepFirmAccountIncomeList;
        

        /// <summary>
        /// NowPageAllMoney 控件。
        /// </summary>
@@ -128,7 +130,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl NowPageAllMoney;
        

        /// <summary>
        /// AllMoney 控件。
        /// </summary>
@@ -137,7 +139,7 @@
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl AllMoney;
        

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

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

@@ -87,7 +87,7 @@
            ///账户类型
            dwAcoountType.DataSource = _Sys_DictionaryBLL.GetDataByType("账户类型");
            dwAcoountType.DataTextField = "Name";
            dwAcoountType.DataValueField = "Keyid";
            dwAcoountType.DataValueField = "Name";
            dwAcoountType.DataBind();
            dwAcoountType.Items.Insert(0, new ListItem("全部", ""));