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 btnDel_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("将删除" + txtNumber.Text + "个号码,是否确定?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (!ValidateControl()) { return; } string stringStart = txtStartNum.Text; string stringEnd = txtEndNum.Text; int numStart = Convert.ToInt32(txtStartNum.Text); int numEnd = Convert.ToInt32(txtEndNum.Text); string FirstLetter = txtLetter.Text; int StringLenght = stringStart.Length; for (int i = numStart; i <= numEnd; i++) { int NumberLenght = i.ToString().Length; string QZID = GetVisaNumberString(FirstLetter, NumberLenght, i); QZKC qzObj = visaORM.QZKC.FirstOrDefault(q => q.FQZID == QZID); if (qzObj != null) { if (qzObj.FIsUse == false) { visaORM.DeleteObject(qzObj); } else { if (MessageBox.Show(QZID + "已经被使用,是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { visaORM.DeleteObject(qzObj); } } } } visaORM.SaveChanges(); MessageBox.Show("删除完成"); InitSumInfo(); } }
void DelModel() { if (MainGrid.SelectedItem == null) { MessageBox.Show("请选择一行"); return; } if (MessageBox.Show("是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { model = MainGrid.SelectedItem as TCountry; visaORM.DeleteObject(model); countryCollection.Remove(model); } }
private void CustomerDel() { CustomerT delObj = visaORM.CustomerT.FirstOrDefault(c => c.FID == model.FID); if (delObj == null) { MessageBox.Show("该数据尚未保存,无需删除"); return; } else { if (MessageBox.Show("是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { visaORM.DeleteObject(delObj); visaORM.SaveChanges(); customerCollection.Remove(delObj); this.model = LeftGrid.SelectedItem as CustomerT; if (this.model == null) { this.model = new CustomerT(); } } } }
private void UserSave() { MainBar.Focus(); if (txtPassConfirm.Text != txtPassword.Text) { MessageBox.Show("两次输入的密码不一致,保存失败。"); return; } if (model.FUserName == null || model.FCompanyName == null) { MessageBox.Show("必须录入用户名和公司。"); return; } if (model.FID == 0 || model.FID.ToString() == "") { var tempObj = visaORM.User.FirstOrDefault(u => u.FUserName == model.FUserName); { if (tempObj != null) { MessageBox.Show("该用户名已经存在,请使用其他用户名"); return; } } visaORM.User.AddObject(model); model.FIsDelete = false; visaORM.SaveChanges(); NowUserId = model.FID; userList.Add(model); //getDefaultModel = 0; InitData(); } else { if (visaORM.ObjectStateManager.GetObjectStateEntries(EntityState.Modified).Count() == 0) { visaORM.User.Attach(model); } visaORM.ObjectStateManager.ChangeObjectState(model, EntityState.Modified); visaORM.SaveChanges(); NowUserId = model.FID; } var list = from m in visaORM.TB_Menu join ur in visaORM.TB_UserRights on m.FID equals ur.FMenuID where m.FType == 1 && ur.FUserID == model.FID select ur; foreach (TB_UserRights urObj in list) { visaORM.DeleteObject(urObj); } selectedMenu.Clear(); foreach (var nodeObjLevel1 in MenuTree.View.Nodes) { foreach (var nodeObjLevel2 in nodeObjLevel1.Nodes) { foreach (var nodeObjLevel3 in nodeObjLevel2.Nodes) { if (nodeObjLevel3.IsChecked == true) { selectedMenu.Add(nodeObjLevel3.Content as TB_Menu); } } if (nodeObjLevel2.IsChecked == true) { selectedMenu.Add(nodeObjLevel2.Content as TB_Menu); } } if (nodeObjLevel1.IsChecked == true) { selectedMenu.Add(nodeObjLevel1.Content as TB_Menu); } } TB_UserRights urModel; foreach (var menuObj in selectedMenu) { urModel = new TB_UserRights(); urModel.FUserID = model.FID; urModel.FMenuID = menuObj.FID; urModel.FCreateDate = DateTime.Now; urModel.FCreateUser = MainContext.UserID; urModel.FModifyDate = DateTime.Now; urModel.FModifyUser = MainContext.UserID; urModel.FStatus = true; visaORM.TB_UserRights.AddObject(urModel); } TB_UserRights outMenuObj; if (CreateURModel(cbTable2Admin, out outMenuObj) == true) { if (outMenuObj != null) { visaORM.TB_UserRights.AddObject(outMenuObj); } } else { if (outMenuObj != null) { visaORM.DeleteObject(outMenuObj); } } visaORM.SaveChanges(); InitData(); MessageBox.Show("保存成功"); }