private void biAddNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var ew = new EasOrder {
Url = BaseStructure.OrderServiceUri
};
var dtRm = ew.GetRm();
var wf = new WmsFunction(BaseStructure.WmsCon);
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", dtRm.Rows[i]["cInvCode"]);
synCmd.Parameters.AddWithValue("@cInvName", dtRm.Rows[i]["cInvName"]);
synCmd.Parameters.AddWithValue("@cInvType", "Rm");
synCmd.Parameters.AddWithValue("@FStatus", dtRm.Rows[i]["FStatus"]);
synCmd.Parameters.AddWithValue("@bLotMgr", dtRm.Rows[i]["FIsLotNumber"]);
wf.ExecSqlCmd(synCmd);
pbMain.Value = i;
WmsFunction.VLogDebug("SyncInventory", dtRm.Rows[i]["cInvCode"] + "/" + dtRm.Rows[i]["cInvName"] + "/" + dtRm.Rows[i]["FStatus"] + "/" + dtRm.Rows[i]["FIsLotNumber"]);
}
MessageBox.Show(@"同步完成");
var bTrue = biDelete.Caption.Equals("停用");
GetRawMaterial(bTrue);
}
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var bfun = new WmsFunction(BaseStructure.WmsCon);
var strTemp = bfun.GetWhereSqlStr("View_SFOrderAndWmsEAS");
if (string.IsNullOrEmpty(strTemp))
{
return;
}
pageListMain.Condition = " View_SFOrderAndWmsEAS where " + strTemp;
pageListMain.WhereStr = strTemp;
pageListMain.GetRecord();
WmsFunction.VLogDebug("biSearch_ItemClick", pageListMain.Condition + "/" + pageListMain.WhereStr);
MessageBox.Show(@"查询成功", @"成功");
}
