From d28cd2993df45bda3b04d93ad4abae6f7a053448 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 27 三月 2025 09:14:46 +0800
Subject: [PATCH] 20250116打印标签需求
---
CY_ECommercePlatform/CY.Model/CY.Model.csproj | 1
CY_ECommercePlatform/CY.WebForm/images/jihuageshi/上传考试标签.xlsx | 0
CY_ECommercePlatform/CY.BLL/CY.BLL.csproj | 1
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx | 270 ++++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.designer.cs | 152 ++++
CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShiJuanBiaoQianDAL.cs | 312 ++++++++++
CY_ECommercePlatform/CY.BLL/OA/OA_ShiJuanBiaoQianBLL.cs | 205 ++++++
CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj | 17
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.cs | 307 +++++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx | 98 +++
CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj | 1
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.designer.cs | 53 +
CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.cs | 122 +++
CY_ECommercePlatform/AbstractFactory/Factory.cs | 6
CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj | 1
CY_ECommercePlatform/CY.Model/OA/OA_ShiJuanBiaoQian.cs | 211 ++++++
CY_ECommercePlatform/CY.IDAL/OA/IOA_ShiJuanBiaoQianDAL.cs | 47 +
17 files changed, 1,804 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/AbstractFactory/Factory.cs b/CY_ECommercePlatform/AbstractFactory/Factory.cs
index 22d378c..4ebce72 100644
--- a/CY_ECommercePlatform/AbstractFactory/Factory.cs
+++ b/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>
/// 寮�绁ㄧ敵璇�
diff --git a/CY_ECommercePlatform/CY.BLL/CY.BLL.csproj b/CY_ECommercePlatform/CY.BLL/CY.BLL.csproj
index 9234b7c..5755ef1 100644
--- a/CY_ECommercePlatform/CY.BLL/CY.BLL.csproj
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_ShiJuanBiaoQianBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_ShiJuanBiaoQianBLL.cs
new file mode 100644
index 0000000..a07dd41
--- /dev/null
+++ b/CY_ECommercePlatform/CY.BLL/OA/OA_ShiJuanBiaoQianBLL.cs
@@ -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);
+ }
+
+ }
+}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj b/CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj
index c4dc6f2..2ff6fdc 100644
--- a/CY_ECommercePlatform/CY.IDAL/CY.IDAL.csproj
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.IDAL/OA/IOA_ShiJuanBiaoQianDAL.cs b/CY_ECommercePlatform/CY.IDAL/OA/IOA_ShiJuanBiaoQianDAL.cs
new file mode 100644
index 0000000..3a062e8
--- /dev/null
+++ b/CY_ECommercePlatform/CY.IDAL/OA/IOA_ShiJuanBiaoQianDAL.cs
@@ -0,0 +1,47 @@
+锘縰sing 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);
+ }
+}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.Model/CY.Model.csproj b/CY_ECommercePlatform/CY.Model/CY.Model.csproj
index 70093ce..f81b056 100644
--- a/CY_ECommercePlatform/CY.Model/CY.Model.csproj
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.Model/OA/OA_ShiJuanBiaoQian.cs b/CY_ECommercePlatform/CY.Model/OA/OA_ShiJuanBiaoQian.cs
new file mode 100644
index 0000000..04c5f63
--- /dev/null
+++ b/CY_ECommercePlatform/CY.Model/OA/OA_ShiJuanBiaoQian.cs
@@ -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
+ }
+}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj b/CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj
index 8ab96bf..2d0eda0 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/CY.SQLDAL.csproj
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShiJuanBiaoQianDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShiJuanBiaoQianDAL.cs
new file mode 100644
index 0000000..45302d8
--- /dev/null
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShiJuanBiaoQianDAL.cs
@@ -0,0 +1,312 @@
+锘縰sing 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;
+ }
+ }
+}
+
diff --git a/CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj b/CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj
index 830deba..65be3eb 100644
--- a/CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx
new file mode 100644
index 0000000..c40f701
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx
@@ -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> --%>
+ <a href="javascript:;" onclick="onDeles()" ><span class="icon_edit" >鎵归噺鎵撳嵃</span></a>
+ <a href="javascript:;" onclick="onAllDelete()" ><span class="icon_delete">鎵归噺鍒犻櫎</span></a>
+
+
+ <a class="aaddModel" href="/images/jihuageshi/涓婁紶鑰冭瘯鏍囩.xlsx"><span class="icon_arr1">涓婁紶妯℃澘</span></a>
+ <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()" />
+
+
+ <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>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.cs
new file mode 100644
index 0000000..21434b6
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.cs
@@ -0,0 +1,307 @@
+锘縰sing 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;
+ // 鍙互娣诲姞鍏朵粬绫诲瀷鐨刢ase
+ }
+
+ return cellvalue;
+ }
+
+
+ }
+}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.designer.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.designer.cs
new file mode 100644
index 0000000..c4349a4
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianList.aspx.designer.cs
@@ -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;
+ }
+}
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx
new file mode 100644
index 0000000..6e7875c
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx
@@ -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;" >
+
+ </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")%> <%#Eval("Kemu")%> <%#Eval("Da")%> + <%#Eval("Xiao")%>
+ </td>
+
+
+
+ </tr>
+
+
+
+ </table>
+ <%#(Container.ItemIndex != (countss-1))?"<div class=\"page-break\"></div>":"" %>
+
+ </ItemTemplate>
+ </asp:Repeater>
+
+
+
+ </form>
+</body>
+</html>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.cs
new file mode 100644
index 0000000..7cbb8f2
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.cs
@@ -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 鍚村磶鍧� 淇敼缁ф壙绫讳负榛樿绫籔age浣挎樉绀轰俊鎭笉鍙楃櫥褰曟帶鍒�
+*
+*
+*
+*
+*
+*
+*/
+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;
+ }
+
+
+
+
+ }
+}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.designer.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.designer.cs
new file mode 100644
index 0000000..b95a831
--- /dev/null
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShiJuanBiaoQianPrint.aspx.designer.cs
@@ -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;
+ }
+}
diff --git "a/CY_ECommercePlatform/CY.WebForm/images/jihuageshi/\344\270\212\344\274\240\350\200\203\350\257\225\346\240\207\347\255\276.xlsx" "b/CY_ECommercePlatform/CY.WebForm/images/jihuageshi/\344\270\212\344\274\240\350\200\203\350\257\225\346\240\207\347\255\276.xlsx"
new file mode 100644
index 0000000..80f5293
--- /dev/null
+++ "b/CY_ECommercePlatform/CY.WebForm/images/jihuageshi/\344\270\212\344\274\240\350\200\203\350\257\225\346\240\207\347\255\276.xlsx"
Binary files differ
--
Gitblit v1.9.1