/// <summary> /// 表格中保存图片事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Image_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { if (string.IsNullOrEmpty(CurrentItem.FQZID)) { MessageBox.Show("请先设置签证号"); return; } try { Customer cObj = visaORM.Customer.FirstOrDefault(c => c.FID == CurrentItem.QID); if (cObj != null) { if (!string.IsNullOrEmpty(cObj.FQZID)) //如果已有签证号,提示是否覆盖 { if ( System.Windows.MessageBox.Show( string.Format("护照号为{0}已存在签证号,是否覆盖当前号码?", CurrentItem.PID), "已存在签证号", MessageBoxButton.YesNo) == MessageBoxResult.No) { return; } ; } //更新表一的签证号码 cObj.FQZID = CurrentItem.FQZID; //更新签证号码表中的使用情况 QZKC QZNOObj = visaORM.QZKC.FirstOrDefault(q => q.FIsUse == false && q.FQZID == CurrentItem.FQZID); if (QZNOObj == null) { MessageBox.Show(string.Format("签证号码{0}已经被使用或不存在,请添加或使用其他起始号码", CurrentItem.FQZID)); return; } cObj.FQZID = QZNOObj.FQZID; QZNOObj.FIsUse = true; //更新表三的签证号码 SendInfo sObj = visaORM.SendInfo.FirstOrDefault(s => s.FCustomerID == cObj.FID); if (sObj != null) { sObj.FQZID = QZNOObj.FQZID; visaORM.ObjectStateManager.ChangeObjectState(sObj, System.Data.EntityState.Modified); } visaORM.ObjectStateManager.ChangeObjectState(cObj, System.Data.EntityState.Modified); visaORM.ObjectStateManager.ChangeObjectState(QZNOObj, System.Data.EntityState.Modified); visaORM.SaveChanges(); MessageBox.Show("保存成功"); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }
void SetIDCs(int numStart, int numEnd, string FirstLetter, int state) { QZKC tempModel; IDCs.Clear(); switch (state) { case 2: for (int i = numStart; i <= numEnd; i++) { tempModel = new QZKC(); int NumberLenght = i.ToString().Length; tempModel.FQZID = GetVisaNumberString(FirstLetter, NumberLenght, i); IDCs.Add(tempModel); //if (visaORM.QZKC.FirstOrDefault(q => q.FQZID == tempModel.FQZID && q.FIsUse==true) != null) MainListBox.SelectedItems.Add(tempModel); } break; case 1: for (int i = numStart; i <= numEnd; i++) { tempModel = new QZKC(); int NumberLenght = i.ToString().Length; tempModel.FQZID = GetVisaNumberString(FirstLetter, NumberLenght, i); if (visaORM.QZKC.FirstOrDefault(q => q.FQZID == tempModel.FQZID && q.FIsUse == true) != null) { tempModel.FIsUse = true; IDCs.Add(tempModel); } } break; case 0: for (int i = numStart; i <= numEnd; i++) { tempModel = new QZKC(); int NumberLenght = i.ToString().Length; tempModel.FQZID = GetVisaNumberString(FirstLetter, NumberLenght, i); if (visaORM.QZKC.FirstOrDefault(q => q.FQZID == tempModel.FQZID && q.FIsUse == false) != null) { IDCs.Add(tempModel); } } break; default: break; } }
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(); } }
// private void btnAdd_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; numStart = Convert.ToInt32(txtStartNum.Text); numEnd = Convert.ToInt32(txtEndNum.Text); string FirstLetter = txtLetter.Text.ToUpper(); 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) { QZKC tempObj = new QZKC(); visaORM.QZKC.AddObject(tempObj); tempObj.FQZID = QZID; tempObj.FIsUse = false; visaORM.SaveChanges(); } } visaORM.SaveChanges(); MessageBox.Show("添加完成"); InitSumInfo(); stateAll_Checked(sender, null); btnPrev_Click(null, null); } }
void sendInfoModel_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { try { if (e.PropertyName == "FQZID" && this.CurrentItem != null && !string.IsNullOrEmpty(this.CurrentItem.FQZID)) { //判断当前签证号是否已经在集合中 if (sendCollection.FirstOrDefault(s => s.FQZID == CurrentItem.FQZID && s.QID != CurrentItem.QID) != null) { DXMessageBox.Show("该签证号已经在本名单中被使用,修改无效。"); CurrentItem.FQZID = ""; return; } SendInfo sendModel = visaORM.SendInfo.FirstOrDefault(c => c.FCustomerID == CurrentItem.QID); if (sendModel.FQZID == CurrentItem.FQZID) { return; } if (sendModel == null) { DXMessageBox.Show("该签证已经被删除,修改无效。"); CurrentItem.FQZID = sendModel.FQZID; return; } Customer custModel = visaORM.Customer.FirstOrDefault(c => c.FID == CurrentItem.QID); //if (custModel == null) //{ // DXMessageBox.Show("还签证已经被删除,修改无效。"); // return; //} QZKC qzkc = visaORM.QZKC.FirstOrDefault(q => q.FQZID == CurrentItem.FQZID); if (qzkc == null) { DXMessageBox.Show("还没有该签证号,请联系管理员设置,或使用其他号码。"); CurrentItem.FQZID = sendModel.FQZID; return; } if (qzkc.FIsUse == true) { DXMessageBox.Show("改签证号码已经被使用,使用其他号码。"); CurrentItem.FQZID = sendModel.FQZID; return; } if (!object.Equals(CurrentItem.FQZID, CurrentItem.FQZID.ToUpper())) { CurrentItem.FQZID = CurrentItem.FQZID.ToUpper(); return; } //QZKC qzkcOri = visaORM.QZKC.FirstOrDefault(q => q.FQZID == custModel.FQZID); ////将原签证号释放 //if (qzkcOri != null) //{ // qzkcOri.FIsUse = false; // visaORM.ObjectStateManager.ChangeObjectState(qzkcOri, System.Data.EntityState.Modified); // visaORM.SaveChanges(); //} //QZKC qzkcNew = visaORM.QZKC.FirstOrDefault(q => q.FQZID == CurrentItem.FQZID); ////将新签证号置为已使用 //if (qzkcNew != null) //{ // qzkcNew.FIsUse = true; // visaORM.ObjectStateManager.ChangeObjectState(qzkcNew, System.Data.EntityState.Modified); // visaORM.SaveChanges(); //} //sendModel.FQZID = CurrentItem.FQZID; //visaORM.ObjectStateManager.ChangeObjectState(sendModel, System.Data.EntityState.Modified); ////修改当前签证的签证号 //if (custModel != null) //{ // custModel.FQZID = CurrentItem.FQZID; // visaORM.ObjectStateManager.ChangeObjectState(custModel, System.Data.EntityState.Modified); //} //visaORM.SaveChanges(); //DXMessageBox.Show("修改签证号成功。"); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }
/// <summary> /// 保存签证号 /// </summary> void saveQZID() { try { this.MainBar.Focus(); if (sendCollection.Count() == 0) { MessageBox.Show("没有签证"); return; } foreach (var SendModel in sendCollection) { if (string.IsNullOrEmpty(SendModel.FQZID)) { if (QZIDnum == "" || QZIDstring == "") { MessageBox.Show("请先设置起始签证号码"); return; } } } string QZID = ""; SendInfo sObj = new SendInfo(); Customer cObj = new Customer(); QZKC QZNOObj = new QZKC(); int i = 0; if (!string.IsNullOrEmpty(QZIDnum)) { i = Convert.ToInt32(QZIDnum); } foreach (var SendModel in sendCollection) { cObj = visaORM.Customer.FirstOrDefault(c => c.FID == SendModel.QID); if (cObj != null) { if (string.IsNullOrEmpty(cObj.FQZID)) //如果没有签证号,就保存签证号 { if (!string.IsNullOrEmpty(SendModel.FQZID)) { QZID = SendModel.FQZID; } else { QZID = GetVisaNumberString(QZIDstring, i.ToString().Length, ref i); } QZNOObj = visaORM.QZKC.FirstOrDefault(q => q.FIsUse == false && q.FQZID == QZID); if (QZNOObj == null) { MessageBox.Show(string.Format("签证号码{0}已经被使用或不存在,请添加或使用其他起始号码", QZID)); return; } cObj.FQZID = QZNOObj.FQZID; QZNOObj.FIsUse = true; sObj = visaORM.SendInfo.FirstOrDefault(s => s.FCustomerID == cObj.FID); if (sObj != null) { sObj.FQZID = QZNOObj.FQZID; } visaORM.ObjectStateManager.ChangeObjectState(sObj, System.Data.EntityState.Modified); visaORM.ObjectStateManager.ChangeObjectState(cObj, System.Data.EntityState.Modified); visaORM.ObjectStateManager.ChangeObjectState(QZNOObj, System.Data.EntityState.Modified); visaORM.SaveChanges(); i++; } else //如果已有签证号,提示是否覆盖 { if ( System.Windows.MessageBox.Show( string.Format("护照号为{0}已存在签证号(可能是上一次录入或者本次手动录入),是否覆盖当前号码?", SendModel.PID), "已存在签证号", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { //更新表一的签证号码 cObj.FQZID = SendModel.FQZID; //更新签证号码表中的使用情况 QZNOObj = visaORM.QZKC.FirstOrDefault(q => q.FIsUse == false && q.FQZID == SendModel.FQZID); if (QZNOObj == null) { MessageBox.Show(string.Format("签证号码{0}已经被使用或不存在,请添加或使用其他起始号码", SendModel.FQZID)); return; } cObj.FQZID = QZNOObj.FQZID; QZNOObj.FIsUse = true; //更新表三的签证号码 sObj = visaORM.SendInfo.FirstOrDefault(s => s.FCustomerID == cObj.FID); if (sObj != null) { sObj.FQZID = QZNOObj.FQZID; visaORM.ObjectStateManager.ChangeObjectState(sObj, System.Data.EntityState.Modified); } visaORM.ObjectStateManager.ChangeObjectState(cObj, System.Data.EntityState.Modified); visaORM.ObjectStateManager.ChangeObjectState(QZNOObj, System.Data.EntityState.Modified); visaORM.SaveChanges(); } } } } MessageBox.Show("保存成功"); if (System.Windows.MessageBox.Show("保存签证成功,是否继续打印表四", "保存成功", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { printTable4(); } //保存时设置为保存为已打印 SaveSysPrint(); //初始化未打印的名单列表 InitNotPrintSource(false); sendCollection.Clear(); cbNotPrint.EditValue = ""; } catch (System.Exception ex) { MessageBox.Show(ex.Message); Log.WriteLog.WriteErorrLog(ex); } }