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
{
}
}
