本文整理汇总了C#中OrderDetail.LoadFromRawSql方法的典型用法代码示例。如果您正苦于以下问题：C# OrderDetail.LoadFromRawSql方法的具体用法？C# OrderDetail.LoadFromRawSql怎么用？C# OrderDetail.LoadFromRawSql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OrderDetail的用法示例。
在下文中一共展示了OrderDetail.LoadFromRawSql方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetStockOutReport
public static DataView GetStockOutReport(int orderId)
{
var query = HCMIS.Repository.Queries.OrderDetail.SelectStockOutDetail(orderId);
var orderDetail = new OrderDetail();
orderDetail.LoadFromRawSql(query);
return orderDetail.DefaultView;
}示例2: GetLastOrderDetailByFacility
/// <summary>
/// This function gives the previous order from the one specified in the parameter
/// </summary>
/// <param name="orderId">The order that gets returned is going to be the one just previous to this order.</param>
/// <param name="facilityId">The facility ID</param>
/// <returns></returns>
public DataTable GetLastOrderDetailByFacility(int orderId, int facilityId)
{
var query = HCMIS.Repository.Queries.OrderDetail.SelectLastOrderDetailByFacility(orderId, facilityId);
this.LoadFromRawSql(query);
this.AddColumn("LastApprovedQuantity", typeof(decimal));
this.AddColumn("LastRequestedQuantity", typeof(decimal));
this.AddColumn("LastRequestedDate", typeof(DateTime));
while (!this.EOF)
{
var oDetail = new OrderDetail();
var querylastdetails = HCMIS.Repository.Queries.OrderDetail.SelectQueryLastDetails(this.ItemID, this.UnitID, (int)this.GetColumn("RequestedBy"));
oDetail.LoadFromRawSql(querylastdetails);
if (oDetail.RowCount > 0)
{
this.SetColumn("LastApprovedQuantity", oDetail.GetColumn("LastApprovedQuantity"));
this.SetColumn("LastRequestedQuantity", oDetail.GetColumn("LastRequestedQuantity"));
this.SetColumn("LastRequestedDate", oDetail.GetColumn("LastRequestedDate"));
}
this.MoveNext();
}
return this.DataTable;
}