/// <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;
}
}
