ap0405140:你好 就是我想要做一个作业,实现下面代码的功能!但现在不知如何将获取到的数据用数组的方式进行遍历,求指点 string str = "select distinct sho_id from view_ocs"; DataSet list_id = o.Select(str); int all = list_id.Tables[0].Rows.Count; for (int i = 0; all > i; i++) { int sho_id = Convert.ToInt32(list_id.Tables[0].Rows[i][0].ToString()); string strt = "select avg(nullif(ord_sendtime,0)) as ord_averagetime from (select top (50) * from view_ocs where sho_id=@p0 order by ord_id desc)tmp; "; DataSet list_time = o.Select(strt, sho_id); int ord_averagetime = Convert.ToInt32(list_time.Tables[0].Rows[0][0].ToString()); if (ord_averagetime == 0) { ord_averagetime = 30; } string up = "update shop set sho_arrivetime=@p0 where sho_id=@p1"; bool flag = o.Handle(up, ord_averagetime, sho_id); }
就是我想把里面的值用sql语句中for循环取出每一个值进行操作 江湖救急,急需答案!!
大家帮帮忙: declare @all int,@sqls nvarchar(100),@i int set @sqls='select sho_id from shop' exec sp_executesql @sqls就是循环获取每一个值,然后进行 set @str2 = 'update shop set sho_arrivetime='+ @avg+' where sho_id='+@p0+'' exec (@str2) 目前就是不知如何获取每一个值并将值赋给@p0
就是我想要做一个作业,实现下面代码的功能!但现在不知如何将获取到的数据用数组的方式进行遍历,求指点
string str = "select distinct sho_id from view_ocs";
DataSet list_id = o.Select(str);
int all = list_id.Tables[0].Rows.Count;
for (int i = 0; all > i; i++)
{
int sho_id = Convert.ToInt32(list_id.Tables[0].Rows[i][0].ToString());
string strt = "select avg(nullif(ord_sendtime,0)) as ord_averagetime from (select top (50) * from view_ocs where sho_id=@p0 order by ord_id desc)tmp; ";
DataSet list_time = o.Select(strt, sho_id); int ord_averagetime = Convert.ToInt32(list_time.Tables[0].Rows[0][0].ToString());
if (ord_averagetime == 0) {
ord_averagetime = 30;
}
string up = "update shop set sho_arrivetime=@p0 where sho_id=@p1";
bool flag = o.Handle(up, ord_averagetime, sho_id);
}
江湖救急,急需答案!!
declare @all int,@sqls nvarchar(100),@i int
set @sqls='select sho_id from shop'
exec sp_executesql @sqls就是循环获取每一个值,然后进行
set @str2 = 'update shop set sho_arrivetime='+ @avg+' where sho_id='+@p0+''
exec (@str2)
目前就是不知如何获取每一个值并将值赋给@p0
for i in a loop
end loop;