110,561
社区成员
发帖
与我相关
我的任务
分享
private void BindData()
{
using(CusModelContainer db = new CusModelContainer())
{
List<bgdatasrc> rBarlist = db.bgdatasrcs.Where(x => x.rptbarid == _rptbarid).ToList(); //本级项目主表
string dsrcno = rBarlist.Select(a => a.dsrcno).FirstOrDefault(); //项目编号
string dsrcna = rBarlist.Select(b => b.dsrcna).FirstOrDefault(); //项目名称
int dsrctype = rBarlist.Select(c => c.dsrctype).FirstOrDefault(); //数据源类型
var dsrclist = db.vDsrcdtls.Where(x => x.dsrcno == dsrcno).Select(x => new
{
x.para,
x.paravalue
}).ToList(); //项目参数表
System.Data.SqlClient.SqlParameter[] para = dsrclist.ToArray();
/*
System.Data.SqlClient.SqlParameter[] para =
{
new System.Data.SqlClient.SqlParameter("@dsrcno",dsrcno)
};
*/
DataSet ds = new DataSet();
string sql = "exec [" + dsrcna + "] " + para;
}
}
System.Data.SqlClient.SqlParameter[] paralist = dsrclist.Select(d => new System.Data.SqlClient.SqlParameter()
{
ParameterName = d.para,
Value = d.paravalue
}).ToArray();
已经OK了,非常感谢
List<System.Data.SqlClient.SqlParameter> paralist = dsrclist.Select(d => new System.Data.SqlClient.SqlParameter()
{
Value = d.paravalue,
ParameterName = d.para
}).ToList();
SqlParameter[] s = myList.Select(x=> new SqlParameter() {Value=xxx,ParameterName=xxx }).ToArray();