public static ClsDataBase Instance()
{
if (clsCommond == null)
{
lock (lockHelper)
{
if (clsCommond == null)
{
//if (ClsBaseClass.ClsBaseDataInfo.sDataBaseType.ToLower().Trim() == "sqlserver")
clsCommond = new ClsBaseClass.ClsSQLServerCommond();
}
}
}
return(clsCommond);
}
public string dtFileV()
{
string sSQL = @"
SELECT
[文件名称]
,[路径]
,[版本]
,[更新日期]
,[创建时间]
FROM [XWSystemDB_FH].[dbo].[文件版本信息]
order by iID
";
ClsBaseClass.ClsDataBase clsSQL = ClsBaseClass.ClsDataBaseFactory.Instance();
DataTable dt = clsSQL.ExecQuery(sSQL);
return(Cls序列化.SerializeDataTableXml(dt));
}
public string dtDownFileVer(string sFileName)
{
string sSQL = @"
SELECT
[文件名称]
,[文件]
,[路径]
,[版本]
,[更新日期]
,[创建时间]
FROM [XWSystemDB_FH].[dbo].[文件版本信息]
where [文件名称] = '111111'
order by iID
";
sSQL = sSQL.Replace("111111", sFileName);
ClsBaseClass.ClsDataBase clsSQL = ClsBaseClass.ClsDataBaseFactory.Instance();
DataTable dt = clsSQL.ExecQuery(sSQL);
return(Cls序列化.SerializeDataTableXml(dt));
}