22,210
社区成员
发帖
与我相关
我的任务
分享
HBSR_HS_SG_BE.HBSR_HS_SG_BE.EntityList sgList = HBSR_HS_SG_BE.HBSR_HS_SG_BE.Finder.FindAll(oql);
if (sgList.Count > 0)
{
foreach (HBSR_HS_SG_BE.HBSR_HS_SG_BE sg in sgList)
{
ZJCNum += sg.ChickenQty;
ZMJSJZL += sg.ChickRealQty;
ZAveJZ += sg.AverageWeight;
#region 称重记录
//循环第一个页签
//计算 出栏只数(大鸡数量+小鸡数量) 总小鸡重量 总小鸡只数
foreach (HBSR_HS_SG_BE.HBSR_HS_SG_BE_Line1 line1 in sg.HBSR_HS_SG_BE_Line1)
{
if (line1.ItemInfo != null)
{
if (line1.ItemInfo.ItemCode.Equals("1000") ||
line1.ItemInfo.ItemCode.Equals("1002"))
{
ZCLNum += line1.RecycleNumber;
}
if (line1.ItemInfo.ItemCode.Equals("1002"))
{
ZXJZL += line1.ChickWeight; //小鸡 毛鸡重量
ZXJNum += line1.RecycleNumber;//小鸡数量
ZXJDTZL += line1.CarcassWeight;
}
if (line1.ItemInfo.ItemCode.Equals("1000"))
{
ZDJDTZL += line1.CarcassWeight;
}
}
}
#endregion
#region 品捡扣重
//循环第二个页签
foreach (HBSR_HS_SG_BE.HBSR_HS_SG_BE_Line2 line2 in sg.HBSR_HS_SG_BE_Line2)
{
if (line2.KZCode != null)
{
switch (line2.KZCode.Name)
{
case "嗉料":
ZSL += line2.YKWeight;
break;
case "鸡胗内容物":
ZJZRRW += line2.YKWeight;
break;
case "病变":
ZBB += line2.YKWeight;
break;
case "死鸡":
ZSJZL += line2.YKWeight;
ZSJNum += line2.SiJiNum;
break;
}
}
}
#endregion
}
--给你一个简单的游标例子
DECLARE @BIANLIANG1 INT
DECLARE @BIANLIANG2 varchar(20)
DECLARE Employee_Cursor CURSOR FOR --定义一个游标
SELECT EmployeeID, Title FROM AdventureWorks.HumanResources.Employee;
OPEN Employee_Cursor; --打开游标
FETCH NEXT FROM Employee_Cursor INTO @BIANLIANG1,@BIANLIANG2 ; --获取游标中的记录
WHILE @@FETCH_STATUS = 0 --如果能成功取到记录
BEGIN
/* 这里写你要进行的操作代码 */
FETCH NEXT FROM Employee_Cursor INTO @BIANLIANG1,@BIANLIANG2; -- 获取下一条游标记录
END;
CLOSE Employee_Cursor; --关闭游标
DEALLOCATE Employee_Cursor; --销毁游标
GO
--创建游标
declare @cursor cursor
declare @id int
--设定游标欲操作的数据集
set @cursor=cursor for
select id from Cust_HBSR_HS_SG_BE
--打开游标
open @cursor
--移动游标指向到第一条数据,提取第一条数据存放在变量中
fetch next from @cursor into @id
--如果上一次操作成功则继续循环
while(@@fetch_status=0)
begin
--操作提出的数据
print @id
--继续提下一行
fetch next from @cursor into @id
end
--关闭游标
close @cursor
--删除游标
deallocate @cursor