public DataSet GetFhxxInfoAll(string fcsj1,string fcsj2,string clbh,string sdzmc,string fgsbm,string sdzbm,string fc_zdzmc)
{
try
{
sqlhelper.GetDataSet("v_fhqdh");//怎么将参数传给视图啊
return ds;
}
catch (Exception)
{ throw;
}
}视图v_fhqdh 代码SELECT DISTINCT
dbo.Fhxx.Fhqdh, dbo.Fhxx.hwbh, dbo.Fhxx.Clbh, dbo.Fhxx.Jydbh, dbo.Fhxx.Fhsl, dbo.Fhxx.Fhzl, dbo.Fhxx.Fhtj, dbo.Fhxx.Fszbm, dbo.Fhxx.Other,
dbo.Fhxx.lwfy, dbo.Hwxx.Sxhh, dbo.Hwxx.Hwmc, dbo.Hwxx.Hwlx, dbo.Fhxx.Fhzt, dbo.Jydxx.Fgsbm, dbo.Jydxx.dzzbm, dbo.Jydxx.qdgl,
dbo.Jydxx.Fhrxm, dbo.Jydxx.Fhrdh, dbo.Jydxx.Shrxm, dbo.Jydxx.Shrdh, dbo.Jydxx.zyfs, dbo.Jydxx.Thfs, dbo.Jydxx.Sdzbm, dbo.Jydxx.zcyf,
dbo.Jydxx.Zbxf, dbo.Jydxx.Jjfy, dbo.Jydxx.Zdzf, dbo.Jydxx.Dshk, dbo.Jydxx.tf, dbo.Jydxx.Yjyfhj, dbo.Jydxx.hf, dbo.Jydxx.Zyf, dbo.Jydxx.Hkze,
dbo.Fcqk.fcsj, dbo.Fcqk.fhy, dbo.Fcqk.zcy, dbo.Fcqk.gsjbr, dbo.Fcqk.fc_Other AS Other_b, dbo.Fcqk.jsyxm, dbo.Fcqk.Jsysfz AS Sfzh,
dbo.Fcqk.Jsydh AS Scdh, dbo.Fcqk.fc_Zdzmc, dbo.Jydxx.Other AS other_c, dbo.Jydxx.Sfjj AS name
FROM dbo.Fhxx LEFT OUTER JOIN
dbo.Fcqk ON dbo.Fhxx.Fhqdh = dbo.Fcqk.Fhqdh RIGHT OUTER JOIN
dbo.Hwxx ON dbo.Fhxx.hwbh = dbo.Hwxx.Hwbh RIGHT OUTER JOIN
dbo.Jydxx ON dbo.Hwxx.Jydbh = dbo.Jydxx.Jydbh
{
try
{
sqlhelper.GetDataSet("v_fhqdh");//怎么将参数传给视图啊
return ds;
}
catch (Exception)
{ throw;
}
}视图v_fhqdh 代码SELECT DISTINCT
dbo.Fhxx.Fhqdh, dbo.Fhxx.hwbh, dbo.Fhxx.Clbh, dbo.Fhxx.Jydbh, dbo.Fhxx.Fhsl, dbo.Fhxx.Fhzl, dbo.Fhxx.Fhtj, dbo.Fhxx.Fszbm, dbo.Fhxx.Other,
dbo.Fhxx.lwfy, dbo.Hwxx.Sxhh, dbo.Hwxx.Hwmc, dbo.Hwxx.Hwlx, dbo.Fhxx.Fhzt, dbo.Jydxx.Fgsbm, dbo.Jydxx.dzzbm, dbo.Jydxx.qdgl,
dbo.Jydxx.Fhrxm, dbo.Jydxx.Fhrdh, dbo.Jydxx.Shrxm, dbo.Jydxx.Shrdh, dbo.Jydxx.zyfs, dbo.Jydxx.Thfs, dbo.Jydxx.Sdzbm, dbo.Jydxx.zcyf,
dbo.Jydxx.Zbxf, dbo.Jydxx.Jjfy, dbo.Jydxx.Zdzf, dbo.Jydxx.Dshk, dbo.Jydxx.tf, dbo.Jydxx.Yjyfhj, dbo.Jydxx.hf, dbo.Jydxx.Zyf, dbo.Jydxx.Hkze,
dbo.Fcqk.fcsj, dbo.Fcqk.fhy, dbo.Fcqk.zcy, dbo.Fcqk.gsjbr, dbo.Fcqk.fc_Other AS Other_b, dbo.Fcqk.jsyxm, dbo.Fcqk.Jsysfz AS Sfzh,
dbo.Fcqk.Jsydh AS Scdh, dbo.Fcqk.fc_Zdzmc, dbo.Jydxx.Other AS other_c, dbo.Jydxx.Sfjj AS name
FROM dbo.Fhxx LEFT OUTER JOIN
dbo.Fcqk ON dbo.Fhxx.Fhqdh = dbo.Fcqk.Fhqdh RIGHT OUTER JOIN
dbo.Hwxx ON dbo.Fhxx.hwbh = dbo.Hwxx.Hwbh RIGHT OUTER JOIN
dbo.Jydxx ON dbo.Hwxx.Jydbh = dbo.Jydxx.Jydbh
Create proc YourName
(
para varchar(20)
)
as
begin
--Your view
end