void SaveModel()
{
MainBar.Focus();
if (string.IsNullOrEmpty(txtName.Text))
{
MessageBox.Show("请填写国家英文名");
return;
}
if (string.IsNullOrEmpty(txtEnName.Text))
{
MessageBox.Show("请填写国家英文名");
return;
}
if (model.FID == 0 || model.FID.ToString() == "")
{
visaORM.TCountry.AddObject(model);
visaORM.SaveChanges();
countryCollection.Add(model);
}
else
{
visaORM.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
visaORM.SaveChanges();
}
MessageBox.Show("保存成功");
}
/// <summary>
/// 保存为已打印
/// </summary>
private void SaveSysPrint()
{
foreach (var SendModel in sendCollection.Where(s => s.FSelectItem == true))
{
SendInfo sObj = visaORM.SendInfo.FirstOrDefault(s => s.FQZID == SendModel.FQZID);
if (sObj != null)
{
if (sObj.FSysPrintNum == null)
{
sObj.FSysPrintNum = 1;
}
else
{
sObj.FSysPrintNum = sObj.FSysPrintNum + 1;
}
sObj.FSysPrint = true;
sObj.FSysPrintDate = DateTime.Now;
sObj.FSysPrintUser = MainContext.UserID;
visaORM.ObjectStateManager.ChangeObjectState(sObj, System.Data.EntityState.Modified);
Customer cObj = visaORM.Customer.FirstOrDefault(c => c.FID == sObj.FCustomerID);
if (cObj != null)
{
cObj.FSysPrint = true;
cObj.FSysPrintDate = DateTime.Now;
cObj.FSysPutUser = MainContext.UserID;
visaORM.ObjectStateManager.ChangeObjectState(cObj, System.Data.EntityState.Modified);
}
}
}
visaORM.SaveChanges();
}
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 UserDel()
{
if (DXMessageBox.Show("是否确定删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
User tempModel = LeftGrid.SelectedItem as User;
if (tempModel == null)
{
return;
}
model = tempModel;
model.FIsDelete = true;
visaORM.ObjectStateManager.ChangeObjectState(model, EntityState.Modified);
visaORM.SaveChanges();
userList.Remove(model);
InitData();
}
}
void DelModel()
{
if (MainGrid.SelectedItem == null)
{
MessageBox.Show("请选择一行");
return;
}
if (MessageBox.Show("是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
model = MainGrid.SelectedItem as TB_AuditPosition;
model.FStatus = false;
visaORM.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
visaORM.SaveChanges();
vietnamCollection.Remove(model);
}
}
private void CustomerSave()
{
try
{
this.MainBar.Focus();
if (!ValidateControl(txtNameEn, "英文姓名"))
{
return;
}
if (!ValidateControl(txtPassportNo, "护照号码"))
{
return;
}
this.model.FModifyDate = DateTime.Now;
this.model.FModifyUser = MainContext.UserID;
if (this.model.FID == 0 || this.model.FID.ToString() == "")
{
visaORM.CustomerT.AddObject(this.model);
this.model.FCreateDate = DateTime.Now;
this.model.FCreateUser = MainContext.UserID;
visaORM.SaveChanges();
//InitData();
customerCollection.Add(model);
this.LeftGrid.SelectedItem = model;
}
else
{
visaORM.ObjectStateManager.ChangeObjectState(this.model, System.Data.EntityState.Modified);
visaORM.SaveChanges();
}
MessageBox.Show("保存成功");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
Log.WriteLog.WriteErorrLog(ex);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
modelPort.FParaValue = txtPort.Text;
visaORM.ObjectStateManager.ChangeObjectState(modelPort, System.Data.EntityState.Modified);
visaORM.SaveChanges();
modelProtocol.FParaValue = txtProtocol.Text;
visaORM.ObjectStateManager.ChangeObjectState(modelProtocol, System.Data.EntityState.Modified);
visaORM.SaveChanges();
MessageBox.Show("保存成功");
}
catch (System.Exception ex)
{
MessageBox.Show("保存失败，原因:" + ex.ToString());
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
List <TB_Position> pList = visaORM.TB_Position.Where(p => p.FGroupID == gourpIDAll && p.FStatus == true).ToList();
foreach (var p in pList)
{
visaORM.ObjectStateManager.ChangeObjectState(p, System.Data.EntityState.Modified);
}
visaORM.SaveChanges();
MessageBox.Show("保存成功");
dg.Close();
}
//
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 auditList()
{
MainBar.Focus();
if (cbSentVisa.SelectedIndex == -1)
{
MessageBox.Show("请选择需要审核的名单");
return;
}
//string SentNo = cbSentVisa.SelectedItem.ToString();
//var modelCollection = from c in visaORM.Customer
// join s in visaORM.SendInfo
// on c.FID equals s.FCustomerID
// where s.FSendNo == SentNo
// select c;
string todayStringShort = DateTime.Now.ToString("yyMMdd");
string todayStringAll = DateTime.Now.ToShortDateString();
int i = 0;
foreach (var model in sendCollection)
{
sp_SelectTable3ForExcel_Result rowObj = gridMain.GetRow(i) as sp_SelectTable3ForExcel_Result;
i++;
if (rowObj.SelectChk == false)
{
continue;
}
Customer cModel = visaORM.Customer.FirstOrDefault(c => c.FID == model.QID);
if (cModel != null)
{
visaORM.Customer.Attach(cModel);
cModel.FSysChk = true;
cModel.FSysChkDate = DateTime.Now;
cModel.FSysChkUser = MainContext.UserID;
visaORM.ObjectStateManager.ChangeObjectState(cModel, System.Data.EntityState.Modified);
var modelSend = visaORM.SendInfo.FirstOrDefault(s => s.FCustomerID == cModel.FID);
if (modelSend != null)
{
modelSend.FModifyDate = DateTime.Now;
modelSend.FModifyUser = MainContext.UserID;
modelSend.FSysChk = true;
modelSend.FSysChkDate = cModel.FSysChkDate;
modelSend.FSysChkUser = MainContext.UserID;
visaORM.ObjectStateManager.ChangeObjectState(modelSend, System.Data.EntityState.Modified);
}
}
}
visaORM.SaveChanges();
MessageBox.Show("审核成功");
InitData();
}
/// <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);
}
}
/// <summary>
/// 提交送审名单
/// </summary>
void SendList()
{
// var modelCollection = visaORM.Customer.Where(c => c.FSysPut == false);
try
{
if (cbVietnamCompany.SelectedItem == null)
{
MessageBox.Show("请先选择越南公司");
return;
}
string todayStringShort = DateTime.Now.ToString("yyMMdd");
string todayStringAll = DateTime.Now.ToShortDateString();
string selectietnamCompany = cbVietnamCompany.SelectedItem.ToString();
int orderNum = 1;
foreach (var model in Sendoc)
{
var BlackListObj = visaORM.CustomerT.FirstOrDefault(c => c.FPassportNo == model.FPassportNo);
if (BlackListObj != null)
{
if (MessageBox.Show(string.Format("护照号{0}是特殊人物，是否让其提交？", model.FPassportNo), "特殊人物确认", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
continue;
}
}
if (model.FSysSend == true)
{
MessageBox.Show(" 此签证已经送审过，不能再次送审:" + model.FPassportNo);
continue;
}
//visaORM.Customer.Attach(model);
Customer modelC = visaORM.Customer.FirstOrDefault(c => c.FID == model.FID);
if (modelC == null)
{
MessageBox.Show("该签证不存在或者已经被删除：" + model.FPassportNo);
continue;
}
visaORM.ObjectStateManager.ChangeObjectState(modelC, System.Data.EntityState.Modified);
modelC.FSysSend = true;
modelC.FSysSendDate = DateTime.Now;
modelC.FSysSendUser = MainContext.UserID;
modelC.FYNCom = selectietnamCompany;
var modelSend = new SendInfo();
modelSend.FCustomerID = model.FID;
modelSend.FQZID = model.FQZID;
modelSend.FSendDate = modelC.FSysSendDate;
modelSend.FDSN = txtDSN.Text;
modelSend.FVietnamCompany = selectietnamCompany;
modelSend.FCreateCompany = MainContext.UserCompanyName;
modelSend.FSendNo = modelSend.FDSN;
modelSend.FOrder = orderNum;
modelSend.FCDate = todayStringShort;
modelSend.FSysPrintNum = 0;
modelSend.FCreateDate = DateTime.Now;
modelSend.FCreateUser = MainContext.UserID;
modelSend.FModifyDate = DateTime.Now;
modelSend.FModifyUser = MainContext.UserID;
modelSend.FStatus = true;
modelSend.FSysSend = true;
modelSend.FSysSendDate = modelC.FSysSendDate;
modelSend.FSysSendUser = 1;
modelSend.FSysChk = false;
modelSend.FSysPrint = false;
visaORM.SendInfo.AddObject(modelSend);
orderNum++;
}
visaORM.SaveChanges();
Sendoc.Clear();
MessageBox.Show("送审成功");
//重新初始化DSN下拉
InitSendComboBox();
this.sendNoString = txtDSN.Text;
//cbListSend.SelectedItem = txtDSN.Text;
//导出
exportList();
//((TableView)gridMain.View).Print();
//越南公司清空
this.cbVietnamCompany.SelectedIndex = -1;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
Log.WriteLog.WriteErorrLog(ex);
}
}