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 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 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 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 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 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 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 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 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 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 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);
}
