20250116打印标签需求

username@email.com

2025-03-27 d28cd2993df45bda3b04d93ad4abae6f7a053448

20250116打印标签需求

 CY_ECommercePlatform/AbstractFactory/Factory.cs

@@ -270,6 +270,7 @@
            OBJECT_PATH.Add(DALInterface.IOA_ShejijijianDAL, "OA_ShejijijianDAL");
            OBJECT_PATH.Add(DALInterface.IOA_DeliverPlanPaicheDAL, "OA_DeliverPlanPaicheDAL");
            OBJECT_PATH.Add(DALInterface.IOA_DriverRecordDAL, "OA_DriverRecordDAL");
            OBJECT_PATH.Add(DALInterface.IOA_ShiJuanBiaoQianDAL, "OA_ShiJuanBiaoQianDAL");
            OBJECT_PATH.Add(DALInterface.IOA_KaipiaonewDAL, "OA_KaipiaonewDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderDAL, "CoreCmsPlanOrderDAL");
            OBJECT_PATH.Add(DALInterface.ICoreCmsPlanOrderItemDAL, "CoreCmsPlanOrderItemDAL");
@@ -936,6 +937,11 @@
        /// </summary>
        IOA_DriverRecordDAL = 1942,

        /// <summary>
        /// è¯•å·æ ‡ç­¾
        /// </summary>
        IOA_ShiJuanBiaoQianDAL = 1943,


        /// <summary>
        /// å¼€ç¥¨ç”³è¯·

 CY_ECommercePlatform/CY.BLL/CY.BLL.csproj

@@ -184,6 +184,7 @@
    <Compile Include="OA\OA_PropertyManageBLL.cs" />
    <Compile Include="OA\OA_PropertyRecordBLL.cs" />
    <Compile Include="OA\OA_ShejijijianBLL.cs" />
    <Compile Include="OA\OA_ShiJuanBiaoQianBLL.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_ShiJuanBiaoQianBLL.cs

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

/**  
* OA_ShiJuanBiaoQianBLL.cs
*
* åŠŸ èƒ½ï¼š åˆä½œå®¢æˆ·ä¸šåŠ¡é€»è¾‘ç±»
* ç±» åï¼š OA_ShiJuanBiaoQianBLL
*
* 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_ShiJuanBiaoQianBLL
    {
        IOA_ShiJuanBiaoQianDAL _IOA_ShiJuanBiaoQianDAL = null;

        /// <summary>
        /// åˆå§‹åŒ–构造
        /// </summary>
        public OA_ShiJuanBiaoQianBLL()
        {
            //获取OA_ShiJuanBiaoQian DAL实现
            _IOA_ShiJuanBiaoQianDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShiJuanBiaoQianDAL) as IOA_ShiJuanBiaoQianDAL;


        }

        /// <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_ShiJuanBiaoQian m_OA_ShiJuanBiaoQian)
        {
            try
            {

                return _IOA_ShiJuanBiaoQianDAL.InserModel(m_OA_ShiJuanBiaoQian);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// ä¿®æ”¹é€è´§å®‰æŽ’
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool UpdateModel(CY.Model.OA_ShiJuanBiaoQian m_OA_ShiJuanBiaoQian)
        {
            try
            {
                return _IOA_ShiJuanBiaoQianDAL.UpdateModel(m_OA_ShiJuanBiaoQian);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// èŽ·å–全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public IEnumerable<OA_ShiJuanBiaoQian> GetModelList()
        {
            Query query = new Query();
            return _IOA_ShiJuanBiaoQianDAL.SelectAllModel(query);
        }


        /// <summary>
        /// æ ¹æ®formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShiJuanBiaoQian> GetModelByformid(Guid formid)
        {

            return _IOA_ShiJuanBiaoQianDAL.GetModelByformid(formid);
        }


        /// <summary>
        /// æ ¹æ®ids获得信息
        /// </summary>
        /// <param name="ids">ids</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShiJuanBiaoQian> GetModelByids(string ids)
        {

            return _IOA_ShiJuanBiaoQianDAL.GetModelByids(ids);
        }

        /// <summary>
        /// èŽ·å–全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public OA_ShiJuanBiaoQian GetModelByKeyid(Guid? keyid)
        {

            return _IOA_ShiJuanBiaoQianDAL.GetModelByKeyid(keyid);
        }

        /// <summary>
        /// åˆ é™¤åˆä½œå®¢æˆ·
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool DeleteModel(CY.Model.OA_ShiJuanBiaoQian rType)
        {
            try
            {
                _IOA_ShiJuanBiaoQianDAL.DeleteModel(rType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// æŸ¥è¯¢åˆä½œå®¢æˆ·åˆ†é¡µåˆ—表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_ShiJuanBiaoQian> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
  string Bianhao, string Quyu, string Xuexiao, string Nianji, string Kemu )
        {
            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(Bianhao))
                Condition += " and  ok.Bianhao like '%" + Bianhao + "%'";

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

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

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

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


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

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



        /// <summary>
        /// æ ¹æ®ç¼–号批量删除数据
        /// </summary>
        /// <param name="currentOperator">当前操作人</param>
        /// <param name="ids">编号集合</param>
        /// <returns></returns>
        public bool DeleteDataByIds(string currentOperator, params int[] ids)
        {
            return _IOA_ShiJuanBiaoQianDAL.DeleteDataByIds(currentOperator, ids);
        }

    }
}

 CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj

@@ -171,6 +171,7 @@
    <Compile Include="OA\IOA_KaipiaonewDAL.cs" />
    <Compile Include="OA\IOA_KipiaoshenqingDAL.cs" />
    <Compile Include="OA\IOA_ShejijijianDAL.cs" />
    <Compile Include="OA\IOA_ShiJuanBiaoQianDAL.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_ShiJuanBiaoQianDAL.cs

New file
@@ -0,0 +1,47 @@
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_ShiJuanBiaoQianDAL : ICommonDAL, IPaging<OA_ShiJuanBiaoQian>, IGetAllModel<OA_ShiJuanBiaoQian>
    {

        /// <summary>
        /// æ ¹æ®ç¼–号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        OA_ShiJuanBiaoQian GetModelByKeyid(Guid? keyid);

        /// <summary>
        /// æ ¹æ®formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        IEnumerable<OA_ShiJuanBiaoQian> GetModelByformid(Guid formid);


        /// <summary>
        /// æ ¹æ®ids获得信息
        /// </summary>
        /// <param name="ids">ids</param>
        /// <returns></returns>
        IEnumerable<OA_ShiJuanBiaoQian> GetModelByids(string ids);


        /// <summary>
        /// æ ¹æ®ç¼–号批量删除数据
        /// </summary>
        /// <param name="currentOperator">当前操作人</param>
        /// <param name="ids">编号集合</param>
        /// <returns></returns>
        bool DeleteDataByIds(string currentOperator, params int[] ids);
    }
}

 CY_ECommercePlatform/CY.Model/CY.Model.csproj

@@ -254,6 +254,7 @@
    <Compile Include="OA\OA_PropertyRecord.cs" />
    <Compile Include="OA\OA_RemittanceAdvice.cs" />
    <Compile Include="OA\OA_Shejijijian.cs" />
    <Compile Include="OA\OA_ShiJuanBiaoQian.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_ShiJuanBiaoQian.cs

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

        public OA_ShiJuanBiaoQian()
        {
        }
        #region Model
        /// <summary>
        /// id
        /// </summary>
        public int Keyid { get; set; }
        /// <summary>
        ///  FirmId
        /// </summary>
        public Guid FirmId { get; set; }
        
        /// <summary>
        /// ç¼–号
        /// </summary>
        public string Bianhao { get; set; }

        /// <summary>
        /// åŒºåŸŸ
        /// </summary>
        public string Quyu { get; set; }

        /// <summary>
        /// å­¦æ ¡
        /// </summary>
        public string Xuexiao { get; set; }

        /// <summary>
        /// å¹´çº§
        /// </summary>
        public string Nianji { get; set; }

        /// <summary>
        /// ç§‘ç›®
        /// </summary>
        public string Kemu { get; set; }

        /// <summary>
        /// å¤§
        /// </summary>
        public string Da { get; set; }

        /// <summary>
        /// å°
        /// </summary>
        public string Xiao { 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 ("Bianhao".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 3)
            {
                this.Bianhao = isChange ? MyConvert.ConvertToString(value) : Bianhao;
                theValue = this.Bianhao;
            }
            else if ("Quyu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 4)
            {
                this.Quyu = isChange ? MyConvert.ConvertToString(value) : Quyu;
                theValue = this.Quyu;
            }
            else if ("Xuexiao".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 11)
            {
                this.Xuexiao = isChange ? MyConvert.ConvertToString(value) : Xuexiao;
                theValue = this.Xuexiao;
            }
            
            else if ("Nianji".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 5)
            {
                this.Nianji = isChange ? MyConvert.ConvertToString(value) : Nianji;
                theValue = this.Nianji;
            }
            else if ("Kemu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 6)
            {
                this.Kemu = isChange ? MyConvert.ConvertToString(value) : Kemu;
                theValue = this.Kemu;
            }
            else if ("Da".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 7)
            {
                this.Da = isChange ? MyConvert.ConvertToString(value) : Da;
                theValue = this.Da;
            }
            else if ("Xiao".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 8)
            {
                this.Xiao = isChange ? MyConvert.ConvertToString(value) : Xiao;
                theValue = this.Xiao;
            }
           




            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

@@ -199,6 +199,7 @@
    <Compile Include="OA\OA_PropertyManageDAL.cs" />
    <Compile Include="OA\OA_PropertyRecordDAL.cs" />
    <Compile Include="OA\OA_ShejijijianDAL.cs" />
    <Compile Include="OA\OA_ShiJuanBiaoQianDAL.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_ShiJuanBiaoQianDAL.cs

New file
@@ -0,0 +1,312 @@
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_ShiJuanBiaoQianDAL : IOA_ShiJuanBiaoQianDAL
    {

        private Database _dataBase = null;
        #region å¸¸é‡
        /// <summary>
        /// æŸ¥è¯¢ç›®æ ‡ 
        /// </summary>
        const string SELECTTARGET = " t.* ";
        /// <summary>
        /// æŸ¥è¯¢æ¥æº
        /// </summary>
        const string FROMSOUCEBEFORE = " ( select  ok.* " +
            
          " from [OA_ShiJuanBiaoQian] ok  " +

        " where 0=0  ";
        const string FROMSOUCEEND = ") as t  ";
        /// <summary>
        /// åˆ†é¡µé»˜è®¤æŽ’序字段
        /// </summary>
        const string ORDERBY = " CreateTime desc  ";
        #endregion
        public OA_ShiJuanBiaoQianDAL()
        {
            _dataBase = new Database();
        }

        /// <summary>
        /// æ–°å¢ž
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.OA_ShiJuanBiaoQian trueModel = model as Model.OA_ShiJuanBiaoQian;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter CreateTime = null;
            if (trueModel.CreateTime.HasValue)
            {
                CreateTime = new SqlParameter("@CreateTime", trueModel.CreateTime.Value);
            }
            else
            {
                CreateTime = new SqlParameter("@CreateTime", DBNull.Value);
            }

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

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

               //  new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                   new SqlParameter("@Bianhao",string.IsNullOrEmpty(trueModel.Bianhao)?"":trueModel.Bianhao),

                    new SqlParameter("@Quyu",string.IsNullOrEmpty(trueModel.Quyu)?"":trueModel.Quyu),
                     new SqlParameter("@Xuexiao",string.IsNullOrEmpty(trueModel.Xuexiao)?"":trueModel.Xuexiao),
                      new SqlParameter("@Nianji",string.IsNullOrEmpty(trueModel.Nianji)?"":trueModel.Nianji),
                       new SqlParameter("@Kemu",string.IsNullOrEmpty(trueModel.Kemu)?"":trueModel.Kemu),
                        new SqlParameter("@Da",string.IsNullOrEmpty(trueModel.Da)?"":trueModel.Da),
                         new SqlParameter("@Xiao",string.IsNullOrEmpty(trueModel.Xiao)?"":trueModel.Xiao),
                             new SqlParameter("@Creater",string.IsNullOrEmpty(trueModel.Creater)?"":trueModel.Creater),
                             CreateTime,
                                new SqlParameter("@Updater",string.IsNullOrEmpty(trueModel.Updater)?"":trueModel.Updater), 
                                LastUpdateTime,
                                 
                                       

            };
            string sql = "Insert Into OA_ShiJuanBiaoQian ([FirmId],[Bianhao],[Quyu],[Xuexiao], [Nianji], [Kemu],[Da], [Xiao],  [Creater],[CreateTime],[Updater],[LastUpdateTime] )"
                                             + " Values ( @FirmId,@Bianhao,@Quyu, @Xuexiao, @Nianji, @Kemu, @Da, @Xiao,   @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_ShiJuanBiaoQian trueModel = model as Model.OA_ShiJuanBiaoQian;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter CreateTime = null;
            if (trueModel.CreateTime.HasValue)
            {
                CreateTime = new SqlParameter("@CreateTime", trueModel.CreateTime.Value);
            }
            else
            {
                CreateTime = new SqlParameter("@CreateTime", DBNull.Value);
            }

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

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

                  new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@FirmId",trueModel.FirmId),
                   new SqlParameter("@Bianhao",string.IsNullOrEmpty(trueModel.Bianhao)?"":trueModel.Bianhao),

                    new SqlParameter("@Quyu",string.IsNullOrEmpty(trueModel.Quyu)?"":trueModel.Quyu),
                     new SqlParameter("@Xuexiao",string.IsNullOrEmpty(trueModel.Xuexiao)?"":trueModel.Xuexiao),
                      new SqlParameter("@Nianji",string.IsNullOrEmpty(trueModel.Nianji)?"":trueModel.Nianji),
                       new SqlParameter("@Kemu",string.IsNullOrEmpty(trueModel.Kemu)?"":trueModel.Kemu),
                        new SqlParameter("@Da",string.IsNullOrEmpty(trueModel.Da)?"":trueModel.Da),
                         new SqlParameter("@Xiao",string.IsNullOrEmpty(trueModel.Xiao)?"":trueModel.Xiao),
                             new SqlParameter("@Creater",string.IsNullOrEmpty(trueModel.Creater)?"":trueModel.Creater),
                             CreateTime,
                                new SqlParameter("@Updater",string.IsNullOrEmpty(trueModel.Updater)?"":trueModel.Updater),
                                LastUpdateTime,



            };
            string sql = "Update OA_ShiJuanBiaoQian Set [FirmId]=@FirmId,[Bianhao]=@Bianhao,[Quyu]=@Quyu,[Xuexiao]=@Xuexiao, [Nianji]=@Nianji, [Kemu]=@Kemu,[Da]=@Da, [Xiao]=@Xiao , [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_ShiJuanBiaoQian GetModelByKeyid(Guid? keyid)
        {
            try
            {
                string condition = "  ";
                if (!keyid.Equals(Guid.Empty))
                {
                    condition = " Keyid='" + keyid + "'";
                }
                else
                {
                    return null;
                }

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

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

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

        /// <summary>
        /// å…¨éƒ¨æŸ¥è¯¢
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShiJuanBiaoQian> GetModelByformid(Guid FirmId)
        {
            return _dataBase.SelectModel<Model.OA_ShiJuanBiaoQian>(" * ", " OA_ShiJuanBiaoQian ", " FirmId = '" + FirmId + "'") as IList<Model.OA_ShiJuanBiaoQian>;//执行查询
        }


        /// <summary>
        /// å…¨éƒ¨æŸ¥è¯¢
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShiJuanBiaoQian> GetModelByids(string ids)
        {
            return _dataBase.SelectModel<Model.OA_ShiJuanBiaoQian>(" * ", " OA_ShiJuanBiaoQian ", " Keyid in  (" + ids + ")") as IList<Model.OA_ShiJuanBiaoQian>;//执行查询
        }


        /// <summary>
        /// æ ¹æ®ç¼–号批量删除数据
        /// </summary>
        /// <param name="currentOperator">当前操作人</param>
        /// <param name="ids">编号集合</param>
        /// <returns></returns>
        public bool DeleteDataByIds(string currentOperator, params int[] ids)
        {
            return Database.DeleteDataByIds<OA_ShiJuanBiaoQian>(this, currentOperator, ids);
        }



        /// <summary>
        /// åˆ†é¡µæŸ¥è¯¢
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_ShiJuanBiaoQian> 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_ShiJuanBiaoQian>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
        }

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


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


 CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj

@@ -1898,8 +1898,10 @@
    <Content Include="Pages\business\DeliverPlanShifou.aspx" />
    <Content Include="Pages\business\DeliverPlanLishiPrint.aspx" />
    <Content Include="Pages\business\DeliverPlanPaicheZhuyishixiang.aspx" />
    <Content Include="Pages\business\ShiJuanBiaoQianPrint.aspx" />
    <Content Include="Pages\business\OrderSonghuoanchiList.aspx" />
    <Content Include="Pages\business\OrderUpLoadLiuyang.aspx" />
    <Content Include="Pages\business\ShiJuanBiaoQianList.aspx" />
    <Content Include="Pages\business\WaixieOrderPrint.aspx" />
    <Content Include="Pages\business\Waixiefukuanweikaipiao.aspx" />
    <Content Include="Pages\business\Waixiefukuanfukuan.aspx" />
@@ -3433,6 +3435,13 @@
    <Compile Include="Pages\business\DeliverPlanPaicheZhuyishixiang.aspx.designer.cs">
      <DependentUpon>DeliverPlanPaicheZhuyishixiang.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\ShiJuanBiaoQianPrint.aspx.cs">
      <DependentUpon>ShiJuanBiaoQianPrint.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\ShiJuanBiaoQianPrint.aspx.designer.cs">
      <DependentUpon>ShiJuanBiaoQianPrint.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\OrderSonghuoanchiList.aspx.cs">
      <DependentUpon>OrderSonghuoanchiList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
@@ -3446,6 +3455,13 @@
    </Compile>
    <Compile Include="Pages\business\OrderUpLoadLiuyang.aspx.designer.cs">
      <DependentUpon>OrderUpLoadLiuyang.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\ShiJuanBiaoQianList.aspx.cs">
      <DependentUpon>ShiJuanBiaoQianList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="Pages\business\ShiJuanBiaoQianList.aspx.designer.cs">
      <DependentUpon>ShiJuanBiaoQianList.aspx</DependentUpon>
    </Compile>
    <Compile Include="Pages\business\WaixieOrderPrint.aspx.cs">
      <DependentUpon>WaixieOrderPrint.aspx</DependentUpon>
@@ -9326,6 +9342,7 @@
    <None Include="images\admin\Thumbs.db" />
    <None Include="images\Common\admin\Thumbs.db" />
    <Content Include="images\jihuageshi\上传计划订单.xlsx" />
    <Content Include="images\jihuageshi\上传考试标签.xlsx" />
    <None Include="js\ColorBox\colorbox.ai" />
    <None Include="js\ColorBox\colorbox.jquery.json" />
    <None Include="js\ColorBox\component.json" />

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

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>科目设置管理</title>
    <uc:CMSHead ID="CMSHead1" runat="server" />
    <script type="text/javascript">
        ///添加
        function addModel(orderkeyid) {
            top.Dialog.open({ URL: "/Pages/business/PlanOrderAdd.aspx?Keyid='0'&&orderkeyid=" + orderkeyid, Title: "新增计划订单", Width: 1100, Height: 900 });
        }

        //查看
        function onView(keyid) {
            top.Dialog.open({ URL: "/Pages/business/PlanOrderDetail.aspx?Keyid=" + keyid, Title: "查看计划订单", Width: 1100, Height: 900 });
        }

        //修改
        function onEdit(keyid) {
            top.Dialog.open({ URL: "/Pages/business/PlanOrderEdit.aspx?Keyid=" + keyid, Title: "修改计划订单", Width: 1100, Height: 900 });
        }

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

        //查看
        function checkSelFile() {

           
            var oFile = document.getElementById('filesel');
            if (oFile.value == "") {
                alertMsg('没有选择文件');
                return false;

            }
            //debugger;
            //replaceParamVal("deleteKeyIds", "");
            return true;
        }

        //批量删除
        function onAllDelete() {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
                //top.Dialog.alert("请选择要删除的记录", function () {
                //});
                alertMsg("请选择要删除的记录");
                return;
            }
            else {
                deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
               
                top.Dialog.confirm("确定要删除所选记录吗？", function () {
                    window.submitUrl = "/Pages/business/ShiJuanBiaoQianList.aspx"; //设置当前页的提交路径
                    CallServer({ Target: "BatchDelete", ids: deleteKeyIds }, function (data, textStatus) {
                        if ('1' == data) {
                            ReLoad();   //刷新页面
                        } else {
                            alertMsg('-1' == data ? '操作过程中发生异常，请重新操作！' : '操作失败！');

                        }
                    });
                });
            }
        }

        //删除
        function onDeles(orderid) {
            var deleteKeyIds = "";
            $(":checkbox").each(
                function () {
                    if ($(this).is(":checked")) {
                        deleteKeyIds += $(this).val() + ",";
                    }
                }
            )
            if (deleteKeyIds == "") {
                //top.Dialog.alert("请选择要打印的记录", function () {
                //});
                alertMsg("请选择要打印的记录");
                return;
            }

            deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1);
            top.Dialog.open({ URL: "/Pages/business/ShiJuanBiaoQianPrint.aspx?orderids=" + deleteKeyIds, Title: "批量打印送货单", Width: 1200, Height: 900 });


        }
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div id="scrollContent">
        <div class="box1" paneltitle="功能面板" roller="false">
        <table class="TableNewStyle">
            <tr>
               <td class="ali03">
                        å¯¼å…¥æ—¥æœŸï¼š
                    </td>
                    <td style="width: 215px">
                        <input id="txtBeginData" type="text" runat="server" class='date w80px' maxlength='10' />-<input id="txtEndDate" type="text" runat="server" class='date w80px' maxlength='10' />
                    </td>
                 <td class="ali03 " style="padding-left: 20px">
                    ç¼–号：
                </td>
                <td>
                    <input id="txtBianhao" type="text" runat="server" />
                </td>
                  <td class="ali03 " style="padding-left: 20px">
                    ç‰‡åŒºï¼š
                </td>
                <td>
                    <input id="txtQuyu" type="text" runat="server" />
                </td>
                <td class="ali03 " style="padding-left: 20px">
                    å­¦æ ¡ï¼š
                </td>
                <td>
                    <input id="txtXuexiao" type="text" runat="server" />
                </td>
                
                  <td class="ali03 " style="padding-left: 20px">
                    å¹´çº§ï¼š
                </td>
                <td>
                    <input id="txtNianji" type="text" runat="server" />
                </td>
                <td class="ali03 " style="padding-left: 20px">
                    ç§‘目：
                </td>
                 <td>
                    <input id="txtKemu" type="text" runat="server" />
                </td>
            </tr>
            <tr>
               
               
                  
                 
                  
                
                
                <td colspan="12">
                    <asp:Button ID="btn_Register" Text="查询" runat="server" OnClick="btn_Register_Click" />
                    <input type="hidden" id="HideKeyid" runat="server" /> 
                </td>

            </tr>
        </table>
    </div>
        <div class="box_tool_min ">
        <div class="center">
            <div class="left">
                <div class="right">
                    <div class="padding_top5 padding_left10">
                        <%--<a href="javascript:;" onclick="addModel( )" class="aaddModel" ><span class="icon_add">新增计划订单</span></a> &nbsp; &nbsp;--%>
                         <a href="javascript:;" onclick="onDeles()" ><span class="icon_edit" >批量打印</span></a> &nbsp; &nbsp;
                         <a href="javascript:;" onclick="onAllDelete()" ><span class="icon_delete">批量删除</span></a> &nbsp; &nbsp;
                       

                       <a class="aaddModel" href="/images/jihuageshi/上传考试标签.xlsx"><span class="icon_arr1">上传模板</span></a>  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                         <input type="file" id="filesel" name="__hetongFile" keepdefaultstyle="true" runat="server" text="请选择文件" /> 
                         <asp:Button ID="UpdateFileNew" Text="上传" runat="server" OnClick="btn_Submit_Click" OnClientClick="return checkSelFile()" />   &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;

                         
                        <div class="clear">
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="clear">
        </div>
    </div>
        <div>
            <asp:Repeater ID="RepSubjeSetctList" runat="server">
                <HeaderTemplate>
                    <table class="tableStyle ali02" useclick="false" usecheckbox="true" sortmode="true">
                        <tr>
                            <th width="25">
                            </th>
                             <th  width="120">
                                å¯¼å…¥æ—¥æœŸ
                            </th>
                            <th width="30" style="text-align: center">
                                ç¼–号
                            </th>
                            
                            <th>
                                ç‰‡åŒº
                            </th>
                            <th>
                                å­¦æ ¡
                            </th>
                            <th>
                                å¹´çº§
                            </th>
                            <th>
                                ç§‘ç›®
                            </th>
                            <th>
                                å¤§
                            </th>
                              <th>
                                å°
                            </th>
                               
                             

                             
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                           <td>
                            <input type="checkbox"  value='<%#Eval("Keyid")%>' />
                        </td>
                          <td>
                             <%#Eval("CreateTime","{0:yyyy-MM-dd}")%> 
                        </td>
                          <td>
                             <%#Eval("Bianhao")%> 
                        </td>
                      
                        <td>
                            <%#Eval("Quyu")%>
                        </td>
                        <td>
                            <%#Eval("Xuexiao")%> 
                        </td>
                       
                        <td>
                            <%#Eval("Nianji")%>
                        </td>
                        <td>
                            <%#Eval("Kemu")%>
                        </td>
                          <td>
                            <%#Eval("Da")%>
                        </td>
                          <td>
                            <%#Eval("Xiao")%>
                        </td>
                          
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
            <div id="page">
                <uc:UCPager ID="UCPager1" runat="server" />
            </div>
        </div>
    </div>
    </form>
</body>
</html>

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

New file
@@ -0,0 +1,307 @@
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;
using CY.BLL.OA;
using CY.BLL.Sys;
using System.IO;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.Transactions;
using CY.BLL.EC;
using CY.BLL.Inquiry;
using CY.Model.Inquiry;

namespace CY.WebForm.Pages.financial 
{
    public partial class ShiJuanBiaoQianList : BasePage
    {

        OA_ShiJuanBiaoQianBLL _ShiJuanBiaoQianBLL = new OA_ShiJuanBiaoQianBLL();
         

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

            if (Request["Target"] != null && Request["Target"] == "BatchDelete")
            {
                CY.WebForm.cs.WebUtil.DeleteData(_ShiJuanBiaoQianBLL.DeleteDataByIds, CurrentUser.ShortName);//调用通用删除方法
                Response.End();
            }

        }


        /// <summary>
        /// åŠ è½½å…¨éƒ¨æ•°æ®
        /// </summary>
        private void BindList()
        {
            
            Pagination pa = new Pagination();
            pa.PageSize = this.UCPager1.AspNetPager.PageSize;
            pa.PageIndex = this.UCPager1.AspNetPager.CurrentPageIndex;
            
            this.RepSubjeSetctList.DataSource = _ShiJuanBiaoQianBLL.SelectModelPage(pa,CurrentUser.MemberId,this.txtBeginData.Value.Trim(),this.txtEndDate.Value.Trim(),
                this.txtBianhao.Value.Trim(), this.txtQuyu.Value.Trim(), this.txtXuexiao.Value.Trim(), this.txtNianji.Value.Trim(), this.txtKemu.Value.Trim());

            this.RepSubjeSetctList.DataBind();
             UCPager1.AspNetPager.RecordCount = pa.RecordCount;
           
        }

        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

        protected void btn_Register_Click(object sender, EventArgs e)
        {
            BindList();
        }

         

        protected void btn_Submit_Click(object sender, EventArgs e)
        {

            var files = Request.Files;
            if (files.Count <= 0)
                return;

            var file = files[0];
            if (file == null)
            {
                JavaScript.MessageBox("请选择文件", this);
                return;
            }

            //初始化上传参数
            var maxSize = 1024 * 1024 * 5; //上传大小5M

            var fileName = file.FileName;
            var fileExt = Path.GetExtension(fileName).ToLowerInvariant();

            //检查大小
            if (file.ContentLength > maxSize)
            {
               
                JavaScript.MessageBox("上传文件大小超过限制，最大允许上传5M", this);
                return;
            }
          
            string FileTypes = "xlsx";//xls,
            //检查文件扩展名
            if (string.IsNullOrEmpty(fileExt) ||
                Array.IndexOf(FileTypes.Split(','), fileExt.Substring(1).ToLower()) == -1)
            {
                JavaScript.MessageBox("上传文件扩展名是不允许的扩展名,请上传后缀名为：" + FileTypes, this);
                return;
            }
            var lie = new List<OA_ShiJuanBiaoQian>();
            
            using (var fileStream = file.InputStream)
            {
                // ä½¿ç”¨HSSFWorkbook打开.xls格式的文件
                IWorkbook workbook = new XSSFWorkbook(fileStream);

                // èŽ·å–第一个工作表
                ISheet sheet = workbook.GetSheetAt(0);







                // è¿­ä»£å·¥ä½œè¡¨ä¸­çš„所有行
                for (int i = 1; i <= sheet.LastRowNum; i++)
                {
                    var hang = new OA_ShiJuanBiaoQian();
                  


                    IRow row = sheet.GetRow(i);
                    if (row == null) continue; // è·³è¿‡ç©ºè¡Œ


                    ICell cell0 = row.GetCell(0);
                    if (cell0 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "编号不能为空", this); 
                        return;
                    }
                    hang.Bianhao = getcellvalue(cell0);

                    ICell cell1 = row.GetCell(1);
                    if (cell1 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "片区不能为空", this);
                        return;
                    }
                    hang.Quyu = getcellvalue(cell1);

                    ICell cell2 = row.GetCell(2);
                    if (cell2 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "学校不能为空", this);
                        return;
                    }
                    hang.Xuexiao = getcellvalue(cell2);

                    ICell cell3 = row.GetCell(3);
                    if (cell3 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "年级不能为空", this);
                        return;
                    }
                    hang.Nianji = getcellvalue(cell3);

                    ICell cell4 = row.GetCell(4);
                    if (cell4 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "科目不能为空", this);
                        return;
                    }
                    hang.Kemu = getcellvalue(cell4);

                    ICell cell5 = row.GetCell(5);
                    if (cell5 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "大不能为空", this);
                        return;
                    }
                    hang.Da = getcellvalue(cell5);

                    ICell cell6 = row.GetCell(6);
                    if (cell6 == null)
                    {
                        JavaScript.MessageBox("第" + (i + 1) + "小不能为空", this);
                        return;
                    }
                    hang.Xiao = getcellvalue(cell6);
                    lie.Add(hang);

                }
            }
        








              
            


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

              
                if (lie != null && lie.Count > 0)
                {
                    var creater= CurrentUser.ShortName;
                    var creattiem = DateTime.Now;
                    var FirmId = CurrentUser.MemberId;
                    for (int j = 0; j < lie.Count; j++)
                    {

                        lie[j].Creater = creater;
                        lie[j].Updater = creater;
                        lie[j].CreateTime = creattiem;
                        lie[j].LastUpdateTime = creattiem;
                        lie[j].FirmId = FirmId;

                        var id = _ShiJuanBiaoQianBLL.InsertModel(lie[j]);
                            
                            
                       

                    }


                }
                else
                {


                    JavaScript.MessageBox("表格无数据", this);
                    return;
                }
                scope.Complete();
            }



           
          

            JavaScript.MessageBox("上传文件成功", this);
            BindList();

            return;
            }




    /// <summary>
    /// è®¡åˆ’订单上传接口
    /// </summary>
    /// <returns></returns>
    public string getcellvalue(ICell cell)
    {
        string cellvalue = "";
        switch (cell.CellType)
        {
            case CellType.String:
                // Console.WriteLine(cell.StringCellValue);
                cellvalue = cell.StringCellValue.Trim();
                break;
            case CellType.Numeric:
                //Console.WriteLine(cell.NumericCellValue);
                cellvalue = cell.NumericCellValue.ToString().Trim();
                break;
            case CellType.Boolean:
                //Console.WriteLine(cell.BooleanCellValue);
                cellvalue = cell.BooleanCellValue.ToString().Trim();
                break;
            case CellType.Error:
                // Console.WriteLine(cell.ErrorCellValue);
                cellvalue = cell.ErrorCellValue.ToString().Trim();
                break;
            case CellType.Blank:
                    // Console.WriteLine(cell.ErrorCellValue);
                    cellvalue = "";
                    break;
                    // å¯ä»¥æ·»åŠ å…¶ä»–类型的case
            }

        return cellvalue;
    }
       

    }
}

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

New file
@@ -0,0 +1,152 @@
//------------------------------------------------------------------------------
// <自动生成>
//     æ­¤ä»£ç ç”±å·¥å…·ç”Ÿæˆã€‚
//
//     å¯¹æ­¤æ–‡ä»¶çš„更改可能导致不正确的行为，如果
//     é‡æ–°ç”Ÿæˆä»£ç ï¼Œåˆ™æ‰€åšæ›´æ”¹å°†ä¸¢å¤±ã€‚
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.financial
{


    public partial class ShiJuanBiaoQianList
    {

        /// <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>
        /// txtBeginData æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtBeginData;

        /// <summary>
        /// txtEndDate æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtEndDate;

        /// <summary>
        /// txtBianhao æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtBianhao;

        /// <summary>
        /// txtQuyu æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtQuyu;

        /// <summary>
        /// txtXuexiao æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtXuexiao;

        /// <summary>
        /// txtNianji æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtNianji;

        /// <summary>
        /// txtKemu æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputText txtKemu;

        /// <summary>
        /// btn_Register æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button btn_Register;

        /// <summary>
        /// HideKeyid æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden HideKeyid;

        /// <summary>
        /// filesel æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputFile filesel;

        /// <summary>
        /// UpdateFileNew æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Button UpdateFileNew;

        /// <summary>
        /// RepSubjeSetctList æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater RepSubjeSetctList;

        /// <summary>
        /// UCPager1 æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::CY.WebForm.Pages.common.UCPager UCPager1;
    }
}

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

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

<!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>
     <script src="../../js/utils/jquery-1.5.1.min.js" type="text/javascript"></script>
    <script src="../../js/common/util.js" type="text/javascript"></script>
    <script src="../../js/common/KeyBehaviorHook.js" type="text/javascript"></script>
    <script src="../../js/common/Printter.js?v=7" type="text/javascript"></script>
    <script src="../../js/common/LodopFuncs.js" type="text/javascript"></script>
    <link href="../../Styles/ParticularWQJ.css" rel="stylesheet" type="text/css" />
    <!--前台页面start-->
     
    <script type="text/javascript">
        
    </script>
</head>
<body style='padding: 0; margin: 0;' onbeforeprint="OnPrint()" onafterprint="OnPrintOver()">
    <form id="form1" runat="server">
    <input type="hidden" runat="server" id="hideOrderId" />
   
        <object id="LODOP_OB" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA" width="0" height="0">
            <embed id="LODOP_EM" type="application/x-print-lodop" width="0" height="0" pluginspage="/Pages/common/install_lodop32.exe"></embed>
        </object>
        <div id='div_tool' printparams='2,2100,2970,"A4"'>
        </div>
       
            <asp:Repeater runat="server" ID='rptOrder'>
                <ItemTemplate>
          
                     <style type="text/css">
        .dbody { margin: 0; margin-left: auto; margin-right: auto; }
        .dtitle { text-align: center; font-size: 19px; font-weight: bold; margin-top: 10px; margin-bottom: 10px; }
        .dbody table { width: 100%; font-size: 12px; margin-top: 5px;  }  /* border: 1px solid #dddddd;border-top: 1px #999999 solid;*/
        .dbody table th, .dbody table td { font-weight: normal; height: 20px; line-height: 20px; vertical-align: middle;/* border: 1px solid #999999;*/ border-top: 0; }
        .dbody table th { background-color: #E0EDF6; font-weight: bold; }
        .dbody table td { border-left: 0; padding-left:2px; }
        .left {text-align: left; }
        #div_tool { text-align: center; }
    </style>
                    <table border="0" cellpadding="0" cellspacing="0" style="border: 0;width:100%;">
                         
                         <tr>
                        
                        <td class='left'style="width:100%;line-height:150px;"  >
                            &nbsp;
                        </td>
                         
                         
                      
                    </tr>
                    <tr>
                        
                        <td class='left'style="font-size: 120px; text-align: center;width:100%;"  >
                            <%#Eval("Bianhao")%>   <%#Eval("Quyu")%> 
                        </td>
                         
                         
                      
                    </tr>

                        
                       
                     <tr>
                        <td class='left' style="font-size: 120px; text-align: center;width:100%;"  >
                              <%#Eval("Xuexiao")%> 
                        </td>
                         
                       
                       
                        
                    </tr>
   

                          <tr>
                        
                        <td class='left'style="font-size: 36px; text-align: center;width:100%;"  >
                            <%#Eval("Nianji")%> &nbsp;&nbsp;  <%#Eval("Kemu")%> &nbsp;&nbsp;  <%#Eval("Da")%> +   <%#Eval("Xiao")%>
                        </td>
                         
                         
                      
                    </tr>

                     
                       
                   </table>
        <%#(Container.ItemIndex !=  (countss-1))?"<div class=\"page-break\"></div>":"" %> 
 
                </ItemTemplate>
            </asp:Repeater>
            
      
    
    </form>
</body>
</html>

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

New file
@@ -0,0 +1,122 @@
/**  
* ShiJuanBiaoQianPrint.aspx.cs
*
* åŠŸ èƒ½ï¼š è®¢å•è¯¦æƒ…
* ç±» åï¼š ShiJuanBiaoQianPrint
*
* Ver    å˜æ›´æ—¥æœŸ             è´Ÿè´£äºº  å˜æ›´å†…容
* â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€
* V0.01  2013-4-24 13:25      å´å´Žå‡    åˆç‰ˆ
* V0.02  2013-5-15 18:23      å´å´Žå‡    ç¼–辑界面样式
* V0.03  2013-5-15 15:58      å´å´Žå‡    å®Œæˆæ•°æ®èŽ·å–
* V0.04  2013-5-21 14:38      å´å´Žå‡    å¢žåŠ è®¢å•è¿›åº¦
* V0.05  2013-5-23 9:33       å´å´Žå‡    ä¿®æ”¹ç»§æ‰¿ç±»ä¸ºé»˜è®¤ç±»Page使显示信息不受登录控制
*
*
*
*
*
*
*/
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;
using CY.Model.Inquiry;
using CY.BLL.Sys;

namespace CY.WebForm.Pages.business
{
    /// <summary>
    /// è®¢å•è¯¦æƒ…
    /// </summary>
    public partial class ShiJuanBiaoQianPrint : BasePage
    {
        OA_ShiJuanBiaoQianBLL _ShiJuanBiaoQianBLL = null;
        public int countss = 0;

        //初始化
        public ShiJuanBiaoQianPrint()
        {
            _ShiJuanBiaoQianBLL = new OA_ShiJuanBiaoQianBLL();
        }
        /// <summary>
        /// é¡µé¢åŠ è½½äº‹ä»¶
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                switch (Request["Target"])
                {
                    case "GetCommunication":
                        break;
                    default:
                        Page_Load_Default();
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                Response.Write("-1");
            }
            Response.End();
        }

        /// <summary>
        /// é»˜è®¤åŠ è½½äº‹ä»¶æ–¹æ³•
        /// </summary>
        private void Page_Load_Default()
        {
            LoadOrderInfo();
        }

        /// <summary>
        /// åŠ è½½è®¢å•ä¿¡æ¯
        /// </summary>
        private bool LoadOrderInfo()
        {
            //如果是批量打印
            string orderIdStr = Request["orderids"];
           

            

           
            var a_ShiJuanBiaoQians = new List<OA_ShiJuanBiaoQian>();
            if (!string.IsNullOrEmpty(orderIdStr))
            {
              var sss =  _ShiJuanBiaoQianBLL.GetModelByids(orderIdStr.Trim(',')).ToList();
                countss = sss.Count;
                rptOrder.DataSource = sss;
                rptOrder.DataBind();
            }
             

            

          

          




            return true;
        }

       

 
    }
}

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

New file
@@ -0,0 +1,53 @@
//------------------------------------------------------------------------------
// <自动生成>
//     æ­¤ä»£ç ç”±å·¥å…·ç”Ÿæˆã€‚
//
//     å¯¹æ­¤æ–‡ä»¶çš„更改可能导致不正确的行为，如果
//     é‡æ–°ç”Ÿæˆä»£ç ï¼Œåˆ™æ‰€åšæ›´æ”¹å°†ä¸¢å¤±ã€‚
// </自动生成>
//------------------------------------------------------------------------------

namespace CY.WebForm.Pages.business
{


    public partial class ShiJuanBiaoQianPrint
    {

        /// <summary>
        /// Head1 æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlHead Head1;

        /// <summary>
        /// form1 æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;

        /// <summary>
        /// hideOrderId æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlInputHidden hideOrderId;

        /// <summary>
        /// rptOrder æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.WebControls.Repeater rptOrder;
    }
}

 CY_ECommercePlatform/CY.WebForm/images/jihuageshi/ÉÏ´«¿¼ÊÔ±êÇ©.xlsx

Binary files differ