Hl.WebMain/AdmPage/BaseBizManage/ServiceInfoEdit-VehicleInfoTips.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Hl.Code;
using Hl.WebMain.Common;

namespace Hl.WebMain.AdmPage.BaseBizManage
{
    public partial class ServiceInfoEdit_VehicleInfoTips : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string fields = "BizServiceInfoHistory.DispatchReportNote  As BgaoNote"
                          + ",BizCustomerLinkManInfo.Note              As LmanNote"
                          + ",BizCustomerInfo.CustomerNote             As KehuNote"
                          + "";
            string tbJoin = "Left Join BizCustomerLinkManInfo On BizCustomerLinkManInfo.Id=BizServiceInfoHistory.LinkManId "
                          + "Left Join BizCustomerInfo        On BizCustomerInfo.Id=BizCustomerLinkManInfo.CustomerId";
            string swhere = "And VehicleId=" + DataConvert.ToInt(Request["VehicleId"], 0) + " ";
            DataTable mDt = DataBll.BizServiceInfoHistory.Select("", fields, tbJoin, swhere, "Order By BizServiceInfoHistory.Id DESC").Tables[0];
            if (mDt.Rows.Count > 0)
            {
                htmlKehuNote.Value = mDt.Rows[0]["KehuNote"].ToString();
                htmlLmanNote.Value = mDt.Rows[0]["LmanNote"].ToString();
                htmlBgaoNote.Value = mDt.Rows[0]["BgaoNote"].ToString();
            }
        }
    }
}