/// <summary>
 /// 控制分组带参构造
 /// </summary>
 /// <param name="Connection"></param>
 public ControlPointGroup(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     GroupType = 0;
     GroupName = "NULL";
     Remarks = "NULL";
 }

		public static void DumpHgbstLists(params string[] listNames)
		{
			var sqlHelper = new SqlHelper();
			DataSet listDs;

			if (listNames == null || listNames.Length == 0 || (listNames.Length == 1 && listNames[0].Trim().Length == 0))
			{
				sqlHelper.CommandText = "SELECT * FROM table_hgbst_lst";
				listDs = sqlHelper.ExecuteDataSet();
			}
			else
			{
				var names = new object[listNames.Length];
				string colName = null;
				const string hgbstListSql = "SELECT * FROM table_hgbst_lst WHERE (title IN({0}))";

				Array.Copy(listNames, 0, names, 0, listNames.Length);

				sqlHelper.CommandText = String.Format(hgbstListSql, SqlHelper.IN_LIST_TOKEN);
				listDs = sqlHelper.ExecuteDataSetInList(names, colName);
			}

			if (listDs == null || listDs.Tables.Count == 0 || listDs.Tables[0].Rows.Count == 0)
			{
				var namesCombined = (listNames == null) ? "" : String.Join("', '", listNames);
				Console.WriteLine("No HGBST lists found matching the specified criteria ('{0}').", namesCombined);

				return;
			}

			DumpHgbstLists(listDs);
		}

 public PlaneIntersection(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     Stake = "NULL";
     PlaneInterName = "NULL";
     bCalcLeft = 0;
     LeftBt = 0;
     LeftL = 0;
     LeftR1 = 0;
     LeftR2 = 0;
     LeftR3 = 0;
     LeftR4 = 0;
     LeftW1 = 0;
     LeftW2 = 0;
     LeftW3 = 0;
     LeftW4 = 0;
     bCalcRight = 0;
     RightBt = 0;
     RightL = 0;
     RightR1 = 0;
     RightR2 = 0;
     RightR3 = 0;
     RightR4 = 0;
     RightW1 = 0;
     RightW2 = 0;
     RightW3 = 0;
     RightW4 = 0;
     Remarks = "NULL";
 }

 public VerticalSectionGroundLine(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     Stake = "NULL";
     H = 0;
 }

 /// <summary>
 /// 设计横断面地面线数据带参构造 
 /// </summary>
 /// <param name="Connection"></param>
 public CrossSectionDesignLineData(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     Stake = "NULL";
     H = 0;
 }

 public void Delete(int id)
 {
     using (SqlHelper sqlh = new SqlHelper(@"
     delete from Access.role
     where role = @Id"))
     {
         sqlh.ExecNoQuery();
     }
 }

 /// <summary>
 /// 控制点带参构造 
 /// </summary>
 /// <param name="Connection"></param>
 public ControlPoint(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     Name = "NULL";
     X = 0;
     Y = 0;
     H = 0;
     Remarks = "NULL";
 }

 public GradeChangePoint(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     Stake = "NULL";
     H = 0;
     R = 0;
     i1 = 0;
     i2 = 0;
 }

 /// <summary>
 /// 涵洞带参构造 
 /// </summary>
 /// <param name="Connection"></param>
 public Culvert(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     CenterStake = "NULL";
     CulvertName = "NULL";
     StructureFrom = 0;
     Angle = 0;
     BottomH = 0;
     SpanDescription = "NULL";
 }

 //初始化竖曲线构造函数
 public VerticalCurv(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     VerticalCurveType = 0;
     GradeChangePointNumber = 0;
     CurveNumber = 0;
     VerticalCurveLength = 0;
     BeginStake = "NULL";
     EndStake = "NULL";
     Description = "NULL";
 }

 /// <summary>
 /// 积木法带参构造 
 /// </summary>
 /// <param name="Connection"></param>
 public BuildingBlockCurve(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     Stake = "NULL";
     X = 0;
     Y = 0;
     Azimuth = 0;
     TurnTo = 0;
     R = 0;
     Description = "NULL";
 }

        public EmailBLL()
        {
            _currentPath = GetType().Assembly.Location;
            _currentPath = _currentPath.Substring(0, _currentPath.LastIndexOf(@"\")) + "\\";
            string mailConfigPath = _currentPath + @"ConfigFiles\MailConfig.xml";

            string connFile = _currentPath + @"ConfigFiles\CommonConfig.xml";
            string connStr = new XmlHelper(connFile).GetValue("ConnectionString");
            _sqlHelper = new SqlHelper(connStr);

            _xmlHelper = new XmlHelper(mailConfigPath);
        }

 /// <summary>
 /// Получает роль по идентификатору.
 /// </summary>
 /// <param name="id">Идентификатор.</param>
 /// <returns>Роль.</returns>
 public RoleItem Get(int id)
 {
     using (var sqlh = new SqlHelper())
     {
         return sqlh.ExecMapping<RoleItem>(@"
     select
     r.role Id,
     r.code Code,
     r.mem Mem
     from Access.role r
     where r.role = @Id", new { id });
     }
 }

 public Tunnel(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     Stake = "NULL";
     StartStake = "NULL";
     EndStake = "NULL";
     Type = 0;
     Name = "NULL";
     Angle = 0;
     LeftWidth = 0;
     RightWidth = 0;
     SpanDescription = "NULL";
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            Response.Clear();

            string str_sql = "";
            IDbHelper sql = GetHelper();
            DbDataReader rd = sql.ExecuteReader(CommandType.Text, "select [name] from sysobjects where xtype='U'");
            while (rd.Read())
            {
                string tableName = rd["name"].ToString();
                if (tableName.ToLower() == "sysuser")
                {
                    continue;
                }

                IDbHelper Helper = new SqlHelper(Voodoo.Setting.DataBase.ConnStr);
                DataTable dt = Helper.ExecuteDataTable(CommandType.Text, string.Format("select * from [{0}]",tableName));

                string str_insert = string.Format("SET IDENTITY_INSERT [{0}] ON ;\n insert into [{0}](", tableName);
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    str_insert += "[" + dt.Columns[i].ColumnName + "]";
                    if (i != dt.Columns.Count - 1)
                    {
                        str_insert += ",";
                    }
                }
                str_insert += ") values(";

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    str_sql += str_insert;
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        str_sql += "N'" + dt.Rows[i][j].ToString().Replace("'", "''") + "'";
                        if (j != dt.Columns.Count - 1)
                        {
                            str_sql += ",";
                        }
                    }
                    str_sql += string.Format(")\n SET IDENTITY_INSERT [{0}] OFF ;\n\n\n",tableName);
                }
            }
            rd.Close();
            rd.Dispose();

            //Response.Write(str_sql);
            Voodoo.IO.File.Write(Server.MapPath("~/e/installer/tabledata.txt"), str_sql, System.IO.FileMode.Create);
            Response.Write("已经生成到：" + Server.MapPath("~/e/installer/tabledata.txt"));
            Response.End();
        }

 public IntersectionPoint(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     JDBH = "NULL";
     Stake = "NULL";
     X = 0;
     Y = 0;
     R = 0;
     Ls1 = 0;
     Ls2 = 0;
     Ls1R = 0;
     Ls2R = 0;
 }

        public int Create(RoleItem role)
        {
            using (SqlHelper sqlh = new SqlHelper(@"
            insert into Access.role(code, mem)
            values (@Code, @Mem)

            select SCOPE_IDENTITY()
            "))
            {
                sqlh.AddWithValue("@Code", role.Code);
                sqlh.AddWithValue("@Mem", role.Mem);
                return (int)sqlh.ExecScalar();
            }
        }

 public RoadWidthChange(string Connection)
 {
     DbConnection = new SqlHelper(Connection);
     SerialNumber = 0;
     Stake = "NULL";
     LeftSoilShoulder = 0;
     LeftHardShoulder = 0;
     LeftCarriageway = 0;
     LeftMiddle = 0;
     RightMiddle = 0;
     RightCarriageway = 0;
     RightHardShoulder = 0;
     RightSoilShoulder = 0;
     Remarks = "NULL";
 }

        public ActionResult Contact()
        {
            ViewBag.Message = "與我們聯絡";

            /*
            List<string> DepartmentList = new List<string>();
            DepartmentList.Add("業務部");
            DepartmentList.Add("創意部");
            DepartmentList.Add("行銷部");

            ViewBag.DepartmentList = DepartmentList;

            return View();

            */

            List<department> departmentlist = new List<department>();

            SqlHelper hp = new SqlHelper();

            DataTable tb = hp.Sql2Table("select id,cname from dep");

            department depobj;
            foreach(DataRow r in tb.Rows)
            {
                depobj = new department();
                depobj.id = r["id"].ToString();
                depobj.departmentName = r["cname"].ToString();
                departmentlist.Add(depobj);
            }

            //return View(departmentlist);

            departmentlist.Clear();
            depobj = new department();
            depobj.id = "a001"; depobj.departmentName = "業務部";
            departmentlist.Add(depobj);

            depobj = new department();
            depobj.id = "a002"; depobj.departmentName = "創意部";
            departmentlist.Add(depobj);

            depobj = new department();
            depobj.id = "a003"; depobj.departmentName = "行銷部";
            departmentlist.Add(depobj);

            return View(departmentlist);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            m_sqlHelper = new SqlHelper();

            string P_id = Request.QueryString["P_id"];
            //string P_id = "054321";

            string commandText = "select distinct Paper.Introduction as 选题简介 " +
                                 "from Paper " +
                                 "where P_id = " + P_id;

            DataTable dt = m_sqlHelper.Query(commandText);

            m_introductionGridView.DataSource = dt;
            m_introductionGridView.DataBind();
        }