/// <summary>
/// 用于向 TB_TableSubmit EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToTB_TableSubmit(TB_TableSubmit tB_TableSubmit)
{
base.AddObject("TB_TableSubmit", tB_TableSubmit);
}
/// <summary>
/// 创建新的 TB_TableSubmit 对象。
/// </summary>
/// <param name="fID">FID 属性的初始值。</param>
public static TB_TableSubmit CreateTB_TableSubmit(global::System.Int32 fID)
{
TB_TableSubmit tB_TableSubmit = new TB_TableSubmit();
tB_TableSubmit.FID = fID;
return tB_TableSubmit;
}
/// <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);
}
}
