| | |
|---|
| | | rowCount = count; |
|---|
| | | } |
|---|
| | | |
|---|
| | | sqlString += "SELECT DISTINCT tb1.*,tb2.Status as AsnStatus,tb3.RealName as CreateUserName, "; |
|---|
| | | sqlString += "SELECT DISTINCT tb1.*,tb2.Type as AsnType,tb2.Status as AsnStatus,tb3.RealName as CreateUserName, "; |
|---|
| | | sqlString += "tb4.RealName as UpdateUserName,isnull(tb6.UnitName,tb5.UnitNo) as UnitName,tb7.PackagName "; |
|---|
| | | sqlString += "FROM BllArrivalNoticeDetail AS tb1 "; |
|---|
| | | sqlString += "LEFT JOIN BllArrivalNotice AS tb2 ON tb1.ASNNo = tb2.ASNNo "; |
|---|
| | |
|---|
| | | Standard = skuModel.Standard, |
|---|
| | | LotNo = asnDetailModel.LotNo, |
|---|
| | | LotText = "", |
|---|
| | | Qty = asnDetailModel.Qty, |
|---|
| | | Qty = (decimal)asnDetailModel.Qty, |
|---|
| | | PackagNo = asnDetailModel.PackagNo, |
|---|
| | | SupplierLot = asnDetailModel.SupplierLot, |
|---|
| | | Status = "0", |
|---|
| | |
|---|
| | | { |
|---|
| | | SkuNo = d.SkuNo, |
|---|
| | | LotNo = d.LotNo, |
|---|
| | | Qty = int.Parse(d.CompleteQty.ToString()), |
|---|
| | | Qty = d.CompleteQty, |
|---|
| | | PackagNo = d.PackagNo, |
|---|
| | | SupplierLot = d.SupplierLot |
|---|
| | | }; |
|---|
