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