/// <summary> /// 刷新 /// </summary> private void RefreshData() { var eo = new EasOrderService.EasOrder(); eo.Url = BaseStructure.OrderServiceUri; uGridCheck.DataSource = eo.GetTransfer(); }
private void uGridCheck_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e) { if (e.Cell.Row == null || e.Cell.Row.Index < 0) { return; } _cOrderNumber = e.Cell.Row.Cells["cOrderNumber"].Value.ToString(); _iRowNo = e.Cell.Row.Index; var eo = new EasOrderService.EasOrder(); eo.Url = BaseStructure.OrderServiceUri; var dtTemp = eo.GetPoDetail(_cOrderNumber); uGridChecks.DataSource = dtTemp; if (dtTemp != null && dtTemp.Rows.Count > 0) { var strTemp = dtTemp.Compute("sum(FAmount)", "").ToString(); if (decimal.TryParse(strTemp, out _iSum)) { _cSumUpper = WmsFunction.ExchangeUper(_iSum); } else { _iSum = 0; _cSumUpper = ""; } } }
private void Work_EasProTransferOrder_Load(object sender, EventArgs e) { var eo = new EasOrderService.EasOrder(); eo.Url = BaseStructure.OrderServiceUri; uGridCheck.DataSource = eo.GetTransfer(); }
private void RefreshData() { var eo = new EasOrderService.EasOrder { Url = BaseStructure.OrderServiceUri }; uGridCheck.DataSource = eo.GetOem(); }
private void uGridCheck_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e) { if (e.Cell.Row == null || e.Cell.Row.Index < 0) { return; } _cOrderNumber = e.Cell.Row.Cells["cOrderNumber"].Value.ToString(); _iRowNo = e.Cell.Row.Index; var eo = new EasOrderService.EasOrder(); eo.Url = BaseStructure.OrderServiceUri; uGridChecks.DataSource = eo.GetTransferDetail(_cOrderNumber); }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { using (var seq = new SearchEasQuery()) { if (seq.ShowDialog() != DialogResult.Yes) { return; } var eo = new EasOrderService.EasOrder { Url = BaseStructure.OrderServiceUri }; uGridCheck.DataSource = eo.GetTransfer2(seq.OrderNumber); } }
private void SyncInventory() { var easOrder = new EasOrderService.EasOrder() { Url = _OrderService }; var dtPro = easOrder.GetPro(); var sfun = new SyncFunction(_wmsCon); pbMain.Maximum = dtPro.Rows.Count - 1; pbMain.Value = 0; for (var i = 0; i < dtPro.Rows.Count; i++) { var synCmd = new SqlCommand("SyncInventory") { CommandType = CommandType.StoredProcedure }; synCmd.Parameters.AddWithValue("@cInvCode", dtPro.Rows[i]["cInvCode"]); synCmd.Parameters.AddWithValue("@cInvName", dtPro.Rows[i]["cInvName"]); synCmd.Parameters.AddWithValue("@cInvType", "Pro"); synCmd.Parameters.AddWithValue("@FStatus", dtPro.Rows[i]["FStatus"]); synCmd.Parameters.AddWithValue("@bLotMgr", dtPro.Rows[i]["FIsLotNumber"]); sfun.ExecSqlCmd(synCmd); pbMain.Value = i; } var dtSemi = easOrder.GetSemi(); pbMain.Maximum = dtSemi.Rows.Count - 1; pbMain.Value = 0; for (var i = 0; i < dtSemi.Rows.Count; i++) { var synCmd = new SqlCommand("SyncInventory") { CommandType = CommandType.StoredProcedure }; synCmd.Parameters.AddWithValue("@cInvCode", dtPro.Rows[i]["cInvCode"]); synCmd.Parameters.AddWithValue("@cInvName", dtPro.Rows[i]["cInvName"]); synCmd.Parameters.AddWithValue("@cInvType", "Semi"); synCmd.Parameters.AddWithValue("@FStatus", dtPro.Rows[i]["FStatus"]); synCmd.Parameters.AddWithValue("@bLotMgr", dtPro.Rows[i]["FIsLotNumber"]); sfun.ExecSqlCmd(synCmd); pbMain.Value = i; } var dtRm = easOrder.GetRm(); pbMain.Maximum = dtRm.Rows.Count - 1; pbMain.Value = 0; for (var i = 0; i < dtRm.Rows.Count; i++) { var synCmd = new SqlCommand("SyncInventory") { CommandType = CommandType.StoredProcedure }; synCmd.Parameters.AddWithValue("@cInvCode", dtPro.Rows[i]["cInvCode"]); synCmd.Parameters.AddWithValue("@cInvName", dtPro.Rows[i]["cInvName"]); synCmd.Parameters.AddWithValue("@cInvType", "Rm"); synCmd.Parameters.AddWithValue("@FStatus", dtPro.Rows[i]["FStatus"]); synCmd.Parameters.AddWithValue("@bLotMgr", dtPro.Rows[i]["FIsLotNumber"]); sfun.ExecSqlCmd(synCmd); pbMain.Value = i; } }