| | |
|---|
| | | "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); //时间 |
|---|
| | | |
|---|
| | | //获取有多少年 |
|---|
