Meeting/Admin/Ajax/WebMethod.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.Services;
using System.Reflection;
using System.IO;
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Drawing;
using DBUtility;


namespace WebApplication.Admin.Ajax
{
    public partial class WebMethod : System.Web.UI.Page
    {
        BLL.Admin.GZXX_UserDepartMent ubll = new BLL.Admin.GZXX_UserDepartMent();
        protected void Page_Load(object sender, EventArgs e)
        {
            string methodName = HttpContext.Current.Request.PathInfo.Substring(1);

            MethodInfo method = this.GetType().GetMethod(methodName);
            if (method != null)
            {
                Response.Write(method.Invoke(this, new object[] { }));
            }
        }

        public string getFormSql(int chanelid, int departID)
        {
          
            Model.Models.GZXX_Model model = new Model.Models.GZXX_Model();
            BLL.Models.GZXX_Model bll = new BLL.Models.GZXX_Model();
            model = bll.GetModelInfo(chanelid);
            string TabName = model.modeltable;

            DataTable dt = new DataTable();
            string sql = string.Empty;
            string where = string.Empty;
            dt = ubll.getDepartMent(departID);

            
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                where += ",'" + chanelid + dt.Rows[i]["DepartId"].ToString() + "'";

            }
            where = where.Substring(1);
            where = "(" + where + ")";
            sql = string.Format("select * from {0} where channelId = {1} and NowDepartID in {2} ", TabName, chanelid, where);