/// <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);
}
}
