public MainWindow(IDBOperation dbOperation) { Rect rc = SystemParameters.WorkArea;//获取工作区大小 //this.Width = 1366; //this.Height = 766; this.Width = rc.Width; this.Height = rc.Height; rcnormal = new Rect((rc.Width - 1366) / 2, (rc.Height - 766) / 2, 1366, 766); InitializeComponent(); this.dbOperation = dbOperation; //if (!FullScreenHelper.IsFullscreen(this)) //{ // FullScreenHelper.GoFullscreen(this); //} this.Loaded += new RoutedEventHandler(MainWindow_Loaded); //this.KeyDown += new KeyEventHandler(MainWindow_KeyDown); //this.StateChanged += new EventHandler(MainWindow_StateChanged); //根据分辨率判断标题字体大小 if (rc.Width < 1680) { _title_dept.FontSize = 17; _title_1.FontSize = 24; } else { _title_dept.FontSize = 22; _title_1.FontSize = 30; } }
public SysReviewLog(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; //初始化查询条件 reportDate_kssj.Value = DateTime.Now.AddDays(-1); reportDate_jssj.Value = DateTime.Now; //检测项目 ComboboxTool.InitComboboxSource(_detect_item, "SELECT ItemID,ItemNAME FROM t_det_item WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1' order by orderId", "cxtj"); MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 10 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 14 }); MyColumns.Add("reviewdate", new MyColumn("reviewdate", "复核检测时间") { BShow = true, Width = 18 }); MyColumns.Add("reviewreagentname", new MyColumn("reviewreagentname", "复核检测方法") { BShow = true, Width = 14 }); MyColumns.Add("reviewresultname", new MyColumn("reviewresultname", "复核检测结果") { BShow = true, Width = 14 }); MyColumns.Add("reviewusername", new MyColumn("reviewusername", "复核检测师") { BShow = true, Width = 14 }); MyColumns.Add("reviewreason", new MyColumn("reviewreason", "复核原因说明") { BShow = true, Width = 22 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.DetailsRowEnvent += new UcTableOperableView.DetailsRowEventHandler(_tableview_DetailsRowEnvent); }
public CertificateProductPreview(IDBOperation dbOperation, string card_id) { InitializeComponent(); this.dbOperation = dbOperation; this.cardId = card_id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_certificate_product_main('{0}')", cardId)).Tables[0]; if (table.Rows.Count > 0) { _card_id.Text = table.Rows[0][0].ToString(); _company.Text = table.Rows[0][2].ToString(); _product_name.Text = table.Rows[0][4].ToString(); _object_count.Text = table.Rows[0][5].ToString(); _cz_cardid.Text = table.Rows[0][3].ToString(); _product_area.Text = table.Rows[0][6].ToString(); _dept_name.Text = table.Rows[0][7].ToString() + " " + table.Rows[0][8].ToString(); _mdd.Text = table.Rows[0][9].ToString(); _bz.Text = table.Rows[0][10].ToString(); _user_name.Text = table.Rows[0][11].ToString(); _user_id.Text = table.Rows[0][15].ToString(); _nian.Text = ConvertStr.convert_nian(table.Rows[0][12].ToString()); _yue.Text = ConvertStr.convert_yue(table.Rows[0][13].ToString()); _day.Text = ConvertStr.convert_day(table.Rows[0][14].ToString()); } }
public UcCertificateMonthReportDetails(IDBOperation dbOperation, string sj, string deptId, string certype) { InitializeComponent(); this.dbOperation = dbOperation; this.Sj = sj; this.DeptId = deptId; this.CerType = certype; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; MyColumns.Add("cardid", new MyColumn("cardid", "检疫证号") { BShow = true, Width = 12 }); MyColumns.Add("cdate", new MyColumn("cdate", "出证时间") { BShow = true, Width = 16 }); MyColumns.Add("createdeptid", new MyColumn("createdeptid", "出证部门id") { BShow = false }); MyColumns.Add("info_name", new MyColumn("info_name", "出证部门") { BShow = true, Width = 16 }); MyColumns.Add("createuserid", new MyColumn("createuserid", "检疫员id") { BShow = false }); MyColumns.Add("info_user", new MyColumn("info_user", "检疫员") { BShow = true, Width = 12 }); MyColumns.Add("companyid", new MyColumn("companyid", "货主id") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "货主") { BShow = true, Width = 12 }); MyColumns.Add("objectcount", new MyColumn("objectcount", "检疫头数") { BShow = true, Width = 12 }); MyColumns.Add("type", new MyColumn("type", "检疫证类型") { BShow = true, Width = 12 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.PageIndex = 1; getdata(); }
"12"};//初始化变量 public SysCertificateMonthReport(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; user_id = (Application.Current.Resources["User"] as UserInfo).ID; dept_id = (Application.Current.Resources["User"] as UserInfo).DepartmentID; _year.ItemsSource = year; _year.SelectedIndex = 5; _month.ItemsSource = month; _month.SelectedIndex = 8; //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; //} //检测单位 ComboboxTool.InitComboboxSource(_detect_dept, "call p_dept_cxtj(" + user_id + ")", "cxtj"); //电子证类型 DataTable dt_type = new DataTable(); dt_type.Columns.Add(new DataColumn("typeid")); dt_type.Columns.Add(new DataColumn("typename")); var row = dt_type.NewRow(); row["typeid"] = "0"; row["typename"] = "动物证"; dt_type.Rows.Add(row); var row2 = dt_type.NewRow(); row2["typeid"] = "1"; row2["typename"] = "产品证"; dt_type.Rows.Add(row2); ComboboxTool.InitComboboxSource(_cer_type, dt_type, "cxtj"); //如果登录用户的部门是站点级别,则将查询条件检测单位赋上默认值 if (user_flag_tier == "4") { _detect_dept.SelectedIndex = 1; } _tableview.DetailsRowEnvent += new UcTableOperableView_NoPages.DetailsRowEventHandler(_tableview_DetailsRowEnvent); }
public SysWarningInfo(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; ////初始化查询条件 //reportDate_kssj.SelectedDate = DateTime.Now.AddDays(-1); //reportDate_jssj.SelectedDate = DateTime.Now; //检测单位 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; } //ComboboxTool.InitComboboxSource(_detect_dept, "call p_dept_cxtj(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); ////检测项目 //ComboboxTool.InitComboboxSource(_detect_item, "SELECT ItemID,ItemNAME FROM t_det_item WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1' order by orderId", "cxtj"); ////检测对象 //ComboboxTool.InitComboboxSource(_detect_object, "SELECT objectId,objectName FROM t_det_object WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1'", "cxtj"); ////检测结果 //ComboboxTool.InitComboboxSource(_detect_result, "SELECT resultId,resultName FROM t_det_result where openFlag='1'"); MyColumns.Add("zj", new MyColumn("zj", "主键") { BShow = false }); //MyColumns.Add("districtid", new MyColumn("districtid", "区id") { BShow = false }); //MyColumns.Add("districtname", new MyColumn("districtname", "区县") { BShow = true,Width = 10 }); MyColumns.Add("partid", new MyColumn("partid", "检测单位id") { BShow = false }); MyColumns.Add("partname", new MyColumn("partname", dept_name) { BShow = true, Width = 18 }); MyColumns.Add("itemid", new MyColumn("itemid", "检测项目id") { BShow = false }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 14 }); MyColumns.Add("objectid", new MyColumn("objectid", "检测对象id") { BShow = false }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 12 }); MyColumns.Add("yang_like", new MyColumn("yang_like", "疑似阳性") { BShow = true, Width = 12 }); MyColumns.Add("yang", new MyColumn("yang", "阳性") { BShow = true, Width = 12 }); MyColumns.Add("count", new MyColumn("count", "合计数量") { BShow = true, Width = 12 }); MyColumns.Add("yang_like_sum", new MyColumn("yang_like_sum", "疑似阳性合计") { BShow = false }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); GetData(); }
public UcYearReportDetails(IDBOperation dbOperation, string sj, string deptId, string itemId, string resultId) { InitializeComponent(); this.dbOperation = dbOperation; this.Sj = sj; this.DeptId = deptId; this.ItemId = itemId; this.ResultId = resultId; MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 8 }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 18 }); MyColumns.Add("partname", new MyColumn("partname", "检测站点") { BShow = true, Width = 16 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 10 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("samplename", new MyColumn("samplename", "检测样本") { BShow = true, Width = 8 }); MyColumns.Add("sensitivityname", new MyColumn("sensitivityname", "检测灵敏度") { BShow = true, Width = 10 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = true, Width = 10 }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = true, Width = 8 }); MyColumns.Add("areaname", new MyColumn("areaname", "来源区域") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "来源单位") { BShow = true, Width = 16 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.PageIndex = 1; GetData(); }
public UcCertificateYearReportDetails(IDBOperation dbOperation, string kssj, string jssj, string deptId, string certype) { InitializeComponent(); this.dbOperation = dbOperation; this.Kssj = kssj; this.Jssj = jssj; this.DeptId = deptId; this.CerType = certype; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; MyColumns.Add("cardid", new MyColumn("cardid", "检疫证号") { BShow = true, Width = 12 }); MyColumns.Add("cdate", new MyColumn("cdate", "出证时间") { BShow = true, Width = 16 }); MyColumns.Add("createdeptid", new MyColumn("createdeptid", "出证部门id") { BShow = false }); MyColumns.Add("info_name", new MyColumn("info_name", "出证部门") { BShow = true, Width = 16 }); MyColumns.Add("createuserid", new MyColumn("createuserid", "检疫员id") { BShow = false }); MyColumns.Add("info_user", new MyColumn("info_user", "检疫员") { BShow = true, Width = 12 }); MyColumns.Add("companyid", new MyColumn("companyid", "货主id") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "货主") { BShow = true, Width = 12 }); MyColumns.Add("objectcount", new MyColumn("objectcount", "检疫头数") { BShow = true, Width = 12 }); MyColumns.Add("type", new MyColumn("type", "检疫证类型") { BShow = true, Width = 12 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.PageIndex = 1; getdata(); }
public CertificatePreview(IDBOperation dbOperation,string card_id) { InitializeComponent(); this.dbOperation = dbOperation; this.cardId = card_id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_certificate_main('{0}')", cardId)).Tables[0]; if (table.Rows.Count > 0) { _card_id.Text = table.Rows[0][0].ToString(); _company.Text = table.Rows[0][2].ToString(); _phone.Text = table.Rows[0][6].ToString(); _detect_object.Text = table.Rows[0][4].ToString(); _object_count.Text = table.Rows[0][5].ToString(); _for_use.Text = table.Rows[0][7].ToString(); _city_ks.Text = table.Rows[0][8].ToString(); _region_ks.Text= table.Rows[0][9].ToString(); _town_ks.Text= table.Rows[0][10].ToString(); _village_ks.Text = table.Rows[0][11].ToString(); _city_js.Text = table.Rows[0][12].ToString(); _region_js.Text = table.Rows[0][13].ToString(); _town_js.Text = table.Rows[0][14].ToString(); _village_js.Text = table.Rows[0][15].ToString(); _object_lable.Text = table.Rows[0][16].ToString(); _user_name.Text = table.Rows[0][17].ToString(); _user_id.Text = table.Rows[0][21].ToString(); _nian.Text = ConvertStr.convert_nian(table.Rows[0][18].ToString()); _yue.Text = ConvertStr.convert_yue(table.Rows[0][19].ToString()); _day.Text = ConvertStr.convert_day(table.Rows[0][20].ToString()); } }
public UcSourceCompanyManager(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; MyColumns.Add("companyid", new MyColumn("companyid", "单位编号") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "来源单位名称") { Width = 2 }); MyColumns.Add("areaid", new MyColumn("areaid", "地区编号")); MyColumns.Add("address", new MyColumn("address", "详细地址") { Width = 3 }); MyColumns.Add("man", new MyColumn("man", "联系人姓名")); MyColumns.Add("phone", new MyColumn("phone", "固话")); MyColumns.Add("mobile", new MyColumn("mobile", "手机")); MyColumns.Add("fax", new MyColumn("fax", "传真")); MyColumns.Add("openflag", new MyColumn("openflag", "是否启用")); MyColumns.Add("deptid", new MyColumn("deptid", "所属部门")); MyColumns.Add("cuserid", new MyColumn("cuserid", "创建者ID") { BShow = false }); MyColumns.Add("cdate", new MyColumn("cdate", "创建日期")); _tableview.MyColumns = MyColumns; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); List<string> provinces = new List<string>(); provinces.Add("请选择"); for (int i = 0; i < rows.Length; i++) { provinces.Add(rows[i]["name"].ToString()); } _province.ItemsSource = provinces; _province.SelectedIndex = 0; _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); _tableview.ModifyRowEnvent += new UcTableOperableView.ModifyRowEventHandler(_tableview_ModifyRowEnvent); _tableview.DeleteRowEnvent += new UcTableOperableView.DeleteRowEventHandler(_tableview_DeleteRowEnvent); }
public SysReviewInfoLt(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; //初始化查询条件 reportDate_kssj.SelectedDate = DateTime.Now.AddDays(-1); reportDate_jssj.SelectedDate = DateTime.Now; //检测单位 ComboboxTool.InitComboboxSource(_detect_dept, string.Format("call p_user_dept('{0}','0')", (Application.Current.Resources["User"] as UserInfo).ID), "cxtj"); //检测项目 ComboboxTool.InitComboboxSource(_detect_item, "SELECT ItemID,ItemNAME FROM t_det_item WHERE OPENFLAG = '1' order by orderId", "cxtj"); MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 8 }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 18 }); MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 16 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 10 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = true, Width = 10 }); MyColumns.Add("detectvalue", new MyColumn("detectvalue", "检测值") { BShow = true, Width = 8 }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = true, Width = 10 }); MyColumns.Add("areaname", new MyColumn("areaname", "来源产地") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "被检单位") { BShow = true, Width = 16 }); MyColumns.Add("reviewflagname", new MyColumn("reviewflagname", "是否复核") { BShow = false }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowState = true; _tableview.StateRowEnvent += new UcTableOperableView_NoTitle.StateRowEventHandler(_tableview_StateRowEnvent); }
public UcCreateCertificatedetails(IDBOperation dbOperation,string batch_no) { InitializeComponent(); this.dbOperation = dbOperation; this.BatchNo = batch_no; MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 8 }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 16 }); MyColumns.Add("batchno", new MyColumn("batchno", "批次编码") { BShow = true, Width = 10 }); MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 14 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 10 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("samplename", new MyColumn("samplename", "检测样本") { BShow = true, Width = 8 }); MyColumns.Add("sensitivityname", new MyColumn("sensitivityname", "检测灵敏度") { BShow = true, Width = 9 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = false, Width = 10 }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = true, Width = 15 }); MyColumns.Add("areaname", new MyColumn("areaname", "来源产地") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "被检单位") { BShow = true, Width = 25 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.PageIndex = 1; GetData(); }
public UcWarningdetailsLt(IDBOperation dbOperation, string deptId, string itemId, string objectId) { InitializeComponent(); this.dbOperation = dbOperation; this.DeptId = deptId; this.ItemId = itemId; this.ObjectId = objectId; MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 8 }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 18 }); MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 16 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 10 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = true, Width = 10 }); MyColumns.Add("detectvalue", new MyColumn("detectvalue", "检测值") { BShow = true, Width = 8 }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = true, Width = 8 }); MyColumns.Add("areaname", new MyColumn("areaname", "来源产地") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "被检单位") { BShow = true, Width = 16 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.PageIndex = 1; GetData(); }
public SysNewDetectScQuery(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //画面初始化-检测单列表画面 dtpStartDate.SelectedDate= DateTime.Now.AddDays(-1); dtpEndDate.SelectedDate = DateTime.Now; ComboboxTool.InitComboboxSource(_source_company1, string.Format(" call p_user_company('{0}','') ", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_station, string.Format("call p_user_dept('{0}','{1}')", userId,"0"), "cxtj"); ComboboxTool.InitComboboxSource(_detect_item1, "SELECT ItemID,ItemNAME FROM t_det_item WHERE OPENFLAG = '1' order by orderId", "cxtj"); ComboboxTool.InitComboboxSource(_detect_object1, "SELECT objectId,objectName FROM t_det_object WHERE OPENFLAG = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_detect_result1, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "cxtj"); ComboboxTool.InitComboboxSource(_detect_person1, string.Format("call p_user_detuser('{0}','{1}')", userId, "0"), "cxtj"); ComboboxTool.InitComboboxSource(_detect_method, "select reagentId,reagentName from t_det_reagent where openFlag = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_detect_type, "SELECT sourceId,sourceName FROM t_det_source where openFlag = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_province1, rows, "cxtj"); _province1.SelectionChanged += new SelectionChangedEventHandler(_province1_SelectionChanged); //20150707检测师改为连动(受监测站点影响) _detect_station.SelectionChanged += new SelectionChangedEventHandler(_detect_station_SelectionChanged); SetColumns(); }
public SysDesignReport(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; reportDate_kssj.Value = DateTime.Now.AddDays(-1); reportDate_jssj.Value = DateTime.Now; //检测站点 ComboboxTool.InitComboboxSource(_detect_dept, "call p_user_dept(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); //检测点属性 ComboboxTool.InitComboboxSource(_detect_type, "SELECT typeId,typeName FROM t_dept_type where openFlag = '1'", "cxtj"); //检测项目 ComboboxTool.InitComboboxSource(_detect_item, "call p_user_item(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); //检测对象 ComboboxTool.InitComboboxSource(_detect_object, "call p_user_object(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); //检测结果 ComboboxTool.InitComboboxSource(_detect_result, "SELECT resultId,resultName FROM t_det_result where openFlag='1' ORDER BY id", "cxtj"); //如果登录用户的部门是站点级别,则将查询条件检测站点赋上默认值 if (isDept()) { _detect_dept.SelectedIndex = 1; } SetColumns(); }
public UcDetectInquire(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //画面初始化-检测单列表画面 dtpStartDate.Value = DateTime.Now.AddDays(-1); dtpEndDate.Value = DateTime.Now; ComboboxTool.InitComboboxSource(_source_company1, string.Format(" call p_user_company('{0}') ", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_station, string.Format("call p_user_dept('{0}')", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_item1, "SELECT ItemID,ItemNAME FROM t_det_item WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1' order by orderId", "cxtj"); ComboboxTool.InitComboboxSource(_detect_object1, "SELECT objectId,objectName FROM t_det_object WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_detect_result1, "SELECT resultId,resultName FROM t_det_result where openFlag = '1' ORDER BY id", "cxtj"); ComboboxTool.InitComboboxSource(_detect_person1, string.Format("call p_user_detuser('{0}')", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_method, "select reagentId,reagentName from t_det_reagent where openFlag = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_detect_type, "SELECT sourceId,sourceName FROM t_det_source where openFlag = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_dept_type, "SELECT typeId,typeName FROM t_dept_type where openFlag = '1'", "cxtj"); ComboboxTool.InitComboboxSource(_province1, rows, "cxtj"); _province1.SelectionChanged += new SelectionChangedEventHandler(_province1_SelectionChanged); SetColumns(); }
public SysCompanyQuery(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; switch (user_flag_tier) { case "0": _dept_name.Text = "选择省:"; break; case "1": _dept_name.Text = "选择市(州):"; break; case "2": _dept_name.Text = "选择区县:"; break; case "3": _dept_name.Text = "选择检测单位:"; break; case "4": _dept_name.Text = "选择检测单位:"; break; default: break; } //检测单位 ComboboxTool.InitComboboxSource(_detect_dept, "call p_dept_cxtj(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); //来源产地 ComboboxTool.InitComboboxSource(_province1, rows, "cxtj"); _province1.SelectionChanged += new SelectionChangedEventHandler(_province1_SelectionChanged); }
public detectdetails(IDBOperation dbOperation,int id) { InitializeComponent(); this.dbOperation = dbOperation; 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(); _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(); }
public detectdetails(IDBOperation dbOperation,int id) { InitializeComponent(); this.dbOperation = dbOperation; 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; } }
}; //初始化变量 public SysQuarterAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_id = (Application.Current.Resources["User"] as UserInfo).ID.ToString(); _year.ItemsSource = year; for (int i = 0; i < _year.Items.Count; i++) { if (_year.Items[i].ToString() == DateTime.Now.Year.ToString()) { _year.SelectedItem = _year.Items[i]; break; } } _month.ItemsSource = month; _month.SelectedIndex = 2; ComboboxTool.InitComboboxSource(_detect_huanjie, "SELECT id,name FROM t_liaoning_huanjie", "cxtj"); //地址从数据库中获取 page_url = dbOperation.GetDbHelper().GetSingle("select quarterreport from t_url ").ToString(); if (page_url == null) { page_url = ""; } }
public SysDeptManager(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; InitUserControlUI(); }
public SysTrendAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_year_count({0})", (Application.Current.Resources["User"] as UserInfo).ID)).Tables[0]; List <string> years = new List <string>(); years.Add("-请选择-"); for (int i = 0; i < table.Rows.Count; i++) { years.Add(table.Rows[i][0].ToString()); } _year.ItemsSource = years; _year.SelectedIndex = 0; List <string> analysisThemes = new List <string>(); analysisThemes.Add("-请选择-"); analysisThemes.Add("年度各项目检测执行趋势分析"); analysisThemes.Add("年度各检测项目阳性样本检出趋势分析"); analysisThemes.Add("年度各检测项目疑似阳性样本检出趋势分析"); _analysis_theme.ItemsSource = analysisThemes; _analysis_theme.SelectedIndex = 0; this.SizeChanged += new SizeChangedEventHandler(SysTrendAnalysis_SizeChanged); _chart.SizeChanged += new SizeChangedEventHandler(_chart_SizeChanged); }
public SysTrendAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_year_count({0})", (Application.Current.Resources["User"] as UserInfo).ID)).Tables[0]; List<string> years = new List<string>(); years.Add("-请选择-"); for (int i = 0; i < table.Rows.Count; i++) { years.Add(table.Rows[i][0].ToString()); } _year.ItemsSource = years; _year.SelectedIndex = 0; List<string> analysisThemes = new List<string>(); analysisThemes.Add("-请选择-"); analysisThemes.Add("年度各项目检测执行趋势分析"); analysisThemes.Add("年度各检测项目阳性样本检出趋势分析"); analysisThemes.Add("年度各检测项目疑似阳性样本检出趋势分析"); _analysis_theme.ItemsSource = analysisThemes; _analysis_theme.SelectedIndex = 0; this.SizeChanged += new SizeChangedEventHandler(SysTrendAnalysis_SizeChanged); _chart.SizeChanged += new SizeChangedEventHandler(_chart_SizeChanged); }
"第四季度"};//初始化变量 public SysQuarterAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_id = (Application.Current.Resources["User"] as UserInfo).ID.ToString(); _year.ItemsSource = year; for (int i = 0; i < _year.Items.Count; i++) { if (_year.Items[i].ToString() == DateTime.Now.Year.ToString()) { _year.SelectedItem = _year.Items[i]; break; } } _month.ItemsSource = month; _month.SelectedIndex = 2; ComboboxTool.InitComboboxSource(_detect_huanjie, "SELECT id,name FROM t_liaoning_huanjie", "cxtj"); //地址从数据库中获取 page_url = dbOperation.GetDbHelper().GetSingle("select quarterreport from t_url ").ToString(); if (page_url == null) { page_url = ""; } }
public SysDeptManager(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = System.Windows.Application.Current.Resources["省市表"] as System.Data.DataTable; user_flag_tier = (System.Windows.Application.Current.Resources["User"] as UserInfo).FlagTier.ToString(); SupplierTable = dbOperation.GetDbHelper().GetDataSet("select supplierId,supplierName from t_supplier").Tables[0]; //赋值所在地下拉选择框 ComboboxTool.InitComboboxSource(_lower_provice, GetRows("0001"), "lr"); _lower_provice.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); //赋值供应商下拉选择框 ComboboxTool.InitComboboxSource(_Supplier, "select supplierId,supplierName from t_supplier", "lr"); //赋值部门级别下拉选择框 dt_level.Columns.Add(new DataColumn("levelid")); dt_level.Columns.Add(new DataColumn("levelname")); var row2 = dt_level.NewRow(); row2["levelid"] = "1"; row2["levelname"] = "省级"; dt_level.Rows.Add(row2); var row3 = dt_level.NewRow(); row3["levelid"] = "2"; row3["levelname"] = "市(州)"; dt_level.Rows.Add(row3); var row4 = dt_level.NewRow(); row4["levelid"] = "3"; row4["levelname"] = "区县"; dt_level.Rows.Add(row4); var row5 = dt_level.NewRow(); row5["levelid"] = "4"; row5["levelname"] = "检测单位"; dt_level.Rows.Add(row5); ComboboxTool.InitComboboxSource(_level, dt_level, "lr"); InitUserControlUI(); }
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 UcQuarantineRecord(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; //检疫员所属部门货主信息flag,屠宰场名称,检疫分站名称 DataTable table = dbOperation.GetDbHelper().GetDataSet("select ifnull(a.shipperflag,'') as shipperflag, " + " tzcname,INFO_NAME" + " from sys_client_sysdept a " + " where INFO_CODE = " + deptId).Tables[0]; if (table.Rows.Count != 0) { shipperflag = table.Rows[0][0].ToString(); _detect_site.Text = table.Rows[0][2].ToString(); _slaughter_site.Text = table.Rows[0][1].ToString(); } //申报人姓名 ComboboxTool.InitComboboxSource(_shipper_name, string.Format("SELECT sbrid,sbrname FROM t_record_sbr WHERE openflag = '1' and createdeptid = '{0}'", deptId), "lr"); //产地 ComboboxTool.InitComboboxSource(_address, string.Format("SELECT areaid,areaname FROM t_record_area WHERE openflag = '1' and createdeptid = '{0}'", deptId), "lr"); //协检员 ComboboxTool.InitComboboxSource(_help_user, string.Format("call p_user_helpuser({0})", userId), "lr"); //官方兽医姓名 _user_name.Text = username; //录入时间 _entering_datetime.Text = string.Format("{0:g}", System.DateTime.Now); //屠宰动物种类 ComboboxTool.InitComboboxSource(_animal, "SELECT animalid,animalname FROM t_animal_new WHERE openflag = '1' and deptflag = '" + shipperflag + "'", "lr"); _animal.SelectionChanged += new SelectionChangedEventHandler(_animal_SelectionChanged); _animal.SelectedIndex = 1; //临床情况 DataTable dt_quater = new DataTable(); dt_quater.Columns.Add(new DataColumn("quaterid")); dt_quater.Columns.Add(new DataColumn("quatername")); var row = dt_quater.NewRow(); row["quaterid"] = "0"; row["quatername"] = "良好"; dt_quater.Rows.Add(row); var row2 = dt_quater.NewRow(); row2["quaterid"] = "1"; row2["quatername"] = "异常"; dt_quater.Rows.Add(row2); ComboboxTool.InitComboboxSource(_quater, dt_quater, "lr"); //是否佩戴规定的畜禽标识 DataTable dt_object_flag = new DataTable(); dt_object_flag.Columns.Add(new DataColumn("flagid")); dt_object_flag.Columns.Add(new DataColumn("flagname")); var row3 = dt_object_flag.NewRow(); row3["flagid"] = "1"; row3["flagname"] = "是"; dt_object_flag.Rows.Add(row3); var row4 = dt_object_flag.NewRow(); row4["flagid"] = "0"; row4["flagname"] = "否"; dt_object_flag.Rows.Add(row4); ComboboxTool.InitComboboxSource(_object_flag, dt_object_flag, "lr"); }
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 AddShipper(IDBOperation dbOperation, string shipperflag) { InitializeComponent(); this.dbOperation = dbOperation; this.shipperFlag = shipperflag; this._id.Text = dbOperation.GetDbHelper().GetSingle(string.Format("select f_create_shipper('{0}')", shipperFlag)).ToString(); }
public CertificatePreview(IDBOperation dbOperation, string card_id) { InitializeComponent(); this.dbOperation = dbOperation; this.cardId = card_id; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("call p_certificate_main('{0}')", cardId)).Tables[0]; if (table.Rows.Count > 0) { _card_id.Text = table.Rows[0][0].ToString(); _company.Text = table.Rows[0][2].ToString(); _phone.Text = table.Rows[0][6].ToString(); _detect_object.Text = table.Rows[0][4].ToString(); _object_count.Text = table.Rows[0][5].ToString(); _for_use.Text = table.Rows[0][7].ToString(); _city_ks.Text = table.Rows[0][8].ToString(); _region_ks.Text = table.Rows[0][9].ToString(); _town_ks.Text = table.Rows[0][10].ToString(); _village_ks.Text = table.Rows[0][11].ToString(); _city_js.Text = table.Rows[0][12].ToString(); _region_js.Text = table.Rows[0][13].ToString(); _town_js.Text = table.Rows[0][14].ToString(); _village_js.Text = table.Rows[0][15].ToString(); _object_lable.Text = table.Rows[0][16].ToString(); _user_name.Text = table.Rows[0][17].ToString(); _user_id.Text = table.Rows[0][21].ToString(); _nian.Text = ConvertStr.convert_nian(table.Rows[0][18].ToString()); _yue.Text = ConvertStr.convert_yue(table.Rows[0][19].ToString()); _day.Text = ConvertStr.convert_day(table.Rows[0][20].ToString()); } }
public UcWarningCountry(IDBOperation dbOperation,string dept_id,string item_id,string object_id) { InitializeComponent(); this.dbOperation = dbOperation; this.DeptId = dept_id; this.ItemId = item_id; this.ObjectId = object_id; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; MyColumns.Add("zj", new MyColumn("zj", "主键") { BShow = false }); MyColumns.Add("partid", new MyColumn("partid", "检测单位id") { BShow = false }); MyColumns.Add("partname", new MyColumn("partname", "区县名称") { BShow = true, Width = 18 }); MyColumns.Add("itemid", new MyColumn("itemid", "检测项目id") { BShow = false }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 14 }); MyColumns.Add("objectid", new MyColumn("objectid", "检测对象id") { BShow = false }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 12 }); MyColumns.Add("yang_like", new MyColumn("yang_like", "疑似阳性") { BShow = true, Width = 12 }); MyColumns.Add("yang", new MyColumn("yang", "阳性") { BShow = true, Width = 12 }); MyColumns.Add("count", new MyColumn("count", "合计数量") { BShow = true, Width = 12 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowDetails = true; _tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); GetData(); }
public SysDetectReport(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = System.Windows.Application.Current.Resources["省市表"] as System.Data.DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //画面初始化-检测单列表画面 dtpStartDate.SelectedDate = DateTime.Now.AddDays(-1); dtpEndDate.SelectedDate = DateTime.Now; ComboboxTool.InitComboboxSource(_source_company1, string.Format(" call p_user_company('{0}','') ", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_station, string.Format("call p_user_dept('{0}')", userId), "cxtj"); ComboboxTool.InitComboboxSource(_detect_person1, string.Format("call p_user_detuser('{0}')", userId), "cxtj"); ComboboxTool.InitComboboxSource(_province1, rows, "cxtj"); _province1.SelectionChanged += new SelectionChangedEventHandler(_province1_SelectionChanged); //20150707检测师改为连动(受监测站点影响) _detect_station.SelectionChanged += new SelectionChangedEventHandler(_detect_station_SelectionChanged); //如果登录用户的部门是站点级别,则将查询条件检测单位赋上默认值 if (user_flag_tier == "4") { _detect_station.SelectedIndex = 1; } }
public UcWarningReportDetailsSchool(IDBOperation dbOperation, string kssj, string jssj, string dept_id, string item_id, string review_id) { InitializeComponent(); this.dbOperation = dbOperation; this.Kssj = kssj; this.Jssj = jssj; this.DeptId = dept_id; this.ItemId = item_id; this.ReviewFlag = review_id; MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = true, Width = 8 }); MyColumns.Add("reviewflagname", new MyColumn("reviewflagname", "复核标志") { BShow = false, Width = 8 }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 16 }); MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 16 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 12 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = true, Width = 10 }); MyColumns.Add("detectvalue", new MyColumn("detectvalue", "检测值") { BShow = true, Width = 8 }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = true, Width = 10 }); MyColumns.Add("areaname", new MyColumn("areaname", "来源产地") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "被检单位") { BShow = true, Width = 16 }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowState = true; _tableview.GetDataByPageNumberEvent += new UcTableOperableView_NoTitle.GetDataByPageNumberEventHandler(_tableview_GetDataByPageNumberEvent); _tableview.StateRowEnvent += new UcTableOperableView_NoTitle.StateRowEventHandler(_tableview_StateRowEnvent); _tableview.PageIndex = 1; GetData(); }
public SysCertificateYearReport(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; user_id = (Application.Current.Resources["User"] as UserInfo).ID; dept_id = (Application.Current.Resources["User"] as UserInfo).DepartmentID; dtpStartDate.SelectedDate = DateTime.Now.AddDays(-1); dtpEndDate.SelectedDate = DateTime.Now; //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; //} //检测单位 ComboboxTool.InitComboboxSource(_detect_dept, "call p_dept_cxtj(" + user_id + ")", "cxtj"); //电子证类型 DataTable dt_type = new DataTable(); dt_type.Columns.Add(new DataColumn("typeid")); dt_type.Columns.Add(new DataColumn("typename")); var row = dt_type.NewRow(); row["typeid"] = "0"; row["typename"] = "动物证"; dt_type.Rows.Add(row); var row2 = dt_type.NewRow(); row2["typeid"] = "1"; row2["typename"] = "产品证"; dt_type.Rows.Add(row2); ComboboxTool.InitComboboxSource(_cer_type, dt_type, "cxtj"); //如果登录用户的部门是站点级别,则将查询条件检测单位赋上默认值 if (user_flag_tier == "4") { _detect_dept.SelectedIndex = 1; } _tableview.DetailsRowEnvent += new UcTableOperableView_NoPages.DetailsRowEventHandler(_tableview_DetailsRowEnvent); }
public AddShipper(IDBOperation dbOperation,string shipperflag) { InitializeComponent(); this.dbOperation = dbOperation; this.shipperFlag = shipperflag; this._id.Text = dbOperation.GetDbHelper().GetSingle(string.Format("select f_create_shipper('{0}')", shipperFlag)).ToString(); }
public SysReviewInfo(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; //初始化查询条件 reportDate_kssj.SelectedDate = DateTime.Now.AddDays(-1); reportDate_jssj.SelectedDate = DateTime.Now; //检测单位 ComboboxTool.InitComboboxSource(_detect_dept, "call p_user_dept(" + (Application.Current.Resources["User"] as UserInfo).ID + ")", "cxtj"); //检测项目 ComboboxTool.InitComboboxSource(_detect_item, "SELECT ItemID,ItemNAME FROM t_det_item WHERE (tradeId ='1'or tradeId ='2' or tradeId ='3' or ifnull(tradeId,'') = '') and OPENFLAG = '1' order by orderId", "cxtj"); ////检测结果 //DataTable table_detect_result = new DataTable(); //table_detect_result.Columns.Add("id", Type.GetType("System.String")); //table_detect_result.Columns.Add("name", Type.GetType("System.String")); //table_detect_result.Rows.Add(new object[] { "0", "未复核" }); //table_detect_result.Rows.Add(new object[] { "1", "已复核" }); //ComboboxTool.InitComboboxSource(_detect_result, table_detect_result,"cxtj"); //MyColumns.Add("zj", new MyColumn("zj", "主键") { BShow = false }); //MyColumns.Add("partid", new MyColumn("partid", "检测单位id") { BShow = false }); //MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 12 }); //MyColumns.Add("itemid", new MyColumn("itemid", "检测项目id") { BShow = false }); //MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 12 }); //MyColumns.Add("review_yes", new MyColumn("review_yes", "已复核") { BShow = true, Width = 10 }); //MyColumns.Add("review_no", new MyColumn("review_no", "未复核") { BShow = true, Width = 10 }); //MyColumns.Add("count", new MyColumn("count", "合计数量") { BShow = true, Width = 10 }); //MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); //_tableview.MyColumns = MyColumns; //_tableview.BShowDetails = true; //_tableview.DetailsRowEnvent += new UcTableOperableView_NoTitle.DetailsRowEventHandler(_tableview_DetailsRowEnvent); MyColumns.Add("orderid", new MyColumn("orderid", "检测单编号") { BShow = false }); MyColumns.Add("detecttypename", new MyColumn("detecttypename", "信息来源") { BShow = true, Width = 8 }); MyColumns.Add("detectdate", new MyColumn("detectdate", "检测时间") { BShow = true, Width = 18 }); MyColumns.Add("partname", new MyColumn("partname", "检测单位") { BShow = true, Width = 18 }); MyColumns.Add("huanjiename", new MyColumn("huanjiename", "样品环节") { BShow = true, Width = 8 }); MyColumns.Add("detectnumber", new MyColumn("detectnumber", "样品编号") { BShow = true, Width = 12 }); MyColumns.Add("itemname", new MyColumn("itemname", "检测项目") { BShow = true, Width = 10 }); MyColumns.Add("objectname", new MyColumn("objectname", "检测对象") { BShow = true, Width = 8 }); MyColumns.Add("samplename", new MyColumn("samplename", "检测样本") { BShow = true, Width = 8 }); MyColumns.Add("sensitivityname", new MyColumn("sensitivityname", "检测灵敏度") { BShow = true, Width = 10 }); MyColumns.Add("reagentname", new MyColumn("reagentname", "检测方法") { BShow = false }); MyColumns.Add("resultname", new MyColumn("resultname", "检测结果") { BShow = true, Width = 8 }); MyColumns.Add("detectusername", new MyColumn("detectusername", "检测师") { BShow = false }); MyColumns.Add("areaname", new MyColumn("areaname", "来源产地") { BShow = false }); MyColumns.Add("companyname", new MyColumn("companyname", "被检单位") { BShow = true, Width = 16 }); MyColumns.Add("cardbrandname", new MyColumn("cardbrandname", "检测卡品牌") { BShow = false }); MyColumns.Add("reviewflagname", new MyColumn("reviewflagname", "是否复核") { BShow = false }); MyColumns.Add("sum_num", new MyColumn("sum_num", "总行数") { BShow = false }); _tableview.MyColumns = MyColumns; _tableview.BShowState = true; _tableview.StateRowEnvent += new UcTableOperableView_NoTitle.StateRowEventHandler(_tableview_StateRowEnvent); }
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 SysDeptManager(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier.ToString(); SupplierTable = dbOperation.GetDbHelper().GetDataSet("select supplierId,supplierName from t_supplier").Tables[0]; InitUserControlUI(); }
public SysDeviceQuery(IDBOperation dbOperation, string depttype) { InitializeComponent(); this.dbOperation = dbOperation; this.dept_type = depttype; user_flag_tier = PubClass.userInfo.FlagTier; }
public SysDeptManager(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; ProvinceCityTable = System.Windows.Application.Current.Resources["省市表"] as System.Data.DataTable; user_flag_tier = (System.Windows.Application.Current.Resources["User"] as UserInfo).FlagTier.ToString(); SupplierTable = dbOperation.GetDbHelper().GetDataSet("select supplierId,supplierName from t_supplier").Tables[0]; InitUserControlUI(); }
public UcSetSamplingRate(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; _tableview.ModifyRowEnvent += new UcTableOperableView_NoPages.ModifyRowEventHandler(_tableview_ModifyRowEnvent); Load_table(); }
}; //初始化变量 public SysAreaAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; _analysis_theme.ItemsSource = analysisThemes; _analysis_theme.SelectedIndex = 0; dtpStartDate.Value = DateTime.Now; dtpEndDate.Value = DateTime.Now; }
"疑似阳性样本检出来源产地分布(省内)分析"};//初始化变量 public SysAreaAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; _analysis_theme.ItemsSource = analysisThemes; _analysis_theme.SelectedIndex = 0; dtpStartDate.SelectedDate = DateTime.Now; dtpEndDate.SelectedDate = DateTime.Now; }
public SetTask(IDBOperation dbOperation, string dept_id, string dept_name, UcSetTask settask) { InitializeComponent(); this.dbOperation = dbOperation; this.deptid = dept_id; this.deptname = dept_name; this.setTask = settask; createTask(); }
public DistributedDataSet(IDataChunk dataChunk, string shardName, IDBOperation operation, IDataLoader dataLoader, Server readerLocationAddress) { _shardName = shardName; _dataChunk = dataChunk; _isFixedSize = dataChunk.IsLastChunk; _isExhausted = false; _operation = operation; _dataLoader = dataLoader; _readerAddress = readerLocationAddress; }
public UcSetTask(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (System.Windows.Application.Current.Resources["User"] as UserInfo).FlagTier; deptid = (System.Windows.Application.Current.Resources["User"] as UserInfo).DepartmentID; _tableview.ModifyRowEnvent += new UcTableOperableView_NoPages.ModifyRowEventHandler(_tableview_ModifyRowEnvent); Load_table(); }
public SetSampling(IDBOperation dbOperation, string dept_id, string dept_name, UcSetSamplingRate setsampling) { InitializeComponent(); this.dbOperation = dbOperation; this.deptid = dept_id; this.deptname = dept_name; this.setSampling = setsampling; createTask(); }
public UcSetSamplingRate(IDBOperation dbOperation, string depttype) { InitializeComponent(); this.dbOperation = dbOperation; this.dept_type = depttype; user_flag_tier = PubClass.userInfo.FlagTier; _tableview.ModifyRowEnvent += new UcTableOperableView_NoPages.ModifyRowEventHandler(_tableview_ModifyRowEnvent); Load_table(); }
public SysComparisonAndAnalysis(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; user_flag_tier = (Application.Current.Resources["User"] as UserInfo).FlagTier; dtpStartDate.Value = DateTime.Now; dtpEndDate.Value = DateTime.Now; switch (user_flag_tier) { case "0": dept_name = "各省检测总量占比分析"; dept_name_2 = "各省阳性样本检出量占比分析"; dept_name_3 = "各省疑似阳性样本检出量占比分析"; break; case "1": dept_name = "各地市检测总量占比分析"; dept_name_2 = "各地市阳性样本检出量占比分析"; dept_name_3 = "各地市疑似阳性样本检出量占比分析"; break; case "2": dept_name = "各区县检测总量占比分析"; dept_name_2 = "各区县阳性样本检出量占比分析"; dept_name_3 = "各区县疑似阳性样本检出量占比分析"; break; case "3": dept_name = "各检测站点检测总量占比分析"; dept_name_2 = "各检测站点阳性样本检出量占比分析"; dept_name_3 = "各检测站点疑似阳性样本检出量占比分析"; break; case "4": dept_name = "各检测站点检测总量占比分析"; dept_name_2 = "各检测站点阳性样本检出量占比分析"; dept_name_3 = "各检测站点疑似阳性样本检出量占比分析"; break; default: break; } analysisThemes = new List <string>() { "-请选择-", dept_name, dept_name_2, dept_name_3, "直属与企业检测点检测总量比较分析", "直属与企业检测点阳性样本检出比较分析", "直属与企业检测点疑似阳性样本检出比较分析", "不同检测项目检测量占比分析", "不同检测项目阳性样本检测占比分析", "不同检测项目疑似阳性样本检测占比分析", "疑似阳性/阳性样本检出总量占比分析" }; //初始化变量 _analysis_theme.ItemsSource = analysisThemes; _analysis_theme.SelectedIndex = 0; }
public SysShipperQuery_product(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; deptId = (System.Windows.Application.Current.Resources["User"] as UserInfo).DepartmentID; shipperflag = dbOperation.GetDbHelper().GetSingle("select ifnull(a.shipperflag,'') as shipperflag " + " from sys_client_sysdept a " + " where INFO_CODE = " + deptId).ToString(); }
public UcCreateCertificatequery(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; dtpStartDate.SelectedDate = DateTime.Now.AddDays(-1); dtpEndDate.SelectedDate = DateTime.Now; //ComboboxTool.InitComboboxSource(_source_company, string.Format("select DISTINCT t_certificate.companyid ,t_shipper.shippername" + // " FROM t_certificate left join t_shipper ON t_certificate.companyid = t_shipper.shipperid" + // " WHERE t_certificate.createdeptid like '{0}%' ", deptId), "cxtj"); }
public NewOrModifyDevice(IDBOperation dbOperation, string company_id, SysDeviceQuery company_query) { InitializeComponent(); flag = 0; this.dbOperation = dbOperation; this.companyId = company_id; this.company = company_query; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //来源产地 ComboboxTool.InitComboboxSource(_province, rows, "cxtj"); _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("select companyName,t_company.deptId,sys_client_sysdept.deptName,areaId,t_company.contacter,t_company.phone " + "from t_company left join sys_client_sysdept " + "on t_company.deptId = sys_client_sysdept.deptId where companyId = '{0}' ", companyId)).Tables[0]; if (table.Rows.Count != 0) { this._companyname.Text = table.Rows[0][0].ToString(); this._deptname.Text = table.Rows[0][2].ToString(); this._phone.Text = table.Rows[0][5].ToString(); this._contacter.Text = table.Rows[0][4].ToString(); //赋值来源产地 for (int i = 0; i < _province.Items.Count; i++) { if ((_province.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString().Substring(0, 2)) { _province.SelectedItem = _province.Items[i]; break; } } for (int i = 0; i < _city.Items.Count; i++) { if ((_city.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString().Substring(0, 4)) { _city.SelectedItem = _city.Items[i]; break; } } for (int i = 0; i < _region.Items.Count; i++) { if ((_region.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString()) { _region.SelectedItem = _region.Items[i]; break; } } } }
public SetTaskGrade(IDBOperation dbOperation, string grade_id, string city_id, DataTable current_table) { InitializeComponent(); this.dbOperation = dbOperation; gradeId = grade_id; cityId = city_id; currentTable = current_table; }
private Rect rcnormal;//定义一个全局rect记录还原状态下窗口的位置和大小。 public MainWindow(IDBOperation dbOperation) { //Rect rc = SystemParameters.WorkArea;//获取工作区大小 this.Width = 1366; this.Height = 766; InitializeComponent(); this.dbOperation = dbOperation; UserInfo userInfo = Application.Current.Resources["User"] as UserInfo; this.userName = userInfo.ShowName; Application.Current.Resources.Add("省市表", dbOperation.GetProvinceCity()); //加载标题 this._user.Text = this.userName; //this._date.Text = DateTime.Now.ToLongDateString().ToString() + DateTime.Now.ToString("dddd"); this._date.Text = DateTime.Now.ToLongDateString().ToString(); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("select companyName,phone from t_supplier where supplierId ='{0}'", (Application.Current.Resources["User"] as UserInfo).SupplierId == "" ? "zrd" : (Application.Current.Resources["User"] as UserInfo).SupplierId)).Tables[0]; this._bottom.Text = table.Rows[0][0].ToString() + "版权所有 版本号:" + ConfigurationManager.AppSettings["version"] + " 技术服务热线:" + table.Rows[0][1].ToString(); DataTable dt = dbOperation.GetDbHelper().GetDataSet(string.Format("SELECT INFO_NAME,image from sys_client_sysdept where INFO_CODE ='{0}'", (Application.Current.Resources["User"] as UserInfo).DepartmentID)).Tables[0]; this._title_dept.Text = dt.Rows[0][0].ToString(); if (dt.Rows[0][1].ToString() != null && dt.Rows[0][1].ToString() != "") { byte[] img = (byte[])dt.Rows[0][1]; ShowSelectedIMG(img); //以流的方式显示图片的方法 } MainMenu_Load(); this.SizeChanged += new SizeChangedEventHandler(MainWindow_SizeChanged); //加载主画面 if (mainMenus[0].Flag_Exits == 1) { TabItem temptb = new TabItem(); temptb.Header = "首页"; temptb.Content = new UcMainPage(); _tab.Items.Add(temptb); _tab.SelectedIndex = _tab.Items.Count - 1; } //if (!FullScreenHelper.IsFullscreen(this)) //{ // FullScreenHelper.GoFullscreen(this); //} //this.Loaded += new RoutedEventHandler(MainWindow_Loaded); //this.KeyDown += new KeyEventHandler(MainWindow_KeyDown); //this.StateChanged += new EventHandler(MainWindow_StateChanged); }