DAL/Area/TCWL_D_Area.cs

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

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

namespace DAL.Area
{
    using Common;
    using System;
    using System.Data;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_Area
    {
        public string GetAreaID(string name)
        {
            string str = "";
            if (!string.IsNullOrEmpty(name))
            {
                DataTable dataTable = DBHelper.GetDataTable("select ID FROM TCWL_Area where Name = '" + name + "'");
                if (dataTable.Rows.Count > 0)
                {
                    str = dataTable.Rows[0][0].ToString();
                }
            }
            return str;
        }

        public string GetAreaName(string id)
        {
            string str = "";
            if (!string.IsNullOrEmpty(id))
            {
                DataTable dataTable = DBHelper.GetDataTable("select Name FROM TCWL_Area where ID = '" + id + "'");
                if (dataTable.Rows.Count > 0)
                {
                    str = dataTable.Rows[0][0].ToString();
                }
            }
            return str;
        }

        public DataTable GetList(string strWhere, string id)
        {
            StringBuilder builder = new StringBuilder();
            DataTable dataTable = new DataTable();
            if (id == "0")
            {
                dataTable = DBHelper.GetDataTable("select ID,Name FROM TCWL_Area where ParentID = '0'");
                strWhere = "ParentID = '" + dataTable.Rows[0]["ID"].ToString() + "'";
            }
            builder.Append("select ID,Name,ParentID,GongSiID,ServiceID,TimeStr ");
            builder.Append(" FROM TCWL_Area ");
            if (strWhere.Trim() != "")
            {
                builder.Append(" where " + strWhere);
            }
            builder.Append(" order by Name");
            return DBHelper.Query(builder.ToString()).Tables[0];
        }

        public DataTable GetListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int total)
        {
            StringBuilder builder = new StringBuilder();