/// <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;
}
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;
}