public string Get()
{
var sql = new Sql();
sql.Select().AddBs(SqlFun.GetSqlFun(DbHelper.Db.MDbType).Now()).AddBs("DateTime");
var ds = DbHelper.Db.ExecuteSet(sql.ToString());
var dt = ds.Tables[0].Rows[0]["DateTime"].ToString();
if (string.IsNullOrEmpty(dt))
{
throw new Exception("数据库连接失败,请检查配置.");
}
return($"{dt} Success");
}
public static bool CreateByTemplate()
{
string TempletFileName = "D:/各DLL源文件/DllResource/dllTestStage/ExcelDemo/" + "测温报表模板5x7.xls"; //模板文件
string ReportFileName = "D:/各DLL源文件/DllResource/dllTestStage/ExcelOut/" + "_tmpAllRoomReport.xls"; //导出文件
string strTempletFile = Path.GetFileName(TempletFileName);
//将模板文件复制到输出文件
FileInfo mode = new FileInfo(TempletFileName);
mode.CopyTo(ReportFileName, true);
//打开excel
object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Application app = null;
Workbook wb = null;
Worksheet ws = null;
Range r = null;
//
try
{
app = new Microsoft.Office.Interop.Excel.Application();
wb = app.Workbooks.Open(ReportFileName, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
app.Visible = true;
//得到WorkSheet对象
ws = (Worksheet)wb.Worksheets.get_Item(1);
string Numsqlstr = "SELECT linepointnum,longlinenum,widelinenum,encirclenum,linesnum,encirclelinepointnum,house,linestartno FROM LineInfor WHERE houseno='14'";
string Datasqlstr = "SELECT [time],[houseNo],[linesNo],[pointNo],[temp] FROM HousePosTempData WHERE [time]='2018-06-06 09:26:57.000' AND [houseNo]='14' order by linesNo,pointNo";
DataSet Numds = SqlFun.SOSelectGetDataSet(Numsqlstr);
DataSet Datads = SqlFun.SOSelectGetDataSet(Datasqlstr);
#region 利用三循环完成温度报表的数据输入
int longlinenum = Convert.ToInt32(Numds.Tables[0].Rows[0][1]); //缆数
int widelinenum = Convert.ToInt32(Numds.Tables[0].Rows[0][2]); //节点数
int linepointnum = Convert.ToInt32(Numds.Tables[0].Rows[0][0]); //探头数
int num = 0;
int lineno = 0;
int dslineno = 0;
int dspoint = 0;
int mergecell = 0;
for (int col = 1; col <= widelinenum; col++)
{
for (int row = 1; row <= longlinenum; row++)
{
for (int point = linepointnum; point >= 1; point--)
{
lineno = longlinenum * (col - 1) + row;
dslineno = Convert.ToInt32(Datads.Tables[0].Rows[num][2]);
dspoint = Convert.ToInt32(Datads.Tables[0].Rows[num][3]);
if (dslineno == lineno && dspoint == (5 - point))
{
ws.Cells[row * 5 + point, col + mergecell] = Datads.Tables[0].Rows[num++][4].ToString();
}
}
}
r = (Range)ws.Cells[6, col + mergecell];
if (r.MergeArea.Cells.Columns.Count > 1)
{
mergecell = mergecell + r.MergeArea.Cells.Columns.Count - 1;
}
}
#endregion
//添加或修改WorkSheet里的数据
//ws.Cells[1, 1] = "求积";
//ws.Cells[2, 1] = "100";
//ws.Cells[2, 2] = "100";
////代码里写个公式
//r = (Range)ws.Cells[2, 3];
//r.Formula = "=A2*B2";
//输出Excel文件并退出
wb.Save();
wb.Close(null, null, null);
app.Workbooks.Close();
}
catch
{
return(false);
}
finally
{
app.Application.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ws);
System.Runtime.InteropServices.Marshal.ReleaseComObject(wb);
app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
GC.Collect();
ws = null;
wb = null;
app = null;
}
}
