| | |
|---|
| | | case '工序流转卡': |
|---|
| | | HModName = "ProcessExchangeBill_3772"; |
|---|
| | | break; |
|---|
| | | case '销售出库单': |
|---|
| | | HModName = "SellOutBill_1205"; |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | //初始查询 |
|---|
| | | get_Display(sWhere, HSouceBillType); |
|---|
| | |
|---|
| | | } |
|---|
| | | return sWhere; |
|---|
| | | break; |
|---|
| | | case "销售出库单": |
|---|
| | | if (HBillNo) { |
|---|
| | | sWhere += " and 单据号 like '%" + HBillNo + "%'"; |
|---|
| | | } |
|---|
| | | if (PartNumber) { |
|---|
| | | sWhere += " and 物料代码 like '%" + PartNumber + "%'"; |
|---|
| | | } |
|---|
| | | if (PartName) { |
|---|
| | | sWhere += " and 物料名称 like '%" + PartName + "%'"; |
|---|
| | | } |
|---|
| | | if (HDeptName && HDeptName != 0) { |
|---|
| | | sWhere += " and HDeptID = '" + HDeptName + "'"; |
|---|
| | | } |
|---|
| | | return sWhere; |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
