public static string GetDBInfoMisa(out DbMisaInfo oMisaInfo)
{
string msg = Exec.ExecQueryStringOne(string.Format(@"SELECT
(SELECT OptionValue FROM dbo.DBOption WHERE OptionID = 'CompanyCode') AS CompanyID ,
(SELECT OptionValue FROM dbo.DBOption WHERE OptionID = 'CompanyName') AS CompanyName,
(SELECT Version FROM DBInfo) AS ExportVersion,
0 AS ParticularID,
(SELECT Application + ' ' + Version FROM DBInfo) AS ProductID,
(SELECT MISAVersionControl FROM DBInfo) AS Version,
(SELECT OptionValue FROM dbo.DBOption WHERE OptionID='DefaultBudgetChapterCode') AS BudgetChapterID,
(SELECT OptionValue FROM dbo.DBOption WHERE OptionID='DefaultBudgetKindItemCode') AS BudgetKindItemID,
(SELECT OptionValue FROM dbo.DBOption WHERE OptionID='DefaultBudgetSubKindItemCode') AS BudgetSubKindItemID,
(SELECT OptionValue FROM DBOption WHERE OptionID = 'DBStartDate') AS StartDate,
(SELECT OptionValue FROM DBOption WHERE OptionID = 'AccountSystem') AS AccountSystem"), out oMisaInfo);
if (msg.Length > 0)
{
return(Msg.Exec_GetDBInfoMisa_Err);
}
if (string.IsNullOrEmpty(oMisaInfo.StartDate))
{
oMisaInfo.StartDate = new DateTime(DateTime.Now.Year, 1, 1).ToString("yyyy-MM-dd HH:mm:ss");
}
DateTime startDateConvert = Convert.ToDateTime(oMisaInfo.StartDate);
oMisaInfo.StartDate = startDateConvert.ToString("yyyy-MM-dd HH:mm:ss");
return("");
}