| | |
| | | "where bind.IsDel = '0' and notice.IsDel = '0' and bind.LotNo in (select LotNo from DataStock where IsDel = '0') "; |
| | | //出库 |
| | | string cstr = "select notice.SONo,allot.LotNo,allot.TaskNo CTaskNo,allot.SkuNo,allot.SkuName,allot.PalletNo," + |
| | | "allot.CreateTime CCreateTime,allot.Qty CQty,allot.Qty CAllotQty,Allot.Qty CFactQty,Allot.CompleteQty CompleteQty," + |
| | | "allot.UpdateTime CCreateTime,allot.Qty CQty,allot.Qty CAllotQty,Allot.Qty CFactQty,Allot.CompleteQty CompleteQty," + |
| | | "allot.LotText,allot.SupplierLot " + |
| | | "from BllExportAllot allot left join BllExportNoticeDetail notice on allot.SODetailNo = notice.Id " + |
| | | "where allot.IsDel = '0' and notice.IsDel = '0' " + |
| | |
| | | { |
| | | EndTime = (Convert.ToDateTime(EndTime).AddDays(1)).ToString(); |
| | | } |
| | | int countjie = 0; //统计结存数量 |
| | | decimal countjie = 0; //统计结存数量 |
| | | ////判断库存信息是否为空 |
| | | //if (stockInfo != null) |
| | | //{ |
| | |
| | | } |
| | | |
| | | //} |
| | | int yeara = 0; //年入库 |
| | | int years = 0; //年出库 |
| | | int montha = 0; //月入库 |
| | | int months = 0; //月出库 |
| | | decimal yeara = 0; //年入库 |
| | | decimal years = 0; //年出库 |
| | | decimal montha = 0; //月入库 |
| | | decimal months = 0; //月出库 |
| | | DateTime createTime = DateTime.Now.AddYears(-1000); //时间 |
| | | |
| | | //获取有多少年 |
| | |
| | | //判断物料是否相同 |
| | | if (dto.SkuNo == item.SkuNo) |
| | | { |
| | | dto.Qty = (Convert.ToInt32(dto.Qty) + Convert.ToInt32(item.Qty)).ToString(); |
| | | dto.FrozenQty = (Convert.ToInt32(dto.FrozenQty) + Convert.ToInt32(item.FrozenQty)).ToString(); |
| | | dto.LockQty = (Convert.ToInt32(dto.LockQty) + Convert.ToInt32(item.LockQty)).ToString(); |
| | | dto.ResidueQty = (Convert.ToInt32(dto.ResidueQty) + Convert.ToInt32(item.ResidueQty)).ToString(); |
| | | var s = Convert.ToDecimal(dto.Qty) ; |
| | | var ss = Convert.ToDecimal(item.Qty); |
| | | dto.Qty = (Convert.ToDecimal(dto.Qty) + Convert.ToDecimal(item.Qty)).ToString(); |
| | | dto.FrozenQty = (Convert.ToDecimal(dto.FrozenQty) + Convert.ToDecimal(item.FrozenQty)).ToString(); |
| | | dto.LockQty = (Convert.ToDecimal(dto.LockQty) + Convert.ToDecimal(item.LockQty)).ToString(); |
| | | dto.ResidueQty = (Convert.ToDecimal(dto.ResidueQty) + Convert.ToDecimal(item.ResidueQty)).ToString(); |
| | | break; |
| | | } |
| | | i += 1; |