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; }
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; }