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(@"查询成功", @"成功"); }