private void btnRemoveCH_Execute(object sender, SimpleActionExecuteEventArgs e) { if (View.CurrentObject == null) return; UnitOfWork uow = new UnitOfWork(); uow.BeginTransaction(); OutlookSystemItem olItem = new OutlookSystemItem(); foreach (Item tmpItem in View.SelectedObjects) { string itemNo = tmpItem.ItemNo; Item item = Item.FindItem(uow, itemNo); if (item.ItemNo.Substring(0, 2) == "CH") { item.ItemNo = item.ItemNo.Replace("CH", ""); olItem.SaveToOutlookSystem(item); item.IsConfirming = true; item.Save(); uow.CommitChanges(); } } uow.CommitTransaction(); }
private void btnCreateFromOldSystem_Execute(object sender, SimpleActionExecuteEventArgs e) { if (View.CurrentObject == null) return; Logger.For(this).Info("从大货系统取资料"); StringBuilder sb = new StringBuilder(); UnitOfWork uow = (UnitOfWork)((XPObjectSpace)View.ObjectSpace).Session; sb.AppendLine("请确认是否从大货系统取出以下产品资料 !!"); foreach (Item items in View.SelectedObjects) { sb.AppendLine(string.Format("产品编码 : {0}, 产品名称 : {1}, 产品种类 : {2}", items.ItemNo, items.ItemName, items.ItemType.ItemTypeName)); } DialogResult dr = XtraMessageBox.Show(sb.ToString(), "确认取出", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { //try //{ foreach (Item items in e.SelectedObjects) { OutlookSystemItem osItem = new OutlookSystemItem(); osItem.CreateItemFromOutlookSystem(items.ItemNo, uow); } uow.CommitTransaction(); XtraMessageBox.Show("完成从大货取出产品资料 !!!"); //} //catch (Exception ex) //{ // XtraMessageBox.Show(ex.Message, "錯誤", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); // uow.RollbackTransaction(); //} } }
private void btnFixSubcon_Click(object sender, EventArgs e) { if (InitExcel("Item") == false) return; OutlookSystemItem olItem = new OutlookSystemItem(); UnitOfWork uow = new UnitOfWork(); String itemNo; string workCenterNo; string workDesc; RouteLine rLine; WorkCenter workCenter; int row = 3; uow.BeginTransaction(); while (ExcelHelper.GetCellStringValue(xlSht, row, 1) != "") { itemNo = ExcelHelper.GetCellStringValue(xlSht, row, 1); olItem.InitRst(itemNo); if (olItem.GetStringField(olItem.rst.Fields["nw:partno"]) != "") { workCenterNo = olItem.GetStringField(olItem.rst.Fields["nw:plating:plater"]); workDesc = olItem.GetStringField(olItem.rst.Fields["nw:plating"]); workCenter = WorkCenter.Find(uow, workCenterNo); if (workCenter != null) { rLine = uow.FindObject<RouteLine>(CriteriaOperator.Parse(string.Format("Item.ItemNo = '{0}' AND WorkCenter.Oid = '{1}'", itemNo, workCenter.Oid))); if (rLine != null) { rLine.updateTimeStamp = false; rLine.WorkDesc = workDesc; rLine.Save(); xlSht.Cells[row, 6] = "ok"; } } } row++; } uow.CommitTransaction(); }
private void btnOutlookItem_Click(object sender, EventArgs e) { if (InitExcel("Item") == false) return; OutlookSystemItem olItem = new OutlookSystemItem(); UnitOfWork uow = new UnitOfWork(); bool replaceItem = false; if (ItemExist.SelectedIndex == 0) replaceItem = true; String itemNo; int row = 3; uow.BeginTransaction(); while (ExcelHelper.GetCellStringValue(xlSht, row, 1) != "") { itemNo = ExcelHelper.GetCellStringValue(xlSht, row, 1); olItem.CreateItemFromOutlookSystem(itemNo, uow, replaceItem); xlSht.Cells[row, 6] = "ok"; row++; } uow.CommitTransaction(); }
public void SaveToOldSystem() { OutlookSystemItem osItem = new OutlookSystemItem(); osItem.SaveToOutlookSystem(this); }