本文整理汇总了C#中Subput.Common.DataBaseUtility.FetchData方法的典型用法代码示例。如果您正苦于以下问题：C# DataBaseUtility.FetchData方法的具体用法？C# DataBaseUtility.FetchData怎么用？C# DataBaseUtility.FetchData使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Subput.Common.DataBaseUtility的用法示例。
在下文中一共展示了DataBaseUtility.FetchData方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetEmpInfo
public DataTable GetEmpInfo()
{
// string query = " select AmtTotalSales as TOTAL_SUBWAY_SALES, QtyFootlongs as FOOT_LONG, Qty6Inches as INCH_6, Qty3Inches INCH_3, QtyMuffinMelt as MUFF_IN_MELT , QtySalads as SALAD ,QtyPizzas as PIZZA , AmtCateringSales as CATERING , AmtTotalRefund as REFUNDS , AmtSubwayVoid as VOIDS, AmtUnitSales as TOTAL_UNIT_SALES , AmtDrinkSales as TOTAL_DRINK_SALES from Report.DrawersSummary where OpeningInformationId in (select OpeningInformationId from dbo.OpeningInformation where BusinessDate between '" + weekDate.ToString("yyyy/MM/dd") + "' and '" + nextDate.ToString("yyyy/MM/dd") + "' )";
DataTable drawersSummaryTable = null;
try
{
string query = "select emp.FirstName , emp.MiddleName, emp.LastName"
+ ", uc.ClockingTime,uc.MinutesWorked, uc.InsertedDate from dbo.UserClocking uc, dbo.Employees emp where emp.EmployeeId = uc.EmployeeId";
DataBaseUtility db = new DataBaseUtility();
drawersSummaryTable = db.FetchData(query);
}
catch (Exception ex)
{
log.Error(" Exception in GetEmpInfo Method ", ex);
}
return drawersSummaryTable;
}示例2: GetUserList
public DataTable GetUserList()
{
DataBaseUtility db = new DataBaseUtility();
string query = " select Id,UserId,Password from dbo.Users ";
DataTable ds = db.FetchData(query);
return ds;
}