private void cbSubmitList_SelectedIndexChanged(object sender, RoutedEventArgs e)
{
try
{
if (cbSubmitList.SelectedItem != null)
{
string cbSelectValue = cbSubmitList.SelectedItem.ToString();
//var selectCustomerList = from c in visaORM.Customer
//join s in visaORM.TB_TableSubmit
//on c.FQZID equals s.FQZID
//where s.FSubmitNo == cbSelectValue
//select c;
gridMain.ItemsSource = visaORM.sp_SelectTbSubmitWithSubmitNo(MainContext.UserCompanyName, cbSelectValue);
// selectCustomerList.ToList();
TB_TableSubmit ts = visaORM.TB_TableSubmit.FirstOrDefault(s => s.FSubmitNo == cbSelectValue);
if (ts != null)
{
txtSubmitNo.Text = ts.FSubmitNo;
txtDate.Text = ts.FCDate;
txtCompanyName.Text = ts.FCompany;
txtSubmitMemo.Text = ts.FSysMemo;
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
Log.WriteLog.WriteErorrLog(ex);
}
}
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 btnDelVisa_Click(object sender, RoutedEventArgs e)
{
if (gridMain.SelectedItem == null)
{
MessageBox.Show("请选择一条数据");
return;
}
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;
}
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.DeleteObject(cObj);
visaORM.SaveChanges();
MessageBox.Show("已经删除签证号为 " + cObj.FPassportNo + " 的签证");
dateFrom_EditValueChanged(null, null);
}
}
public ChkUnScan(ObservableCollection <Customer> ScannedCustomers)
{
InitializeComponent();
FAutoID = ScannedCustomers.First().FAutoID;
TB_TableSubmit submitObj = visaORM.TB_TableSubmit.FirstOrDefault(tbs => tbs.FAutoID == FAutoID);
if (submitObj == null)
{
MessageBox.Show("该签证尚未提交，请先提交");
return;
}
string submitNo = submitObj.FSubmitNo;
customerObjs = (from c in visaORM.Customer
join k in visaORM.TB_TableSubmit.Where(tbs => tbs.FSubmitNo == submitNo)
on c.FAutoID equals k.FAutoID
select c).ToList();
InitDataContext(ScannedCustomers);
gridMain.DataContext = customerObjs;
}
/// <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);
}
}
