private void cbSubmitList_SelectedIndexChanged(object sender, RoutedEventArgs e) { try { if (cbSubmitList.SelectedItem != null) { string cbSelectValue = cbSubmitList.SelectedItem.ToString(); //var selectCustomerList = from c in visaORM.Customer //join s in visaORM.TB_TableSubmit //on c.FQZID equals s.FQZID //where s.FSubmitNo == cbSelectValue //select c; gridMain.ItemsSource = visaORM.sp_SelectTbSubmitWithSubmitNo(MainContext.UserCompanyName, cbSelectValue); // selectCustomerList.ToList(); TB_TableSubmit ts = visaORM.TB_TableSubmit.FirstOrDefault(s => s.FSubmitNo == cbSelectValue); if (ts != null) { txtSubmitNo.Text = ts.FSubmitNo; txtDate.Text = ts.FCDate; txtCompanyName.Text = ts.FCompany; txtSubmitMemo.Text = ts.FSysMemo; } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }
private void btnZFVisa_Click(object sender, RoutedEventArgs e) { if (gridMain.SelectedItem == null) { MessageBox.Show("请选择一条数据"); return; } try { if (MessageBox.Show("是否确认作废该签证?", "作废确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { int CID = (gridMain.SelectedItem as sp_Customer_Select_ByDate_Result).FID; Customer cObj = visaORM.Customer.FirstOrDefault(c => c.FID == CID); if (cObj == null) { MessageBox.Show("找不到对应签证数据,作废失败"); return; } visaORM.Customer.Attach(cObj); cObj.FsysZF = true; cObj.FSysSend = false; cObj.FSysPut = false; cObj.FSysChk = false; cObj.FSysPrint = false; visaORM.ObjectStateManager.ChangeObjectState(cObj, System.Data.EntityState.Modified); TB_TableSubmit submitObj = visaORM.TB_TableSubmit.FirstOrDefault(s1 => s1.FAutoID == cObj.FAutoID); if (submitObj != null) { visaORM.DeleteObject(submitObj); } SendInfo sendObj = visaORM.SendInfo.FirstOrDefault(s2 => s2.FCustomerID == cObj.FID); if (sendObj != null) { visaORM.DeleteObject(sendObj); } visaORM.SaveChanges(); MessageBox.Show("已经作废签证号为 " + cObj.FPassportNo + " 的签证"); dateFrom_EditValueChanged(null, null); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }
private void btnDelVisa_Click(object sender, RoutedEventArgs e) { if (gridMain.SelectedItem == null) { MessageBox.Show("请选择一条数据"); return; } if (MessageBox.Show("是否确认删除该签证,取消后将不能使用?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { int CID = (gridMain.SelectedItem as sp_Customer_Select_ByDate_Result).FID; Customer cObj = visaORM.Customer.FirstOrDefault(c => c.FID == CID); if (cObj == null) { MessageBox.Show("找不到对应签证数据,作废失败"); return; } TB_TableSubmit submitObj = visaORM.TB_TableSubmit.FirstOrDefault(s1 => s1.FAutoID == cObj.FAutoID); if (submitObj != null) { visaORM.DeleteObject(submitObj); } SendInfo sendObj = visaORM.SendInfo.FirstOrDefault(s2 => s2.FCustomerID == cObj.FID); if (sendObj != null) { visaORM.DeleteObject(sendObj); } visaORM.DeleteObject(cObj); visaORM.SaveChanges(); MessageBox.Show("已经删除签证号为 " + cObj.FPassportNo + " 的签证"); dateFrom_EditValueChanged(null, null); } }
public ChkUnScan(ObservableCollection <Customer> ScannedCustomers) { InitializeComponent(); FAutoID = ScannedCustomers.First().FAutoID; TB_TableSubmit submitObj = visaORM.TB_TableSubmit.FirstOrDefault(tbs => tbs.FAutoID == FAutoID); if (submitObj == null) { MessageBox.Show("该签证尚未提交,请先提交"); return; } string submitNo = submitObj.FSubmitNo; customerObjs = (from c in visaORM.Customer join k in visaORM.TB_TableSubmit.Where(tbs => tbs.FSubmitNo == submitNo) on c.FAutoID equals k.FAutoID select c).ToList(); InitDataContext(ScannedCustomers); gridMain.DataContext = customerObjs; }
/// <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); } }