/// <summary>
/// 获取菜品优惠
/// </summary>
/// <param name="workerStaffEnum">职工类型</param>
/// <param name="cookbookId">菜品ID</param>
/// <param name="organizationId">机构ID</param>
public CookbookPreferentialWorkerInfo Select(WorkerStaffEnum workerStaffEnum, int cookbookId, int organizationId)
{
var parameters = new[] {
new SqlParameter("@WorkerStaffEnum", workerStaffEnum.ToString()),
new SqlParameter("@CookbookId", cookbookId),
new SqlParameter("@OrganizationId", organizationId),
};
CookbookPreferentialWorkerInfo ret = null;
using (var dr = SQLHelper.ExecuteReader(SQLHelper.ConnString, CommandType.Text, CONST_SQL_SELECT_BY_WORKERSTAFFENUM_CBID_ORGID, parameters))
{
if (dr.Read())
{
ret = this.BuildModel(dr);
}
dr.Close();
}
return(ret);
}
/// <summary>
/// 获取菜品优惠
/// </summary>
public CookbookPreferentialWorkerInfo GetCookbookPreferentialWorker(WorkerStaffEnum workerStaffEnum, int cookbookId, int organizationId)
{
return(StaticCookbookPreferentialWorkerDAL.Select(workerStaffEnum, cookbookId, organizationId));
}
