Exemple #1
0
 /// <summary>
 /// 带参数的数据查询
 /// </summary>
 /// <param name="Begin">开始时间</param>
 /// <param name="Over">结束时间</param>
 /// <param name="Name">操作方式</param>
 /// <returns>DataSet</returns>
 public static DataSet SelectByWorkWise(string Begin, string Over, string Name)
 {
     string sql2 = Sql() + " where WorkName='" + Name + "' and DT between '" + Begin + "' and '" + Over + "' order by ID desc";
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new WSV.DAL.MyLog.Modify();
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(sql2);
     }
     catch (Exception ex)
     { throw new Exception(ex.Message); }
     finally
     {
         db.Dispose();
     }
     return ds;
 }
Exemple #2
0
 public static DataSet SelectMain()
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new WSV.DAL.MyLog.Modify();
     DataSet ds = new DataSet();
     try
     {
         ds = db.ReturnDataSet(visitor, "SelMain", "LC_Main");
     }
     catch (Exception ex)
     { throw new Exception(ex.Message); }
     finally
     {
         db.Dispose();
     }
     return ds;
 }