private SortedList GetProcedures()
{
CnasRemotCall RemoteClient = new CnasRemotCall();
SortedList procedures = new SortedList();
DataTable data = RemoteClient.RemotInterface.SelectData("HCS-procedure-sec002", null);
if (data != null)
{
for (int i = 0; i < data.Rows.Count; i++)
{
Dictionary <string, string> item = new Dictionary <string, string>();
DataRow row = data.Rows[i] as DataRow;
if (row["id"] != null)
{
item.Add("id", row["id"].ToString());
}
if (row["pd_code"] != null)
{
item.Add("pd_code", row["pd_code"].ToString());
}
if (row["pd_bcode"] != null)
{
item.Add("pd_bcode", row["pd_bcode"].ToString());
}
if (row["pd_name"] != null)
{
item.Add("pd_name", row["pd_name"].ToString());
}
if (row["pd_scan"] != null)
{
item.Add("pd_scan", row["pd_scan"].ToString());
}
if (row["pd_description"] != null)
{
item.Add("pd_description", row["pd_description"].ToString());
}
if (row["pd_Type"] != null)
{
item.Add("pd_Type", row["pd_Type"].ToString());
}
if (row["state"] != null)
{
item.Add("state", row["state"].ToString());
}
if (row["split_count"] != null)
{
item.Add("split_count", row["split_count"].ToString());
}
if (row["cyc_location"] != null)
{
item.Add("cyc_location", row["cyc_location"].ToString());
}
if (row["si_id"] != null)
{
item.Add("si_id", row["si_id"].ToString());
}
procedures.Add(i, item);
}
}
return(procedures);
}
/// <summary>
/// 读取数据
/// </summary>
private void Loaddata()
{
dgv_01.Rows.Clear();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, CnasBaseData.SystemID);
string sterilizer = reCnasRemotCall.RemotInterface.CheckSelectData("hcs-sterilizer-device-sec001", sttemp01);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("hcs-sterilizer-device-sec001", sttemp01);
if (getdt != null && getdt.Rows.Count > 0)
{
int ii = getdt.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (getdt.Rows[i]["id"] != null)
{
dgv_01.Rows[i].Cells["id"].Value = getdt.Rows[i]["id"].ToString();
}
if (getdt.Rows[i]["bar_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = getdt.Rows[i]["bar_code"].ToString();
}
if (getdt.Rows[i]["ca_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = getdt.Rows[i]["ca_name"].ToString();
}
if (getdt.Rows[i]["ca_model"] != null)
{
dgv_01.Rows[i].Cells["ca_model"].Value = getdt.Rows[i]["ca_model"].ToString();
}
if (getdt.Rows[i]["run_times"] != null)
{
dgv_01.Rows[i].Cells["run_times"].Value = getdt.Rows[i]["run_times"].ToString();
}
if (getdt.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = getdt.Rows[i]["cre_date"].ToString();
}
if (getdt.Rows[i]["mod_date"] != null)
{
dgv_01.Rows[i].Cells["mod_date"].Value = getdt.Rows[i]["mod_date"].ToString();
}
if (getdt.Columns.Contains("price") && getdt.Rows[i]["price"] != null && !string.IsNullOrEmpty(getdt.Rows[i]["price"].ToString()))
{
dgv_01.Rows[i].Cells["price"].Value = Convert.ToDouble(getdt.Rows[i]["price"].ToString()).ToString("C");
}
if (getdt.Rows[i]["ca_remarks"] != null)
{
dgv_01.Rows[i].Cells["ca_remarks"].Value = getdt.Rows[i]["ca_remarks"].ToString();
}
if (getdt.Rows[i]["ca_vender"] != null)
{
if (!string.IsNullOrEmpty(getdt.Rows[i]["ca_vender"].ToString()))
{
dgv_01.Rows[i].Cells["ca_vender"].Value = sl_VenderType[getdt.Rows[i]["ca_vender"].ToString()].ToString();
}
}
if (getdt.Rows[i]["sales_id"] != null)
{
dgv_01.Rows[i].Cells["sales_id"].Value = sl_SalesType[getdt.Rows[i]["sales_id"].ToString()].ToString();
}
if (getdt.Rows[i]["bd_test_time"] != null)
{
dgv_01.Rows[i].Cells["bd_test_time"].Value = getdt.Rows[i]["bd_test_time"].ToString();
}
if (getdt.Rows[i]["if_bdtest"] != null)
{
dgv_01.Rows[i].Cells["if_bdtest"].Value = (getdt.Rows[i]["if_bdtest"].ToString() == "1") ? "需要" : "不需要";
}
if (getdt.Rows[i]["std_stu"] != null)
{
dgv_01.Rows[i].Cells["std_stu"].Value = getdt.Rows[i]["std_stu"].ToString();
}
if (getdt.Rows[i]["min_stu"] != null)
{
dgv_01.Rows[i].Cells["min_stu"].Value = getdt.Rows[i]["min_stu"].ToString();
}
if (getdt.Rows[i]["max_stu"] != null)
{
dgv_01.Rows[i].Cells["max_stu"].Value = getdt.Rows[i]["max_stu"].ToString();
}
}
dgv_01.CurrentRow = dgv_01.Rows[0];
}
}
public List <Dictionary <string, string> > GetPdOperations(string pdCode)
{
List <Dictionary <string, string> > operations = new List <Dictionary <string, string> >();
CnasRemotCall RemoteClient = new CnasRemotCall();
SortedList condition = new SortedList();
condition.Add(1, pdCode);
string sqlTest = RemoteClient.RemotInterface.CheckSelectData("HCS-ca-operation-sec001", condition);
DataTable data = RemoteClient.RemotInterface.SelectData("HCS-ca-operation-sec001", condition);
if (data != null)
{
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow row = data.Rows[i] as DataRow;
Dictionary <string, string> operation = new Dictionary <string, string>();
if (row["id"] != null)
{
operation.Add("id", row["id"].ToString());
}
if (row["op_name"] != null)
{
operation.Add("op_name", row["op_name"].ToString());
}
if (row["op_brietcode"] != null)
{
operation.Add("op_brietcode", row["op_brietcode"].ToString());
}
if (row["function_name"] != null)
{
operation.Add("function_name", row["function_name"].ToString());
}
if (row["state"] != null)
{
operation.Add("state", row["state"].ToString());
}
if (row["op_ico"] != null)
{
operation.Add("op_ico", row["op_ico"].ToString());
}
if (row["sort_id"] != null)
{
operation.Add("sort_id", row["sort_id"].ToString());
}
if (row["op_barCode"] != null)
{
operation.Add("op_barCode", row["op_barCode"].ToString());
}
if (row["is_contextmenu"] != null)
{
operation.Add("is_contextmenu", row["is_contextmenu"].ToString());
}
if (row["op_objectType"] != null)
{
operation.Add("op_objectType", row["op_objectType"].ToString());
}
operations.Add(operation);
//buttonGroup.Items.Add(operation);
}
}
return(operations);
}
private void rBut_ok_Click(object sender, EventArgs e)
{
DataSet set = new DataSet();
DataTable windowsXPTable = new DataTable("WindowsXP"); //新建一个柱型来显示数据
DataTable windows7Table = new DataTable("Windows7"); //新建一个柱型来显示数据
set.Tables.Clear(); //清除一个柱型的数据
windowsXPTable.Rows.Clear(); //清除柱型数据
windows7Table.Rows.Clear(); //清除柱型数据
radChartView1.Series.Clear(); //清除数据柱型图数据
set.Tables.Add(windowsXPTable); //给柱型添加数据
set.Tables.Add(windows7Table); //给柱型添加数据
foreach (DataTable table in set.Tables) //循环给每条柱型添加数据
{
table.Columns.Add("Month"); //表示柱型下面的数据
table.Columns.Add("Usage", typeof(double)); //给每条柱型添加数值
// table.Columns.Add("Usage1", typeof(double));
}
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
int yearInt = int.Parse(cb_year.Text); //讲年份转化成int类型
SortedList bb = new SortedList(); // 给存储过程传值的集合
bb.Add("firstTime", new DateTime(yearInt - 1, 1, 1)); //时间
DataSet result = reCnasRemotCall.RemotInterface.ExecuteProcedure("secondsend", bb); //根据时间，类型查询返回所需要的数据
if (result != null && result.Tables != null && result.Tables.Count > 0)
{
int selectYearTotal = 0;
int beforeYearTotal = 0;
DataTable table = result.Tables[0];
for (int i = 0; i < 2; i++)//用于判断是哪一年的
{
int calYear = i == 0 ? yearInt : yearInt - 1;
//j表示哪一月
for (int j = 1; j < 13; j++)
{
string calMonth = calYear.ToString() + j.ToString().PadLeft(2, '0');
DataRow rowData = null;
if (table.Rows != null)
{
foreach (DataRow row in table.Rows)
{
if (row["calMonth"] != null && row["calMonth"].ToString() == calMonth)
{
rowData = row;
break;
}
}
}
if (rowData == null)
{
if (calYear.ToString() == cb_year.Text && j.ToString() == cb_month.Text)
{
c1RG7.Value = 0;
}
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
else
{
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
}
else
{
double calResult = rowData["result"] is DBNull ? 0 : Convert.ToDouble(rowData["result"]);
if (calYear.ToString() == cb_year.Text && j.ToString() == cb_month.Text)
{
c1RG7.Value = calResult;
}
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), calResult);
selectYearTotal += rowData["ccount"] is DBNull ? 0 : int.Parse(rowData["ccount"].ToString());
}
else
{
beforeYearTotal += rowData["ccount"] is DBNull ? 0 : int.Parse(rowData["ccount"].ToString());
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), calResult);
}
}
}
RefreshDataGrid(table);
}
currentYearTxt.Text = selectYearTotal.ToString();
lastyeartet.Text = beforeYearTotal.ToString();
radLabel3.Text = beforeYearTotal == selectYearTotal ? "平稳" : (beforeYearTotal > selectYearTotal) ? "下降" : "上升";
}
this.radChartView1.DataSource = set;
BarSeries windowsXPSeries = new BarSeries("Usage", "Month");
windowsXPSeries.DataMember = "WindowsXP";
windowsXPSeries.LegendTitle = "Windows XP";
BarSeries windows7Series = new BarSeries("Usage", "Month");
windows7Series.DataMember = "Windows7";
windows7Series.LegendTitle = "Windows 7";
windowsXPSeries.ShowLabels = true;
windows7Series.ShowLabels = true;
this.radChartView1.Series.AddRange(windowsXPSeries, windows7Series);
}
private void load_pdpar()
{
dgv_04.Rows.Clear();
dgv_05.Rows.Clear();
cb_par.Items.Clear();
//sl_PCdata.Clear();
string strappid = str_prid;
SortedList sttemp02 = new SortedList();
//sttemp02.Add(1, strappid);
sttemp02.Add(1, CnasBaseData.SystemID);
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
DataTable dt01 = reCnasRemotCall.RemotInterface.SelectData("HCS-pdbasepar-sec01", sttemp02);
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, strappid);
DataTable dt02 = reCnasRemotCall.RemotInterface.SelectData("HCS-pdpar-sec01", sttemp01);
if (dt01 != null)
{
string secid = "";
for (int i = 0; i < dt01.Rows.Count; i++)
{
secid = dt01.Rows[i]["id"].ToString();
dgv_04.RowCount++;
//int ii = dgv_04.RowCount - 1;
dgv_04.Rows[i].Cells[0].Value = false;
if (dt01.Rows[i]["id"] != null)
{
dgv_04.Rows[i].Cells["id04"].Value = dt01.Rows[i]["id"].ToString();
}
if (dt01.Rows[i]["pd_id"] != null)
{
dgv_04.Rows[i].Cells["pd_id04"].Value = dt01.Rows[i]["pd_id"].ToString();
}
if (dt01.Rows[i]["par_code"] != null)
{
dgv_04.Rows[i].Cells["par_code04"].Value = dt01.Rows[i]["par_code"].ToString();
}
if (dt01.Rows[i]["par_name"] != null)
{
dgv_04.Rows[i].Cells["par_name04"].Value = dt01.Rows[i]["par_name"].ToString();
}
if (dt01.Rows[i]["par_def_value"] != null)
{
dgv_04.Rows[i].Cells["par_def_value04"].Value = dt01.Rows[i]["par_def_value"].ToString();
}
if (dt01.Rows[i]["par_type"] != null)
{
dgv_04.Rows[i].Cells["par_type04"].Value = dt01.Rows[i]["par_type"].ToString();
}
if (dt01.Rows[i]["par_description"] != null)
{
dgv_04.Rows[i].Cells["par_description04"].Value = dt01.Rows[i]["par_description"].ToString();
}
if (dt02 != null)
{
DataRow[] arrayDR01 = dt02.Select("par_id=" + secid);
if (arrayDR01.Length > 0)
{
dgv_04.Rows[i].Cells["isselected4"].Value = true;
dgv_05.RowCount++;
int ii = dgv_05.RowCount - 1;
if (dt01.Rows[i]["id"] != null)
{
dgv_05.Rows[ii].Cells["id05"].Value = dt01.Rows[i]["id"].ToString();
}
if (dt01.Rows[i]["pd_id"] != null)
{
dgv_05.Rows[ii].Cells["pd_id05"].Value = dt01.Rows[i]["pd_id"].ToString();
}
if (dt01.Rows[i]["par_code"] != null)
{
dgv_05.Rows[ii].Cells["par_code05"].Value = dt01.Rows[i]["par_code"].ToString();
}
if (dt01.Rows[i]["par_name"] != null)
{
dgv_05.Rows[ii].Cells["par_name05"].Value = dt01.Rows[i]["par_name"].ToString();
}
if (dt01.Rows[i]["par_def_value"] != null)
{
dgv_05.Rows[ii].Cells["par_def_value05"].Value = dt01.Rows[i]["par_def_value"].ToString();
}
if (dt01.Rows[i]["par_type"] != null)
{
dgv_05.Rows[ii].Cells["par_type05"].Value = dt01.Rows[i]["par_type"].ToString();
}
if (dt01.Rows[i]["par_description"] != null)
{
dgv_05.Rows[ii].Cells["par_description05"].Value = dt01.Rows[i]["par_description"].ToString();
}
if (arrayDR01[0]["par_priority"] != null)
{
dgv_05.Rows[ii].Cells["par_priority05"].Value = arrayDR01[0]["par_priority"].ToString();
}
else
{
dgv_05.Rows[ii].Cells["par_priority05"].Value = "";
}
string strkey_code = dt01.Rows[i]["par_name"].ToString();
string strvalue_code = dt01.Rows[i]["par_description"].ToString();
//sl_PCdata.Add(strkey_code, strvalue_code);
cb_par.Items.Add(strvalue_code + "：" + strkey_code);
}
}
}
}
if (dgv_05.RowCount > 0)
{
tb_26.Text = dgv_05.Rows[0].Cells["id05"].Value.ToString();
}
this.loadparvalue();
but_01.Enabled = true;
}
private void rBut_ok_Click(object sender, EventArgs e)
{
//c1RG6.Value = 0;
DataSet set = new DataSet();
DataTable windowsXPTable = new DataTable("WindowsXP");
DataTable windows7Table = new DataTable("Windows7");
set.Tables.Clear();
windowsXPTable.Rows.Clear();
windows7Table.Rows.Clear();
radChartView1.Series.Clear();
set.Tables.Add(windowsXPTable);
set.Tables.Add(windows7Table);
foreach (DataTable table in set.Tables)
{
table.Columns.Add("Month");
table.Columns.Add("Usage", typeof(double));
// table.Columns.Add("Usage1", typeof(double));
}
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
int yearInt = int.Parse(cb_year.Text);
SortedList bb = new SortedList();
DataSet result = null;
bb.Add("time", new DateTime(yearInt - 1, 1, 1));
if (N_type == "207")//湿包项
{
bb.Add("norm1", "208");
bb.Add("norm", N_type);
result = reCnasRemotCall.RemotInterface.ExecuteProcedure("total_average1", bb);
}
else if (N_type == "301")//灭菌失败项
{
bb.Add("norm1", "302");
bb.Add("norm2", "303");
bb.Add("norm", N_type);
result = reCnasRemotCall.RemotInterface.ExecuteProcedure("total_average2", bb);
}
else
{
bb.Add("norm", N_type);
result = reCnasRemotCall.RemotInterface.ExecuteProcedure("total_average", bb);
}
if (result != null && result.Tables != null && result.Tables.Count > 0)
{
int selectYearTotal = 0;
int beforeYearTotal = 0;
DataTable table = result.Tables[0];
for (int i = 0; i < 2; i++)
{
int calYear = i == 0 ? yearInt : yearInt - 1;
for (int j = 1; j < 13; j++)
{
string calMonth = calYear.ToString() + j.ToString().PadLeft(2, '0');
DataRow rowData = null;
if (table.Rows != null)
{
foreach (DataRow row in table.Rows)
{
if (row["calMonth"] != null && row["calMonth"].ToString() == calMonth)
{
rowData = row;
break;
}
}
}
if (rowData == null)
{
if (calYear.ToString() == cb_year.Text && j.ToString() == DateTime.Now.Month.ToString())
{
c1RG.Value = 0;
}
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
else
{
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
}
else
{
double calResult = rowData["total"] is DBNull ? 0 : Convert.ToDouble(rowData["total"]);
if (calYear.ToString() == cb_year.Text && j.ToString() == DateTime.Now.Month.ToString())
{
c1RG.Value = calResult;
}
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), calResult);
selectYearTotal += rowData["total"] is DBNull ? 0 : int.Parse(rowData["total"].ToString());
}
else
{
beforeYearTotal += rowData["total"] is DBNull ? 0 : int.Parse(rowData["total"].ToString());
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), calResult);
}
}
}
}
RefreshDataGrid(table);
if (cb_year.Text == DateTime.Now.Year.ToString())//只显示今年和去年的数据
{
currentYearTxt.Text = selectYearTotal.ToString();
lastyeartet.Text = beforeYearTotal.ToString();
radLabel3.Text = beforeYearTotal == selectYearTotal ? "平稳" : (beforeYearTotal > selectYearTotal) ? "下降" : "上升";
}
}
this.radChartView1.DataSource = set;
BarSeries windowsXPSeries = new BarSeries("Usage", "Month");
windowsXPSeries.DataMember = "WindowsXP";
windowsXPSeries.LegendTitle = "Windows XP";
BarSeries windows7Series = new BarSeries("Usage", "Month");
windows7Series.DataMember = "Windows7";
windows7Series.LegendTitle = "Windows 7";
windowsXPSeries.ShowLabels = true;
windows7Series.ShowLabels = true;
this.radChartView1.Series.AddRange(windowsXPSeries, windows7Series);
}
private void select_pd(string inpdid)
{
dgv_02.Rows.Clear();
dgv_03.Rows.Clear();
#region 获取流程允许扫描码
DataRow[] arrayDRsecpd = dtall.Select("pd_code=" + inpdid);
tb_pdscan.Text = arrayDRsecpd[0]["pd_scan"].ToString();
#endregion
PD_codeData = inpdid;
#region 获取已经配置好流程数据
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, inpdid);
dtselect = reCnasRemotCall.RemotInterface.SelectData("HCS-procedure_relation-sec001", sttemp01);
if (dtall != null)
{
if (dtselect == null)
{
for (int i = 0; i < dtall.Rows.Count; i++)
{
string str_id = "", str_name = "";
if (dtall.Rows[i]["pd_code"] != null)
{
str_id = dtall.Rows[i]["pd_code"].ToString();
}
if (dtall.Rows[i]["pd_name"] != null)
{
str_name = dtall.Rows[i]["pd_name"].ToString();
}
DataGridViewRow drtemp01 = new DataGridViewRow();
drtemp01.Cells.Add(new DataGridViewCheckBoxCell()); //选择
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //id
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //名称
drtemp01.SetValues(false, str_id, str_name);
dgv_02.Rows.Add(drtemp01);
}
}
else
{
for (int i = 0; i < dtall.Rows.Count; i++)
{
string str_id = "", str_name = "", str_priority = "0", str_condition = "";
if (dtall.Rows[i]["pd_code"] != null)
{
str_id = dtall.Rows[i]["pd_code"].ToString();
}
if (dtall.Rows[i]["pd_name"] != null)
{
str_name = dtall.Rows[i]["pd_name"].ToString();
}
DataRow[] arrayDRsec = dtselect.Select("next_pdcode=" + str_id);
DataGridViewRow drtemp01 = new DataGridViewRow();
drtemp01.Cells.Add(new DataGridViewCheckBoxCell()); //选择
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //id
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //名称
if (arrayDRsec.Length == 0)
{
drtemp01.SetValues(false, str_id, str_name);
}
else
{
drtemp01.SetValues(true, str_id, str_name);
if (arrayDRsec[0]["pr_priority"] != null)
{
str_priority = arrayDRsec[0]["pr_priority"].ToString();
}
if (arrayDRsec[0]["pr_condition"] != null)
{
str_condition = arrayDRsec[0]["pr_condition"].ToString();
}
DataGridViewRow drtemp02 = new DataGridViewRow();
drtemp02.Cells.Add(new DataGridViewTextBoxCell());
drtemp02.Cells.Add(new DataGridViewTextBoxCell());
drtemp02.Cells.Add(new DataGridViewTextBoxCell());
drtemp02.Cells.Add(new DataGridViewTextBoxCell());
drtemp02.SetValues(str_id, str_name, str_priority, str_condition);
dgv_03.Rows.Add(drtemp02);
}
dgv_02.Rows.Add(drtemp01);
}
dgv_03.Sort(dgv_03.Columns["pr_priority"], ListSortDirection.Ascending);
}
}
SortedList sttemp02 = new SortedList();
sttemp02.Add(1, inpdid);
//string testConfigSql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-pdparametervalue-sec04", sttemp01);
dtpartvalueconfig = reCnasRemotCall.RemotInterface.SelectData("HCS-pdparametervalue-sec04", sttemp02);
#endregion
#region 获取允许配置的参数
cb_par.Items.Clear();
cb_value.Items.Clear();
SortedList sttemp05 = new SortedList();
sttemp05.Add(1, inpdid);
sttemp05.Add(2, 9);
DataTable dt01 = reCnasRemotCall.RemotInterface.SelectData("HCS-pdparameter-sec03", sttemp05);
if (dt01 != null)
{
for (int i = 0; i < dt01.Rows.Count; i++)
{
string strpar_code = dt01.Rows[i]["par_code"].ToString();
string strkey_code = dt01.Rows[i]["par_name"].ToString();
string strvalue_code = dt01.Rows[i]["par_description"].ToString();
cb_par.Items.Add(strvalue_code + "：" + strkey_code + "：" + strpar_code);
}
}
#endregion
}
public HCSSM_user_group_app(string str_groupid, string str_gpname, string str_gptype)
{
InitializeComponent();
this.but_addall.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "allRight", EnumImageType.PNG);
this.but_addone.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "rightShift", EnumImageType.PNG);
this.but_reall.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "allLeft", EnumImageType.PNG);
this.but_reaone.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "leftShift", EnumImageType.PNG);
this.but_save.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "savePicture", EnumImageType.PNG);
//this.Font = new Font(this.Font.FontFamily, 11);
this.Text = ConfigurationManager.AppSettings["SystemName"].ToString() + "--配置群组";
Icon = new Icon(ResourcesImageHelper.Instance.GetResourcesStream("Common.icon", "MainIco", EnumImageType.ICO));
Strgroupid = str_groupid;
this.Text = this.Text + " " + str_gptype + "->" + str_gpname;
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, CnasBaseData.SystemID);
string a = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-app-sec001", sttemp01);
dtappall = reCnasRemotCall.RemotInterface.SelectData("HCS-app-sec001", sttemp01);
SortedList sttemp02 = new SortedList();
sttemp02.Add(1, str_groupid);
string b = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-usergroup_app-sec001", sttemp01);
dtgpappall = reCnasRemotCall.RemotInterface.SelectData("HCS-usergroup_app-sec001", sttemp02);
if (dtappall != null)
{
DataRow[] arrayDR = dtappall.Select("app_type=1");
if (dtgpappall == null)//无配置文件，全部放到dvg_01
{
foreach (DataRow dr in arrayDR)
{
string str_id = "", str_app_name = "", str_app_briefcode = "";
if (dtappall.Columns.Contains("id") && dr["id"] != null)
{
str_id = dr["id"].ToString();
}
if (dtappall.Columns.Contains("app_name") && dr["app_name"] != null)
{
str_app_name = dr["app_name"].ToString();
}
if (dtappall.Columns.Contains("app_briefcode") && dr["app_briefcode"] != null)
{
str_app_briefcode = dr["app_briefcode"].ToString();
}
GridViewRowInfo drtemp01 = null;
//drtemp01.Cells.Add(new DataGridViewCheckBoxCell());//选择
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//编码
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//简码
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//名字
//drtemp01.SetValues(false, str_id, str_app_briefcode, str_app_name);
//dgv_01.Rows.Add(drtemp01);
drtemp01 = dgv_01.Rows.AddNew();
sl_allapp.Add(str_id, str_app_name);
if (drtemp01 != null)
{
drtemp01.Cells[0].Value = false;
drtemp01.Cells[1].Value = str_id;
drtemp01.Cells[2].Value = str_app_briefcode;
drtemp01.Cells[3].Value = str_app_name;
}
drtemp01.Tag = dr;
}
}
else
{
foreach (DataRow dr in arrayDR)
{
string str_id = "", str_app_name = "", str_app_briefcode = "";
if (dtappall.Columns.Contains("id") && dr["id"] != null)
{
str_id = dr["id"].ToString();
}
if (dtappall.Columns.Contains("app_name") && dr["app_name"] != null)
{
str_app_name = dr["app_name"].ToString();
}
if (dtappall.Columns.Contains("app_briefcode") && dr["app_briefcode"] != null)
{
str_app_briefcode = dr["app_briefcode"].ToString();
}
GridViewRowInfo drtemp01 = null;
//drtemp01.Cells.Add(new DataGridViewCheckBoxCell());//选择
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//编码
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//简码
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//名字
//drtemp01.SetValues(false, str_id, str_app_briefcode, str_app_name);
DataRow[] arrayDRsec = dtgpappall.Select("app_id=" + str_id);
if (arrayDRsec.Length > 0)
{
//dgv_02.Rows.Add(drtemp01);
drtemp01 = dgv_02.Rows.AddNew();
sl_gpapp.Add(str_id, str_app_name);
}
else
{
drtemp01 = dgv_01.Rows.AddNew();
sl_allapp.Add(str_id, str_app_name);
}
if (drtemp01 != null)
{
drtemp01.Cells[0].Value = false;
drtemp01.Cells[1].Value = str_id;
drtemp01.Cells[2].Value = str_app_briefcode;
drtemp01.Cells[3].Value = str_app_name;
}
drtemp01.Tag = dr;
}
}
}
}
private void but_sel_Click(object sender, EventArgs e)
{
DataRow[] arrayDR = null;
dgv_01.Rows.Clear();
string strsecdata = tb_sname.Text.Trim();
string str_usertp = Sl_type_02.GetKey(Sl_type_02.IndexOfValue(this.cb_customer.Text)).ToString();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, CnasBaseData.SystemID);
// string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-set-sec004", sttemp01);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-set-sec004", sttemp01);
if (str_usertp == "0")//查询所有客户的基本包
{
arrayDR = getdt.Select(" ca_name like '%" + strsecdata + "%' ");
}
else
{
arrayDR = getdt.Select("customer_code=" + "'" + str_usertp + "'" + " and ( ca_name like '%" + strsecdata + "%' )");//根据客户查询包
}
int ii = arrayDR.Length;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
int i = 0;
foreach (DataRow dr in arrayDR)
{
if (getdt.Rows[i]["id"] != null)
{
dgv_01.Rows[i].Cells["id"].Value = dr["id"].ToString();
}
if (getdt.Rows[i]["ca_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = dr["ca_name"].ToString();
}
if (getdt.Rows[i]["cost_center"] != null)
{
dgv_01.Rows[i].Cells["cost_center"].Value = Sl_type_01[dr["cost_center"].ToString()].ToString();
}
if (getdt.Rows[i]["bar_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = dr["bar_code"].ToString();
}
if (getdt.Rows[i]["ca_position"] != null)
{
dgv_01.Rows[i].Cells["ca_position"].Value = dr["ca_position"].ToString();
}
if (getdt.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = dr["cre_date"].ToString();
}
if (getdt.Rows[i]["mod_date"] != null)
{
dgv_01.Rows[i].Cells["mod_date"].Value = dr["mod_date"].ToString();
}
i++;
}
dgv_01.Rows[0].Selected = true;
}
private void but_ok_Click_1(object sender, EventArgs e)
{
dgv_01.Rows.Clear();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, user_id);
sttemp01.Add(2, dt_start.Value);
sttemp01.Add(3, dt_end.Value);
try
{
// string text = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-user-set-sec001", sttemp01);
DataTable dtUsers = reCnasRemotCall.RemotInterface.SelectData("HCS-user-set-sec001", sttemp01);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
int ii = dtUsers.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (dtUsers.Columns.Contains("set_code") && dtUsers.Rows[i]["set_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = dtUsers.Rows[i]["set_code"].ToString();
}
if (dtUsers.Columns.Contains("set_name") && dtUsers.Rows[i]["set_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = dtUsers.Rows[i]["set_name"].ToString();
}
if (dtUsers.Columns.Contains("pd_name") && dtUsers.Rows[i]["pd_name"] != null)
{
dgv_01.Rows[i].Cells["wf_code"].Value = dtUsers.Rows[i]["pd_name"].ToString();
}
if (dtUsers.Columns.Contains("cre_date") && dtUsers.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = dtUsers.Rows[i]["cre_date"].ToString();
}
if (dtUsers.Columns.Contains("mod_date") && dtUsers.Rows[i]["mod_date"] != null)
{
dgv_01.Rows[i].Cells["end_date"].Value = dtUsers.Rows[i]["mod_date"].ToString();
}
}
tb_inum.Text = dtUsers.Rows.Count.ToString();
dgv_01.CurrentRow = dgv_01.Rows[0];
}
SortedList SLkey_value = new SortedList();
SLkey_value.Add("first_time", dt_start.Value);
SLkey_value.Add("end_time", dt_end.Value);
SLkey_value.Add("userid", user_id);
DataSet DSnorm = new DataSet();
DSnorm = reCnasRemotCall.RemotInterface.ExecuteProcedure("performance_appraisal", SLkey_value);
if (DSnorm == null)
{
return;
}
if (DSnorm.Tables[0] != null && DSnorm.Tables[0].Rows.Count > 0)
{
DataRow[] arrayDR = null;
dgv_02.Rows.Clear();
arrayDR = DSnorm.Tables[0].Select();
int ii = arrayDR.Length;
if (ii <= 0)
{
return;
}
dgv_02.RowCount = ii;
int i = 0;
foreach (DataRow dr in arrayDR)
{
if (DSnorm.Tables[0].Columns.Contains("num") && DSnorm.Tables[0].Rows[i]["num"] != null)
{
dgv_02.Rows[i].Cells["num"].Value = dr["num"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("user_id") && DSnorm.Tables[0].Rows[i]["user_id"] != null)
{
dgv_02.Rows[i].Cells["user"].Value = dr["user_id"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("wf_code") && DSnorm.Tables[0].Rows[i]["wf_code"] != null)
{
dgv_02.Rows[i].Cells["wf_code"].Value = dr["wf_code"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("isconfirm") && DSnorm.Tables[0].Rows[i]["isconfirm"] != null)
{
dgv_02.Rows[i].Cells["isconfirm"].Value = dr["isconfirm"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("pd_name") && DSnorm.Tables[0].Rows[i]["pd_name"] != null)
{
dgv_02.Rows[i].Cells["pd_name"].Value = dr["pd_name"].ToString();
}
i++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Getdata()
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, user_id);
sttemp01.Add(2, dt_start.Value);
sttemp01.Add(3, dt_end.Value);
DataTable dtUsers = reCnasRemotCall.RemotInterface.SelectData("HCS-user-set-sec001", sttemp01);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
DataRow[] arrayDR = null;
dgv_01.Rows.Clear();
// string strsecdata = tb_sname.Text.Trim().ToUpper();
arrayDR = dtUsers.Select();
int ii = arrayDR.Length;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
int i = 0;
foreach (DataRow dr in arrayDR)
{
if (dtUsers.Columns.Contains("set_code") && dtUsers.Rows[i]["set_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = dr["set_code"].ToString();
}
if (dtUsers.Columns.Contains("set_name") && dtUsers.Rows[i]["set_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = dr["set_name"].ToString();
}
if (dtUsers.Columns.Contains("pd_name") && dtUsers.Rows[i]["pd_name"] != null)
{
dgv_01.Rows[i].Cells["wf_code"].Value = dr["pd_name"].ToString();
}
if (dtUsers.Columns.Contains("cre_date") && dtUsers.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = dr["cre_date"].ToString();
}
if (dtUsers.Columns.Contains("mod_date") && dtUsers.Rows[i]["mod_date"] != null)
{
dgv_01.Rows[i].Cells["end_date"].Value = dr["mod_date"].ToString();
}
i++;
}
dgv_01.CurrentRow = dgv_01.Rows[0];
}
SortedList SLkey_value = new SortedList();
SLkey_value.Add("first_time", dt_start.Value);
SLkey_value.Add("end_time", dt_end.Value);
SLkey_value.Add("userid", user_id);
DataSet DSnorm = new DataSet();
DSnorm = reCnasRemotCall.RemotInterface.ExecuteProcedure("performance_appraisal", SLkey_value);
if (DSnorm.Tables[0] != null && DSnorm.Tables[0].Rows.Count > 0)
{
DataRow[] arrayDR = null;
dgv_02.Rows.Clear();
arrayDR = DSnorm.Tables[0].Select();
int ii = arrayDR.Length;
if (ii <= 0)
{
return;
}
dgv_02.RowCount = ii;
int i = 0;
foreach (DataRow dr in arrayDR)
{
if (DSnorm.Tables[0].Columns.Contains("num") && DSnorm.Tables[0].Rows[i]["num"] != null)
{
dgv_02.Rows[i].Cells["num"].Value = dr["num"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("user_id") && DSnorm.Tables[0].Rows[i]["user_id"] != null)
{
dgv_02.Rows[i].Cells["user"].Value = dr["user_id"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("wf_code") && DSnorm.Tables[0].Rows[i]["wf_code"] != null)
{
dgv_02.Rows[i].Cells["wf_code"].Value = dr["wf_code"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("isconfirm") && DSnorm.Tables[0].Rows[i]["isconfirm"] != null)
{
dgv_02.Rows[i].Cells["isconfirm"].Value = dr["isconfirm"].ToString();
}
if (DSnorm.Tables[0].Columns.Contains("pd_name") && DSnorm.Tables[0].Rows[i]["pd_name"] != null)
{
dgv_02.Rows[i].Cells["pd_name"].Value = dr["pd_name"].ToString();
}
i++;
}
}
}
private void but_select_Click_1(object sender, EventArgs e)
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList slttmp = new SortedList();
string SqlWhere = string.Format("(s_room like '%{0}%' and s_basket like '%{1}%' and s_cabinet like '%{2}%')", tb_room.Text, tb_lan.Text, tb_gui.Text);
//slttmp.Add(1, tb_room.Text);
//slttmp.Add(2, tb_gui.Text);
//slttmp.Add(3, tb_lan.Text);
slttmp.Add(1, SqlWhere);
// string gg = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-storage-sec0010", slttmp);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-storage-sec0010", slttmp);
dgv_02.Rows.Clear();
if (getdt != null)
{
for (int i = 0; i < getdt.Rows.Count; i++)
{
if (getdt.Rows[i]["bar_code"].ToString() != "")
{
int dgvIndex = dgv_02.Rows.AddNew().Index;
if (getdt.Columns.Contains("ca_name") && !string.IsNullOrEmpty(getdt.Rows[i]["ca_name"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_set"].Value = getdt.Rows[i]["ca_name"];
}
if (getdt.Columns.Contains("bar_code") && !string.IsNullOrEmpty(getdt.Rows[i]["bar_code"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_barcode"].Value = getdt.Rows[i]["bar_code"];
}
if (getdt.Columns.Contains("s_name") && !string.IsNullOrEmpty(getdt.Rows[i]["s_name"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_stor"].Value = getdt.Rows[i]["s_name"];
}
if (getdt.Columns.Contains("s_room") && !string.IsNullOrEmpty(getdt.Rows[i]["s_room"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_room"].Value = getdt.Rows[i]["s_room"];
}
if (getdt.Columns.Contains("s_basket") && !string.IsNullOrEmpty(getdt.Rows[i]["s_basket"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_lan"].Value = getdt.Rows[i]["s_basket"];
}
if (getdt.Columns.Contains("mod_date") && !string.IsNullOrEmpty(getdt.Rows[i]["mod_date"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["time"].Value = getdt.Rows[i]["mod_date"];
}
if (getdt.Columns.Contains("ca_expiration") && !string.IsNullOrEmpty(getdt.Rows[i]["ca_expiration"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["baozhi"].Value = getdt.Rows[i]["ca_expiration"];
}
if (getdt.Columns.Contains("mod_date") && !string.IsNullOrEmpty(getdt.Rows[i]["mod_date"].ToString()))
{
string a = getdt.Rows[i]["mod_date"].ToString();
DateTime time1 = DateTime.Parse(a);
TimeSpan time2 = DateTime.Now.Subtract(time1);
int tianshu = time2.Days;
if (tianshu < int.Parse(getdt.Rows[i]["ca_expiration"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["out"].Value = int.Parse(getdt.Rows[i]["ca_expiration"].ToString()) - tianshu;
}
else
{
dgv_02.Rows[dgvIndex].Cells["out"].Value = "已过期";
}
}
if (getdt.Columns.Contains("s_cabinet") && !string.IsNullOrEmpty(getdt.Rows[i]["s_cabinet"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_gui"].Value = getdt.Rows[i]["s_cabinet"];
}
if (getdt.Columns.Contains("location_id") && !string.IsNullOrEmpty(getdt.Rows[i]["location_id"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_location"].Value = sl_location[getdt.Rows[i]["location_id"].ToString()].ToString();
}
}
}
if (dgv_02.RowCount > 0)
{
dgv_02.CurrentRow = dgv_02.Rows[0];
}
}
tb_num.Text = dgv_02.Rows.Count.ToString();
}
private void NameGetData()
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList slttmp = new SortedList();
slttmp.Add(1, tb_name.Text);
//string gg = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-storage-sec012", slttmp);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-storage-sec012", slttmp);
dgv_02.Rows.Clear();
tb_num.Clear();
if (getdt != null)
{
for (int i = 0; i < getdt.Rows.Count; i++)
{
if (getdt.Rows[i]["bar_code"].ToString() != "")
{
int dgvIndex = dgv_02.Rows.AddNew().Index;
if (getdt.Columns.Contains("ca_name") && !string.IsNullOrEmpty(getdt.Rows[i]["ca_name"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_set"].Value = getdt.Rows[i]["ca_name"];
}
if (getdt.Columns.Contains("bar_code") && !string.IsNullOrEmpty(getdt.Rows[i]["bar_code"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_barcode"].Value = getdt.Rows[i]["bar_code"];
}
if (getdt.Columns.Contains("s_name") && !string.IsNullOrEmpty(getdt.Rows[i]["s_name"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_stor"].Value = getdt.Rows[i]["s_name"];
}
if (getdt.Columns.Contains("s_room") && !string.IsNullOrEmpty(getdt.Rows[i]["s_room"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_room"].Value = getdt.Rows[i]["s_room"];
}
if (getdt.Columns.Contains("s_basket") && !string.IsNullOrEmpty(getdt.Rows[i]["s_basket"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_lan"].Value = getdt.Rows[i]["s_basket"];
}
if (getdt.Columns.Contains("s_cabinet") && !string.IsNullOrEmpty(getdt.Rows[i]["s_cabinet"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_gui"].Value = getdt.Rows[i]["s_cabinet"];
}
if (getdt.Columns.Contains("mod_date") && !string.IsNullOrEmpty(getdt.Rows[i]["mod_date"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["time"].Value = getdt.Rows[i]["mod_date"];
}
if (getdt.Columns.Contains("ca_expiration") && !string.IsNullOrEmpty(getdt.Rows[i]["ca_expiration"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["baozhi"].Value = getdt.Rows[i]["ca_expiration"];
}
if (getdt.Columns.Contains("mod_date") && !string.IsNullOrEmpty(getdt.Rows[i]["mod_date"].ToString()))
{
string a = getdt.Rows[i]["mod_date"].ToString();
DateTime time1 = DateTime.Parse(a);
TimeSpan time2 = DateTime.Now.Subtract(time1);
int lastDays = time2.Days;
if (lastDays < int.Parse(getdt.Rows[i]["ca_expiration"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["out"].Value = int.Parse(getdt.Rows[i]["ca_expiration"].ToString()) - lastDays;
}
else
{
dgv_02.Rows[dgvIndex].Cells["out"].Value = "已过期";
}
}
if (getdt.Columns.Contains("location_id") && !string.IsNullOrEmpty(getdt.Rows[i]["location_id"].ToString()))
{
dgv_02.Rows[dgvIndex].Cells["s_location"].Value = sl_location[getdt.Rows[i]["location_id"].ToString()].ToString();
}
}
}
if (dgv_02.RowCount > 0)
{
dgv_02.CurrentRow = dgv_02.Rows[0];
}
}
tb_num.Text = dgv_02.Rows.Count.ToString();
}
private void but_ok_Click_1(object sender, EventArgs e)
{
if (cb_type.Text.Trim() == "")
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("filltype", EnumPromptMessage.warning, new string[] { "成本" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
DataTable DTtype = null;
SortedList sltemp = new SortedList();
sltemp.Add(1, DateTime.Parse(cb_time.Text.ToString()));
if (stratr == "")
{
string gs = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-operating-cost-sec005", sltemp);
DTtype = reCnasRemotCall.RemotInterface.SelectData("HCS-operating-cost-sec005", sltemp);
}
else
{
sltemp.Add(2, stratr);
string gs = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-operating-cost-sec006", sltemp);
DTtype = reCnasRemotCall.RemotInterface.SelectData("HCS-operating-cost-sec006", sltemp);
}
if (DTtype != null && DTtype.Rows.Count > 0)
{
for (int i = 0; i < DTtype.Rows.Count; i++)
{
if (cb_type.Text.Substring(0, 1) == DTtype.Rows[i]["operation_type"].ToString())
{
MessageBox.Show("该月的费用类型已有数据,请重新选择", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
if (tb_money.Text.Trim() == "")
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("fillmoney", EnumPromptMessage.warning), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (stratr == "")
{
// CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList slttmp = new SortedList();
SortedList slttmp01 = new SortedList();
slttmp.Add(1, cb_type.Text.Trim().Substring(0, 1));
slttmp.Add(2, tb_money.Text.Trim());
slttmp.Add(3, DateTime.Parse(cb_time.Text.ToString()));
slttmp.Add(4, sl_user.GetKey(sl_user.IndexOfValue(CnasBaseData.UserName)));
slttmp.Add(5, tb_remark.Text.Trim());
slttmp01.Add(1, slttmp);
string gg = reCnasRemotCall.RemotInterface.CheckUPData(1, "HCS-operatingcost-add001", slttmp01, null);
int recint = reCnasRemotCall.RemotInterface.UPData(1, "HCS-operatingcost-add001", slttmp01, null);
if (recint > -1)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("addsuccessful", EnumPromptMessage.warning, new string[] { "运营成本" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else//修改
{
SortedList sttemp = new SortedList();
SortedList sttemp01 = new SortedList();
sttemp.Add(1, cb_type.Text.Trim().Substring(0, 1));
sttemp.Add(2, tb_money.Text.Trim());
sttemp.Add(3, DateTime.Parse(cb_time.Text.ToString()));
sttemp.Add(4, sl_user.GetKey(sl_user.IndexOfValue(CnasBaseData.UserName)));
sttemp.Add(5, stratr);
sttemp01.Add(1, sttemp);
// CnasRemotCall reCnasRemotCall=new CnasRemotCall();
string gg = reCnasRemotCall.RemotInterface.CheckUPData(1, "HCS-operatingcost-up001", sttemp01, null);
int recint = reCnasRemotCall.RemotInterface.UPData(1, "HCS-operatingcost-up001", sttemp01, null);
if (recint > -1)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("updatesuccessful", EnumPromptMessage.warning, new string[] { "运营成本" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadDataForm()
{
setDataGrid.Rows.Clear();
pdCodeType = GetReleaseMachineType();
if (pdCodeType == 0)
{
MessageBox.Show("内部流程码错误!");
return;
}
if (!string.IsNullOrEmpty(PdCode) && !string.IsNullOrEmpty(_UserCode) && !string.IsNullOrEmpty(_MachineCode))
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList condition = new SortedList();
string tempDescription = string.Empty;
DataTable machineInfo = null; //这里查询机器码相关信息
condition.Add(1, _MachineCode);
condition.Add(2, CnasBaseData.SystemID);
int deviceProgramLastTimes = 10;
//清洗
if (pdCodeType == 2)
{
string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS_work_set_freeinfo_show_sec002", condition);
machineInfo = reCnasRemotCall.RemotInterface.SelectData("HCS_work_set_freeinfo_show_sec002", condition);
}
//灭菌
else if (pdCodeType == 1)
{
string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS_work_set_freeinfo_show_sec003", condition);
machineInfo = reCnasRemotCall.RemotInterface.SelectData("HCS_work_set_freeinfo_show_sec003", condition);
}
if (machineInfo != null)
{
//getdt不知道会不会出现多个Row
if (machineInfo.Rows != null && machineInfo.Rows.Count > 0)
{
txtBatch.Text = GetValueStr(machineInfo.Rows[0]["dev_runtimes"]);
machineTxt.Text = GetValueStr(machineInfo.Rows[0]["dev_name"]);
txtProgram.Text = GetValueStr(machineInfo.Rows[0]["pr_name"]);
int.TryParse(GetValueStr(machineInfo.Rows[0]["pro_runtimes"]), out deviceProgramLastTimes);
if (machineInfo.Rows[0]["start_time"] != null)
{
txtBatchStartDate.Value = DateTime.Parse(machineInfo.Rows[0]["start_time"].ToString());
txtBatchEndDate.Value = txtBatchStartDate.Value.AddMinutes(deviceProgramLastTimes);
txtCreateDate.Value = txtBatchStartDate.Value;
}
if (machineInfo.Columns.Contains("dev_id") && !(machineInfo.Rows[0]["dev_id"] is DBNull))
{
_machineId = machineInfo.Rows[0]["dev_id"].ToString();
machineTxt.Tag = _machineId;
}
}
}
//查询datagrid的数据
condition = new SortedList();
DataTable data = null;
condition.Add(1, PdCode);
condition.Add(2, "0");
condition.Add(3, _MachineCode);
setNumTxt.Text = "0";
data = reCnasRemotCall.RemotInterface.SelectData("HCS-work-set-sec005", condition);
if (data != null)
{
DateTime createDate = DateTime.Now;
foreach (DataRow item in data.Rows)
{
DataConverter.ConvertSetData(setDataGrid, item);
}
setDataGrid.Rows[0].Selected = true;
}
AppendTempBCCSet();
setNumTxt.Text = setDataGrid.RowCount.ToString();
}
}
private void Loaddata(string cu_barcode)
{
dgv_01.Rows.Clear();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, CnasBaseData.SystemID);
DataTable getdt = null;
if (cu_barcode == null)
{
// string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-set-sec004", sttemp01);
getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-set-sec004", sttemp01);
}
else
{
sttemp01.Add(2, cu_barcode);
string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-set-sec003", sttemp01);
getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-set-sec003", sttemp01);
}
if (getdt != null)
{
int ii = getdt.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (getdt.Rows[i]["id"] != null)
{
dgv_01.Rows[i].Cells["id"].Value = getdt.Rows[i]["id"].ToString();
}
if (getdt.Rows[i]["ca_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = getdt.Rows[i]["ca_name"].ToString();
}
if (getdt.Rows[i]["cost_center"] != null)
{
dgv_01.Rows[i].Cells["cost_center"].Value = Sl_type_01[getdt.Rows[i]["cost_center"].ToString()].ToString();
}
if (getdt.Rows[i]["bar_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = getdt.Rows[i]["bar_code"].ToString();
}
if (getdt.Rows[i]["ca_position"] != null)
{
dgv_01.Rows[i].Cells["ca_position"].Value = getdt.Rows[i]["ca_position"].ToString();
}
if (getdt.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = getdt.Rows[i]["cre_date"].ToString();
}
if (getdt.Rows[i]["mod_date"] != null)
{
dgv_01.Rows[i].Cells["mod_date"].Value = getdt.Rows[i]["mod_date"].ToString();
}
// if (getdt.Rows[i]["customer_code"] != null) dgv_01.Rows[i].Cells["customer_code"].Value = getdt.Rows[i]["customer_code"].ToString();
if (getdt.Rows[i]["customer_code"] != null)
{
dgv_01.Rows[i].Cells["customer_code"].Value = Sl_type_02[getdt.Rows[i]["customer_code"].ToString()].ToString();
}
}
}
dgv_01.Rows[0].Selected = true;
}
public HCSCM_plasticenvelop_device_procedure(SortedList slselect)
{
InitializeComponent();
//设置窗体图标
this.Icon = new Icon(ResourcesImageHelper.Instance.GetResourcesStream("Common.icon", "MainIco", EnumImageType.ICO));
this.but_addall.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "allRight", EnumImageType.PNG);
this.but_addone.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "rightShift", EnumImageType.PNG);
this.but_reall.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "allLeft", EnumImageType.PNG);
this.but_reone.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "leftShift", EnumImageType.PNG);
this.but_save.Image = ResourcesImageHelper.Instance.GetResourcesImage("Common.Buttom", "savePicture", EnumImageType.PNG);
//this.Font = new Font(this.Font.FontFamily, 11);
this.Text = styStemName + "--塑封流程";
this.tb_cssd.Text = CnasBaseData.SystemInfoData.Rows[0]["customer"].ToString() + "-->" + CnasBaseData.SystemInfoData.Rows[0]["site_name"].ToString();
this.tb_department.Text = slselect["ca_name"].ToString();
select_id = slselect["id"].ToString();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
dtall = reCnasRemotCall.RemotInterface.SelectData("HCS-plasticenvelop-program-sec001", null);
SortedList sttemp02 = new SortedList();
sttemp02.Add(1, slselect["id"].ToString());
// string a = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-plasticenvelop-deviceprogram-sec001", sttemp02);
dtselect = reCnasRemotCall.RemotInterface.SelectData("HCS-plasticenvelop-deviceprogram-sec001", sttemp02);
if (dtall != null)
{
for (int i = 0; i < dtall.Rows.Count; i++)
{
string str_id = "", str_app_name = "";
if (dtall.Columns.Contains("id") && dtall.Rows[i]["id"] != null)
{
str_id = dtall.Rows[i]["id"].ToString();
}
if (dtall.Columns.Contains("pr_name") && dtall.Rows[i]["pr_name"] != null)
{
str_app_name = dtall.Rows[i]["pr_name"].ToString();
}
GridViewRowInfo drtemp01 = null;
//drtemp01.Cells.Add(new DataGridViewCheckBoxCell());//选择
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//id
//drtemp01.Cells.Add(new DataGridViewTextBoxCell());//名字
//drtemp01.SetValues(false, str_id, str_app_name);
if (dtselect == null)
{
drtemp01 = dgv_01.Rows.AddNew();
sl_allapp.Add(str_id, str_app_name);
}
else
{
DataRow[] arrayDRsec = dtselect.Select("p_id=" + str_id);
if (arrayDRsec.Length > 0)
{
drtemp01 = dgv_02.Rows.AddNew();
sl_gpapp.Add(str_id, str_app_name);
}
else
{
drtemp01 = dgv_01.Rows.AddNew();
sl_allapp.Add(str_id, str_app_name);
}
}
if (drtemp01 != null)
{
drtemp01.Cells[0].Value = str_id;
drtemp01.Cells[1].Value = str_app_name;
}
drtemp01.Tag = dtall.Rows[i];
}
}
}
private void GetData()
{
dgv_01.Rows.Clear();
dgv_01.ClearSelection();
string customerValue = cb_customer.SelectedItem != null && cb_customer.SelectedItem.Value != null?cb_customer.SelectedItem.Value.ToString() : string.Empty;
string locationValue = cb_location.SelectedItem != null && cb_location.SelectedItem.Value != null?cb_location.SelectedItem.Value.ToString() : string.Empty;
if (!string.IsNullOrEmpty(customerValue) && !string.IsNullOrEmpty(locationValue))
{
string[] ids = customerValue.Split(':');
if (ids.Length >= 2)
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList slttmp = new SortedList();
slttmp.Add(2, locationValue);
slttmp.Add(1, ids[1]);
string qq = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-work-set-sec010", slttmp);
DataTable getdt01 = reCnasRemotCall.RemotInterface.SelectData("HCS-work-set-sec010", slttmp);
if (getdt01 != null)
{
int ii = getdt01.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (getdt01.Columns.Contains("set_code") && !string.IsNullOrEmpty(getdt01.Rows[i]["set_code"].ToString()))
{
dgv_01.Rows[i].Cells["bar_code"].Value = getdt01.Rows[i]["set_code"].ToString();
}
if (getdt01.Columns.Contains("ca_name") && !string.IsNullOrEmpty(getdt01.Rows[i]["ca_name"].ToString()))
{
dgv_01.Rows[i].Cells["name"].Value = getdt01.Rows[i]["ca_name"].ToString();
}
if (getdt01.Columns.Contains("cu_name") && !string.IsNullOrEmpty(getdt01.Rows[i]["cu_name"].ToString()))
{
dgv_01.Rows[i].Cells["customer"].Value = getdt01.Rows[i]["cu_name"].ToString();
}
;
if (getdt01.Columns.Contains("ca_name1") && !string.IsNullOrEmpty(getdt01.Rows[i]["ca_name1"].ToString()))
{
dgv_01.Rows[i].Cells["costcenter"].Value = getdt01.Rows[i]["ca_name1"].ToString();
}
if (getdt01.Columns.Contains("u_uname") && !string.IsNullOrEmpty(getdt01.Rows[i]["u_uname"].ToString()))
{
dgv_01.Rows[i].Cells["location"].Value = getdt01.Rows[i]["u_uname"].ToString();
}
if (getdt01.Columns.Contains("mod_date1") && !string.IsNullOrEmpty(getdt01.Rows[i]["mod_date1"].ToString()))
{
dgv_01.Rows[i].Cells["sterilizerdate"].Value = getdt01.Rows[i]["mod_date1"].ToString();
}
if (getdt01.Columns.Contains("user_name") && !string.IsNullOrEmpty(getdt01.Rows[i]["user_name"].ToString()))
{
dgv_01.Rows[i].Cells["sterilizeruser"].Value = getdt01.Rows[i]["user_name"].ToString();
}
if (getdt01.Columns.Contains("user_name1") && !string.IsNullOrEmpty(getdt01.Rows[i]["user_name1"].ToString()))
{
dgv_01.Rows[i].Cells["washinguser"].Value = getdt01.Rows[i]["user_name1"].ToString();
}
if (getdt01.Columns.Contains("mod_date2") && !string.IsNullOrEmpty(getdt01.Rows[i]["mod_date2"].ToString()))
{
dgv_01.Rows[i].Cells["washingdate"].Value = getdt01.Rows[i]["mod_date2"].ToString();
}
if (getdt01.Columns.Contains("batch") && !string.IsNullOrEmpty(getdt01.Rows[i]["batch"].ToString()))
{
dgv_01.Rows[i].Cells["batch"].Value = getdt01.Rows[i]["batch"].ToString();
}
}
if (ii > 0)
{
dgv_01.CurrentRow = dgv_01.Rows[0];
}
}
}
}
}
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RadForm1_Load(object sender, EventArgs e)
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
//设定一个年份
int yearValue = 2016;
DateTime dataNow = DateTime.Now;
//如果年份等于当前年份则需要处理
if (yearValue == dataNow.Year)
{
//如果年份相等，则判断月份
if (dataNow.Year == yearValue)
{
//获取当月的最后一天
int LastDay = dataNow.AddMonths(1).AddDays(-dataNow.AddMonths(1).Day).Day;
//如果日已经达到最后一天，则传入当前月份，否则传入当前月份减一
if (dataNow.Day == LastDay)
{
sttemp01.Add(1, dataNow.Month);
}
else
{
sttemp01.Add(1, dataNow.Month - 1);
}
}
}
else
{
sttemp01.Add(1, 12);
}
sttemp01.Add(2, yearValue);
//处理器械总件数(除以月数的平均数)
//string text = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-instrument-report-sec001", sttemp01);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-instrument-report-sec001", sttemp01);
c1RadialGauge2.Value = Convert.ToDouble(getdt.Rows[0][0]);
//处理敷料的总件数(除以月数的平均数)
DataTable getdt1 = reCnasRemotCall.RemotInterface.SelectData("HCS-instrument-report-sec002", sttemp01);
c1RadialGauge1.Value = Convert.ToDouble(getdt1.Rows[0][0]);
//处理外来器械的总件数(除以月数的平均数)
DataTable getdt2 = reCnasRemotCall.RemotInterface.SelectData("HCS-instrument-report-sec003", sttemp01);
c1RadialGauge3.Value = Convert.ToDouble(getdt2.Rows[0][0]);
SortedList sttemp02 = new SortedList();
sttemp02.Add(1, sttemp01[1]);
sttemp02.Add(2, sttemp01[1]);
string text = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-sterilizer-report-sec001", sttemp01);
//手术器械包次日下送发生率(按月统计)
DataTable getdt3 = reCnasRemotCall.RemotInterface.SelectData("HCS-instrument-report-sec004", sttemp02);
//乘以100，表示计算百分比
c1RadialGauge4.Value = Convert.ToDouble(getdt3.Rows[0][0].ToString() == "" ? 0 : getdt3.Rows[0][0]) * 100;
//处理外来器械的总件数(除以月数的平均数)
DataTable getdt4 = reCnasRemotCall.RemotInterface.SelectData("HCS-sterilizer-report-sec001", sttemp01);
c1RadialGauge5.Value = Convert.ToDouble(getdt4.Rows[0][0]);
}
private void but_ok_Click(object sender, EventArgs e)
{
if (tb_name.Text.Trim() == "")
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("fillname", EnumPromptMessage.warning, new string[] { "清洗程序" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.cb_type.Text == "")
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("filltype", EnumPromptMessage.warning, new string[] { "清洗" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.tb_run_time.Text.Trim() == "")
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("fillruntime", EnumPromptMessage.warning), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
if (Strselectid == "")//增加
{
#region 判断名字是否存在
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-washing-program-sec001", null);//49
if (getdt != null)
{
DataRow[] getdt_01 = getdt.Select();
foreach (DataRow dr in getdt_01)
{
if (tb_name.Text.Trim().ToString() == dr["pr_name"].ToString().Trim())
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("namerepetition", EnumPromptMessage.warning, new string[] { "清洗程序" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
#endregion
SortedList sltmp = new SortedList();
SortedList sltmp01 = new SortedList();
sltmp.Add(1, tb_name.Text.Trim());
sltmp.Add(2, tb_remarks.Text.Trim());
sltmp.Add(3, tb_run_time.Text.Trim());
sltmp.Add(4, cb_type.Text.Trim().Substring(0, 1));
sltmp01.Add(1, sltmp);
string strtmp = reCnasRemotCall.RemotInterface.CheckUPData(1, "HCS-washing-program-add001", sltmp01, null);
int recint = reCnasRemotCall.RemotInterface.UPData(1, "HCS-washing-program-add001", sltmp01, null);
if (recint > -1)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("addsuccessful", EnumPromptMessage.warning, new string[] { "清洗程序" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
#region 判断名字是否存在
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
if (this.tb_name.Text.Trim() != Strselectname)
{
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-washing-program-sec001", null);//49
if (getdt != null)
{
DataRow[] getdt_01 = getdt.Select();
foreach (DataRow dr in getdt_01)
{
if (tb_name.Text.Trim().ToString() == dr["pr_name"].ToString().Trim())
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("namerepetition", EnumPromptMessage.warning, new string[] { "清洗程序" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
}
#endregion
SortedList sltmp = new SortedList();
SortedList sltmp01 = new SortedList();
sltmp01.Add(1, tb_name.Text.Trim());
sltmp01.Add(2, tb_remarks.Text.Trim());
sltmp01.Add(3, cb_type.Text.Trim().Substring(0, 1));
sltmp01.Add(4, tb_run_time.Text.Trim());
sltmp01.Add(5, Strselectid);
sltmp.Add(1, sltmp01);
// string sql = reCnasRemotCall.RemotInterface.CheckUPData(1, "HCS-washing-program-up001", sltmp, null);
int recint = reCnasRemotCall.RemotInterface.UPData(1, "HCS-washing-program-up001", sltmp, null);
if (recint > -1)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("updatesuccessful", EnumPromptMessage.warning, new string[] { "清洗程序" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("unknowerror", EnumPromptMessage.error, new string[] { ex.Message }), "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
private void Loaddata(string cu_barcode)
{
dgv_01.Rows.Clear();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, CnasBaseData.SystemID);
DataTable getdt = null;
if (cu_barcode == null)
{
// string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-orderid-manager-sec001", sttemp01);
dtsel = getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-orderid-manager-sec001", sttemp01);
}
else
{
sttemp01.Add(2, cu_barcode);
//string sql = reCnasRemotCall.RemotInterface.CheckSelectData("HCS-orderid-manager-sec003", sttemp01);
dtsel = getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-orderid-manager-sec003", sttemp01);
}
if (getdt != null)
{
int ii = getdt.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (getdt.Columns.Contains("id") && getdt.Rows[i]["id"] != null)
{
dgv_01.Rows[i].Cells["id"].Value = getdt.Rows[i]["id"].ToString();
}
if (getdt.Columns.Contains("ca_name") && getdt.Rows[i]["ca_name"] != null)
{
dgv_01.Rows[i].Cells["ca_name"].Value = getdt.Rows[i]["ca_name"].ToString();
}
if (getdt.Columns.Contains("bar_code") && getdt.Rows[i]["bar_code"] != null)
{
dgv_01.Rows[i].Cells["bar_code"].Value = getdt.Rows[i]["bar_code"].ToString(); //值是bar_code
}
if (getdt.Columns.Contains("ca_name1") && getdt.Rows[i]["ca_name1"] != null)
{
dgv_01.Rows[i].Cells["costbar_codename"].Value = getdt.Rows[i]["ca_name1"].ToString();
dgv_01.Rows[i].Cells["costbar_code"].Value = getdt.Rows[i]["costbar_code"].ToString();
}
if (getdt.Columns.Contains("u_uname") && getdt.Rows[i]["u_uname"] != null)
{
dgv_01.Rows[i].Cells["location_name"].Value = getdt.Rows[i]["u_uname"].ToString();
dgv_01.Rows[i].Cells["location_id"].Value = getdt.Rows[i]["location_id"].ToString();
}
if (getdt.Columns.Contains("cu_name") && getdt.Rows[i]["cu_name"] != null)
{
dgv_01.Rows[i].Cells["customer_barcode"].Value = getdt.Rows[i]["customer_barcode"].ToString();
dgv_01.Rows[i].Cells["customer_barcodename"].Value = getdt.Rows[i]["cu_name"].ToString();
}
if (getdt.Columns.Contains("cre_date") && getdt.Rows[i]["cre_date"] != null)
{
dgv_01.Rows[i].Cells["cre_date"].Value = getdt.Rows[i]["cre_date"].ToString();
}
if (getdt.Columns.Contains("remark") && getdt.Rows[i]["remark"] != null)
{
dgv_01.Rows[i].Cells["remark"].Value = getdt.Rows[i]["remark"].ToString();
}
}
if (dgv_01.Rows.Count > 0)
{
dgv_01.CurrentRow = dgv_01.Rows[0];
}
}
}
private void LoadFromEvent()
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
//器械类型
DataRow[] typeDR = CnasBaseData.SystemBaseData.Select("type_code='HCS_instrument_type'");
this.cb_type.Items.Add("----所有----");
foreach (DataRow dr in typeDR)
{
cb_type.Items.Add(dr["value_code"].ToString().Trim());
}
cb_type.Text = "----所有----";
//成本中心
DataTable getdt03 = reCnasRemotCall.RemotInterface.SelectData("HCS-costcenter-sec003", null);
if (getdt03 != null)
{
this.cb_cost_center.Items.Add(new RadListDataItem()
{
Text = "----所有----", Value = "0"
});
int ii = getdt03.Rows.Count;
if (ii <= 0)
{
return;
}
for (int i = 0; i < ii; i++)
{
if (getdt03.Rows[i]["id"].ToString() != null && getdt03.Rows[i]["ca_name"].ToString().Trim() != null)
{
cb_cost_center.Items.Add(new RadListDataItem()
{
Text = getdt03.Rows[i]["ca_name"].ToString().Trim(), Value = getdt03.Rows[i]["id"].ToString()
});
}
}
cb_cost_center.Text = "----所有----";
}
//顾客
DataTable getdt04 = reCnasRemotCall.RemotInterface.SelectData("HCS-customer-sec002", null);
if (getdt04 != null)
{
this.cb_customer.Items.Add(new RadListDataItem()
{
Text = "----所有----", Value = "0"
});
int ii = getdt04.Rows.Count;
if (ii <= 0)
{
return;
}
for (int i = 0; i < ii; i++)
{
if (getdt04.Rows[i]["id"].ToString() != null && getdt04.Rows[i]["cu_name"].ToString().Trim() != null)
{
cb_customer.Items.Add(new RadListDataItem()
{
Text = getdt04.Rows[i]["cu_name"].ToString().Trim(), Value = getdt04.Rows[i]["id"].ToString()
});
}
}
cb_customer.SelectedIndex = 0;
}
// LoadData();
}
public HCSSM_procedure_relation(string str_inid, string str_inname, string str_incode, DataTable indtall)
{
InitializeComponent();
//this.Font = new Font(this.Font.FontFamily, 11);
this.Text = ConfigurationManager.AppSettings["SystemName"].ToString() + "--流程关系管理";
str_prid = str_inid;
dtall = indtall;
this.Text = this.Text + " ->" + str_incode + "--" + str_inname;
DataRow[] arrayDRsec01 = dtall.Select("id=" + str_inid);
if (arrayDRsec01[0]["pd_scan"] != null)
{
tb_02.Text = arrayDRsec01[0]["pd_scan"].ToString();
}
#region 获取已经配置好流程数据
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, str_inid);
dtselect = reCnasRemotCall.RemotInterface.SelectData("HCS-procedure_relation-sec001", sttemp01);
if (dtall != null)
{
for (int i = 0; i < dtall.Rows.Count; i++)
{
string str_id = "", str_code = "", str_name = "", str_priority = "0", str_condition = "";
if (dtall.Rows[i]["id"] != null)
{
str_id = dtall.Rows[i]["id"].ToString();
}
if (dtall.Rows[i]["pd_code"] != null)
{
str_code = dtall.Rows[i]["pd_code"].ToString();
}
if (dtall.Rows[i]["pd_name"] != null)
{
str_name = dtall.Rows[i]["pd_name"].ToString();
}
DataGridViewRow drtemp01 = new DataGridViewRow();
drtemp01.Cells.Add(new DataGridViewCheckBoxCell()); //选择
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //id
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //编码
drtemp01.Cells.Add(new DataGridViewTextBoxCell()); //名称
if (dtselect == null)
{
drtemp01.SetValues(false, str_id, str_code, str_name);
dgv_01.Rows.Add(drtemp01);
sl_01data.Add(str_id, str_name);
}
else
{
DataRow[] arrayDRsec = dtselect.Select("next_pid=" + str_id);
if (arrayDRsec.Length > 0)
{
if (arrayDRsec[0]["pr_priority"] != null)
{
str_priority = arrayDRsec[0]["pr_priority"].ToString();
}
if (arrayDRsec[0]["pr_condition"] != null)
{
str_condition = arrayDRsec[0]["pr_condition"].ToString();
}
drtemp01.Cells.Add(new DataGridViewTextBoxCell());
drtemp01.Cells.Add(new DataGridViewTextBoxCell());
drtemp01.SetValues(false, str_id, str_code, str_name, str_priority, str_condition);
//drtemp01.SetValues(false, str_id, str_code, str_name);
dgv_02.Rows.Add(drtemp01);
sl_02data.Add(str_id, str_name);
}
else
{
drtemp01.SetValues(false, str_id, str_code, str_name);
dgv_01.Rows.Add(drtemp01);
sl_01data.Add(str_id, str_name);
}
}
}
}
#endregion
load_pdpar();
}
/// <summary>
/// 加载DGV数据
/// </summary>
private void LoadData()
{
dgv_01.Rows.Clear();
string strsecdata = tb_sname.Text.Trim();
string str_usertp = this.cb_customer.Text;
string str_cc_id = this.cb_cost_center.Text;
string str_type = this.cb_type.Text;
string selectSql = string.Format("( in_name like '%{0}%')", strsecdata);
if (str_usertp != "----所有----")
{
selectSql += string.Format(" and cu_name='{0}'", str_usertp);
}
if (str_cc_id != "----所有----")
{
selectSql += string.Format(" and ca_name='{0}'", str_cc_id);
}
if (str_type != "----所有----")
{
selectSql += string.Format(" and value_code='{0}'", str_type);
}
if (rb_storage.Checked == true)
{
selectSql += string.Format(" and act_type='{0}'", 1);
}
else
{
selectSql += string.Format(" and act_type='{0}'", 2);
}
if (startTimePicker.Text != "" && endTimePicker.Text != "")
{
selectSql += string.Format(" and cre_date>='{0}' and cre_date<='{1}'", startTimePicker.Value, endTimePicker.Value);
}
SortedList sttemp01 = new SortedList();
sttemp01.Add(1, selectSql);
//selectSql += " order by id";
//DataRow[] arrayDR = getdt.Select(selectSql).OrderBy(item => item["id"]).ToArray();
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
// string ggg = reCnasRemotCall.RemotInterface.CheckSelectData("HCS_instrument-in-out-log-sel001", sttemp01);
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS_instrument-in-out-log-sel001", sttemp01);
if (getdt == null)
{
return;
}
int ii = getdt.Rows.Count;
if (ii <= 0)
{
return;
}
dgv_01.RowCount = ii;
for (int i = 0; i < ii; i++)
{
if (!string.IsNullOrEmpty(getdt.Rows[i]["id"].ToString()))
{
dgv_01.Rows[i].Cells["id"].Value = getdt.Rows[i]["id"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["in_name"].ToString()))
{
dgv_01.Rows[i].Cells["ca_name"].Value = getdt.Rows[i]["in_name"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["cu_name"].ToString()))
{
dgv_01.Rows[i].Cells["cu_name"].Value = getdt.Rows[i]["cu_name"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["ca_name"].ToString()))
{
dgv_01.Rows[i].Cells["cc_name"].Value = getdt.Rows[i]["ca_name"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["value_code"].ToString()))
{
dgv_01.Rows[i].Cells["value_code"].Value = getdt.Rows[i]["value_code"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["act_type"].ToString()))
{
dgv_01.Rows[i].Cells["act_type"].Value = (getdt.Rows[i]["act_type"].ToString() == "1") ? "入库" : "出库";
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["act_count"].ToString()))
{
dgv_01.Rows[i].Cells["act_count"].Value = getdt.Rows[i]["act_count"].ToString();
}
if (!string.IsNullOrEmpty(getdt.Rows[i]["cre_date"].ToString()))
{
dgv_01.Rows[i].Cells["cre_date"].Value = getdt.Rows[i]["cre_date"].ToString();
}
}
//foreach (DataRow dr in arrayDR)
//{
// if (!string.IsNullOrEmpty(dr["id"].ToString())) dgv_01.Rows[i].Cells["id"].Value = dr["id"].ToString();
// if (!string.IsNullOrEmpty(dr["ca_name"].ToString())) dgv_01.Rows[i].Cells["ca_name"].Value = dr["ca_name"].ToString();
// if (!string.IsNullOrEmpty(dr["cu_name"].ToString())) dgv_01.Rows[i].Cells["cu_name"].Value = dr["cu_name"].ToString();
// if (!string.IsNullOrEmpty(dr["cc_name"].ToString())) dgv_01.Rows[i].Cells["cc_name"].Value = dr["cc_name"].ToString();
// if (!string.IsNullOrEmpty(dr["value_code"].ToString())) dgv_01.Rows[i].Cells["value_code"].Value = dr["value_code"].ToString();
// if (!string.IsNullOrEmpty(dr["act_type"].ToString())) dgv_01.Rows[i].Cells["act_type"].Value = (dr["act_type"].ToString() == "1") ? "入库" : "出库";
// if (!string.IsNullOrEmpty(dr["act_count"].ToString())) dgv_01.Rows[i].Cells["act_count"].Value = dr["act_count"].ToString();
// if (!string.IsNullOrEmpty(dr["cre_date"].ToString())) dgv_01.Rows[i].Cells["cre_date"].Value = dr["cre_date"].ToString();
// i++;
//}
if (dgv_01.Rows.Count > 0)
{
dgv_01.CurrentRow = dgv_01.Rows[0];
}
}
private void rBut_ok_Click(object sender, EventArgs e)
{
DataSet set = new DataSet();
DataTable windowsXPTable = new DataTable("WindowsXP");
DataTable windows7Table = new DataTable("Windows7");
set.Tables.Clear();
windowsXPTable.Rows.Clear();
windows7Table.Rows.Clear();
radChartView1.Series.Clear();
set.Tables.Add(windowsXPTable);
set.Tables.Add(windows7Table);
foreach (DataTable table in set.Tables)
{
table.Columns.Add("Month");
table.Columns.Add("Usage", typeof(double));
}
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
int yearInt = int.Parse(cb_year.Text);
SortedList bb = new SortedList();
bb.Add("fisrtTime", new DateTime(yearInt - 1, 1, 1));
DataSet result = reCnasRemotCall.RemotInterface.ExecuteProcedure("dispose_instrument", bb);
if (result != null && result.Tables != null && result.Tables.Count > 0)
{
int selectYearTotal = 0;
int beforeYearTotal = 0;
double Total = 0;
DataTable table = result.Tables[0];
for (int i = 0; i < 2; i++)
{
int calYear = i == 0 ? yearInt : yearInt - 1;
for (int j = 1; j < 13; j++)
{
string calMonth = calYear.ToString() + j.ToString().PadLeft(2, '0');
DataRow rowData = null;
if (table.Rows != null)
{
foreach (DataRow row in table.Rows)
{
if (row["calmon"] != null && row["calmon"].ToString() == calMonth)
{
rowData = row;
break;
}
}
}
if (rowData == null)
{
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
else
{
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), 0);
}
}
if (rowData != null)
{
double calResult = rowData["total"] is DBNull ? 0 : Convert.ToDouble(rowData["total"]);
if (calYear.ToString() == cb_year.Text)
{
Total += calResult;
}
c1RG.Value = double.Parse(String.Format("{0:F}", Total / 12));
if (i == 0)
{
windowsXPTable.Rows.Add(GetMonthLbl(j.ToString()), calResult);
selectYearTotal += rowData["total"] is DBNull ? 0 : int.Parse(rowData["total"].ToString());
}
else
{
beforeYearTotal += rowData["total"] is DBNull ? 0 : int.Parse(rowData["total"].ToString());
windows7Table.Rows.Add(GetMonthLbl(j.ToString()), calResult);
}
}
}
RefreshDataGrid(table);
}
currentYearTxt.Text = selectYearTotal.ToString();
lastyeartet.Text = beforeYearTotal.ToString();
radLabel3.Text = beforeYearTotal == selectYearTotal ? "平稳" : (beforeYearTotal > selectYearTotal) ? "下降" : "上升";
}
this.radChartView1.DataSource = set;
BarSeries windowsXPSeries = new BarSeries("Usage", "Month");
windowsXPSeries.DataMember = "WindowsXP";
windowsXPSeries.LegendTitle = "Windows XP";
BarSeries windows7Series = new BarSeries("Usage", "Month");
windows7Series.DataMember = "Windows7";
windows7Series.LegendTitle = "Windows 7";
windowsXPSeries.ShowLabels = true;
windows7Series.ShowLabels = true;
this.radChartView1.Series.AddRange(windowsXPSeries, windows7Series);
}
//删除
private void but_remove_Click(object sender, EventArgs e)
{
if (this.dgv_01.SelectedRows.Count <= 0)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("choicechange", EnumPromptMessage.warning, new string[] { "删除", "灭菌器" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
CnasRemotCall reCnasRemotCall = new CnasRemotCall();
#region 判断灭菌器是否被灭菌流程占用
DataTable getdt = reCnasRemotCall.RemotInterface.SelectData("HCS-sterilizer-deviceprogram-sec003", null);//99
if (getdt != null)
{
int ii = getdt.Rows.Count;
if (ii <= 0)
{
return;
}
for (int i = 0; i < ii; i++)
{
if (getdt.Rows[i]["dev_id"].ToString() != null)
{
if (dgv_01.SelectedRows[0].Cells["id"].Value.ToString() == getdt.Rows[i]["dev_id"].ToString().Trim())
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("relation", EnumPromptMessage.warning, new string[] { "灭菌器", "灭菌流程", "灭菌流程" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
}
#endregion
if (MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("choicedelete", EnumPromptMessage.warning, new string[] { dgv_01.SelectedRows[0].Cells["ca_name"].Value.ToString(), "灭菌器" }), ConfigurationManager.AppSettings["SystemName"] + "--删除灭菌器", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
int selectedIndex = dgv_01.Rows.IndexOf(dgv_01.SelectedRows[0]);
SortedList sltmp = new SortedList();
SortedList sltmp01 = new SortedList();
sltmp01.Add(1, dgv_01.SelectedRows[0].Cells["id"].Value);
sltmp.Add(1, sltmp01);
// string sql = reCnasRemotCall.RemotInterface.CheckUPData(1, "HCS-washing-device-del001", sltmp, null);
int recint = reCnasRemotCall.RemotInterface.UPData(1, "HCS-sterilizer-device-del001", sltmp, null);
if (recint > -1)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("deletesuccessful", EnumPromptMessage.warning, new string[] { "灭菌器" }), "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgv_01.Rows.RemoveAt(selectedIndex);//移除选择的dgv的数据
if (dgv_01.Rows.Count > 0)
{
if (selectedIndex == 0)//删除后判断是否为0
{
dgv_01.CurrentRow = dgv_01.Rows[0];
}
else
{
dgv_01.CurrentRow = dgv_01.Rows[selectedIndex - 1];
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(PromptMessageXmlHelper.Instance.GetPromptMessage("unknowerror", EnumPromptMessage.warning, new string[] { ex.Message }), "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
