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