把这个我们政财里面有个常用资料，常用资料有通讯录和账号密码。把这个也放到川一头去，川饮也需要这个东西，就放在川渝的行政管理好行政管理里面。你二级栏目就...

username@email.com

2025-02-28 f1b2ef9600a038008e11b151a5cb7cffab336be5

把这个我们政财里面有个常用资料，常用资料有通讯录和账号密码。把这个也放到川一头去，川饮也需要这个东西，就放在川渝的行政管理好行政管理里面。你二级栏目就是常用资料。

好通讯录和QQ密码我们都要增加一个阅读权限，也就是说新增这个通讯录，新增这个账号密码的时候，都要增加阅读权限啊，这个阅读权限还是能够根据用户的角色。可以多选，就哪些人可以看，哪些人不能看的嘛。

 CY_ECommercePlatform/AbstractFactory/Factory.cs

@@ -267,6 +267,7 @@
            OBJECT_PATH.Add(DALInterface.IOA_BaozhengjinDAL, "OA_BaozhengjinDAL");
            OBJECT_PATH.Add(DALInterface.IOA_WorkPlan_shenpiDAL, "OA_WorkPlan_shenpiDAL");
            OBJECT_PATH.Add(DALInterface.IOA_WorkPlan_attachmentDAL, "OA_WorkPlan_attachmentDAL");
            OBJECT_PATH.Add(DALInterface.IOA_ShejijijianDAL, "OA_ShejijijianDAL");
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewDAL, "OA_KaipiaonewDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderDAL, "CoreCmsPlanOrderDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderItemDAL, "CoreCmsPlanOrderItemDAL");
@@ -917,6 +918,11 @@
        /// </summary>
        IOA_WorkPlan_attachmentDAL = 1939,

        /// <summary>
        /// 开票申请
        /// </summary>
        IOA_ShejijijianDAL = 1940,


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

 CY_ECommercePlatform/CY.BLL/CY.BLL.csproj

@@ -181,6 +181,7 @@
    <Compile Include="OA\OA_PropertyCateBLL.cs" />
    <Compile Include="OA\OA_PropertyManageBLL.cs" />
    <Compile Include="OA\OA_PropertyRecordBLL.cs" />
    <Compile Include="OA\OA_ShejijijianBLL.cs" />
    <Compile Include="OA\OA_StaffBLL.cs" />
    <Compile Include="OA\OA_BrandBLL.cs" />
    <Compile Include="OA\OA_CargoSpaceBLL.cs" />

 CY_ECommercePlatform/CY.BLL/OA/OA_ShejijijianBLL.cs

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

/**  
* OA_ShejijijianBLL.cs
*
* 功 能： 合作客户业务逻辑类
* 类 名： OA_ShejijijianBLL
*
* 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_ShejijijianBLL
    {

        IOA_ShejijijianDAL _IOA_ShejijijianDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_ShejijijianBLL()
        {
            //获取OA_Shejijijian DAL实现
            _IOA_ShejijijianDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShejijijianDAL) as IOA_ShejijijianDAL;


        }

        /// <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_Shejijijian m_OA_Shejijijian)
        {
            try
            {

                return _IOA_ShejijijianDAL.InserModel(m_OA_Shejijijian);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

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


        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Shejijijian> GetModelByformid(Guid formid, string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status)
        {

            return _IOA_ShejijijianDAL.GetModelByformid(formid, Dingdanleixing, Fengmianneiye, Shejileixing, Status);
        }

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

            return _IOA_ShejijijianDAL.GetModelByKeyid(keyid);
        }

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

        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Shejijijian> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
   string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status)
        {
            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(Dingdanleixing))
                Condition += " and  ok.Dingdanleixing = '" + Dingdanleixing + "'";

            if (!string.IsNullOrEmpty(Fengmianneiye))
                Condition += " and  ok.Fengmianneiye = '" + Fengmianneiye + "'    ";
            if (!string.IsNullOrEmpty(Shejileixing))
                Condition += " and  ok.Shejileixing = '" + Shejileixing + "'";
            if (Status.HasValue && Status > 0)
                Condition += " and  ok.[Status] = " + Status + "";

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

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

    }
}

 CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj

@@ -168,6 +168,7 @@
    <Compile Include="OA\IOA_KaipiaonewcuishouDAL.cs" />
    <Compile Include="OA\IOA_KaipiaonewDAL.cs" />
    <Compile Include="OA\IOA_KipiaoshenqingDAL.cs" />
    <Compile Include="OA\IOA_ShejijijianDAL.cs" />
    <Compile Include="OA\IOA_WageAwardPunishDAL.cs" />
    <Compile Include="LF\ILF_OrderFilesDAL.cs" />
    <Compile Include="OA\IOA_CarDictionaryDAL.cs" />

 CY_ECommercePlatform/CY.IDAL/OA/IOA_ShejijijianDAL.cs

New file
@@ -0,0 +1,33 @@
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_ShejijijianDAL : ICommonDAL, IPaging<OA_Shejijijian>, IGetAllModel<OA_Shejijijian>
    {

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

        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        IEnumerable<OA_Shejijijian> GetModelByformid(Guid formid,string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status);


         
    }
}

 CY_ECommercePlatform/CY.Model/CY.Model.csproj

@@ -252,6 +252,7 @@
    <Compile Include="OA\OA_PropertyManage.cs" />
    <Compile Include="OA\OA_PropertyRecord.cs" />
    <Compile Include="OA\OA_RemittanceAdvice.cs" />
    <Compile Include="OA\OA_Shejijijian.cs" />
    <Compile Include="OA\OA_Specification.cs" />
    <Compile Include="OA\OA_Staff.cs" />
    <Compile Include="OA\OA_StaffFirmProfile.cs" />

 CY_ECommercePlatform/CY.Model/OA/OA_Document.cs

@@ -314,6 +314,15 @@
                _operator = value;
            }
        }


        /// <summary>
        /// 操作人
        /// </summary>		
        public string Jusequanxian
        {
            get;set;
        }
        #endregion Model

        #region Visiter
@@ -428,6 +437,12 @@
                this.Operator = isChange ? MyConvert.ConvertToString(value) : Operator;
                theValue = this.Operator;
            }
            else if ("Jusequanxian".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 21)
            {
                this.Jusequanxian = isChange ? MyConvert.ConvertToString(value) : Jusequanxian;
                theValue = this.Jusequanxian;
            }
            
            return theValue;
        }
        #endregion Visiter

 CY_ECommercePlatform/CY.Model/OA/OA_FirmRole.cs

@@ -91,6 +91,14 @@
            set { _remark = value; }
            get { return _remark; }
        }

        /// <summary>
        /// 是否选择
        /// </summary>
        public string ShifouCheck
        {
            get;set;
        }
        #endregion Model

        #region Visiter

 CY_ECommercePlatform/CY.Model/OA/OA_Shejijijian.cs

New file
@@ -0,0 +1,222 @@
/**  
* 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_Shejijijian : IAggregateRoot
    {

        public OA_Shejijijian()
        {
        }
        #region Model
        /// <summary>
        /// id
        /// </summary>
        public int Keyid { get; set; }
        /// <summary>
        ///  FirmId
        /// </summary>
        public Guid FirmId { get; set; }
        /// <summary>
        /// 订单类型
        /// </summary>
        public string Dingdanleixing { get; set; }

        /// <summary>
        ///订单类型
        /// </summary>
        public string DingdanleixingName { get; set; }

        /// <summary>
        /// 封面内页
        /// </summary>
        public string Fengmianneiye { get; set; }

        /// <summary>
        ///封面内页
        /// </summary>
        public string FengmianneiyeName { get; set; }

        /// <summary>
        /// 设计类型
        /// </summary>
        public string Shejileixing { get; set; }

        /// <summary>
        ///设计类型
        /// </summary>
        public string ShejileixingName { get; set; }




        public decimal? Shejilemoney { get; set; }



        public int? Status { get; set; }



        /// <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;
        }



        #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 ("Dingdanleixing".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.Dingdanleixing = isChange ? MyConvert.ConvertToString(value) : Dingdanleixing;
                theValue = this.Dingdanleixing;
            }
            else if ("DingdanleixingName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.DingdanleixingName = isChange ? MyConvert.ConvertToString(value) : DingdanleixingName;
                theValue = this.DingdanleixingName;
            }

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

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


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







            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;
            }
 


            return theValue;
        }

        #endregion
    }
}
 

 CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj

@@ -196,6 +196,7 @@
    <Compile Include="OA\OA_PropertyCateDAL.cs" />
    <Compile Include="OA\OA_PropertyManageDAL.cs" />
    <Compile Include="OA\OA_PropertyRecordDAL.cs" />
    <Compile Include="OA\OA_ShejijijianDAL.cs" />
    <Compile Include="OA\OA_StaffFirmProfileDAL.cs" />
    <Compile Include="OA\OA_StaffPostCategoryDAL.cs" />
    <Compile Include="OA\OA_StaffPostDAL.cs" />

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_DocumentDAL.cs

@@ -100,8 +100,9 @@
                            new SqlParameter("@DM_PrintTime", trueModel.DM_PrintTime) ,            
                            new SqlParameter("@DM_PrintStatus", trueModel.DM_PrintStatus) ,            
                            new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime) ,            
                            new SqlParameter("@Operator", trueModel.Operator)             
                     };
                            new SqlParameter("@Operator", trueModel.Operator),
                             new SqlParameter("@Jusequanxian", trueModel.Jusequanxian),
                     };
            try
            {
                _dataBase.Query("sp_OA_Document_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShejijijianDAL.cs

New file
@@ -0,0 +1,272 @@
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_ShejijijianDAL : IOA_ShejijijianDAL
    {

        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_Shejijijian] ok  " +


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


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


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

                 new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@Dingdanleixing",string.IsNullOrEmpty(trueModel.Dingdanleixing)?"":trueModel.Dingdanleixing),
                      new SqlParameter("@DingdanleixingName",string.IsNullOrEmpty(trueModel.DingdanleixingName)?"":trueModel.DingdanleixingName),
                        new SqlParameter("@Fengmianneiye",string.IsNullOrEmpty(trueModel.Fengmianneiye)?"":trueModel.Fengmianneiye),
                          new SqlParameter("@FengmianneiyeName",string.IsNullOrEmpty(trueModel.FengmianneiyeName)?"":trueModel.FengmianneiyeName),
                            new SqlParameter("@Shejileixing",string.IsNullOrEmpty(trueModel.Shejileixing)?"":trueModel.Shejileixing),
                              new SqlParameter("@ShejileixingName",string.IsNullOrEmpty(trueModel.ShejileixingName)?"":trueModel.ShejileixingName),
                               new SqlParameter("@Shejilemoney",trueModel.Shejilemoney.HasValue?trueModel.Shejilemoney.Value:0),
                                 new SqlParameter("@Status",trueModel.Status.HasValue?trueModel.Status.Value:0),
                                         new SqlParameter("@CreateTime",trueModel.CreateTime),
                                new SqlParameter("@Updater",trueModel.Updater),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                                    new SqlParameter("@Creater",trueModel.Creater),
                                     




            };
            string sql = "Insert Into OA_Shejijijian ([FirmId],[Dingdanleixing],[DingdanleixingName],[Fengmianneiye], [FengmianneiyeName], [Shejileixing],[ShejileixingName], [Shejilemoney],[Status], [Creater],[CreateTime],[Updater],[LastUpdateTime] )"
                                             + " Values (@FirmId,@Dingdanleixing,@DingdanleixingName, @Fengmianneiye, @FengmianneiyeName, @Shejileixing, @ShejileixingName, @Shejilemoney, @Status, @Creater,@CreateTime,@Updater,@LastUpdateTime  )";

            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_Shejijijian trueModel = model as Model.OA_Shejijijian;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter KehuqianshouTime = null;


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

                 new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@Dingdanleixing",string.IsNullOrEmpty(trueModel.Dingdanleixing)?"":trueModel.Dingdanleixing),
                      new SqlParameter("@DingdanleixingName",string.IsNullOrEmpty(trueModel.DingdanleixingName)?"":trueModel.DingdanleixingName),
                        new SqlParameter("@Fengmianneiye",string.IsNullOrEmpty(trueModel.Fengmianneiye)?"":trueModel.Fengmianneiye),
                          new SqlParameter("@FengmianneiyeName",string.IsNullOrEmpty(trueModel.FengmianneiyeName)?"":trueModel.FengmianneiyeName),
                            new SqlParameter("@Shejileixing",string.IsNullOrEmpty(trueModel.Shejileixing)?"":trueModel.Shejileixing),
                              new SqlParameter("@ShejileixingName",string.IsNullOrEmpty(trueModel.ShejileixingName)?"":trueModel.ShejileixingName),
                               new SqlParameter("@Shejilemoney",trueModel.Shejilemoney.HasValue?trueModel.Shejilemoney.Value:0),
                                 new SqlParameter("@Status",trueModel.Status.HasValue?trueModel.Status.Value:0),
                                         new SqlParameter("@CreateTime",trueModel.CreateTime),
                                new SqlParameter("@Updater",trueModel.Updater),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                                    new SqlParameter("@Creater",trueModel.Creater),

            };
            string sql = "Update OA_Shejijijian Set [FirmId]=@FirmId,[Dingdanleixing]=@Dingdanleixing,[DingdanleixingName]=@DingdanleixingName,[Fengmianneiye]=@Fengmianneiye, [FengmianneiyeName]=@FengmianneiyeName, [Shejileixing]=@Shejileixing,[ShejileixingName]=@ShejileixingName, [Shejilemoney]=@Shejilemoney,[Status]=@Status, [Creater]=@Creater,[CreateTime]=@CreateTime,[Updater]=@Updater,[LastUpdateTime]=@LastUpdateTime 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_Shejijijian GetModelByKeyid(int keyid)
        {
            try
            {
                string condition = "  ";
                if (keyid > 0)
                {
                    condition = " Keyid=" + keyid + "";
                }
                else
                {
                    return null;
                }

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

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

                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_Shejijijian> SelectAllModel(Infrastructure.Query.Query query)
        {
            return _dataBase.SelectModel<Model.OA_Shejijijian>(" * ", " OA_Shejijijian ") as IList<Model.OA_Shejijijian>;//执行查询
        }

        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Shejijijian> GetModelByformid(Guid FirmId, string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status)
        {
            string query = " FirmId = '" + FirmId + "'";
            if (!string.IsNullOrEmpty(Dingdanleixing))
            {
                query += " and  Dingdanleixing = '" + Dingdanleixing + "'";
            }
            if (!string.IsNullOrEmpty(Fengmianneiye))
            {
                query += " and  Fengmianneiye = '" + Fengmianneiye + "'";
            }
            if (!string.IsNullOrEmpty(Shejileixing))
            {
                query += " and  Shejileixing = '" + Shejileixing + "'";
            }
            if (Status.HasValue && Status > 0)
            {
                query += " and  Status = " + Status + "";
            }

            return _dataBase.SelectModel<Model.OA_Shejijijian>(" * ", " OA_Shejijijian ", query) as IList<Model.OA_Shejijijian>;//执行查询
        }


        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Shejijijian> 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_Shejijijian>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
        }

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


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

 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -2786,6 +2786,7 @@
    <Content Include="Pages\work\OA_DocumentDetail.aspx" />
    <Content Include="Pages\work\OA_DocumentDicAdd.aspx" />
    <Content Include="Pages\work\OA_DocumentDicDetail.aspx" />
    <Content Include="Pages\work\OA_DocumentJuese.aspx" />
    <Content Include="Pages\work\OA_DocumentDicList.aspx" />
    <Content Include="Pages\work\OA_DocumentList.aspx" />
    <Content Include="Pages\work\BaoxiaoReplyAdd.aspx" />
@@ -9044,6 +9045,13 @@
    <Compile Include="Pages\work\OA_DocumentDicDetail.aspx.designer.cs">
      <DependentUpon>OA_DocumentDicDetail.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\work\OA_DocumentJuese.aspx.cs">
      <DependentUpon>OA_DocumentJuese.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\work\OA_DocumentJuese.aspx.designer.cs">
      <DependentUpon>OA_DocumentJuese.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\work\OA_DocumentDicList.aspx.cs">
      <DependentUpon>OA_DocumentDicList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

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

@@ -10,7 +10,7 @@
    <link href="../../Styles/changes.css" rel="stylesheet" type="text/css" />
    <link href="../../Styles/ParticularWQJ.css" rel="stylesheet" type="text/css" />
    <script src="../../js/Inquiry/Inquiry.js?v=157" type="text/javascript"></script>
    <script src="../../js/business/Order.js?v=45" type="text/javascript"></script>
    <script src="../../js/business/Order.js?v=46" type="text/javascript"></script>
    <!--前台页面end-->
    <script type="text/javascript" language="javascript">


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

@@ -186,6 +186,19 @@
            var url = "/Pages/business/Waixiefukuanshenqing.aspx?id=" + orderId + "&&orderno=" + orderno;
            top.Dialog.open({ URL: url, Title: "外协付款申请", Height: 600, Width: 580 });
        }




        function showProgress() {
            document.getElementById('progressBar').style.display = 'block';
           
          
                setTimeout(function () {
                    document.getElementById('progressBar').style.display = 'none';
                }, 5000); // 10000毫秒等于10秒
          
        }
    </script>
    <style type="text/css">
        .tableStyleXS th { padding: 1px 0 1px 3px; background-image:none; border-bottom:1px solid #CCC; }
@@ -331,6 +344,11 @@
                    <td> </td>
                    <td>
                        <asp:button id="btn_Search" text="查询" runat="server" />&nbsp;<input type="button" value='重置' onclick='document.body.innerHTML="";window.location=window.location;' />

                           <asp:Button ID="Button1" Text="导出" OnClientClick="showProgress();return true;" runat="server" OnClick="btn_Daochu_Click" />
                        <div id="progressBar" style="display:none; position:fixed; top:50%; left:50%; transform:translate(-50%, -50%);border:1px solid black;height:50px;background-color:azure;">
    正在导出Excel文件，请稍候...
</div>
                        <input type="hidden" id='txtCommission' runat="server" />
                    </td>
                </tr>

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

@@ -28,6 +28,10 @@
using CY.Infrastructure.Common;
using CY.BLL;
using CY.WebForm.Pages.common;
using System.IO;
using CY.Infrastructure.Query;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;

namespace CY.WebForm.Pages.business
{
@@ -780,6 +784,126 @@
            return isCan;
        }


        //查询事件
        protected void btn_Daochu_Click(object src, EventArgs e)
        {

            byte[] fileBytes = ExportToExcel();
            if (fileBytes != null)
            {
                Response.Clear();
                Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                Response.AppendHeader("Content-Disposition", "attachment; filename=订单导出.xlsx");
                Response.BinaryWrite(fileBytes);
                Response.End();
            }
            else
            {
                // 处理导出失败的情况
                Response.Write("导出失败，请稍后重试！");
            }

        }

        public byte[] ExportToExcel()
        {
            byte[] bt = null;
            try
            {
                Pagination pa = new Pagination();
                pa.PageSize = 500;
                pa.PageIndex = 1;

                Dictionary<int, object> searchParam = new Dictionary<int, object>();

                SetParamValue(searchParam, 1, CurrentUser.MemberId);
                SetParamValue(searchParam, 2, this.txtOrderId.Value.Trim());
                SetParamValue(searchParam, 3, this.txtCustormerName.Value.Trim());
                SetParamValue(searchParam, 4, this.txtBeginData.Value.Trim());
                SetParamValue(searchParam, 5, this.txtEndDate.Value.Trim());
                SetParamValue(searchParam, 6, this.selPrintTypes.Value);
                SetParamValue(searchParam, 7, this.selOrderTypes.Value);
                SetParamValue(searchParam, 8, this.selOrderStates.Value);
                SetParamValue(searchParam, 9, this.selPayStates.Value);
                SetParamValue(searchParam, 10, this.txtCreaterName.Value.Trim());
                SetParamValue(searchParam, 11, this.selCustormerLevels.Value);
                SetParamValue(searchParam, 12, this.selCustormerManager.Value);
                SetParamValue(searchParam, 13, this.selBusinessManager.Value);
                SetParamValue(searchParam, 14, this.selPayType.SelectedValue);
                SetParamValue(searchParam, 15, this.selReturnvisit.SelectedValue);
                SetParamValue(searchParam, 16, this.selAppraise.SelectedValue);
                SetParamValue(searchParam, 18, (CurrentUser.StaffId > 0 ? 0 : 0));
                SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
                SetParamValue(searchParam, 20, CurrentUser.StaffId);
                SetParamValue(searchParam, 21, CurrentUser.TrueName);
                SetParamValue(searchParam, 28, this.txtSearchyjname.Value);

                var oA_WorkPlans = _eC_OrderBasicBLL.SelectModelPage_Seller(pa, searchParam);


                // 创建工作簿
                IWorkbook workbook = new XSSFWorkbook();
                ISheet sheet = workbook.CreateSheet("导出数据");

                // 创建表头
                IRow headerRow = sheet.CreateRow(0);
                headerRow.CreateCell(0).SetCellValue("编号");
                headerRow.CreateCell(1).SetCellValue("订单号");
                headerRow.CreateCell(2).SetCellValue("客户名称");
                headerRow.CreateCell(3).SetCellValue("订单来源");
                headerRow.CreateCell(4).SetCellValue("订单类别");
                headerRow.CreateCell(5).SetCellValue("合同序号");
                headerRow.CreateCell(6).SetCellValue("印件名称");
                headerRow.CreateCell(7).SetCellValue("数量");
                headerRow.CreateCell(8).SetCellValue("单位");
                headerRow.CreateCell(9).SetCellValue("订单状态");
                headerRow.CreateCell(10).SetCellValue("收款状态");
                headerRow.CreateCell(11).SetCellValue("付款方式");
                headerRow.CreateCell(12).SetCellValue("金额");
                headerRow.CreateCell(13).SetCellValue("已收款");
                headerRow.CreateCell(14).SetCellValue("未付款");

                // 添加数据
                int rowIndex = 1;
                foreach (var order in oA_WorkPlans)
                {
                    IRow row = sheet.CreateRow(rowIndex++);
                    row.CreateCell(0).SetCellValue((rowIndex - 1).ToString());
                    row.CreateCell(1).SetCellValue(order.SellerOrderId);
                    row.CreateCell(2).SetCellValue(order.BuyerName);
                    row.CreateCell(3).SetCellValue(order.OrderType.Name);
                    row.CreateCell(4).SetCellValue(order.PrintType.PrintName);
                    row.CreateCell(5).SetCellValue(order.Duiyinghetongbianhao);
                    row.CreateCell(6).SetCellValue(order.DocumentName);
                    row.CreateCell(7).SetCellValue(order.OrderExtend.PrintNum.HasValue? order.OrderExtend.PrintNum.Value:0);
                    row.CreateCell(8).SetCellValue(order.yssldw);
                    row.CreateCell(9).SetCellValue(order.OrderStateObj.Name);
                    row.CreateCell(10).SetCellValue(order.PayStateObj.Name);
                    row.CreateCell(11).SetCellValue(order.PayType);
                    row.CreateCell(12).SetCellValue(order.SumPrice.HasValue? order.SumPrice.Value.ToDouble2().Value:0);
                    row.CreateCell(13).SetCellValue(order.TradingSingle.PayedMoney.HasValue ? order.TradingSingle.PayedMoney.Value.ToDouble2().Value : 0);
                    row.CreateCell(14).SetCellValue(order.UnPayedMoney.ToDouble2().Value);


                }

                // 将工作簿写入内存流
                using (var ms = new MemoryStream())
                {
                    workbook.Write(ms);
                    bt = ms.ToArray();
                }
            }
            catch (Exception e)
            {
                bt = null;
                // 记录日志

            }
            return bt;
        }

        /// <summary>
        /// 是否已经操作
        /// </summary>

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

@@ -195,6 +195,15 @@
        protected global::System.Web.UI.WebControls.Button btn_Search;

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

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

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

@@ -57,6 +57,26 @@
            this.txtDM_DocumentType.Value = "";
            this.txtDM_Number.Value = "";
            this.txtDM_DocumentNumber.InnerHtml = "";

            if (!string.IsNullOrEmpty(Request["keyid"]))
            {
                OA_Document m_OA_Document = bll_OA_DocumentBLL.GetModelByKeyid(Request["keyid"].ToInt32());
                if (m_OA_Document != null)
                {
                    this.txtDM_Title.Value = m_OA_Document.DM_Title.ToString2(); ;
                    this.txtDM_Content.Text = m_OA_Document.DM_Content;
                    this.txtDM_ThemeWords.Value = m_OA_Document.DM_ThemeWords;
                    this.txtDM_CCUnit.Text = m_OA_Document.DM_CCUnit;
                    this.txtDM_PrintNumber.Value = m_OA_Document.DM_PrintNumber.HasValue ? m_OA_Document.DM_PrintNumber.Value.ToString() : "";
                    this.txtDM_PostingId.SelectedValue = m_OA_Document.DM_PostingId.HasValue ? m_OA_Document.DM_PostingId.Value.ToString() : "";
                    OA_DocumentDic m_OA_DocumentDic = bll_OA_DocumentDicBLL.GetModelByKeyid(this.txtDM_PostingId.SelectedValue.ToInt32());
                    this.txtDM_PostingFirmName.InnerHtml = m_OA_DocumentDic.ParName;
                    this.txtDM_DocumentType.Value = m_OA_Document.DM_DocumentType;
                    this.txtDM_Number.Value = m_OA_Document.DM_Number.HasValue ? m_OA_Document.DM_Number.Value.ToString() : "";
                    this.txtDM_DocumentNumber.InnerHtml = m_OA_Document.DM_DocumentNumber;
                }
            }
           
        }

        //表单提交
@@ -66,36 +86,75 @@
            {
                DateTime nowTime = DateTime.Now;
                OA_Document m_OA_Document = new OA_Document();
                m_OA_Document.FirmId = CurrentUser.MemberId;
                m_OA_Document.DM_PromulgatedDate = nowTime;
                m_OA_Document.DM_DelTime = nowTime;
                m_OA_Document.DM_PrintTime = nowTime;
                m_OA_Document.DM_PrintStatus = 1;
                m_OA_Document.DM_Status = 1;

                OA_DocumentDic m_OA_DocumentDic = bll_OA_DocumentDicBLL.GetModelByKeyid(this.txtDM_PostingId.SelectedValue.ToInt32());
                m_OA_Document.DM_PostingId = this.txtDM_PostingId.SelectedValue.ToInt32();
                m_OA_Document.DM_PostingName = m_OA_DocumentDic.ParType;
                m_OA_Document.DM_PostingFirmName = m_OA_DocumentDic.ParName;
                m_OA_Document.DM_DocumentType = this.txtDM_DocumentType.Value.ToString2();
                m_OA_Document.DM_Number = this.txtDM_Number.Value.ToInt32();
                m_OA_Document.DM_DocumentNumber = m_OA_DocumentDic.ParType + "(" + DateTime.Now.Year.ToString2() + ")" + "第 " + this.txtDM_Number.Value.ToInt32().Value.ToString("000") + " 号";
                m_OA_Document.DM_Title = this.txtDM_Title.Value.ToString2();
                m_OA_Document.DM_Content = this.txtDM_Content.Text.ToString2();
                m_OA_Document.DM_ThemeWords = this.txtDM_ThemeWords.Value.ToString2();
                m_OA_Document.DM_CCUnit = this.txtDM_CCUnit.Text.ToString2();
                m_OA_Document.DM_PrintNumber = this.txtDM_PrintNumber.Value.ToInt32();
                m_OA_Document.LastUpdateTime = nowTime;
                m_OA_Document.Operator = CurrentUser.ShortName;


                if (bll_OA_DocumentBLL.InsertModel(m_OA_Document))
                if (!string.IsNullOrEmpty(Request["keyid"]))
                {
                    JavaScript.MessageBox("新增成功", this, false, true);
                    InitData();
                    m_OA_Document = bll_OA_DocumentBLL.GetModelByKeyid(Request["keyid"].ToInt32());
                    m_OA_Document.FirmId = CurrentUser.MemberId;
                    m_OA_Document.DM_PromulgatedDate = nowTime;
                    m_OA_Document.DM_DelTime = nowTime;
                    m_OA_Document.DM_PrintTime = nowTime;
                    m_OA_Document.DM_PrintStatus = 1;
                    m_OA_Document.DM_Status = 1;

                    OA_DocumentDic m_OA_DocumentDic = bll_OA_DocumentDicBLL.GetModelByKeyid(this.txtDM_PostingId.SelectedValue.ToInt32());
                    m_OA_Document.DM_PostingId = this.txtDM_PostingId.SelectedValue.ToInt32();
                    m_OA_Document.DM_PostingName = m_OA_DocumentDic.ParType;
                    m_OA_Document.DM_PostingFirmName = m_OA_DocumentDic.ParName;
                    m_OA_Document.DM_DocumentType = this.txtDM_DocumentType.Value.ToString2();
                    m_OA_Document.DM_Number = this.txtDM_Number.Value.ToInt32();
                    //m_OA_Document.DM_DocumentNumber = m_OA_DocumentDic.ParType + "(" + DateTime.Now.Year.ToString2() + ")" + "第 " + this.txtDM_Number.Value.ToInt32().Value.ToString("000") + " 号";
                    m_OA_Document.DM_Title = this.txtDM_Title.Value.ToString2();
                    m_OA_Document.DM_Content = this.txtDM_Content.Text.ToString2();
                    m_OA_Document.DM_ThemeWords = this.txtDM_ThemeWords.Value.ToString2();
                    m_OA_Document.DM_CCUnit = this.txtDM_CCUnit.Text.ToString2();
                    m_OA_Document.DM_PrintNumber = this.txtDM_PrintNumber.Value.ToInt32();
                    m_OA_Document.LastUpdateTime = nowTime;
                    m_OA_Document.Operator = CurrentUser.ShortName;


                    if (bll_OA_DocumentBLL.UpdateModel(m_OA_Document))
                    {
                        JavaScript.MessageBox("修改成功", this, true, true);
                        //InitData();
                    }
                    else
                        JavaScript.MessageBox("修改失败", this);
                }
                else
                    JavaScript.MessageBox("新增失败", this);
                {
                    m_OA_Document.FirmId = CurrentUser.MemberId;
                    m_OA_Document.DM_PromulgatedDate = nowTime;
                    m_OA_Document.DM_DelTime = nowTime;
                    m_OA_Document.DM_PrintTime = nowTime;
                    m_OA_Document.DM_PrintStatus = 1;
                    m_OA_Document.DM_Status = 1;

                    OA_DocumentDic m_OA_DocumentDic = bll_OA_DocumentDicBLL.GetModelByKeyid(this.txtDM_PostingId.SelectedValue.ToInt32());
                    m_OA_Document.DM_PostingId = this.txtDM_PostingId.SelectedValue.ToInt32();
                    m_OA_Document.DM_PostingName = m_OA_DocumentDic.ParType;
                    m_OA_Document.DM_PostingFirmName = m_OA_DocumentDic.ParName;
                    m_OA_Document.DM_DocumentType = this.txtDM_DocumentType.Value.ToString2();
                    m_OA_Document.DM_Number = this.txtDM_Number.Value.ToInt32();
                    m_OA_Document.DM_DocumentNumber = m_OA_DocumentDic.ParType + "(" + DateTime.Now.Year.ToString2() + ")" + "第 " + this.txtDM_Number.Value.ToInt32().Value.ToString("000") + " 号";
                    m_OA_Document.DM_Title = this.txtDM_Title.Value.ToString2();
                    m_OA_Document.DM_Content = this.txtDM_Content.Text.ToString2();
                    m_OA_Document.DM_ThemeWords = this.txtDM_ThemeWords.Value.ToString2();
                    m_OA_Document.DM_CCUnit = this.txtDM_CCUnit.Text.ToString2();
                    m_OA_Document.DM_PrintNumber = this.txtDM_PrintNumber.Value.ToInt32();
                    m_OA_Document.LastUpdateTime = nowTime;
                    m_OA_Document.Operator = CurrentUser.ShortName;


                    if (bll_OA_DocumentBLL.InsertModel(m_OA_Document))
                    {
                        JavaScript.MessageBox("新增成功", this, false, true);
                        InitData();
                    }
                    else
                        JavaScript.MessageBox("新增失败", this);
                }
                

            }
            catch (Exception ex)

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

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>公文基础数据列表</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        //查看
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentDicDetail.aspx?keyid=" + keyid, Title: "公文基础数据明细", Width: 500, Height: 240 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentDicAdd.aspx", Title: "新增公文基础数据", Width: 500, Height: 240 });
        }

        //修改
        function EditModel(keyid) {
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentDicAdd.aspx?keyid=" + keyid, Title: "修改公文基础数据", Width: 500, Height: 240 });
        }

        //删除
        function onDele(keyid) {
            top.Dialog.confirm("确定要删除该数据吗？", function () {
                window.location = "/Pages/work/OA_DocumentJuese.aspx?delete=" + keyid;
            });
        }

        //批量删除
        function onAllDelete() {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
               // deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
                //window.location = "/Pages/work/OA_DocumentJuese.aspx?deleteKeyIds=" + deleteKeyIds + "&&orderkeyid=<%=keyid %>";
                $("#deleteKeyIds").val(deleteKeyIds);
            }
            else {
                deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
               // window.location = "/Pages/work/OA_DocumentJuese.aspx?deleteKeyIds=" + deleteKeyIds + "&&orderkeyid=<%=keyid %>";
                $("#deleteKeyIds").val(deleteKeyIds);
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent">
        <div class="box_tool_min ">
            <div class="center">
                <div class="left">
                    <div class="right">
                        <div class="padding_top5 padding_left10">
                           
                            <%--<a href="javascript:;" onclick="onAllDelete()" menu_member_case_id="case_onBaocunJuese" menu_member_case_name="保存角色"><span class="icon_add">保存角色</span></a>--%>

                            <asp:Button ID="btn_submit" runat="server" OnClientClick="onAllDelete()" OnClick="btn_submit_form" Text="提交" />
                            <input type="hidden" id="deleteKeyIds"  name="deleteKeyIds" runat="server" />
                            <div class="clear">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="clear">
            </div>
        </div>
        <div>
            <asp:Repeater ID="RepClientList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle">
                        <tr>
                            <th width="25">
                            </th>
                            <th width="30" style="text-align: center">
                                编号
                            </th>
                            <th style="text-align: center">
                                名称
                            </th>
                            
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td>
                            <input type="checkbox" value='<%#Eval("Keyid")%>' <%#Eval("ShifouCheck") %> />
                        </td>
                        <td style="text-align: center">
                            <%#Container.ItemIndex + 1 %>
                        </td>
                        <td style="text-align: center">
                            <%#Eval("RoleName")%> 
                        </td>
                        
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            
        </div>
    </div>
    </form>
</body>
</html>

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

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

namespace CY.WebForm.Pages.work
{
    //吴辉
    //公文基础数据列表
    public partial class OA_DocumentJuese : BasePage
    {
        OA_DocumentDicBLL bll_OA_DocumentDicBLL = null;
        OA_DocumentBLL bll_OA_DocumentBLL = null;
        OA_FirmRoleBLL oA_FirmRoleBLL = null;
        public string keyid = "";

        //初始化
        public OA_DocumentJuese()
        {
            bll_OA_DocumentDicBLL = new OA_DocumentDicBLL();
            bll_OA_DocumentBLL = new OA_DocumentBLL();
            oA_FirmRoleBLL = new OA_FirmRoleBLL();
        }

        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {
            
            if (!IsPostBack)
            {
                BindList();
            }
            if (Request["delete"] != null)
            {
                OA_DocumentDic model = bll_OA_DocumentDicBLL.GetModelByKeyid(Request["delete"].ToInt32());
                if (model != null && model.Keyid != null)
                {
                    bll_OA_DocumentDicBLL.DeleteModel(model);
                    JavaScript.MessageBox("删除成功", this);
                    Response.Redirect("/Pages/work/OA_DocumentJuese.aspx");
                }
                else
                    JavaScript.MessageBox("删除失败", this);
            }

            if (Request["deleteKeyIdsfsdfdsfsdfd"] != null)
            {
                var orderkeyid = Request["orderkeyid"];
                OA_Document m_OA_Document = bll_OA_DocumentBLL.GetModelByKeyid(Request["orderkeyid"].ToInt32());
                m_OA_Document.Jusequanxian = Request["deleteKeyIds"].ToString();
               if(bll_OA_DocumentBLL.UpdateModel(m_OA_Document))
                {
                    JavaScript.MessageBox("保存成功", this, true, false);
                }
                else
                {
                    JavaScript.MessageBox("保存失败", this);
                    return;
                }

                //List<int> deleteKeyIdList = new List<int>();
                //string deleteKeyIds = Request["deleteKeyIds"].ToString().Trim(',');
                //string[] keyIdArry = deleteKeyIds.Split(',');
                //foreach (string keyId in keyIdArry)
                //{
                //    OA_DocumentDic model = bll_OA_DocumentDicBLL.GetModelByKeyid(keyId.ToInt32());
                //    if (model.Keyid != null && model != null)
                //        bll_OA_DocumentDicBLL.DeleteModel(model);
                //    else
                //    {
                //        JavaScript.MessageBox("删除失败", this);
                //        return;
                //    }
                //}

                //Response.Redirect("/Pages/work/OA_DocumentJuese.aspx");
            }
        }

        //绑定数据
        private void BindList()
        {
            keyid = Request["keyid"];
            if (!string.IsNullOrEmpty(Request["keyid"]))
            {
                OA_Document m_OA_Document = bll_OA_DocumentBLL.GetModelByKeyid(Request["keyid"].ToInt32());
                if (m_OA_Document != null)
                {
                 var Jusequanxian =   m_OA_Document.Jusequanxian;
                    var oA_FirmRoles = oA_FirmRoleBLL.SelectList(CurrentUser.MemberId).Where(x=>x.IsUsed == true);
                    foreach(var oA_FirmRole in oA_FirmRoles)
                    {
                        if (!string.IsNullOrEmpty(Jusequanxian))
                        {
                           var  Jusequanxians = Jusequanxian.Split(',');
                           if(Jusequanxians.Count(x => x == oA_FirmRole.Keyid.Value.ToString()) > 0)
                            {
                                oA_FirmRole.ShifouCheck = "checked=\"checked\"";
                            }
                        }
                        


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


               
        }


        //表单提交
        protected void btn_submit_form(object sender, EventArgs e)
        {
            try
            {
                
                OA_Document m_OA_Document = bll_OA_DocumentBLL.GetModelByKeyid(Request["keyid"].ToInt32());
                m_OA_Document.Jusequanxian = deleteKeyIds.Value;
                if (bll_OA_DocumentBLL.UpdateModel(m_OA_Document))
                {
                    JavaScript.MessageBox("保存成功", this, true, false);
                }
                else
                {
                    JavaScript.MessageBox("保存失败", this);
                    return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("保存失败", this);
            }
        }


    }
}

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

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

namespace CY.WebForm.Pages.work
{


    public partial class OA_DocumentJuese
    {

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

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

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

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

@@ -11,9 +11,20 @@
            OpenSmallWindowByUrlUseSize("/Pages/work/OA_DocumentDetail.aspx?keyid=" + keyid, 1080, 780);
        }

        //查看
        function Juesequanxian(keyid) {
            
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentJuese.aspx?keyid=" + keyid, Title: "分配公文查看角色", Width: 850, Height: 600 });
        }

        //添加
        function addModel() {
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentAdd.aspx", Title: "新增公文管理", Width: 850, Height: 600 });
        }

        //添加
        function editModel(keyid) {
            top.Dialog.open({ URL: "/Pages/work/OA_DocumentAdd.aspx?keyid=" + keyid, Title: "修改公文管理", Width: 850, Height: 600 });
        }

        //删除
@@ -193,7 +204,12 @@
                            <%#Eval("DM_PrintStatus").ToString() == "1" ? "未打印" : "已打印"%>
                        </td>
                        <td class="Operate " style="text-align: center">
                            <span menu_member_case_id="case_OnDetail" menu_member_case_name="查看" onclick="onEdit('<%#Eval("Keyid")%>')">查看</span> <span menu_member_case_id="case_OnDele" menu_member_case_name="删除" onclick="onDele('<%#Eval("Keyid")%>')">删除</span>
                            <span menu_member_case_id="case_OnDetail" menu_member_case_name="查看" onclick="onEdit('<%#Eval("Keyid")%>')">查看</span>    <span menu_member_case_id="case_OnUpdate" menu_member_case_name="修改" onclick="editModel('<%#Eval("Keyid")%>')">修改</span>   <span menu_member_case_id="case_OnDele" menu_member_case_name="删除" onclick="onDele('<%#Eval("Keyid")%>')">删除</span>

                             <span menu_member_case_id="case_Juesequanxian" menu_member_case_name="查看角色权限" onclick="Juesequanxian('<%#Eval("Keyid")%>')">查看角色权限</span>


                            
                        </td>
                    </tr>
                </ItemTemplate>

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

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

namespace CY.WebForm.Pages.work {
    
    
    public partial class OA_DocumentList {
        
namespace CY.WebForm.Pages.work
{


    public partial class OA_DocumentList
    {

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

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

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

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

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

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

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

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

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

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

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

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

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

 CY_ECommercePlatform/CY.WebForm/js/business/Order.js

@@ -546,7 +546,7 @@
            document.getElementById('txtDocumentName').value = document.getElementById('txtDocumentNameHide').value;
        }
       
        $("#Duiyinghetongbianhao").hide();
      
    }
    else {
        document.getElementById('tbFacing').style.display = '';
@@ -556,6 +556,12 @@
        document.getElementById('selVerifyWay321').style.display = '';
        document.getElementById('selVerifyWay1234').style.display = '';
        document.getElementById('selVerifyWay4321').style.display = '';
       
    }

    if (sel.value == 37 || sel.value == 38) {
        $("#Duiyinghetongbianhao").hide();
    } else {
        $("#Duiyinghetongbianhao").show();
    }
}