/*
* public List<measureRec> FnGetMeasureRec(string Identifier = "2CE25FBB", string UserId = "HCTest",
* string ItemName = "血壓-收縮壓", int InputTypeCode = 0, string DeviceModel = "D40b")
*/
public IEnumerable <measureRecItem> FnGetMeasureRec(MeasureParameter mp)
{
SqlParameter pUserId = new SqlParameter
{
ParameterName = "UserId",
DbType = DbType.String,
Size = 50,
Direction = ParameterDirection.Input,
Value = mp.UserId
};
SqlParameter pIdentifier = new SqlParameter
{
ParameterName = "Identifier",
DbType = DbType.String,
Size = 50,
Direction = ParameterDirection.Input,
Value = mp.Identifier
};
SqlParameter pItemName = new SqlParameter
{
ParameterName = "ItemName",
DbType = DbType.String,
Size = 100,
Direction = ParameterDirection.Input,
Value = mp.ItemName
};
SqlParameter pInputTypeCode = new SqlParameter
{
ParameterName = "InputTypeCode",
DbType = DbType.Int32,
Direction = ParameterDirection.Input,
Value = mp.InputTypeCode
};
SqlParameter pDeviceModel = new SqlParameter
{
ParameterName = "DeviceModel",
DbType = DbType.String,
Size = 100,
Direction = ParameterDirection.Input,
Value = mp.DeviceModel
};
IEnumerable <measureRecItem> Result = db.Database.SqlQuery <measureRecItem>("SELECT * FROM FnGetMeasureRec(@Identifier, @UserId, @ItemName, @InputTypeCode, @DeviceModel)", pIdentifier, pUserId, pItemName, pInputTypeCode, pDeviceModel);
return(Result);
}
public measureRecRoot(MeasureParameter mp)
{
_mp = mp;
}
