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 = "";
}
}
