public detectDetailsReview(IDBOperation dbOperation, int id) { InitializeComponent(); this.dbOperation = dbOperation; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details('{0}')", id)).Tables[0]; //给画面上的控件赋值 _areaName.Text = table.Rows[0][10].ToString(); _companyName.Text = table.Rows[0][11].ToString(); _cardId.Text = table.Rows[0][12].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _sampleName.Text = table.Rows[0][5].ToString(); _reagentName.Text = table.Rows[0][7].ToString(); _sensitivityName.Text = table.Rows[0][6].ToString(); _resultName.Text = table.Rows[0][8].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][9].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); _reviewBz.Text = table.Rows[0][19].ToString(); _reviewUserid.Text = table.Rows[0][14].ToString(); _reviewReagent_text.Text = table.Rows[0][15].ToString(); _reviewResult_text.Text = table.Rows[0][16].ToString(); _reviewDate.Text = table.Rows[0][17].ToString(); }
public MainWindow() { InitializeComponent(); dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper(); pgbUpdate.Maximum = 6; //if (Application.Current.Properties["startexe"] != null) //{ // startexe = Application.Current.Properties["startexe"].ToString().Trim(); //} //系统名称和更新地址从数据库中取 //startexe = dbOperation.GetSingle("select systemname from t_url ").ToString(); if (startexe == "") { startexe = "ZRDDcsSystem.exe"; } if (Application.Current.Properties["version"] != null) { version = Application.Current.Properties["version"].ToString().Trim(); } }
public AddReviewDetails(IDBOperation dbOperation, int id,SysReviewInfo sysreviewinfo) { InitializeComponent(); this.dbOperation = dbOperation; this.sysreviewinfo = sysreviewinfo; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; string reviewflag = dbHelper.GetSingle(string.Format("select ReviewFlag from t_detect_report where ORDERID = '{0}'", id)).ToString(); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details('{0}')", id)).Tables[0]; //给画面上的控件赋值 _areaName.Text = table.Rows[0][10].ToString(); _companyName.Text = table.Rows[0][11].ToString(); _cardId.Text = table.Rows[0][12].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _sampleName.Text = table.Rows[0][5].ToString(); _reagentName.Text = table.Rows[0][7].ToString(); _sensitivityName.Text = table.Rows[0][6].ToString(); _resultName.Text = table.Rows[0][8].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][9].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); if (reviewflag == "1") { _reviewUserid.Text = table.Rows[0][14].ToString(); _reviewReagent_text.Text = table.Rows[0][15].ToString(); _reviewResult_text.Text = table.Rows[0][16].ToString(); _reviewDate.Text = table.Rows[0][17].ToString(); _reviewBz.Text = table.Rows[0][19].ToString(); btnSave.Visibility = Visibility.Hidden; _reviewReagent.Visibility = Visibility.Hidden; _reviewResult.Visibility = Visibility.Hidden; _reviewReagent_text.Visibility = Visibility.Visible; _reviewResult_text.Visibility = Visibility.Visible; _reviewBz.IsEnabled = false; } else { _reviewUserid.Text = (Application.Current.Resources["User"] as UserInfo).ShowName; _reviewDate.Text = DateTime.Now.ToString(); ComboboxTool.InitComboboxSource(_reviewResult, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "lr"); ComboboxTool.InitComboboxSource(_reviewReagent, "select reagentId,reagentName from t_det_reagent where openFlag = '1' and reagentId <> '1'", "lr"); btnSave.Visibility = Visibility.Visible; _reviewReagent.Visibility = Visibility.Visible; _reviewResult.Visibility = Visibility.Visible; _reviewReagent_text.Visibility = Visibility.Hidden; _reviewResult_text.Visibility = Visibility.Hidden; _reviewBz.IsEnabled = true; } }
public UcTaskAllocation() { InitializeComponent(); dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper(); btnSave.Tag = "新增"; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; supplierId = (Application.Current.Resources["User"] as UserInfo).SupplierId; switch (user_flag_tier) { case "0": _dept_name.Text = "选择省:"; dept_name = "省名称"; break; case "1": _dept_name.Text = "选择地市:"; dept_name = "地市名称"; break; case "2": _dept_name.Text = "选择区县:"; dept_name = "区县名称"; break; case "3": _dept_name.Text = "选择检测站点:"; dept_name = "检测站点名称"; break; case "4": _dept_name.Text = "选择检测站点:"; dept_name = "检测站点名称"; break; default: break; } _tableview.ModifyRowEnvent += new UcTableOperableView.ModifyRowEventHandler(_tableview_ModifyRowEnvent); _tableview.DeleteRowEnvent += new UcTableOperableView.DeleteRowEventHandler(_tableview_DeleteRowEnvent); }
public UcDetectBillManager() { InitializeComponent(); dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper(); ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //画面初始化-新增检测单画面 ComboboxTool.InitComboboxSource(_province, rows,"lr"); _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); ComboboxTool.InitComboboxSource(_source_company, "SELECT COMPANYID,COMPANYNAME FROM v_user_company WHERE userid = " + userId,"lr"); if (supplierId == "nkrx") { ComboboxTool.InitComboboxSource(_detect_trade, "select tradeId,tradeName from t_trade where openFlag = '1' order by orderId", "lr"); } else { ComboboxTool.InitComboboxSource(_detect_trade, "select tradeId,tradeName from t_trade where openFlag = '1'", "lr"); } _detect_trade.SelectionChanged += new SelectionChangedEventHandler(_detect_trade_SelectionChanged); //ComboboxTool.InitComboboxSource(_detect_item, "SELECT itemid,ItemNAME FROM v_user_item WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_object, " SELECT objectId,objectName FROM v_user_object WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_sample, " SELECT sampleId,sampleName FROM v_user_sample WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_sensitivity, "SELECT sensitivityId,sensitivityName FROM t_det_sensitivity where openFlag = '1'", "lr"); ComboboxTool.InitComboboxSource(_detect_result, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "lr"); _entering_datetime.Text = string.Format("{0:g}", System.DateTime.Now); _source_company.SelectionChanged += new SelectionChangedEventHandler(_source_company_SelectionChanged); _detect_person.Text = (Application.Current.Resources["User"] as UserInfo).ShowName; _detect_site.Text = dbOperation.GetSingle("SELECT INFO_NAME from sys_client_sysdept WHERE INFO_CODE = " + (Application.Current.Resources["User"] as UserInfo).DepartmentID).ToString(); }
public UcDetectBillManager() { InitializeComponent(); dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper(); ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataTable table = dbOperation.GetDataSet("select proviceid as id , name " + "from t_set_area LEFT JOIN sys_city ON t_set_area.proviceid = sys_city.id " + "where deptid = " + deptid).Tables[0]; DataRow[] rows; if (table.Rows.Count == 0) { rows = ProvinceCityTable.Select("pid = '0001'"); } else { rows = table.Select(); } //画面初始化-新增检测单画面 ComboboxTool.InitComboboxSource(_province, rows,"lr"); _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); //查找登录者部门所属的省份 string proviceid = dbOperation.GetSingle("select province from sys_client_sysdept where INFO_CODE = " + deptid).ToString(); int i = 1; foreach(DataRow row in rows) { if (row["id"].ToString() == proviceid) { _province.SelectedIndex = i; } i = i + 1; } ComboboxTool.InitComboboxSource(_source_company, "SELECT COMPANYID,COMPANYNAME FROM v_user_company WHERE userid = " + userId, "lr"); //if (supplierId == "nkrx") //{ // ComboboxTool.InitComboboxSource(_detect_trade, "select tradeId,tradeName from t_trade where openFlag = '1' order by orderId", "lr"); //} //else //{ // ComboboxTool.InitComboboxSource(_detect_trade, "select tradeId,tradeName from t_trade where openFlag = '1'", "lr"); //} //_detect_trade.SelectionChanged += new SelectionChangedEventHandler(_detect_trade_SelectionChanged); //_detect_trade.SelectedIndex = 1; //ComboboxTool.InitComboboxSource(_detect_item, "SELECT itemid,ItemNAME FROM v_user_item WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_object, " SELECT objectId,objectName FROM v_user_object WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_sample, " SELECT sampleId,sampleName FROM v_user_sample WHERE userid = " + userId); //ComboboxTool.InitComboboxSource(_detect_sensitivity, "SELECT sensitivityId,sensitivityName FROM t_det_sensitivity where openFlag = '1'", "lr"); ComboboxTool.InitComboboxSource(_detect_item, string.Format("SELECT ItemID,ItemNAME FROM t_det_item WHERE (tradeId ='1'or ifnull(tradeId,'') = '') and OPENFLAG = '1' order by orderId"), "lr"); _detect_item.SelectionChanged += new SelectionChangedEventHandler(_detect_item_SelectionChanged); ComboboxTool.InitComboboxSource(_detect_result, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "lr"); ComboboxTool.InitComboboxSource(_card_brand, "SELECT cardbrandid,cardbrandname FROM t_cardbrand where openFlag = '1'", "lr"); _entering_datetime.Text = string.Format("{0:g}", System.DateTime.Now); _source_company.SelectionChanged += new SelectionChangedEventHandler(_source_company_SelectionChanged); _detect_person.Text = (Application.Current.Resources["User"] as UserInfo).ShowName; _detect_site.Text = dbOperation.GetSingle("SELECT INFO_NAME from sys_client_sysdept WHERE INFO_CODE = " + (Application.Current.Resources["User"] as UserInfo).DepartmentID).ToString(); }
void SysPersonManager_Loaded(object sender, RoutedEventArgs e) { dbHelper = DbHelperMySQL.CreateDbHelper(); this.txtPersonCode.Text = CreateNewNumber(); InitComboboxs(); BindData(); Clear(); }
/// <summary> /// 返回一个DbHelperMySQL的实例,如果没有则先创建再返回 /// </summary> /// <returns>DbHelperMySQL的实例</returns> public static DbHelperMySQL CreateDbHelper() { if (instance == null) { instance = new DbHelperMySQL(); instance.connectionString = Conn.GetConnString(); } return instance; }
public bool DealWithAlarm(DbHelperMySQL dbHelper) { bool bok = false; if (DealwithAlarmMsg(this.Alarmid, dbHelper)) { bdealwith = true; bok = true; } return bok; }
/// <summary> /// 返回一个DbHelperMySQL的实例,如果没有则先创建再返回 /// </summary> /// <param name="configurationName">连接字符串名</param> /// <returns>DbHelperMySQL的实例</returns> public static DbHelperMySQL CreateDbHelper(string configurationName) { if (instance == null) { instance = new DbHelperMySQL(); Conn.ConnectionConfigurationName = configurationName; instance.connectionString = Conn.GetConnString(); } return instance; }
public detectDetailsReview(IDBOperation dbOperation, int id) { InitializeComponent(); this.dbOperation = dbOperation; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details_sc('{0}')", id)).Tables[0]; //给画面上的控件赋值 _orderid.Text = table.Rows[0][15].ToString(); _areaName.Text = table.Rows[0][8].ToString(); _companyName.Text = table.Rows[0][9].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _reangetName.Text = table.Rows[0][5].ToString(); _resultName.Text = table.Rows[0][6].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][7].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); _detectvalue.Text = table.Rows[0][18].ToString(); _reviewBz.Text = table.Rows[0][16].ToString(); _reviewUserid.Text = table.Rows[0][11].ToString(); _reviewReagent_text.Text = table.Rows[0][12].ToString(); _reviewResult_text.Text = table.Rows[0][13].ToString(); _reviewDate.Text = table.Rows[0][14].ToString(); //检测结果为疑似阳性变红 if (_resultName.Text == "疑似阳性" || _resultName.Text == "确证阳性") { _resultName.Foreground = Brushes.Red; } else { _resultName.Foreground = Brushes.Black; } if(table.Rows[0][17].ToString() == "0") { _result_id.Text = "检测卡假阳性"; } else if (table.Rows[0][19].ToString() == "1") { _result_id.Text = "确证阳性"; } else { _result_id.Text = ""; } }
private bool DealwithAlarmMsg(string id, DbHelperMySQL dbHelper) { bool r_bool = false; string str_sql = "UPDATE sys_alarm_data SET ALARM_STATE='0' WHERE NUMB_ALARM=" + id; try { dbHelper.ExecuteSql(str_sql); r_bool = true; } catch (System.Exception e) { r_bool = false; } return r_bool; }
public UcMainPage() { InitializeComponent(); dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper(); //首页地址改为从数据库中获取 string page_url = dbOperation.GetSingle("select firstpageurl from t_url ").ToString(); if (page_url == "") { page_url = "http://www.zrodo.com:8040/ulsocialevent/getMapTesttt.do?user_id={0}"; } _webBrowser.Source = new Uri(string.Format(page_url, (Application.Current.Resources["User"] as UserInfo).ID)); // _webBrowser.Source = new Uri(string.Format("http://www.zrodo.com:8040/ulsocialevent/getMapTesttt.do?user_id={0}", (Application.Current.Resources["User"] as UserInfo).ID)); }
/// <summary> /// 从数据库获取数据 /// </summary> /// private void BindData() { DataTable dt = null; lvlist.DataContext = null; string strSql = string.Format("select NUMB_ROLE,INFO_NAME,INFO_EXPL,FLAG_TIER FROM sys_client_role where cuserid = '{0}'", (Application.Current.Resources["User"] as UserInfo).ID); try { dbHelper = DbHelperMySQL.CreateDbHelper(); dt = dbHelper.GetDataSet(strSql).Tables[0]; lvlist.DataContext = dt; currentTable = dt; } catch (Exception) { return; } }
public AddReviewDetails(IDBOperation dbOperation, int id,SysReviewInfoSc sysreviewinfosc) { InitializeComponent(); this.dbOperation = dbOperation; this.sysreviewinfosc = sysreviewinfosc; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; string reviewflag = dbHelper.GetSingle(string.Format("select ReviewFlag from t_detect_report where ORDERID = '{0}'", id)).ToString(); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details_sc('{0}')", id)).Tables[0]; //给画面上的控件赋值 _orderid.Text = table.Rows[0][15].ToString(); _areaName.Text = table.Rows[0][8].ToString(); _companyName.Text = table.Rows[0][9].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _reangetName.Text = table.Rows[0][5].ToString(); _resultName.Text = table.Rows[0][6].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][7].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); _detectvalue.Text = table.Rows[0][18].ToString(); //检测结果为疑似阳性变红 if (_resultName.Text == "疑似阳性" || _resultName.Text == "确证阳性") { _resultName.Foreground = Brushes.Red; } else { _resultName.Foreground = Brushes.Black; } _reviewUserid.Text = (Application.Current.Resources["User"] as UserInfo).ShowName; _reviewDate.Text = DateTime.Now.ToString(); ComboboxTool.InitComboboxSource(_reviewResult, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "lr"); ComboboxTool.InitComboboxSource(_reviewReagent, "select reagentId,reagentName from t_det_reagent where openFlag = '1' and reagentId <> '1'", "lr"); }
public MainWindowTradition(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; dbHelper = DbHelperMySQL.CreateDbHelper(); //系统标题的显示 string sql = string.Format("select title from sys_client_sysdept where INFO_CODE = '{0}'", (Application.Current.Resources["User"] as UserInfo).DepartmentID); string title = dbOperation.GetDbHelper().GetSingle(sql).ToString(); this.Title = title + " " + "当前登录用户:" + (Application.Current.Resources["User"] as UserInfo).ShowName; Application.Current.Resources.Add("省市表", dbOperation.GetProvinceCity()); MenuRole(); foreach (FatherMenuTitle fatherMenuTitle in menuTitles) { MenuItem fatherMenu = new MenuItem(); fatherMenu.FontSize = 16; fatherMenu.Header = fatherMenuTitle.Name; if (fatherMenuTitle.ChildMenuTitle.Count == 0) { fatherMenu.Click += new RoutedEventHandler(childMenu_Click); } else { foreach (string childMenuTitle in fatherMenuTitle.ChildMenuTitle) { MenuItem childMenu = new MenuItem(); childMenu.FontSize = 16; childMenu.Header = childMenuTitle; childMenu.Click += new RoutedEventHandler(childMenu_Click); fatherMenu.Items.Add(childMenu); } } _menu.Items.Add(fatherMenu); } mainPage = new UcMainPage(); grid_Component.Children.Add(mainPage); this.WindowState = WindowState.Maximized; }
/// <summary> /// 从数据库获取数据 /// </summary> private void BindData() { string strSql = "select RECO_PKID,NUMB_USER,sys_client_user.INFO_USER,sys_client_sysdept.INFO_NAME,sys_client_role.INFO_NAME as role_expl " + "FROM sys_client_user ,sys_client_sysdept,sys_client_role " + "WHERE sys_client_user.fk_dept = sys_client_sysdept.INFO_CODE " + "and sys_client_user.ROLE_ID = sys_client_role.NUMB_ROLE " + "and sys_client_user.cuserid = " + (Application.Current.Resources["User"] as UserInfo).ID; try { dbHelper = DbHelperMySQL.CreateDbHelper(); DataTable dt = dbHelper.GetDataSet(strSql).Tables[0]; lvlist.DataContext = null; lvlist.DataContext = dt; lvlist.Tag = dt; } catch (Exception) { return; } }
public SysModifyPassword() { dbHelper = DbHelperMySQL.CreateDbHelper(); InitializeComponent(); }
public AlarmEngine(DbHelperMySQL dbHelper) { this.dbHelper = dbHelper; }
public AddReviewDetails(IDBOperation dbOperation, int id,SysReviewInfo sysreviewinfo) { InitializeComponent(); this.dbOperation = dbOperation; this.sysreviewinfo = sysreviewinfo; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; string reviewflag = dbHelper.GetSingle(string.Format("select ReviewFlag from t_detect_report where ORDERID = '{0}'", id)).ToString(); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details_new('{0}')", id)).Tables[0]; //给画面上的控件赋值 //图片地址改为从数据库中获取 string picture_url = dbOperation.GetDbHelper().GetSingle("select pictureurl from t_url ").ToString(); if (picture_url == "") { picture_url = "http://www.zrodo.com:8080/xmjc/"; } _img.Source = new BitmapImage(new Uri(picture_url + table.Rows[0][20].ToString())); //_img.Source = new BitmapImage(new Uri("http://www.zrodo.com:8080/xmjc/" + table.Rows[0][20].ToString())); _orderid.Text = table.Rows[0][18].ToString(); _areaName.Text = table.Rows[0][10].ToString(); _companyName.Text = table.Rows[0][11].ToString(); _cardId.Text = table.Rows[0][12].ToString(); _objectLable.Text = table.Rows[0][21].ToString(); _objectCount.Text = table.Rows[0][22].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _sampleName.Text = table.Rows[0][5].ToString(); _reangetName.Text = table.Rows[0][7].ToString(); _sensitivityName.Text = table.Rows[0][6].ToString(); _resultName.Text = table.Rows[0][8].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][9].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); _cardbrand.Text = table.Rows[0][23].ToString(); _cardno.Text = table.Rows[0][24].ToString(); //检测结果为疑似阳性变红 if (_resultName.Text == "疑似阳性" || _resultName.Text == "确证阳性") { _resultName.Foreground = Brushes.Red; } else { _resultName.Foreground = Brushes.Black; } if (reviewflag == "1") { _reviewUserid.Text = table.Rows[0][14].ToString(); _reviewReagent_text.Text = table.Rows[0][15].ToString(); _reviewResult_text.Text = table.Rows[0][16].ToString(); _reviewDate.Text = table.Rows[0][17].ToString(); _reviewBz.Text = table.Rows[0][19].ToString(); btnSave.Visibility = Visibility.Hidden; _reviewReagent.Visibility = Visibility.Hidden; _reviewResult.Visibility = Visibility.Hidden; _reviewReagent_text.Visibility = Visibility.Visible; _reviewResult_text.Visibility = Visibility.Visible; _reviewBz.IsEnabled = false; } else { _reviewUserid.Text = (Application.Current.Resources["User"] as UserInfo).ShowName; _reviewDate.Text = DateTime.Now.ToString(); ComboboxTool.InitComboboxSource(_reviewResult, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "lr"); ComboboxTool.InitComboboxSource(_reviewReagent, "select reagentId,reagentName from t_det_reagent where openFlag = '1' and reagentId <> '1'", "lr"); btnSave.Visibility = Visibility.Visible; _reviewReagent.Visibility = Visibility.Visible; _reviewResult.Visibility = Visibility.Visible; _reviewReagent_text.Visibility = Visibility.Hidden; _reviewResult_text.Visibility = Visibility.Hidden; _reviewBz.IsEnabled = true; } }
public MainWindowTradition(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; dbHelper = DbHelperMySQL.CreateDbHelper(); //系统标题的显示 string sql = string.Format("select title from sys_client_sysdept where INFO_CODE = '{0}'", (Application.Current.Resources["User"] as UserInfo).DepartmentID); string title = dbOperation.GetDbHelper().GetSingle(sql).ToString(); this.Title = title + " "+"当前登录用户:" + (Application.Current.Resources["User"] as UserInfo).ShowName; Application.Current.Resources.Add("省市表", dbOperation.GetProvinceCity()); MenuRole(); foreach (FatherMenuTitle fatherMenuTitle in menuTitles) { MenuItem fatherMenu = new MenuItem(); fatherMenu.FontSize = 16; fatherMenu.Header = fatherMenuTitle.Name; if (fatherMenuTitle.ChildMenuTitle.Count == 0) { fatherMenu.Click += new RoutedEventHandler(childMenu_Click); } else { foreach (string childMenuTitle in fatherMenuTitle.ChildMenuTitle) { MenuItem childMenu = new MenuItem(); childMenu.FontSize = 16; childMenu.Header = childMenuTitle; childMenu.Click += new RoutedEventHandler(childMenu_Click); fatherMenu.Items.Add(childMenu); } } _menu.Items.Add(fatherMenu); } mainPage = new UcMainPage(); grid_Component.Children.Add(mainPage); this.WindowState = WindowState.Maximized; }
public detectDetailsReview(IDBOperation dbOperation, int id) { InitializeComponent(); this.dbOperation = dbOperation; dbHelper = DbHelperMySQL.CreateDbHelper(); orderid = id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_detect_details_new('{0}')", id)).Tables[0]; //给画面上的控件赋值 //图片地址改为从数据库中获取 string picture_url = dbOperation.GetDbHelper().GetSingle("select pictureurl from t_url ").ToString(); if (picture_url == "") { picture_url = "http://www.zrodo.com:8080/xmjc/"; } _img.Source = new BitmapImage(new Uri(picture_url + table.Rows[0][20].ToString())); // _img.Source = new BitmapImage(new Uri("http://www.zrodo.com:8080/xmjc/" + table.Rows[0][20].ToString())); _orderid.Text = table.Rows[0][18].ToString(); _areaName.Text = table.Rows[0][10].ToString(); _companyName.Text = table.Rows[0][11].ToString(); _cardId.Text = table.Rows[0][12].ToString(); _objectLable.Text = table.Rows[0][21].ToString(); _objectCount.Text = table.Rows[0][22].ToString(); _itemName.Text = table.Rows[0][3].ToString(); _objectName.Text = table.Rows[0][4].ToString(); _sampleName.Text = table.Rows[0][5].ToString(); _reangetName.Text = table.Rows[0][7].ToString(); _sensitivityName.Text = table.Rows[0][6].ToString(); _resultName.Text = table.Rows[0][8].ToString(); _deptName.Text = table.Rows[0][2].ToString(); _detectDate.Text = table.Rows[0][1].ToString(); _detectUserName.Text = table.Rows[0][9].ToString(); _detectTypeName.Text = table.Rows[0][0].ToString(); _cardbrand.Text = table.Rows[0][23].ToString(); _reviewBz.Text = table.Rows[0][19].ToString(); _reviewUserid.Text = table.Rows[0][14].ToString(); _reviewReagent_text.Text = table.Rows[0][15].ToString(); _reviewResult_text.Text = table.Rows[0][16].ToString(); _reviewDate.Text = table.Rows[0][17].ToString(); _cardno.Text = table.Rows[0][24].ToString(); //检测结果为疑似阳性变红 if (_resultName.Text == "疑似阳性" || _resultName.Text == "确证阳性") { _resultName.Foreground = Brushes.Red; } else { _resultName.Foreground = Brushes.Black; } if(table.Rows[0][25].ToString() == "0") { _result_id.Text = "检测卡假阳性"; } else if (table.Rows[0][25].ToString() == "1") { _result_id.Text = "确证阳性"; } else { _result_id.Text = ""; } }