private void BindGridData() { webService.Service sw = new webService.Service(); try { webService.ReturnValue resoult = sw.GetListEmployee(" Where Employee.EmployeeID <> '000000000000000000'"); if (resoult.ErrorFlag) { for (int i = 0; i < resoult.ResultDataSet.Tables[0].Rows.Count; i++) { grdMain.Rows.Add((i + 1).ToString(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeID"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeName"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmpSex"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeBM"].ToString().Trim() == "请选择" ? "" : resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeBM"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeDW"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeJG"].ToString().Trim(), resoult.ResultDataSet.Tables[0].Rows[i]["EmployeeGZID"].ToString().Trim()); } } else { MessageBox.Show(resoult.ErrorID); } } catch { this.Cursor = Cursors.Default; } this.Cursor = Cursors.Default; }
private void btnImport_Click(object sender, EventArgs e) { //this.dataGridView1.DataSource = null; //byte[] buffer = GlobalVal.gloWebSerices.GetAllBiochemistryData(); //if (buffer != null) //{ // DataSet ds = DataSetZip.Decompress(buffer); // this.dataGridView1.DataSource = ds.Tables[0]; //} webService.Service ws = new webService.Service(); webService.Service sw=new webService.Service(); byte[] buffer = sw.GetAllBiochemistryData(); bool resoult = ws.InportBiochemistryData(buffer); if (resoult) { MessageBox.Show("导入成功"); } else { MessageBox.Show("导入失败"); } }
private void btnSearch_Click(object sender, EventArgs e) { //this.dataGridView1.DataSource = null; //GlobalVal.gloWebSerices.GetAllBiochemistryDataCompleted += new webService.GetAllBiochemistryDataCompletedEventHandler(gloWebSerices_GetAllBiochemistryDataCompleted); //GlobalVal.gloWebSerices.GetAllBiochemistryDataAsync(); //btnSearch.Enabled = false; webService.Service sw = new webService.Service(); byte[] buffer = sw.GetAllBiochemistryData(); if (buffer != null) { DataSet ds = DataSetZip.Decompress(buffer); this.dataGridView1.DataSource = ds.Tables[0]; this.label1.Text = ds.Tables[0].Rows.Count.ToString(); } BindGridData(); }
private void grdMain_DoubleClick(object sender, EventArgs e) { string EmployeeID = grdMain.CurrentRow.Cells["EmployeeID"].Value.ToString(); webService.Service ws = new webService.Service(); byte[] buffer = ws.GetStatisticsDataByID(EmployeeID); if (buffer != null) { DataSet ds = DataSetZip.Decompress(buffer); if (ds.Tables.Count > 0) { this.dataGridView1.DataSource = ds.Tables[0]; int length = 0; int lenghtCopy = 0; if (ckbFA.Checked)//防癌 { length += FA.Length; } if (ckbXZ.Checked)//血脂 { length += XZ.Length; } if (ckbGG.Checked)//肝功 { length += GG.Length; } if (ckbSG.Checked)//肾功 { length += SG.Length; } if (ckbXT.Checked)//血糖 { length += XT.Length; } string[] series = new string[length]; if (ckbFA.Checked)//防癌 { FA.CopyTo(series, lenghtCopy); lenghtCopy += FA.Length; } if (ckbXZ.Checked)//血脂 { XZ.CopyTo(series, lenghtCopy); lenghtCopy += XZ.Length; } if (ckbGG.Checked)//肝功 { GG.CopyTo(series, lenghtCopy); lenghtCopy += GG.Length; } if (ckbSG.Checked)//肾功 { SG.CopyTo(series, lenghtCopy); lenghtCopy += SG.Length; } if (ckbXT.Checked)//血糖 { XT.CopyTo(series, lenghtCopy); lenghtCopy += XT.Length; } try { chart2.Series.Clear(); chart2.DataSource = ds.Tables[0]; for (int i = 0; i < series.Length; i++) { Series series1 = new Series(series[i]); series1.ChartType = SeriesChartType.Column; chart2.Series.Add(series1); series1.XValueMember = "YearMonth"; series1.YValueMembers = series[i]; } chart2.DataBind(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
/// <summary> /// 个人统计,打开员工选择窗口 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPersonal_Click(object sender, EventArgs e) { if (GlobalVal.FormEmpManage.ShowDialog(this) == DialogResult.OK) { webService.Service ws = new webService.Service(); byte[] buffer = ws.GetStatisticsDataByID(GlobalVal.StatisticsEmployeeID); if (buffer != null) { DataSet ds = DataSetZip.Decompress(buffer); if (ds.Tables.Count > 0) { this.dataGridView1.DataSource = ds.Tables[0]; int length = 0; int lenghtCopy = 0; if (ckbFA.Checked)//防癌 { length += FA.Length; } if (ckbXZ.Checked)//血脂 { length += XZ.Length; } if (ckbGG.Checked)//肝功 { length += GG.Length; } if (ckbSG.Checked)//肾功 { length += SG.Length; } if (ckbXT.Checked)//血糖 { length += XT.Length; } string[] series = new string[length]; if (ckbFA.Checked)//防癌 { FA.CopyTo(series, lenghtCopy); lenghtCopy += FA.Length; } if (ckbXZ.Checked)//血脂 { XZ.CopyTo(series, lenghtCopy); lenghtCopy += XZ.Length; } if (ckbGG.Checked)//肝功 { GG.CopyTo(series, lenghtCopy); lenghtCopy += GG.Length; } if (ckbSG.Checked)//肾功 { SG.CopyTo(series, lenghtCopy); lenghtCopy += SG.Length; } if (ckbXT.Checked)//血糖 { XT.CopyTo(series, lenghtCopy); lenghtCopy += XT.Length; } try { chart2.Series.Clear(); chart2.DataSource = ds.Tables[0]; for (int i = 0; i < series.Length; i++) { Series series1 = new Series(series[i]); series1.ChartType = SeriesChartType.Column; chart2.Series.Add(series1); series1.XValueMember = "YearMonth"; series1.YValueMembers = series[i]; } chart2.DataBind(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } else { } }