/// <summary>
/// 初始化数据--HLB
/// </summary>
//public void InitFlexGrid(Panel GbxMontior, string sqlSel, ComboBox comboxSA, string flag, ListView lstCount, string sqlCount,bool isDoctor)
//{
// GbxMontior.Controls.Clear();
// Class_Table[] table = new Class_Table[2];
// table[0] = new Class_Table();
// table[0].Sql = sqlSel;
// table[0].Tablename = "sqlSel";
// table[1] = new Class_Table();
// table[1].Sql = sqlCount;
// table[1].Tablename = "sqlCount";
// DS_QUALITYTABLE = App.GetDataSet(table);
// DataSet dataSet = DS_QUALITYTABLE;
// ListViewItem[] item = new ListViewItem[dataSet.Tables[0].Rows.Count];
// Class_Record_Monitor_View[] crmv = new Class_Record_Monitor_View[dataSet.Tables[0].Rows.Count];
// if (dataSet.Tables["sqlSel"] != null)
// {
// Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlSel"].Rows.Count];
// //using (Graphics gh = Graphics.FromHwnd(GbxMontior.Handle))
// //{
// string section_name = string.Empty;
// for (int j = 0; j < dataSet.Tables["sqlSel"].Rows.Count; j++)
// {
// string doctor_name = dataSet.Tables["sqlSel"].Rows[j]["sick_doctor_name"].ToString();
// int yelNum = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["黄灯"].ToString());
// int redNum = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["红灯"].ToString());
// string names = dataSet.Tables["sqlSel"].Rows[j]["names"].ToString();
// Image red = lstCount.SmallImageList.Images[0];
// Image yellow = lstCount.SmallImageList.Images[1];
// UserControl uc = new UcMerger(true,doctor_name, yelNum, yellow, redNum, red, flag);
// Class_Record_Monitor_View crmv5 = new Class_Record_Monitor_View();
// crmv5.DocType = doctor_name;
// crmv5.SickArea_Name = names;
// uc.Tag = crmv5;
// //if (section_name != names)
// //{
// // if (!string.IsNullOrEmpty(names))
// // {
// // section_name = names;
// // Label lbl = new Label();
// // lbl.Text = section_name;
// // lbl.ForeColor = Color.Blue;
// // GbxMontior.Controls.Add(lbl);
// // //AddUcontrol(GbxMontior, uc, section_name);
// // }
// //}
// GbxMontior.Controls.Add(uc);
// }
// //}
// }
// GbxMontior.Refresh();
// ListViewGroup CountGroup = new ListViewGroup();
// CountGroup.Header = "统计列表";
// CountGroup.Name = "统计列表";
// lstCount.Groups.Add(CountGroup);
// if (dataSet.Tables["sqlCount"] != null)
// {
// Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlCount"].Rows.Count];
// for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
// {
// crmv1[i] = new Class_Record_Monitor_View();
// crmv1[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
// crmv1[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
// crmv1[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv1[i];
// tempItem.Name = crmv1[i].DocType;
// tempItem.Text = crmv1[i].DocType + "[" + crmv1[i].Num.ToString() + "]";
// if (crmv1[i].PV == 0)
// {
// tempItem.ImageIndex = 1;//黄灯
// }
// else
// {
// tempItem.ImageIndex = 0;//红灯
// }
// tempItem.Group = lstCount.Groups["统计列表"];
// lstCount.Items.Add(tempItem);
// }
// }
//}
#endregion
/// <summary>
/// 管床医生监控界面-初始化数据
/// </summary>
/// <param name="GbxMontior"></param>
/// <param name="sqlSel"></param>
/// <param name="comboxSA"></param>
/// <param name="flag"></param>
/// <param name="pCount"></param>
/// <param name="sqlCount"></param>
/// <param name="isDoctor"></param>
/// <param name="img"></param>
/// <param name="IsQualityAlert">是否质控提醒界面查询</param>
public void InitFlexGrid(Panel GbxMontior, string sqlSel, ComboBox comboxSA, string flag, Panel pCount, string sqlCount, bool isBuLu, ImageList img, bool IsQualityAlert)
{
GbxMontior.Controls.Clear();
pCount.Controls.Clear();
Class_Table[] table = new Class_Table[2];
table[0] = new Class_Table();
table[0].Sql = sqlSel;
table[0].Tablename = "sqlSel";
table[1] = new Class_Table();
table[1].Sql = sqlCount;
table[1].Tablename = "sqlCount";
DS_QUALITYTABLE = App.GetDataSet(table);
DataSet dataSet = DS_QUALITYTABLE;
//ListViewItem[] item = new ListViewItem[dataSet.Tables[0].Rows.Count];
//Class_Record_Monitor_View[] crmv = new Class_Record_Monitor_View[dataSet.Tables[0].Rows.Count];
if (dataSet.Tables["sqlSel"] != null)
{
Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlSel"].Rows.Count];
string section_name = string.Empty;
int no = 0;
for (int j = 0; j < dataSet.Tables["sqlSel"].Rows.Count; j++)
{
crmv1[j] = new Class_Record_Monitor_View();
string doctor_name = dataSet.Tables["sqlSel"].Rows[j]["sick_doctor_name"].ToString();
string sid = dataSet.Tables["sqlSel"].Rows[j]["section_id"].ToString();
string names = dataSet.Tables["sqlSel"].Rows[j]["section_name"].ToString();
Image red = img.Images[0];
Image yellow = img.Images[1];
Image bl = img.Images[3];
UserControl uc;
//Class_Record_Monitor_View crmv5 = new Class_Record_Monitor_View();
if (isBuLu)
{
int blNum = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["补录"].ToString());
uc = new UcLight(true, IsQualityAlert, doctor_name, blNum, bl, flag);
//uc = new UcLight(doctor_name, blNum, bl, "", true);
crmv1[j].Num = blNum;
crmv1[j].PV = 3;
}
else
{
int yelNum = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["黄灯"].ToString());
int redNum = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["红灯"].ToString());
uc = new UcMerger(true, IsQualityAlert, doctor_name, yelNum, yellow, redNum, red, flag);
}
crmv1[j].DocType = doctor_name;
crmv1[j].SickArea_ID = sid;
crmv1[j].SickArea_Name = names;
uc.Tag = crmv1[j];
if (section_name != crmv1[j].SickArea_Name)
{
if (!string.IsNullOrEmpty(crmv1[j].SickArea_Name))
{
section_name = crmv1[j].SickArea_Name;
Label lbl = new Label();
//lbl.AutoSize = true;//考虑到排版会不对称,取消自动宽度,变成固定宽度
no++;
lbl.Text = no.ToString() + "." + section_name;
lbl.Width = 120;
lbl.ForeColor = Color.Blue;
GbxMontior.Controls.Add(lbl);
}
}
GbxMontior.Controls.Add(uc);
}
//}
}
GbxMontior.Refresh();
if (dataSet.Tables["sqlCount"] != null)
{
Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlCount"].Rows.Count];
for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
{
crmv1[i] = new Class_Record_Monitor_View();
crmv1[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
crmv1[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
crmv1[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
if (comboxSA.Text != "" && !comboxSA.Text.Contains("请选择"))
{
crmv1[i].SickArea_ID = comboxSA.SelectedValue == null ? "" : comboxSA.SelectedValue.ToString();
crmv1[i].SickArea_Name = comboxSA.Text;
}
int onePv = crmv1[i].PV;
int oneNum = crmv1[i].Num;
string text = crmv1[i].DocType;
//取反条件
int intPv = onePv == 1 ? 0 : 1;
string swithcs = " DOCTYPE='" + crmv1[i].DocType + "' and PV='" + intPv + "'";
DataRow[] rows = dataSet.Tables["sqlCount"].Select(swithcs);
int otherPv = 0;
int otherNum = 0;
UserControl uc;
if (rows.Length > 0) //相同的文书
{
otherNum = Convert.ToInt32(rows[0]["NUM"].ToString());
otherPv = Convert.ToInt32(rows[0]["PV"].ToString());
dataSet.Tables["sqlCount"].Rows.Remove(rows[0]);
Image red = img.Images[0];
Image yellow = img.Images[1];
if (onePv == 0)//黄灯
{
uc = new UcMerger(IsQualityAlert, text, oneNum, yellow, otherNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
else
{
uc = new UcMerger(IsQualityAlert, text, otherNum, yellow, oneNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
}
else
{
Image image;
if (onePv == 3)//补录灯
{
image = img.Images[3];
}
else if (onePv == 0)//黄灯
{
image = img.Images[1];
}
else
{
image = img.Images[0];
}
uc = new UcLight(IsQualityAlert, text, oneNum, image, flag);
//uc = new PbLight(text, oneNum, img);
}
uc.Tag = crmv1[i];
pCount.Controls.Add(uc);
}
}
pCount.Refresh();
}
/// <summary>
/// 初始化数据--HLB
/// </summary>
//public void InitFlexGrid(ListView lstMontior,string sqlSel,ComboBox comboxSA,string flag,ListView lstCount,string sqlCount)
//{
// try
// {
// float x = 20;
// float y = 20;
// ArrayList tempList = new ArrayList();
// ImageList imaList = lstMontior.SmallImageList;
// ImageList imgState = lstMontior.StateImageList;
// //红灯
// Image img1 = imgState.Images[0];
// //黄灯
// Image img2 = imgState.Images[1];
// imaList.Images.Clear();
// //imaList.Images.Add(img1);
// //imaList.Images.Add(img2);
// //Image.GetThumbnailImageAbort imgAbort = new Image.GetThumbnailImageAbort(GetImg);
// //imaList.Images.Clear();
// //imaList.Images.Add(img1.GetThumbnailImage(100,20,imgAbort,IntPtr.Zero));
// //imaList.Images.Add(img2.GetThumbnailImage(100,20,imgAbort,IntPtr.Zero));
// //imaList.Images.Clear();
// Class_Table[] table = new Class_Table[2];
// table[0] = new Class_Table();
// table[0].Sql = sqlSel;
// table[0].Tablename = "sqlSel";
// table[1] = new Class_Table();
// table[1].Sql = sqlCount;
// table[1].Tablename = "sqlCount";
// DS_QUALITYTABLE = App.GetDataSet(table);
// DataSet dataSet = DS_QUALITYTABLE;
// ListViewItem[] item = new ListViewItem[dataSet.Tables[0].Rows.Count];
// Class_Record_Monitor_View[] crmv = new Class_Record_Monitor_View[dataSet.Tables[0].Rows.Count];
// if (dataSet.Tables["sqlSel"] != null)
// {
// if (flag == "HLB")
// {
// //加载病区组
// for (int i = 0; i < dataSet.Tables["sqlSel"].Rows.Count; i++)
// {
// if (!IsHaveGroup(dataSet.Tables["sqlSel"].Rows[i]["SICK_AREA_NAME"].ToString(), lstMontior))
// {
// ListViewGroup tempGroup = new ListViewGroup();
// tempGroup.Header = dataSet.Tables["sqlSel"].Rows[i]["SICK_AREA_NAME"].ToString();
// tempGroup.Name = dataSet.Tables["sqlSel"].Rows[i]["SICK_AREA_NAME"].ToString();
// //if (comboxSA.Text != tempGroup.Name)
// //{
// // ShowCommboBoxValue(comboxSA, tempGroup.Name);//病区名字
// //}
// lstMontior.Groups.Add(tempGroup);
// }
// }
// for (int i = 0; i < dataSet.Tables["sqlSel"].Rows.Count; i++)
// {
// crmv[i] = new Class_Record_Monitor_View();
// crmv[i].SickArea_ID = dataSet.Tables["sqlSel"].Rows[i]["SICK_AREA_ID"].ToString();
// crmv[i].SickArea_Name = dataSet.Tables["sqlSel"].Rows[i]["SICK_AREA_NAME"].ToString();
// crmv[i].DocType = dataSet.Tables["sqlSel"].Rows[i]["DOCTYPE"].ToString();
// crmv[i].Num = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[i]["NUM"].ToString());
// crmv[i].PV = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[i]["PV"].ToString());
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv[i];
// tempItem.Name = crmv[i].DocType;
// tempItem.Text = crmv[i].DocType + "[" + crmv[i].Num.ToString() + "]";
// if (crmv[i].PV == 0)
// {
// tempItem.ImageIndex = 1;
// }
// else
// {
// tempItem.ImageIndex = 0;
// }
// tempItem.Group = lstMontior.Groups[crmv[i].SickArea_Name];
// lstMontior.Items.Add(tempItem);
// }
// ListViewGroup CountGroup = new ListViewGroup();
// CountGroup.Header = "统计列表";
// CountGroup.Name = "统计列表";
// lstCount.Groups.Add(CountGroup);
// if (dataSet.Tables["sqlCount"] != null)
// {
// for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
// {
// crmv[i] = new Class_Record_Monitor_View();
// crmv[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
// crmv[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
// crmv[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv[i];
// tempItem.Name = crmv[i].DocType;
// tempItem.Text = crmv[i].DocType + "[" + crmv[i].Num.ToString() + "]";
// if (crmv[i].PV == 0)
// {
// tempItem.ImageIndex = 1;
// }
// else
// {
// tempItem.ImageIndex = 0;
// }
// tempItem.Group = lstCount.Groups["统计列表"];
// lstCount.Items.Add(tempItem);
// }
// }
// }
// if (flag == "YWC")
// {
// //加载科室组
// for (int i = 0; i < dataSet.Tables["sqlSel"].Rows.Count; i++)
// {
// //!IsHaveGroup(dataSet.Tables["sqlSel"].Rows[i]["SECTION_NAME"].ToString(), lstMontior)
// if (lstMontior.Items.Count == 0)
// {
// ListViewGroup tempGroup = new ListViewGroup();
// tempGroup.Header = dataSet.Tables["sqlSel"].Rows[i]["SECTION_NAME"].ToString();
// tempGroup.Name = dataSet.Tables["sqlSel"].Rows[i]["SECTION_NAME"].ToString();
// //if (comboxSA.Text != tempGroup.Name)
// //{
// // ShowCommboBoxValue(comboxSA, tempGroup.Name);//病区名字
// //}
// lstMontior.Groups.Add(tempGroup);
// }
// }
// //string sql = "select doctype,count(*) as num from record_monitor_view_ywc group by doctype,section_id having count(*) > 1";
// //DataSet ds = App.GetDataSet(sql);
// for (int i = 0; i < dataSet.Tables["sqlSel"].Rows.Count; i++)
// {
// crmv[i] = new Class_Record_Monitor_View();
// crmv[i].SickArea_ID = dataSet.Tables["sqlSel"].Rows[i]["SECTION_ID"].ToString();
// crmv[i].SickArea_Name = dataSet.Tables["sqlSel"].Rows[i]["SECTION_NAME"].ToString();
// crmv[i].DocType = dataSet.Tables["sqlSel"].Rows[i]["DOCTYPE"].ToString();
// crmv[i].Num = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[i]["NUM"].ToString());
// crmv[i].PV = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[i]["PV"].ToString());
// int onePv = crmv[i].PV;
// int oneNum = crmv[i].Num;
// string text = crmv[i].DocType;
// //取反条件
// int intPv = onePv == 1 ? 0 : 1;
// string swithcs = "SECTION_ID='" + crmv[i].SickArea_ID + "' and DOCTYPE='" +
// crmv[i].DocType + "' and PV='"+intPv+"'";
// DataRow[] rows = dataSet.Tables["sqlSel"].Select(swithcs);
// int otherPv = 0;
// int otherNum = 0;
// if (rows.Length > 0) //相同的文书
// {
// //i++;
// //crmv[i] = new Class_Record_Monitor_View();
// //crmv[i].SickArea_ID = rows[0]["SECTION_ID"].ToString();
// //crmv[i].SickArea_Name = rows[0]["SECTION_NAME"].ToString();
// //crmv[i].DocType = rows[0]["DOCTYPE"].ToString();
// //crmv[i].Num =
// //crmv[i].PV =
// otherNum = Convert.ToInt32(rows[0]["NUM"].ToString());
// otherPv = Convert.ToInt32(rows[0]["PV"].ToString());
// dataSet.Tables["sqlSel"].Rows.Remove(rows[0]);
// }
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv[i];
// tempItem.Name = crmv[i].DocType;
// if (rows.Length > 0)
// {
// int imgIndex1 = onePv == 0 ? 1 : 0;
// int imgIndex2 = otherPv == 0 ? 1 : 0;
// Image img;
// if (imgIndex1 == 1)
// {
// img = CreateImage(oneNum, otherNum, img2, img1);
// }
// else
// {
// img = CreateImage(otherNum,oneNum , img1, img2);
// }
// imaList.Images.Add(tempItem.Name, img);
// tempItem.ImageKey = tempItem.Name;
// tempItem.Text = text;
// }
// else
// {
// // if (onePv == 0)
// // {
// // tempItem.StateImageIndex = 1;//黄灯
// // }
// // else
// // {
// // tempItem.StateImageIndex = 0;//红灯
// // }
// Image imgOne;
// if (onePv == 0)
// {
// imgOne = CreateImage(oneNum, img2);
// }
// else
// {
// imgOne = CreateImage(oneNum, img1);
// }
// imaList.Images.Add(tempItem.Name, imgOne);
// tempItem.ImageKey = tempItem.Name;
// tempItem.Text = text;
// //tempItem.Text = crmv[i].DocType + "[" + crmv[i].Num.ToString() + "]";
// }
// tempItem.Group = lstMontior.Groups[crmv[i].SickArea_Name];
// lstMontior.Items.Add(tempItem);
// }
// ListViewGroup CountGroup = new ListViewGroup();
// CountGroup.Header = "统计列表";
// CountGroup.Name = "统计列表";
// lstCount.Groups.Add(CountGroup);
// if (dataSet.Tables["sqlCount"] != null)
// {
// for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
// {
// crmv[i] = new Class_Record_Monitor_View();
// crmv[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
// crmv[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
// crmv[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv[i];
// tempItem.Name = crmv[i].DocType;
// tempItem.Text = crmv[i].DocType + "[" + crmv[i].Num.ToString() + "]";
// if (crmv[i].PV == 0)
// {
// tempItem.ImageIndex = 1;//黄灯
// }
// else
// {
// tempItem.ImageIndex = 0;//红灯
// }
// tempItem.Group = lstCount.Groups["统计列表"];
// lstCount.Items.Add(tempItem);
// }
// }
// }
// }
// }
// catch
// { }
//}
/// <summary>
/// 初始化数据--HLB
/// </summary>
//public void InitFlexGrid(Panel GbxMontior, string sqlSel, ComboBox comboxSA, string flag, ListView lstCount, string sqlCount)
//{
// GbxMontior.Controls.Clear();
// Class_Table[] table = new Class_Table[2];
// table[0] = new Class_Table();
// table[0].Sql = sqlSel;
// table[0].Tablename = "sqlSel";
// table[1] = new Class_Table();
// table[1].Sql = sqlCount;
// table[1].Tablename = "sqlCount";
// DS_QUALITYTABLE = App.GetDataSet(table);
// DataSet dataSet = DS_QUALITYTABLE;
// Class_Record_Monitor_View[] crmv=null;
// if (dataSet.Tables[0].Rows.Count > 0)
// {
// crmv = new Class_Record_Monitor_View[dataSet.Tables[0].Rows.Count];
// }
// else
// {
// return;
// }
// if (dataSet.Tables["sqlSel"] != null)
// {
// Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlSel"].Rows.Count];
// //using (Graphics gh = Graphics.FromHwnd(GbxMontior.Handle))
// //{
// string section_name = string.Empty;
// bool isLine = false;
// for (int j = 0; j < dataSet.Tables["sqlSel"].Rows.Count; j++)
// {
// crmv1[j] = new Class_Record_Monitor_View();
// crmv1[j].SickArea_ID = dataSet.Tables["sqlSel"].Rows[j]["SECTION_ID"].ToString();
// crmv1[j].SickArea_Name = dataSet.Tables["sqlSel"].Rows[j]["SECTION_NAME"].ToString();
// crmv1[j].DocType = dataSet.Tables["sqlSel"].Rows[j]["DOCTYPE"].ToString();
// crmv1[j].Num = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["NUM"].ToString());
// crmv1[j].PV = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["PV"].ToString());
// int onePv = crmv1[j].PV;
// int oneNum = crmv1[j].Num;
// string text = crmv1[j].DocType;
// //取反条件
// int intPv = onePv == 1 ? 0 : 1;
// string swithcs = "SECTION_ID='" + crmv1[j].SickArea_ID + "' and DOCTYPE='" +
// crmv1[j].DocType + "' and PV='" + intPv + "'";
// DataRow[] rows = dataSet.Tables["sqlSel"].Select(swithcs);
// int otherPv = 0;
// int otherNum = 0;
// UserControl uc;
// if (rows.Length > 0) //相同的文书
// {
// otherNum = Convert.ToInt32(rows[0]["NUM"].ToString());
// otherPv = Convert.ToInt32(rows[0]["PV"].ToString());
// dataSet.Tables["sqlSel"].Rows.Remove(rows[0]);
// Image red = lstCount.SmallImageList.Images[0];
// Image yellow = lstCount.SmallImageList.Images[1];
// if (onePv == 0)//黄灯
// {
// uc = new UcMerger(text, oneNum, yellow, otherNum, red, flag);
// //uc = new PbMerger(text, oneNum, yellow, otherNum, red);
// }
// else
// {
// uc = new UcMerger(text, otherNum, yellow, oneNum, red, flag);
// //uc = new PbMerger(text, oneNum, yellow, otherNum, red);
// }
// }
// else
// {
// Image img;
// if (onePv == 0)//黄灯
// {
// img = lstCount.SmallImageList.Images[1];
// }
// else
// {
// img = lstCount.SmallImageList.Images[0];
// }
// uc = new UcLight(text, oneNum, img, flag);
// //uc = new PbLight(text, oneNum, img);
// }
// uc.Tag = crmv1[j];
// if (section_name != crmv1[j].SickArea_Name)
// {
// if (!string.IsNullOrEmpty(crmv1[j].SickArea_Name))
// {
// section_name = crmv1[j].SickArea_Name;
// Label lbl = new Label();
// lbl.Text = section_name;
// lbl.ForeColor = Color.Blue;
// GbxMontior.Controls.Add(lbl);
// //AddUcontrol(GbxMontior, uc, section_name);
// }
// }
// else
// {
// //AddUcontrol(GbxMontior, uc);
// }
// GbxMontior.Controls.Add(uc);
// }
// //}
// }
// GbxMontior.Refresh();
// ListViewGroup CountGroup = new ListViewGroup();
// CountGroup.Header = "统计列表";
// CountGroup.Name = "统计列表";
// lstCount.Groups.Add(CountGroup);
// if (dataSet.Tables["sqlCount"] != null)
// {
// Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlCount"].Rows.Count];
// for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
// {
// crmv1[i] = new Class_Record_Monitor_View();
// crmv1[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
// crmv1[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
// crmv1[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
// ListViewItem tempItem = new ListViewItem();
// tempItem.Tag = crmv1[i];
// tempItem.Name = crmv1[i].DocType;
// tempItem.Text = crmv1[i].DocType + "[" + crmv1[i].Num.ToString() + "]";
// if (crmv1[i].PV == 0)
// {
// tempItem.ImageIndex = 1;//黄灯
// }
// else
// {
// tempItem.ImageIndex = 0;//红灯
// }
// tempItem.Group = lstCount.Groups["统计列表"];
// lstCount.Items.Add(tempItem);
// }
// }
//}
#endregion
/// <summary>
/// 质控监控界面-初始化数据
/// </summary>
/// <param name="GbxMontior"></param>
/// <param name="sqlSel"></param>
/// <param name="comboxSA"></param>
/// <param name="flag"></param>
/// <param name="pCount"></param>
/// <param name="sqlCount"></param>
/// <param name="img"></param>
public void InitFlexGrid(Panel GbxMontior, string sqlSel, ComboBox comboxSA, string flag, Panel pCount, string sqlCount, ImageList img)
{
GbxMontior.Controls.Clear();
pCount.Controls.Clear();
Class_Table[] table = new Class_Table[2];
table[0] = new Class_Table();
table[0].Sql = sqlSel;
table[0].Tablename = "sqlSel";
table[1] = new Class_Table();
table[1].Sql = sqlCount;
table[1].Tablename = "sqlCount";
DS_QUALITYTABLE = App.GetDataSet(table);
DataSet dataSet = DS_QUALITYTABLE;
Class_Record_Monitor_View[] crmv = null;
if (dataSet.Tables[0].Rows.Count > 0)
{
crmv = new Class_Record_Monitor_View[dataSet.Tables[0].Rows.Count];
}
else
{
return;
}
if (dataSet.Tables["sqlSel"] != null)
{
Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlSel"].Rows.Count];
//using (Graphics gh = Graphics.FromHwnd(GbxMontior.Handle))
//{
string section_name = string.Empty;
int no = 0;
bool isLine = false;
for (int j = 0; j < dataSet.Tables["sqlSel"].Rows.Count; j++)
{
crmv1[j] = new Class_Record_Monitor_View();
crmv1[j].SickArea_ID = dataSet.Tables["sqlSel"].Rows[j]["SECTION_ID"].ToString();
crmv1[j].SickArea_Name = dataSet.Tables["sqlSel"].Rows[j]["SECTION_NAME"].ToString();
crmv1[j].DocType = dataSet.Tables["sqlSel"].Rows[j]["DOCTYPE"].ToString();
crmv1[j].Num = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["NUM"].ToString());
crmv1[j].PV = Convert.ToInt32(dataSet.Tables["sqlSel"].Rows[j]["PV"].ToString());
if (crmv1[j].DocType == "体温单" || crmv1[j].DocType == "体温单其他") //'体温单','体温单其他'
{ //找出所有对应的规则id
crmv1[j].DocTypeID = App.ReadSqlVal("select wm_concat(tqv.id) id from t_quality_var_hlb tqv inner join t_data_code ta on tqv.document_type=ta.id where ta.name='" + crmv1[j].DocType + "'", 0, "id");
}
int onePv = crmv1[j].PV;
int oneNum = crmv1[j].Num;
string text = crmv1[j].DocType;
//取反条件
int intPv = onePv == 1 ? 0 : 1;
string swithcs = "SECTION_ID='" + crmv1[j].SickArea_ID + "' and DOCTYPE='" +
crmv1[j].DocType + "' and PV='" + intPv + "'";
DataRow[] rows = dataSet.Tables["sqlSel"].Select(swithcs);
int otherPv = 0;
int otherNum = 0;
UserControl uc;
if (rows.Length > 0) //相同的文书
{
otherNum = Convert.ToInt32(rows[0]["NUM"].ToString());
otherPv = Convert.ToInt32(rows[0]["PV"].ToString());
dataSet.Tables["sqlSel"].Rows.Remove(rows[0]);
Image red = img.Images[0];
Image yellow = img.Images[1];
if (onePv == 0)//黄灯
{
uc = new UcMerger(text, oneNum, yellow, otherNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
else
{
uc = new UcMerger(text, otherNum, yellow, oneNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
}
else
{
Image image;
if (onePv == 3)
{
image = img.Images[3]; //补录
}
else if (onePv == 0) //黄灯
{
image = img.Images[1];
}
else
{
image = img.Images[0];
}
uc = new UcLight(text, oneNum, image, flag);
//uc = new PbLight(text, oneNum, img);
}
uc.Tag = crmv1[j];
if (section_name != crmv1[j].SickArea_Name)
{
if (!string.IsNullOrEmpty(crmv1[j].SickArea_Name))
{
section_name = crmv1[j].SickArea_Name;
Label lbl = new Label();
//lbl.AutoSize = true;
no++;
lbl.Text = no.ToString() + "." + section_name;
lbl.Width = 120;
lbl.ForeColor = Color.Blue;
GbxMontior.Controls.Add(lbl);
//AddUcontrol(GbxMontior, uc, section_name);
}
}
else
{
//AddUcontrol(GbxMontior, uc);
}
GbxMontior.Controls.Add(uc);
}
//}
}
GbxMontior.Refresh();
if (dataSet.Tables["sqlCount"] != null)
{
Class_Record_Monitor_View[] crmv1 = new Class_Record_Monitor_View[dataSet.Tables["sqlCount"].Rows.Count];
for (int i = 0; i < dataSet.Tables["sqlCount"].Rows.Count; i++)
{
crmv1[i] = new Class_Record_Monitor_View();
crmv1[i].DocType = dataSet.Tables["sqlCount"].Rows[i]["DOCTYPE"].ToString();
crmv1[i].Num = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["NUM"].ToString());
crmv1[i].PV = Convert.ToInt32(dataSet.Tables["sqlCount"].Rows[i]["PV"].ToString());
if (comboxSA.Text != "" && !comboxSA.Text.Contains("请选择"))
{
crmv1[i].SickArea_ID = comboxSA.SelectedValue == null ? "" : comboxSA.SelectedValue.ToString();
crmv1[i].SickArea_Name = comboxSA.Text;
}
if (crmv1[i].DocType == "体温单" || crmv1[i].DocType == "体温单其他") //'体温单','体温单其他'
{ //找出所有对应的规则id
crmv1[i].DocTypeID = App.ReadSqlVal("select wm_concat(tqv.id) id from t_quality_var_hlb tqv inner join t_data_code ta on tqv.document_type=ta.id where ta.name='" + crmv1[i].DocType + "'", 0, "id");
}
int onePv = crmv1[i].PV;
int oneNum = crmv1[i].Num;
string text = crmv1[i].DocType;
//取反条件
int intPv = onePv == 1 ? 0 : 1;
string swithcs = " DOCTYPE='" + crmv1[i].DocType + "' and PV='" + intPv + "'";
DataRow[] rows = dataSet.Tables["sqlCount"].Select(swithcs);
int otherPv = 0;
int otherNum = 0;
UserControl uc;
if (rows.Length > 0) //相同的文书
{
otherNum = Convert.ToInt32(rows[0]["NUM"].ToString());
otherPv = Convert.ToInt32(rows[0]["PV"].ToString());
dataSet.Tables["sqlCount"].Rows.Remove(rows[0]);
Image red = img.Images[0];
Image yellow = img.Images[1];
if (onePv == 0)//黄灯
{
uc = new UcMerger(text, oneNum, yellow, otherNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
else
{
uc = new UcMerger(text, otherNum, yellow, oneNum, red, flag);
//uc = new PbMerger(text, oneNum, yellow, otherNum, red);
}
}
else
{
Image image;
if (onePv == 3)//补录
{
image = img.Images[3];
}
else if (onePv == 0)//黄灯
{
image = img.Images[1];
}
else
{
image = img.Images[0];
}
uc = new UcLight(text, oneNum, image, flag);
//uc = new PbLight(text, oneNum, img);
}
uc.Tag = crmv1[i];
pCount.Controls.Add(uc);
}
}
pCount.Refresh();
}
