Пример #1
0
        internal DataTable loadData()
        {
            DataTable dt = new DataTable();

            string strSQL = @"SELECT [Id]
                              ,[Spid]       AS '企业号'
                              ,[ComName]    AS '企业名'
                              ,CASE [Aattribute] WHEN 0 THEN '营销'
                               WHEN 1 THEN '行业' END AS '企业通道'
                              ,[LoginName]  AS '登陆名'
                              ,[Password]   
                              ,[QueryCNT]   AS '流量'
                              ,CASE WHEN [SendStatus] = 0 THEN '未启用'
                                    WHEN [SendStatus] = 1 THEN '已启用'
                               END AS '状态'
                              ,[CreateTime]
                          FROM [dbo].[CFG_Account]";

            LogicHandle LgH = new LogicHandle();

            dt = LgH.GetDataView(strSQL);

            return dt;

        }
Пример #2
0
        internal DataTable loadData(string _strId)
        {
            DataTable dt = new DataTable();

            LogicHandle lgH = new LogicHandle();

            string strSQL = @"SELECT [Id]
                              ,[Com]
                              ,[ComName]
                              ,[Spid]
                              ,[LoginName]
                              ,[Password] 
                              ,[QueryCNT]
                              ,[Aattribute]
                          FROM [dbo].[CFG_Account]
                          WHERE [Id] = '" + _strId+"'";

            dt = lgH.GetDataView(strSQL);
            return dt;
        }