Hl.WebMain/Controls/JsControls/JsItemList.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.Data;
using Hl.Code;
using Hl.WebMain.Common;

namespace Hl.WebMain.Controls.JsControls
{
    public partial class JsItemList : System.Web.UI.Page
    {
        #region "页面加载"

        protected void Page_Load(object sender, EventArgs e)
        {
            string returnInfo = "";
            #region "开始处理"
            string op = DataConvert.ToString(Request.QueryString["op"], "");
            switch (op)
            {
                case "BizServiceItemList":
                    returnInfo = BizServiceItemList();
                    break;
            }
            #endregion
            Response.Write(returnInfo);
            Response.End();
        }

        #endregion

        #region "绑定数据"

        /// <summary>
        /// 维修项目列表
        /// </summary>
        protected string BizServiceItemList()
        {
            string returnInfo = "";
            #region "开始处理"
            DataModel.DataHelp dataHelp = new DataModel.DataHelp();
            dataHelp.DataComm.TopNum = "";
            dataHelp.DataComm.Fields = " BizServiceItem.Id"
                                     + ",BizServiceItem.Code   项目编号"
                                     + ",BizServiceItem.Name   项目名称"
                                     + ",BizServiceItem.[Desc] 项目说明"
                                     + ",BizServiceItem.ItemTypeNo    项目工种"
                                     + ",CAST(BizServiceItem.StandardMoney As decimal(18,2)) 标准金额"
                                     + ",CAST(BizServiceItem.StandardHours As decimal(18,2)) 标准工时"
                                     + "";
            dataHelp.DataComm.TbJoin = "";
            dataHelp.DataComm.SWhere = "";
            #region "条　件"
            dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByStrParm("Name", " And Name {0} ");
            dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByStrParm("Code", " And Code {0} ");
            dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByIntParm("ItemClassId", " And ItemClassId In (" + TreeHelper.InitTreeString(DataBll.BizServiceItemClass.Select("", "*", "", "", "Order By SortNumber ASC").Tables[0], DataConvert.ToInt(Request["ItemClassId"], 0).ToString()) + ") ");
            dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByIntParm("ItemTypeId", " And ItemTypeId={0} ");