Пример #1
0
        /// <summary>
        /// ִ�д洢���̻�SQL��䣬������һ��DataTable
        /// </summary>
        /// <param name="strProcedureName">Ҫ�󷵻�DataTable�Ĵ洢���̻�SQL���</param>
        /// <returns></returns>
        public DataTable ExcuteProcedure(string strProcedureName)
        {
            DataTable dt = new DataTable();
            SqlConnection conn=null;

            try
            {
                conn = new SqlConnection(ConfigurationSettings.AppSettings.GetValues("connection")[0]);

                SqlDataAdapter sda = new SqlDataAdapter(strProcedureName, conn);

                DataSet ds = new DataSet();
                conn.Open();

                sda.Fill(ds);

                dt = ds.Tables[0];

                sda.Dispose();

                conn.Close();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                Err MyErr = new Err(ex.Message.ToString());
            }

            return dt;
        }
Пример #2
0
 /// <summary>
 /// ִ��SQL��䣬����������
 /// </summary>
 /// <param name="strSQL">��Ҫ�󷵻��з���ֵ��SQL����洢����</param>
 public void ExcuteSqlReturnNull(string strSQL)
 {
     SqlConnection conn = null;
         try
         {
             conn = new SqlConnection(ConfigurationSettings.AppSettings.GetValues("connection")[0]);
             conn.Open();
             SqlCommand comm = new SqlCommand(strSQL, conn);
             comm.ExecuteNonQuery();
             comm.Dispose();
             conn.Close();
             conn.Dispose();
         }
         catch (Exception ex)
         {
             Err MyErr = new Err(ex.Message.ToString());
         }
 }
Пример #3
0
        //������д�ļ�
        public void CreateFile()
        {
            //���Ŀ¼�����ڣ��򴴽�Ŀ¼
            if (!Directory.Exists(strFileRoot))
            {
                Directory.CreateDirectory(strFileRoot);
            }

            //���Ҫ�������ļ������ڣ��򴴽��ļ�
            if (!File.Exists(strFileRoot + "\\" + strFileDateTime + strFileName))
            {
                try
                {

                    FileStream fs = File.Create(strFileRoot+"\\" + strFileDateTime + strFileName);
                    fs.Close();
                    //�����ļ��ɹ�֮�������������ļ���׷������
                    File.AppendAllText(strFileRoot+"\\" + strFileDateTime + strFileName, strContent, Encoding.Default);
                }
                catch (Exception ex)
                {
                    Err e = new Err(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "   " + ex.Message.ToString());
                }
            }
            else
            {
                try
                {
                    //����ļ����ڣ���ֱ��׷��
                    File.AppendAllText(strFileRoot+"\\" + strFileDateTime + strFileName, strContent, Encoding.Default);

                }
                catch (Exception ex)
                {
                    Err MyErr = new Err(ex.Message.ToString());
                }
            }
        }
Пример #4
0
        public void Return_MineID()
        {
            try
            {
                string MineIDPath = Application.StartupPath + "\\config\\mineSystem.xml";

                XmlDocument doc = new XmlDocument();

                doc.Load(MineIDPath);

                XmlNodeList xmlnodelist = doc.FirstChild.NextSibling.ChildNodes;
                for (int x = 0; x < xmlnodelist.Count;x++ )
                {
                    if (x == 0)
                    {
                        MyMineID = xmlnodelist[x].InnerText.ToString();
                    }
                    else
                    {
                        FilePath = xmlnodelist[x].InnerText.ToString();
                    }
                }
                //MyMineID = doc.FirstChild.NextSibling.ChildNodes[0].ChildNodes[0].InnerText.ToString();
                //FilePath = doc.FirstChild.NextSibling.ChildNodes[0].ChildNodes[1].InnerText.ToString();

            }
            catch (Exception ex)
            {
                Err myErr = new Err(ex.Message.ToString());
            }
        }
Пример #5
0
        public void DataProduct()
        {
            string dt = DateTime.Now.ToString("yyyyMMddHHmmss");
            string strStartProcessPath = Application.StartupPath + "\\config";

            if (txtShow.Lines.Length > 27)//��ʾ�ı�����27�о���գ���������
            {
                try
                {
                    string[] strFilePath = Directory.GetFiles(strStartProcessPath);
                    for (int x = 0; x < strFilePath.Length; x++)
                    {
                        if (strFilePath[x].IndexOf("mine.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//����ú����Ϣ�ļ�
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ú����Ϣ�ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("area.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//�������������ļ�
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ���������ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("trackline.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//���ɹ켣�߶����ļ�
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ �켣�߶����ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("person.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//������Ա��Ϣ�ļ�
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ��Ա��Ϣ�ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("track.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//����Ԥ��켣�ļ�
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ Ԥ��켣�ļ�" + Environment.NewLine;
                        }

                    }
                }
                catch (Exception ex)
                {
                    Err myErr = new Err(ex.Message.ToString());
                }
            }
            else
            {
                try
                {
                    string[] strFilePath = Directory.GetFiles(strStartProcessPath);
                    for (int x = 0; x < strFilePath.Length; x++)
                    {
                        if (strFilePath[x].IndexOf("mine.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//����ú����Ϣ�ļ�
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ú����Ϣ�ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("area.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//�������������ļ�
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ���������ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("trackline.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//���ɹ켣�߶����ļ�
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ �켣�߶����ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("person.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//������Ա��Ϣ�ļ�
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ��Ա��Ϣ�ļ�" + Environment.NewLine;
                        }

                        if (strFilePath[x].IndexOf("track.xml") >= 0)
                        {
                            MyXML mxml = new MyXML(strFilePath[x], dt, FilePath);//����Ԥ��켣�ļ�
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ Ԥ��켣�ļ�" + Environment.NewLine;
                        }

                    }
                }
                catch (Exception ex)
                {
                    Err myErr = new Err(ex.Message.ToString());
                }
            }
        }
Пример #6
0
        private void Time5Second_Tick(object sender, EventArgs e)
        {
            try
            {
                //iCount20S++;
                iCount2M++;

                #region��2���Ӷ�ʱ����ʵʱ�����ļ���

                if (iCount2M >= 24)
                {

                    //DO.ReturnDataSet_ExcuteSQL("update Station_Head_Info set StationHeadNO=selfno");
                    if (DO.ReturnDataSet_ExcuteSQL("exec proc_SXLW_SSGC_Select").Tables[0].Rows.Count > 0)
                    {

                        //ʵʱ�����ļ�----ʱ���+RYSS
                        MyDataTable MDT = new MyDataTable(DO.ReturnDataSet_ExcuteSQL("exec proc_SXLW_SSGC").Tables[0], DateTime.Now.ToString("yyyyMMddHHmmss"), "RYSS", "D:\\Location");
                        SetFormMainListBoxMsg(MDT.returnStr);
                        intProcdutCount++;
                        //lblResult.Text = "��ǰ������Ѿ�����ʵʱ�ļ� [ " + intProcdutCount.ToString() + " ] ��";
                    }
                    else
                    {
                        MyDataTable MDT = new MyDataTable(new DataTable(), DateTime.Now.ToString("yyyyMMddHHmmss"), "RYSS", "D:\\Location");
                        intProcdutCount++;
                        SetFormMainListBoxMsg(MDT.returnStr);
                    }
                    iCount2M = 0;
                }
                #endregion

                #region���жϻ�����Ϣ�Ƿ��Ѿ�������ȫ��

                try
                {
                    DO.ReturnDataSet_ExcuteSQL(" declare @MineNOss varchar(30) set @MineNOss=(select distinct( MineNO) from Parameter_Mine) update  Parameter_OverEmployee set MineNO =@MineNOss "
                                                + " update  Parameter_RT_OverTime set MineNO=@MineNOss update  Parameter_SpecialWT_Exception set MineNO=@MineNOss  "
                                                + " update  Parameter_Station_Break set MineNO=@MineNOss update Parameter_TrackLine set MineNO=@MineNOss ");
                    //if (FindFormByName())
                    //{
                    //    return;       //�������ÿ���Ϣ���ݲ�����ʵʱ�ļ�
                    //}

                    dsTemp = DO.ReturnDataSet_ExcuteSQL(" SELECT MineFullName FROM  Parameter_Mine "
                                                    + " SELECT AreaNO from Parameter_Area where AreaNO IS NOT NULL "
                                                    + " SELECT StationName AS ��ϵͳ��վ FROM  Parameter_Station  WHERE  StationNO=NULL OR  StationName NOT IN(SELECT StationName FROM  Parameter_Area_Station ) "
                                                    + " UNION  ALL SELECT StationHeadPlace  AS ��ϵͳ��վ FROM  Station_Head_Info WHERE SelfNO NOT IN (SELECT SerialNumber FROM  Parameter_Station  ) "
                                                    + " SELECT  PersonName FROM dbo.Parameter_Person WHERE  MineNO='' OR  IDCard ='' OR WorkPlace='' OR WorkType=''  OR birthDay IS NULL ");

                    if (dsTemp.Tables[0].Rows.Count < 1 || dsTemp.Tables[0].Rows[0][0].ToString() == "")
                    {
                        if (isMine == false)
                        {
                            Err myErr = new Err(" δ¼�����Ϣ������¼�����Ϣ��--��ʼʱ��" + DateTime.Now.ToString("yyyy-MM-dd HH:ss:mm"));
                            isMine = true;
                            MessageBox.Show("δ¼�����Ϣ������¼�����Ϣ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        // return;
                    }
                    else
                    {
                        isMine = false;
                    }

                    if (dsTemp.Tables[1].Rows.Count < 1)
                    {
                        if (isArea == false)
                        {
                            Err myErr = new Err(" δ����������Ϣ��������������Ϣ��--��ʼʱ��" + DateTime.Now.ToString("yyyy-MM-dd HH:ss:mm"));
                            isArea = true;
                            MessageBox.Show("δ����������Ϣ��������������Ϣ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        // return;
                    }
                    else
                    {
                        isArea = false;
                    }

                    if (dsTemp.Tables[2].Rows.Count > 0)
                    {
                        if (isStat == false)
                        {
                            Err myErr = new Err(" ��վ��Ϣ���ò�ȫ�������÷�վ��Ϣ��--��ʼʱ��" + DateTime.Now.ToString("yyyy-MM-dd HH:ss:mm"));
                            isStat = true;
                            MessageBox.Show(" ��վ��Ϣ���ò�ȫ�������÷�վ��Ϣ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        //return;
                    }
                    else
                    {
                        isStat = false;
                    }

                    if (dsTemp.Tables[3].Rows.Count > 0)
                    {

                        if (isPeople == false)
                        {
                            Err myErr = new Err(" ��Ա��Ϣ���ò�ȫ����������Ա��Ϣ��--��ʼʱ��" + DateTime.Now.ToString("yyyy-MM-dd HH:ss:mm"));/////
                            isPeople = true;
                            MessageBox.Show("��Ա��Ϣ���ò�ȫ����������Ա��Ϣ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        // return;
                    }
                    else
                    {
                        isPeople = false;
                    }

                }
                catch
                {
                    Err myErr = new Err("����ʵʱ����ǰ�жϴ���");
                }
                #endregion

                DO.ReturnDataSet_ExcuteSQL(" Proc_SXLW_GZYC_ADD ");

                DO.ReturnDataSet_ExcuteSQL(" IF EXISTS( SELECT 1 FROM Parameter_SpecialWT_Exception WHERE  DATEDIFF(ss, CheckReachStationTime,GETDATE()) >0 and DATEDIFF(ss, CheckReachStationTime,GETDATE()) <6 ) "
            + " BEGIN update  Parameter_SpecialWT_Exception SET  IsRead=0 WHERE state='�ٵ�' OR (DATEDIFF(ss, CheckReachStationTime,GETDATE()) >=0 OR state='δ��') END ");

                //5������ϵͳ�����쳣�ļ�

                #region��5������ϵͳ�����쳣�ļ���

                //*******Czlt-2011-07-10**������վ���ϱ���*XTYC-ϵͳ�쳣****************************

                int tempCount = DO.ReturnDataSet_ExcuteSQL("Proc_SXLW_XTYC_Select").Tables[0].Rows.Count;
                if (tempCount > 0)
                {
                    //DataSet dsStnNO = DO.ReturnDataSet_ExcuteSQL(" select StationNO from Parameter_Station_Break PSB where PSB.IsRead = 0  order by StationNO ");
                    if (_stnLastCount == tempCount)
                    {
                        //ϵͳ�����쳣�ļ�-----ʱ���+RYYC
                        MyDataTable mt = new MyDataTable(DO.ReturnDataSet_ExcuteSQL("Proc_SXLW_XTYC").Tables[0], DateTime.Now.ToString("yyyyMMddHHmmss"), "RYYC", "D:\\Location");
                        intProcdutCount++;
                        SetFormMainListBoxMsg(mt.returnStr);
                        //lblResult.Text = "��ǰ������Ѿ�����ʵʱ�ļ� [ " + intProcdutCount.ToString() + " ] ��";
                    }
                }
                _stnLastCount = tempCount;

                #endregion

                //20������ʵʱ�ļ�

                #region��5������ʵʱ�ļ���

                //***************Czlt-2011-07-10 ��ʱ��������****************Start****************

                int rtOver = Convert.ToInt32(DO.ReturnDataSet_ExcuteSQL("Select count(1) from Parameter_RT_OverTime where OverTimeEndTime is null").Tables[0].Rows[0][0].ToString());
                if (rtOverTime != rtOver)
                {
                    if (DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCS_Select") != null && DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCS_Select").Tables.Count > 0)
                    {
                        if (DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCS_Select").Tables[0].Rows.Count > 0)
                        {
                            //��ʱ�����ļ�-----ʱ���+RYSC

                            MyDataTable MYT = new MyDataTable(DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCS").Tables[0], DateTime.Now.ToString("yyyyMMddHHmmss"), "RYCS", "D:\\Location");
                            intProcdutCount++;
                            SetFormMainListBoxMsg(MYT.returnStr);
                            //lblResult.Text = "��ǰ������Ѿ�����ʵʱ�ļ� [ " + intProcdutCount.ToString() + " ] ��";
                        }

                    }
                    rtOverTime = rtOver;
                }

                //***************Czlt-2011-07-10 ��ʱ��������****************End******************

                int InOut = Convert.ToInt32(DO.ReturnDataSet_ExcuteSQL("Select count(1) from parameter_OverEmployee where AlarmEndTime is null").Tables[0].Rows[0][0].ToString());
                if (InOut != dtInOutMine)
                {
                    if (DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCY_Select").Tables[0].Rows.Count > 0)
                    {

                        //��Ա/�����������򱨾��ļ�-----ʱ���+RYCY

                        MyDataTable mdt = new MyDataTable(DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_SSCY").Tables[0], DateTime.Now.ToString("yyyyMMddHHmmss"), "RYCYXZ", "D:\\Location");
                        intProcdutCount++;
                        SetFormMainListBoxMsg(mdt.returnStr);
                        //lblResult.Text = "��ǰ������Ѿ�����ʵʱ�ļ� [ " + intProcdutCount.ToString() + " ] ��";
                    }
                    dtInOutMine = InOut;
                }
                if (DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_GZYC_Select").Tables[0].Rows.Count > 0)
                {
                    //������ҵ��Ա�����쳣-----ʱ���+RYTZ
                    MyDataTable md = new MyDataTable(DO.ReturnDataSet_ExcuteSQL("exec Proc_SXLW_GZYC").Tables[0], DateTime.Now.ToString("yyyyMMddHHmmss"), "RYTZYC", "D:\\Location");
                    intProcdutCount++;
                    SetFormMainListBoxMsg(md.returnStr);
                    //lblResult.Text = "��ǰ������Ѿ�����ʵʱ�ļ� [ " + intProcdutCount.ToString() + " ] ��";
                }

                #endregion
            }
            catch
            {
                //*********************Czlt-2011-05-19 ���ݿ����Ӳ���*Start****************************************
                try
                {
                    strMessage = DO.CheckConIsOpen();
                    lblMessage.Text = strMessage;
                }
                catch
                {
                    lblMessage.Text = "���ݿ������쳣������������Ϣ��";
                    //*******Czlt-2011-05-05 ȡ����¼����********

                    this.MainPanel.Visible = true;

                    IsLogin = true;

                    return;
                }
                //*******************Czlt-2011-05-19 ���ݿ����Ӳ���*End*****************************************
            }
        }
Пример #7
0
        public void GetStationFile()
        {
            string strStartProcessPath = Application.StartupPath + "\\config";
            string dt = DateTime.Now.ToString("yyyyMMddHHmmss");

            if (txtShow.Lines.Length > 27)//��ʾ�ı�����27�о���գ���������
            {
                try
                {
                    string[] strFilePath = Directory.GetFiles(strStartProcessPath);
                    for (int x = 0; x < strFilePath.Length; x++)
                    {
                        if (strFilePath[x].IndexOf("station.xml") >= 0)
                        {
                            MyXMLToDataSet mxml = new MyXMLToDataSet(strFilePath[x], dt, FilePath);//ʱʱ���·�վ������Ϣ
                            txtShow.Text = "";
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ��վ/�켣�������ļ�" + Environment.NewLine;
                        }
                    }
                }
                catch (Exception ex)
                {
                    Err myErr = new Err(ex.Message.ToString());
                }
            }
            else
            {
                try
                {
                    string[] strFilePath = Directory.GetFiles(strStartProcessPath);
                    for (int x = 0; x < strFilePath.Length; x++)
                    {
                        if (strFilePath[x].IndexOf("station.xml") >= 0)
                        {
                            MyXMLToDataSet mxml = new MyXMLToDataSet(strFilePath[x], dt, FilePath);//ʱʱ���·�վ������Ϣ
                            txtShow.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "  ������������ ��վ/�켣�������ļ�" + Environment.NewLine;
                        }
                    }
                }
                catch (Exception ex)
                {
                    Err myErr = new Err(ex.Message.ToString());
                }
            }
        }
Пример #8
0
        public int RunProcedure(string storedProcName, IDataParameter[] parameters)
        {
            int intRowsCount = 0;
            using (SqlConnection connection = new SqlConnection(StrConnection))
            {
                try
                {
                    connection.Open();
                    SqlCommand command = BuildIntCommand(connection, storedProcName, parameters);
                    intRowsCount = command.ExecuteNonQuery();

                    connection.Close();

                    command.Dispose();
                    connection.Dispose();
                }
                catch (Exception ex)
                {
                    Err err = new Err(storedProcName + ": " + ex.Message.ToString());
                }
            }
            return intRowsCount;
        }
Пример #9
0
        public int ReturnInt_ExcuteSQL(string strSQL)
        {
            int intI = 0;

            try
            {
                SqlConnection conn = new SqlConnection(StrConnection);

                conn.Open();

                SqlCommand comm = new SqlCommand(strSQL, conn);

                intI = comm.ExecuteNonQuery();

                comm.Dispose();

                conn.Close();

                conn.Dispose();
            }
            catch (Exception EX)
            {
                Err err = new Err(strSQL + ": " + EX.Message.ToString());
            }

            return intI;
        }
Пример #10
0
        public DataSet ReturnDataSet_ExcuteSQL(string strSQL)
        {
            //������ݿ�����״̬
            string strIsCon = CheckConIsOpen();
            DataSet ds = new DataSet();
            if (!strIsCon.Trim().Equals("���ݿ������쳣��"))
            {
                try
                {
                    SqlConnection conn = new SqlConnection(StrConnection);
                    SqlDataAdapter sda = new SqlDataAdapter(strSQL, conn);

                    sda.Fill(ds);

                    sda.Dispose();

                }
                catch (Exception EX)
                {
                    Err err = new Err(strSQL + ": " + EX.Message.ToString());
                }
            }

            return ds;
        }
Пример #11
0
        public DataSet GetUserPassWord(string UserName)
        {
            DataSet ds = new DataSet();

            try
            {
                SqlConnection conn = new SqlConnection(StrConnection);
                string strSql = "select password from admins where Account='" + UserName + "'";
                SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);

                sda.Fill(ds);

                sda.Dispose();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                Err err = new Err(UserName + ": " + ex.Message.ToString());
            }

            return ds;
        }
Пример #12
0
        /// <summary>
        /// ��ȡú�������Ϣ
        /// </summary>
        /// <returns></returns>
        public DataSet GetMineInfo()
        {
            //������ݿ�����״̬
            string strIsCon = CheckConIsOpen();

            DataSet ds = new DataSet();
            if (!strIsCon.Trim().Equals("���ݿ������쳣��"))
            {

                string strSql = "select * from parameter_Mine";

                try
                {
                    SqlConnection conn = new SqlConnection(StrConnection);

                    SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);

                    sda.Fill(ds);

                    sda.Dispose();

                }
                catch (Exception ex)
                {
                    Err err = new Err(strSql + ": " + ex.Message.ToString());
                }
            }

            return ds;
        }