gharibeh223
دوشنبه 07 شهریور 1390, 14:45 عصر
یکی به من بگه نوع خروجی این تابع چی بگیرم ؟؟؟ به جای xxxxxxx چی بزارم ؟؟؟؟؟؟؟
public xxxxxxxxxxxxxxxxxxxxxxxx SelectForView(string id)
{
var bank = new DCDataContext();
var query = (from A in bank.A01s where (A.WellCode == id)
join F in bank.Fields on A.FieldCode equals F.FieldCode into A_F
join W in bank.WellTypes on A.WellTypeCode equals W.WellTypeCode into A_W
join C in bank.Contractors on A.ContractorCode equals C.ContractorCode into A_C
join P in bank.WellProfiles on A.WellProfileCode equals P.WellProfileCode into A_p
from F in A_F .DefaultIfEmpty()
from W in A_W .DefaultIfEmpty()
from C in A_C .DefaultIfEmpty()
from P in A_p.DefaultIfEmpty()
select new {A.WellCode, A.FieldCode, A.Location, A.WellTypeCode,
A.WellProfileCode, A.RIG, A.SpuddedInDate, A.ReleasedDate,
A.Reservoir, A.ContractorCode, A.FinalForecastedDepth, A.EstTTLRigDays, A.ActRigDays,
A.RTLevelSea, A.WaterDepth,
A.Zone, F.FieldName, C.Contractor1, W.WellType1 , P.WellProfileName,
P.WellProfileAbri}).Single() ;
return query;
}
public xxxxxxxxxxxxxxxxxxxxxxxx SelectForView(string id)
{
var bank = new DCDataContext();
var query = (from A in bank.A01s where (A.WellCode == id)
join F in bank.Fields on A.FieldCode equals F.FieldCode into A_F
join W in bank.WellTypes on A.WellTypeCode equals W.WellTypeCode into A_W
join C in bank.Contractors on A.ContractorCode equals C.ContractorCode into A_C
join P in bank.WellProfiles on A.WellProfileCode equals P.WellProfileCode into A_p
from F in A_F .DefaultIfEmpty()
from W in A_W .DefaultIfEmpty()
from C in A_C .DefaultIfEmpty()
from P in A_p.DefaultIfEmpty()
select new {A.WellCode, A.FieldCode, A.Location, A.WellTypeCode,
A.WellProfileCode, A.RIG, A.SpuddedInDate, A.ReleasedDate,
A.Reservoir, A.ContractorCode, A.FinalForecastedDepth, A.EstTTLRigDays, A.ActRigDays,
A.RTLevelSea, A.WaterDepth,
A.Zone, F.FieldName, C.Contractor1, W.WellType1 , P.WellProfileName,
P.WellProfileAbri}).Single() ;
return query;
}