private void btn_ModifyStudent_Click(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (DataGridView_Student.SelectedIndex != -1)
{
DataRowView row = (DataRowView)DataGridView_Student.SelectedItem;
string id = row[0].ToString();
string sid = row[1].ToString();
string sname = row[2].ToString();
string ssex = row[3].ToString();
string sbirth = row[4].ToString().Split(' ')[0];
string shome = row[5].ToString();
IFeatureLayer pFeatureLayer = WxzUtils.Ae.GetFeatureLayerByName("Students");
IFeatureCursor pFeatureCursor = pFeatureLayer.FeatureClass.Search(null, false);
IFeature pFeature = pFeatureCursor.NextFeature();
while (pFeature != null)
{
if (pFeature.get_Value(pFeature.Fields.FindField("Id")).ToString() == id.ToString())
{
IPoint pPoint = pFeature.Shape as IPoint;
f_AddStudent.SetModify(pPoint, id, sid, sname, ssex, sbirth, shome);
f_AddStudent.Show();
return;
}
pFeature = pFeatureCursor.NextFeature();
}
}
else
{
MessageBox.Show("请选择需要修改的学生");
}
}
private void but_nom_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
frame_emp fremp = new frame_emp();
fremp.con1 = this;
fremp.ShowDialog();
}
private void but_add_role1_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
add_role adrole = new add_role();
adrole.con = this;
adrole.ShowDialog();
}
private void bbNew_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
var active_tab = NumericalShemes.SelectedTabItem;
switch (active_tab.Name)
{
case "Interpolation":
schemes.cInterpolation.Add(new VInterpolationScheme());
break;
case "SnGrad":
schemes.cSnGrad.Add(new VSurfaceNormalGradientScheme());
break;
case "Divergence":
schemes.cDivergence.Add(new VDivergenceScheme());
break;
case "Gradient":
schemes.cGradient.Add(new VGradientScheme());
break;
case "Laplacian":
schemes.cLaplacian.Add(new VLaplacianScheme());
break;
case "TimeScheme":
schemes.cTime.Add(new VTimeScheme());
break;
default:
schemes.cFlux.Add(new VFluxControl());
break;
}
}
private void biHDDC_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
biKG.IsEnabled = true;
frmThemHDDC a = new frmThemHDDC();
a.Show();
}
private void BarButtonItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
var file = string.Empty;
if (openFileDialog.ShowDialog() == true)
{
string pathFile = openFileDialog.FileName;
List <string[]> rows = File.ReadAllLines(pathFile).Select(x => x.Split(',')).ToList();
//add cols to datatable:
string[] labelnya = rows[0];
rows.RemoveAt(0);
int no = 1;
foreach (var item in rows)
{
var data = new TutupanLahan();
data.no = no++;
data.band1 = double.Parse(item[0]);
data.band2 = double.Parse(item[1]);
data.band3 = double.Parse(item[2]);
data.kelas = item[3];
lisdata.Add(data);
}
GridSource.DataContext = lisdata;
RowsCount.Content = lisdata.Count;
DecisinTree(labelnya, rows);
}
}
private void btnAExport_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
try
{
System.Windows.Forms.SaveFileDialog SFD = new System.Windows.Forms.SaveFileDialog();
SFD.Filter = "XML files (*.xml)|*.xml|STA files (*.sta)|*.sta|XLS files (*.xls)|*.xls|XLSX files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
if (SFD.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
XYDataList lstXYData = (this.DataContext as NFTestStepVM).LossTableAfterDut;
if (SFD.FilterIndex == 3 || SFD.FilterIndex == 4)
{
NFTestStepVM.TableToExcel(lstXYData, SFD.FileName);
}
else
{
CommUtils.SerializeData(lstXYData.GetType(), lstXYData, SFD.FileName);
}
MessageBox.Show("导出成功！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void bicn_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
var window = Application.Current.Windows.OfType <MainWindow>().SingleOrDefault(w => w.IsActive);
window.usnv.Content = new UCHDKyGui();
grid.ItemsSource = new HDKGModelView().DSHDKG;
}
private void bixoa_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Bạn có đồng ý xóa hợp đồng này ?", "Thông Báo", MessageBoxButton.YesNo);
switch (result)
{
case MessageBoxResult.Yes:
HDKGView a = grid.SelectedItem as HDKGView;
if (a == null)
{
MessageBox.Show("Không tồn tại hợp đồng!!");
return;
}
;
foreach (HopDongKyGui i in dc.HopDongKyGuis.Where(x => x.kgid == a.kgid))
{
if (i != null)
{
dc.HopDongKyGuis.DeleteOnSubmit(i);
dc.SubmitChanges();
MessageBox.Show("Xóa hợp đồng thành công !");
grid.ItemsSource = new HDKGModelView().DSHDKG;
}
else
{
MessageBox.Show("Không thể xóa hợp đồng !!");
}
}
break;
case MessageBoxResult.No:
break;
}
}
private void DelDzien_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
ArItHarmonogramNaglDniWolne ith = new ArItHarmonogramNaglDniWolne();
if (row == null)
{
MessageBox.Show("Wybierz Rok z Listy");
return;
}
DateTime data = dtData.DateTime;
if (row != null)
{
if (row.Rok != data.Year)
{
MessageBox.Show("Wybierz właściwy okres (Rok)");
return;
}
HarmonogramDataAdapter hDa = new HarmonogramDataAdapter();
ith.IdArItHarmonogramNagl = row.IdArItHarmonogramNagl;
hDa.DelDzienWolny(ith, data, mUwagi.Text);
PokazHarmonogram(row.Rok);
PokazDniWolne(row.IdArItHarmonogramNagl);
Messenger.Default.Send <int>(1);
}
}
private void DeleteDzienTyg_Click_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
ArItHarmonogramNaglDniWolne ith = new ArItHarmonogramNaglDniWolne();
if (row == null)
{
MessageBox.Show("Wybierz Rok z Listy");
return;
}
if (ComboBoxDzienTyg.Text == String.Empty)
{
MessageBox.Show("Wybierz Dzień Tygodnia");
return;
}
int numerDnia = (int)ComboBoxDzienTyg.EditValue;
if (row != null)
{
HarmonogramDataAdapter hDa = new HarmonogramDataAdapter();
int IdArItHarmonogramNagl = row.IdArItHarmonogramNagl;
hDa.DelDniWolneDlaDnia(IdArItHarmonogramNagl, numerDnia, mUwagi.Text);
PokazHarmonogram(row.Rok);
PokazDniWolne(row.IdArItHarmonogramNagl);
Messenger.Default.Send <int>(1);
}
}
private void btnDelete_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
foreach (int handle in gridControl1.GetSelectedRowHandles())
{
((DataRowView)gridControl1.GetRow(handle)).Delete();
}
}
//连接数据库
private void barButtondownload_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (listView.SelectedItem == null)
{
DXMessageBox.Show("请选择一个方案！", "导出文件", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
DataSet ds = null;
id = (listView.SelectedItem as StateFileModel).ID.ToString();
if (DataUtils.StaticInfo.MesMode.ToLower() == "true")
{
ds = DataUtils.DB.GetDataSetFromSQL(string.Format("SELECT StateData,Material FROM SYS_TEST_PLAN WHERE FILEID='{0}'", id));
}
else
{
ds = DataUtils.DB.GetDataSetFromSQL(string.Format("SELECT StateData FROM ATE_TEST_FILE WHERE FILEID='{0}'", id));
}
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["StateData"] != System.DBNull.Value)
{
byte[] data = (byte[])ds.Tables[0].Rows[0]["StateData"];
System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();
saveFileDialog.Filter = "STA 文件|*.sta";
saveFileDialog.RestoreDirectory = true;
if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
System.IO.File.WriteAllBytes(saveFileDialog.FileName, data);
}
}
}
}
private void btn_DeleteStudent_Click(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
f_AddStudent.Hide();
if (DataGridView_Student.SelectedIndex != -1)
{
DataRowView row = (DataRowView)DataGridView_Student.SelectedItem;
string id = row[0].ToString();
string sname = row[2].ToString();
if (MessageBox.Show(String.Format("是否删除学生【{0}】", sname), "提醒", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
if (WxzUtils.Sql.CommandSQL(
String.Format("DELETE FROM StudentInfo WHERE Id= '{0}'", id)) != 0)
{
WxzUtils.Ae.DeleteStudent(id);
m_pMapC2.Refresh();
UpdateDataTable();
MessageBox.Show(String.Format("学生【{0}】删除成功", sname));
}
else
{
MessageBox.Show(String.Format("学生【{0}】删除失败", sname));
}
}
}
else
{
MessageBox.Show("请选择需要删除的学生");
}
}
private void bicn_ItemClick_1(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
KhachHangCaNhanView kh = (KhachHangCaNhanView)gridControlkh.SelectedItem;
KhachHang k = new KhachHang();
foreach (KhachHang n in dc.KhachHangs.Where(x => x.khid == kh.khid))
{
k = n;
}
string str = "Bạn có đồng ý chuyển Khách Hàng [" + k.hoten + "] cho Nhân Viên [" + cbx.Text + "] không ?";
MessageBoxResult result = MessageBox.Show(str, "Thông Báo", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
k.NhanVien = dc.NhanViens.Single(x => x.nvid == int.Parse(cbx.SelectedValue.ToString()));
dc.SubmitChanges();
}
else
{
return;
}
List <KhachHangCaNhanView> khcn = new List <KhachHangCaNhanView>();
khcn = nvmd.getdskhcn(nv.nvid);
gridControlkh.ItemsSource = khcn;
}
private void bbFileSave_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
var panel = dockLayoutManager1.DockController.ActiveItem;
var key = FindKeyByObject(panel);
if (key == "")
{
return;
}
var documentPanel = _openDocuments[key];
var scrollView = (ScrollViewer)documentPanel.Content;
var content = (Control)scrollView.Content;
var editor = content as IProjectItemView;
if (editor == null)
{
return;
}
var save = editor.GetSaveCommand();
if (save == null)
{
return;
}
save();
}
private void BtnCancel_Click(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
//取消
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
private void miLogOut_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
Properties.Settings.Default.checkerAuto = false;
Properties.Settings.Default.Save();
System.Windows.Forms.Application.Restart();
this.Close();
}
private void filter_patient_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
PatientListFilter pFilter = new PatientListFilter();
pFilter.ShowDialog();
if (pFilter.status_ok)
{
MySqlConnection MyCon = WsApplication.ConnectionString();
try
{
MyCon.Open();
MySqlCommand cmd = MyCon.CreateCommand();
cmd.CommandText = "select p.id,p.name,p.address,p.age,p.m_status,p.health_status,d.doctorName,p.p_status from patient p left join doctor d on p.doctor_id=d.id where p.ts>='" + WsApplication.fd + "' and p.ts<='" + WsApplication.td + "'";
MySqlDataReader reader = cmd.ExecuteReader();
gc_patient_list.ItemsSource = reader;
MyCon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show(pFilter.patientstatus);
pFilter.Close();
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
Document doc = richEditControl1.Document;
// Create a custom mark at the caret position and attach arbitrary data to the mark.
// In this example the data specifies the color that will be used to draw the mark.
CustomMark m = doc.CustomMarks.Create(doc.Selection.Start, new SolidColorBrush(Colors.Orange));
}
private void btnAImport_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
try
{
System.Windows.Forms.OpenFileDialog OFD = new System.Windows.Forms.OpenFileDialog();
OFD.Filter = "XML files (*.xml)|*.xml|STA files (*.sta)|*.sta|XLS files (*.xls)|*.xls|XLSX files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
XYDataList lstXYData = new XYDataList();
if (OFD.FilterIndex == 3 || OFD.FilterIndex == 4)
{
lstXYData = NFTestStepVM.ExcelToTable(OFD.FileName);
}
else
{
lstXYData = (XYDataList)CommUtils.DeserializerData(typeof(XYDataArr), OFD.FileName);
}
(this.DataContext as NFTestStepVM).LossTableAfterDut = lstXYData;
//MessageBox.Show("导入成功！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void testAdd_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
Model.Devices device1 = new Model.Devices {
DevicesName = "GZ11", IpAddress = "192.168.1.1", IpPort = "6000", Status = 1, Region = "广州", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.Devices device2 = new Model.Devices {
DevicesName = "GZ12", IpAddress = "192.168.1.2", IpPort = "6000", Status = 1, Region = "广州", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.Devices device3 = new Model.Devices {
DevicesName = "GZ13", IpAddress = "192.168.1.3", IpPort = "6000", Status = 1, Region = "广州", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.Devices device4 = new Model.Devices {
DevicesName = "SH11", IpAddress = "192.168.2.1", IpPort = "6000", Status = 1, Region = "上海", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.Devices device5 = new Model.Devices {
DevicesName = "SH12", IpAddress = "192.168.2.2", IpPort = "6000", Status = 1, Region = "上海", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.Devices device6 = new Model.Devices {
DevicesName = "SH13", IpAddress = "192.168.2.3", IpPort = "6000", Status = 1, Region = "上海", Protocols = "TCP", MACAddress = "11-22-33-44-55"
};
Model.DevicesDAL devicesDAL = new Model.DevicesDAL();
devicesDAL.Add(device1);
devicesDAL.Add(device2);
devicesDAL.Add(device3);
devicesDAL.Add(device4);
devicesDAL.Add(device5);
devicesDAL.Add(device6);
}
private void OnDelete(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (DeleteEventHandler != null)
{
DeleteEventHandler(GetSelectedOis());
}
}
private void biNV_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
usnv.Content = b;
biNV.IsEnabled = false;
nbiList.IsEnabled = true;
biKH.IsEnabled = true;
}
private void CloseDocumentButton_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (reportDesigner.ActiveDocument != null)
{
reportDesigner.ActiveDocument.Close();
}
}
private void btnExit_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
login log = new login();
log.Show();
this.Close();
}
private void but_add_user_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
add_user user = new add_user();
user.con = this;
user.ShowDialog();
}
private void OnDisplayDBLogins(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
// Get the list of logins for the Database
var row = gc_Databases.View.FocusedRowData.Row;
SQLInformation.Data.ApplicationDataSet.DatabasesRow database =
(SQLInformation.Data.ApplicationDataSet.DatabasesRow)((DataRowView)row).Row;
Guid instanceID = database.Instance_ID;
Guid dbID = database.ID;
var logins = Common.ApplicationDataSet.Logins.Where(l => l.Instance_ID == instanceID).OrderBy(n => n.Name_Login);
var dbUsers = Common.ApplicationDataSet.DBUsers.Where(u => u.Database_ID == dbID).OrderBy(n => n.Name_User);
var win = new EyeOnLife.User_Interface.Windows.InstanceDatabaseInfo();
win.tb_Instance.Text = database.Name_Instance;
win.tb_Database.Text = database.Name_Database;
win.lv_Logins.ItemsSource = logins;
win.lv_Users.ItemsSource = dbUsers;
win.Show();
//foreach (var login in logins)
//{
// System.Diagnostics.Debug.WriteLine("{0} - {1}", login.Name_Instance, login.Name_Login);
//}
//foreach (var user in dbUsers)
//{
// System.Diagnostics.Debug.WriteLine("{0} - {1}", user.Login, user.Name_User);
//}
}
private void but_del_role1_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
try
{
//Команда добавления
FbCommand sqlforin = new FbCommand("IUD_ROLES", preh.fb);
sqlforin.CommandType = System.Data.CommandType.StoredProcedure;
sqlforin.Parameters.Add("@FLAG", FbDbType.Char).Value = "D";
sqlforin.Parameters.Add("@ID", FbDbType.Integer).Value = grid_roles.GetFocusedRowCellValue("ID").ToString();
sqlforin.Parameters.Add("@NAME", FbDbType.VarChar).Value = null;
sqlforin.ExecuteNonQuery();
grid_roles.ItemsSource = dt_grid_roles();
prop_grid_roles(grid_roles);
System.Windows.MessageBox.Show("Запись успешно удалена!");
}
catch
{
System.Windows.MessageBox.Show("Невозможно удалить запись!");
}
}
private void btn_Save_Click(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (WxzUtils.Ae.SaveMxd())
{
MessageBox.Show("地图文档保存成功");
}
}
