private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
var conn = BaseDataBaseTools.GetDbConnection() as SqlConnection;
var t1 = DateTime.Now;
conn.Select("select * from grades");
List <string> sqls = new List <string>();
sqls.Add("select * from grades");
sqls.Add("select * from t_sys_menu");
var ds = conn.Select(sqls);
tbOutput.Text += Environment.NewLine + "打开并查询成功, 耗时: " + (DateTime.Now - t1).TotalMilliseconds + "毫秒";
}
catch (Exception ex)
{
tbOutput.Text += Environment.NewLine + "异常: " + ex.Message;
}
}
public void DoAction(object obj)
{
try
{
using (var conn = BaseDataBaseTools.GetDbConnection() as SqlConnection)
{
var t1 = DateTime.Now;
conn.Select("select * from grades");
List <string> sqls = new List <string>();
sqls.Add("select * from grades");
sqls.Add("select * from t_sys_menu");
var ds = conn.Select(sqls);
Logger.Info(obj.ToString() + "打开并查询成功, 耗时: " + (DateTime.Now - t1).TotalMilliseconds + "毫秒");
}
}
catch (Exception ex)
{
Logger.Info(obj.ToString() + "===========" + ex.Message);
}
}
