Web/ReportMgr/AdBuildingDailyReport.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Transactions;
using RhData;
using CityMgr;
using CityMgr.Base;
using CityMgr.Report;

namespace WebApp.ReportMgr
{
    public partial class AdBuildingDailyReport : System.Web.UI.Page
    {
        protected LxUserContext m_uct = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            m_uct = Session["UserContext"] as LxUserContext;
            if (m_uct == null)
                Response.Redirect("../Login.aspx");

            LxCommon.CheckAuth("RPT004");
            AjaxPro.Utility.RegisterTypeForAjax( typeof(LxAjaxEntityHelpper));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxAjaxFunction));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxEasyUITableHelperr));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxEasyUITreeNode));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(AdBuildingDailyReport));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxUserContext));
        }

        /// <summary>
        /// 获取数据
        /// </summary>
        [AjaxPro.AjaxMethod]
        public string GetData(string strDateCode, string strSbDeptCode)
        {
            string sql = "";
            sql = "select ABRI.gId as gId,RI.cRptItemCode as RptItemCode,RI.cRptItemName as RptItemName,RI.cItemUnit as ItemUnit,ABRI.cWgName as cWgName,ABRI.cLjxName as cLjxName,ABRI.cName as cName,ABRI.iAddNum as iAddNum,"
                + "ABRI.iDisrepairNum as iDisrepairNum,ABRI.gId as LocatePics,ABRI.gId as Handle "
                + " from AdBuildingDailyReport ABDR inner join AdBuildingReportItem ABRI on ABDR.cDateCode=ABRI.cDateCode and ABDR.cSbrDeptCode=ABRI.cSbrDeptCode  "
                + " inner join ReportItem RI on  ABRI.cRptItemCode=RI.cRptItemCode where ABDR.cDateCode='" + Sql.Format(strDateCode) + "' and ABDR.cSbrDeptCode='" + Sql.Format(strSbDeptCode) + "' order by RptItemCode";

            using (DataTable data = Sql.ExecuteDataset(CommandType.Text, sql).Tables[0])
            {
                return LxEasyUITableHelperr.DataToJson(data);
            }
        }

        /// <summary>
        /// 广告建筑垃圾日报表0上报
        /// </summary>
        /// <param name="AdDailyRpt">主报表对象</param>
        [AjaxPro.AjaxMethod]
        public void ZeroSubmit(LxAdBuildingDailyReport AdDailyRpt)
        {
            LxUserContext Uct = Session["UserContext"] as LxUserContext;