本文整理汇总了C#中IDBOperation类的典型用法代码示例。如果您正苦于以下问题:C# IDBOperation类的具体用法?C# IDBOperation怎么用?C# IDBOperation使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
IDBOperation类属于命名空间,在下文中一共展示了IDBOperation类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: MainWindow
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;
}
}
开发者ID:wuqiangqiang,项目名称:lnxcp,代码行数:31,代码来源:MainWindow.xaml.cs
示例2: detectdetails
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();
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:25,代码来源:detectdetails.xaml.cs
示例3: SysCertificateMonthReport
"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);
}
开发者ID:wuqiangqiang,项目名称:lnxcp,代码行数:62,代码来源:SysCertificateMonthReport.xaml.cs
示例4: SysReviewLog
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);
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:25,代码来源:SysReviewLog.xaml.cs
示例5: SysTrendAnalysis
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);
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:26,代码来源:SysTrendAnalysis.xaml.cs
示例6: SysWarningInfo
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();
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:60,代码来源:SysWarningInfo.xaml.cs
示例7: UcYearReportDetails
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();
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:32,代码来源:UcYearReportDetails.xaml.cs
示例8: detectDetailsReview
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();
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:31,代码来源:detectDetailsReview.xaml.cs
示例9: SysDetectReport
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;
}
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:26,代码来源:SysDetectReport.xaml.cs
示例10: AddReviewDetails
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;
}
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:60,代码来源:AddReviewDetails.xaml.cs
示例11: UcCertificateYearReportDetails
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();
}
开发者ID:wuqiangqiang,项目名称:lnxcp,代码行数:31,代码来源:UcCertificateYearReportDetails.xaml.cs
示例12: CertificatePreview
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());
}
}
开发者ID:wuqiangqiang,项目名称:lnxcp,代码行数:31,代码来源:CertificatePreview.xaml.cs
示例13: SysNewDetectScQuery
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();
}
开发者ID:wuqiangqiang,项目名称:dcs,代码行数:26,代码来源:SysNewDetectScQuery.xaml.cs
示例14: SysReviewInfoLt
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);
}
开发者ID:wuqiangqiang,项目名称:dcs,代码行数:32,代码来源:SysReviewInfoLt.xaml.cs
示例15: CertificateProductPreview
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());
}
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:25,代码来源:CertificateProductPreview.xaml.cs
示例16: SysQuarterAnalysis
"第四季度"};//初始化变量
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 = "";
}
}
开发者ID:wuqiangqiang,项目名称:lnxcp,代码行数:32,代码来源:SysQuarterAnalysis.xaml.cs
示例17: UcCreateCertificatedetails
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();
}
开发者ID:wuqiangqiang,项目名称:easyfood,代码行数:30,代码来源:UcCreateCertificatedetails.xaml.cs
示例18: detectdetails
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;
}
}
开发者ID:wuqiangqiang,项目名称:dcs,代码行数:32,代码来源:detectdetails.xaml.cs
示例19: UcWarningReportDetailsSchool
-
六六分期app的软件客服如何联系?不知道吗?加qq群【895510560】即可!标题:六六分期
阅读:19256|2023-10-27
-
今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题,可能很多用户都不知
阅读:10007|2022-11-06
-
今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置,可能很多用户都不知道
阅读:8335|2022-11-06
-
今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法,想必大家都遇到过需要
阅读:8703|2022-11-06
-
我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置,可能很多
阅读:8650|2022-11-06
-
今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题,可能很多用户都不
阅读:9677|2022-11-06
-
电脑对日常生活的重要性小编就不多说了,可是一旦碰到win7系统设置cf烟雾头的问题,很
阅读:8635|2022-11-06
-
我们在日常使用电脑的时候,有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法
阅读:8008|2022-11-06
-
今天小编告诉大家如何对win7系统打开vcf文件进行设置,可能很多用户都不知道怎么对win
阅读:8671|2022-11-06
-
今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置,可能很多用户都不知道怎
阅读:7542|2022-11-06
|
请发表评论