订单打印能查看合同

username@email.com

2025-02-07 6bb722be12f95d3f55a141555be2c79b8fcaeca9

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

@@ -30,6 +30,8 @@
using CY.BLL;
using CY.Model.Inquiry;
using CY.BLL.Sys;
using CY.SQLDAL;
using System.Data.SqlClient;

namespace CY.WebForm.Pages.business
{
@@ -39,7 +41,9 @@
    public partial class OrderDeatil : BasePage
    {
        EC_OrderBasicBLL _eC_OrderBasicBLL = new EC_OrderBasicBLL();

        Sys_DictionaryBLL _sys_DictionaryBLL = new Sys_DictionaryBLL();//字典业务逻辑操作类对象
        public int ContractCount = 0;
        public string BuyerId = "";
        /// <summary>
        /// 页面加载事件
        /// </summary>
@@ -140,6 +144,33 @@
            {
                _inquiryCommonModel.PrintDemand = _inquiryCommonModel.PrintCountName + "，" + _inquiryCommonModel.PrintDemand;
            }
            var sys_Dictionarie = _sys_DictionaryBLL.GetDataByType("印刷单位").FirstOrDefault(x=>x.MeanValue == _inquiryCommonModel.Unit);
            if (sys_Dictionarie != null)
            {
                _eC_OrderBasic.UnitName = sys_Dictionarie.Name;
            }
            BuyerId = _eC_OrderBasic.BuyerId.ToString();
            //查询客户是否有合同
            Database DC = new Database();
            try
            {

                string sqlStr = string.Format("select  count(*) from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}'", _eC_OrderBasic.BuyerId);
                SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                ContractCount = (int)myCmd.ExecuteScalar();
            }
            catch (Exception)
            {

                ContractCount = 0;
            }
            finally
            {
                if (DC.Connection.State != System.Data.ConnectionState.Closed)
                    DC.Connection.Close();
            }


            rptOrder.DataSource = new List<EC_OrderBasic>() { _eC_OrderBasic };
            rptOrder.DataBind();
            rptAccpteWay.DataSource = "自提".Equals(_inquiryCommonModel.DeliveryModeName) ? null : new List<EC_AcceptWayByOrder>() { _eC_AcceptWayByOrder };