public DataTable getOutParamter(Reportdat re, List <Paramater> list) { HIS.SYSTEM.DatabaseAccessLayer.ParameterEx[] parameters = new HIS.SYSTEM.DatabaseAccessLayer.ParameterEx[list.Count]; for (int index = 0; index < list.Count; index++) { parameters[index].Text = list[index].PARAMETER; if (list[index].PARAMETER_TYPE == "OUT") { parameters[index].ParaSize = Convert.ToInt32(list[index].DATALENGTH.ToString()); parameters[index].ParaDirection = ParameterDirection.Output; } else { if (list[index].PARAMDATATYPE == 1) { parameters[index].Value = Convert.ToInt32(list[index].objvalue); } else { parameters[index].Value = list[index].objvalue.ToString(); } parameters[index].ParaDirection = ParameterDirection.Input; } } DataTable result; result = oleDb.GetDataTable(re.PROCEDURES, parameters); return(result); }
private void SetNodeCheck(TreeNode node, int groupid) { foreach (TreeNode nd in node.Nodes) { if (nd.Tag.GetType() == typeof(OpReportMaster)) { SetNodeCheck(nd, groupid); } else { HIS.Report_BLL.Reportdat report = (HIS.Report_BLL.Reportdat)nd.Tag; DataRow[] drs = _reportGroup.Select("report_id=" + report.REPORT_ID + " and group_id=" + groupid); if (drs.Length != 0) { nd.Checked = true; } } } }