| | |
| | | SetCellText(spreadsheetControl1.ActiveWorksheet, "B1", "申请数量", true); |
| | | SetCellText(spreadsheetControl1.ActiveWorksheet, "C1", "申请备注", true); |
| | | break; |
| | | case "其它出库": |
| | | SetCellText(spreadsheetControl1.ActiveWorksheet, "A1", "物料编号", true); |
| | | SetCellText(spreadsheetControl1.ActiveWorksheet, "B1", "申请数量", true); |
| | | SetCellText(spreadsheetControl1.ActiveWorksheet, "C1", "申请备注", true); |
| | | //SetCellText(spreadsheetControl1.ActiveWorksheet, "D1", "不良类型", true); |
| | | break; |
| | | } |
| | | } |
| | | else |
| | |
| | | itemName = dy.itemName, |
| | | itemModel = dy.itemModel, |
| | | dwName = dy.kfName, |
| | | itemId = dy.itemId |
| | | itemId = dy.itemId, |
| | | //默认仓库和仓库数量 |
| | | depotName = dy.depotName, |
| | | depotId = dy.depotId, |
| | | kcQty = dy.kcQty, |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | MsgHelper.ShowError("复制失败:【" + itemNo + "】可能不存在,请检查后重试!"); |
| | | return; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.ShowError("复制失败:【" + itemNo + "】发生错误,请检查后重试!" + ex.Message); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | break; |
| | | case "其它出库": |
| | | #region MyRegion |
| | | { |
| | | for (int row = 2; row <= rowsCount; row++) |
| | | { |
| | | string itemNo = spreadsheetControl1.ActiveWorksheet.Cells["A" + row.ToString()].Value.ToString().Trim(); |
| | | string sl = spreadsheetControl1.ActiveWorksheet.Cells["B" + row.ToString()].Value.ToString().Trim(); |
| | | string bz = spreadsheetControl1.ActiveWorksheet.Cells["C" + row.ToString()].Value.ToString().Trim(); |
| | | var _obj = new |
| | | { |
| | | itemNo = itemNo, |
| | | orgId = this.orgId, |
| | | }; |
| | | try |
| | | { |
| | | var strJson = UtilityHelper.HttpPost("", "MesItemsManager/GetModelByOrg", JsonConvert.SerializeObject(_obj)); |
| | | var _rtn = UtilityHelper.ReturnToDynamic(strJson); |
| | | if (_rtn.rtnCode > 0) |
| | | { |
| | | var dy = _rtn.rtnData; |
| | | list.Add(new |
| | | { |
| | | itemNo = itemNo, |
| | | sl = sl, |
| | | bz = bz, |
| | | itemName = dy.itemName, |
| | | itemModel = dy.itemModel, |
| | | dwName = dy.kfName, |
| | | itemId = dy.itemId, |
| | | //默认仓库和仓库数量 |
| | | depotName = dy.depotName, |
| | | depotId = dy.depotId, |
| | | kcQty = dy.kcQty, |
| | | }); |
| | | } |
| | | else |