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