/// <summary> /// 用于向 TB_TableSubmit EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToTB_TableSubmit(TB_TableSubmit tB_TableSubmit) { base.AddObject("TB_TableSubmit", tB_TableSubmit); }
/// <summary> /// 创建新的 TB_TableSubmit 对象。 /// </summary> /// <param name="fID">FID 属性的初始值。</param> public static TB_TableSubmit CreateTB_TableSubmit(global::System.Int32 fID) { TB_TableSubmit tB_TableSubmit = new TB_TableSubmit(); tB_TableSubmit.FID = fID; return tB_TableSubmit; }
/// <summary> /// 提交签证 /// </summary> void submitVisa() { try { var modelCollection = visaORM.Customer.Where(c => c.FSysPut == false && c.FCreateUser == MainContext.UserID && c.FsysZF != true && c.FStopSend != true); string todayStringShort = DateTime.Now.ToString("yyMMdd"); string todayStringAll = DateTime.Now.ToShortDateString(); string NoSeq = "001"; var lastSeqModelList = visaORM.TB_TableSubmit.Where(s => s.FCDate == todayStringShort).OrderByDescending(s => s.FID).Take(1); if (lastSeqModelList != null) { foreach (TB_TableSubmit lastSeqModel in lastSeqModelList) { string tempString = "00" + (Convert.ToInt32(lastSeqModel.FSubmitNo.Substring(lastSeqModel.FSubmitNo.Length - 3)) + 1).ToString(); NoSeq = tempString.Substring(tempString.Length - 3); break; } } foreach (var model in modelCollection) { visaORM.Customer.Attach(model); visaORM.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified); model.FSysPut = true; model.FSysPutDate = DateTime.Now; model.FSysPutUser = MainContext.UserID; var modelSubmit = new TB_TableSubmit(); modelSubmit.FCDate = todayStringShort; modelSubmit.FCompany = MainContext.UserCompanyName; modelSubmit.FSubmitNo = "TJ-" + todayStringShort + "-" + NoSeq; modelSubmit.FAutoID = model.FAutoID; modelSubmit.FSysMemo = txtSubmitMemo.Text; modelSubmit.FCreateDate = DateTime.Now; modelSubmit.FCreateUser = MainContext.UserID; modelSubmit.FModifyDate = DateTime.Now; modelSubmit.FModifyUser = MainContext.UserID; modelSubmit.FStatus = true; visaORM.TB_TableSubmit.AddObject(modelSubmit); } visaORM.SaveChanges(); newSubmitNo = "TJ-" + todayStringShort + "-" + NoSeq; MessageBox.Show("提交成功"); if (System.Windows.MessageBox.Show("提交成功,是否打印表二", "保存成功", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { //printVisa(); (App.Current.Windows[1] as MainWindow).MainFrame.Navigate(new Report2(MainContext.UserCompanyName, newSubmitNo)); } refreshSubmit(); } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }