/// <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);
}
}
//
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);
}
}
/// <summary>
/// 用于向 QZKC EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToQZKC(QZKC qZKC)
{
base.AddObject("QZKC", qZKC);
}
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;
}
}
/// <summary>
/// 创建新的 QZKC 对象。
/// </summary>
/// <param name="fQZID">FQZID 属性的初始值。</param>
/// <param name="fIsUse">FIsUse 属性的初始值。</param>
public static QZKC CreateQZKC(global::System.String fQZID, global::System.Boolean fIsUse)
{
QZKC qZKC = new QZKC();
qZKC.FQZID = fQZID;
qZKC.FIsUse = fIsUse;
return qZKC;
}
