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 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();
}
}
void DelModel()
{
if (MainGrid.SelectedItem == null)
{
MessageBox.Show("请选择一行");
return;
}
if (MessageBox.Show("是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
model = MainGrid.SelectedItem as TCountry;
visaORM.DeleteObject(model);
countryCollection.Remove(model);
}
}
private void CustomerDel()
{
CustomerT delObj = visaORM.CustomerT.FirstOrDefault(c => c.FID == model.FID);
if (delObj == null)
{
MessageBox.Show("该数据尚未保存，无需删除");
return;
}
else
{
if (MessageBox.Show("是否确认删除?", "删除确认", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
visaORM.DeleteObject(delObj);
visaORM.SaveChanges();
customerCollection.Remove(delObj);
this.model = LeftGrid.SelectedItem as CustomerT;
if (this.model == null)
{
this.model = new CustomerT();
}
}
}
}
private void UserSave()
{
MainBar.Focus();
if (txtPassConfirm.Text != txtPassword.Text)
{
MessageBox.Show("两次输入的密码不一致，保存失败。");
return;
}
if (model.FUserName == null || model.FCompanyName == null)
{
MessageBox.Show("必须录入用户名和公司。");
return;
}
if (model.FID == 0 || model.FID.ToString() == "")
{
var tempObj = visaORM.User.FirstOrDefault(u => u.FUserName == model.FUserName);
{
if (tempObj != null)
{
MessageBox.Show("该用户名已经存在，请使用其他用户名");
return;
}
}
visaORM.User.AddObject(model);
model.FIsDelete = false;
visaORM.SaveChanges();
NowUserId = model.FID;
userList.Add(model);
//getDefaultModel = 0;
InitData();
}
else
{
if (visaORM.ObjectStateManager.GetObjectStateEntries(EntityState.Modified).Count() == 0)
{
visaORM.User.Attach(model);
}
visaORM.ObjectStateManager.ChangeObjectState(model, EntityState.Modified);
visaORM.SaveChanges();
NowUserId = model.FID;
}
var list = from m in visaORM.TB_Menu
join ur in visaORM.TB_UserRights
on m.FID equals ur.FMenuID
where m.FType == 1 && ur.FUserID == model.FID
select ur;
foreach (TB_UserRights urObj in list)
{
visaORM.DeleteObject(urObj);
}
selectedMenu.Clear();
foreach (var nodeObjLevel1 in MenuTree.View.Nodes)
{
foreach (var nodeObjLevel2 in nodeObjLevel1.Nodes)
{
foreach (var nodeObjLevel3 in nodeObjLevel2.Nodes)
{
if (nodeObjLevel3.IsChecked == true)
{
selectedMenu.Add(nodeObjLevel3.Content as TB_Menu);
}
}
if (nodeObjLevel2.IsChecked == true)
{
selectedMenu.Add(nodeObjLevel2.Content as TB_Menu);
}
}
if (nodeObjLevel1.IsChecked == true)
{
selectedMenu.Add(nodeObjLevel1.Content as TB_Menu);
}
}
TB_UserRights urModel;
foreach (var menuObj in selectedMenu)
{
urModel = new TB_UserRights();
urModel.FUserID = model.FID;
urModel.FMenuID = menuObj.FID;
urModel.FCreateDate = DateTime.Now;
urModel.FCreateUser = MainContext.UserID;
urModel.FModifyDate = DateTime.Now;
urModel.FModifyUser = MainContext.UserID;
urModel.FStatus = true;
visaORM.TB_UserRights.AddObject(urModel);
}
TB_UserRights outMenuObj;
if (CreateURModel(cbTable2Admin, out outMenuObj) == true)
{
if (outMenuObj != null)
{
visaORM.TB_UserRights.AddObject(outMenuObj);
}
}
else
{
if (outMenuObj != null)
{
visaORM.DeleteObject(outMenuObj);
}
}
visaORM.SaveChanges();
InitData();
MessageBox.Show("保存成功");
}
