/// <summary>
        /// ����
        /// </summary>
        /// <param name="BSinfo"></param>
        public static void UpDateBS_basedate(BS_basedate bs_datedate)
        {
            string InsertSQL =
              "UPDATE  [BS_basedate] " +
            "   SET " +
            "      [�] ='" + bs_datedate.B�.ToString().Replace("'", "''") + "'" +
            "      ,[�������A] ='" + bs_datedate.B�������A.ToString().Replace("'", "''") + "'" +
            "      ,[����A] ='" + bs_datedate.B����A.ToString().Replace("'", "''") + "'" +
            "      ,[����A] ='" + bs_datedate.B����A.ToString().Replace("'", "''") + "'" +
            "      ,[��������A] ='" + bs_datedate.B��������A.ToString().Replace("'", "''") + "'" +
            "      ,[ָ��A] ='" + bs_datedate.Bָ��A.ToString().Replace("'", "''") + "'" +
            "      ,[�������C] ='" + bs_datedate.B�������C.ToString().Replace("'", "''") + "'" +
            "      ,[����C] ='" + bs_datedate.B����C.ToString().Replace("'", "''") + "'" +
            "      ,[����C] ='" + bs_datedate.B����C.ToString().Replace("'", "''") + "'" +
            "      ,[��������C] ='" + bs_datedate.B��������C.ToString().Replace("'", "''") + "'" +
            "      ,[ָ��C] ='" + bs_datedate.Bָ��C.ToString().Replace("'", "''") + "'" +
            "      ,[�������B] ='" + bs_datedate.B�������B.ToString().Replace("'", "''") + "'" +
            "      ,[����B] ='" + bs_datedate.B����B.ToString().Replace("'", "''") + "'" +
            "      ,[����B] ='" + bs_datedate.B����B.ToString().Replace("'", "''") + "'" +
            "      ,[��������B] ='" + bs_datedate.B��������B.ToString().Replace("'", "''") + "'" +
            "      ,[ָ��B] ='" + bs_datedate.Bָ��B.ToString().Replace("'", "''") + "'" +
            "      ,[����] ='" + bs_datedate.B����.ToString().Replace("'", "''") + "'" +
            "      ,[��վ����] ='" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            "      ,[��ַ] ='" + bs_datedate.B��ַ.ToString().Replace("'", "''") + "'" +
            "      ,[��վ����] ='" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            "      ,[��������] ='" + bs_datedate.B��������.ToString().Replace("'", "''") + "'" +
            "      ,[��վ����] ='" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            "      ,[��Ȩ] ='" + bs_datedate.B��Ȩ.ToString().Replace("'", "''") + "'" +
            "      ,[��վ��] ='" + bs_datedate.B��վ��.ToString().Replace("'", "''") + "'" +
            "      ,[��Ȩ����] ='" + bs_datedate.B��Ȩ����.ToString().Replace("'", "''") + "'" +
            "      ,[�����ز�����] ='" + bs_datedate.B�����ز�����.ToString().Replace("'", "''") + "'" +
            "      ,[DO�ز�����] ='" + bs_datedate.BDO�ز�����.ToString().Replace("'", "''") + "'" +
            "      ,[CELLTD] ='" + bs_datedate.BCELLTD.ToString().Replace("'", "''") + "'" +
            "      ,[�ز����] ='" + bs_datedate.B�ز����.ToString().Replace("'", "''") + "'" +
            "      ,[�����ز����] ='" + bs_datedate.B�����ز����.ToString().Replace("'", "''") + "'" +
            "      ,[���߹Ҹ�] ='" + bs_datedate.B���߹Ҹ�.ToString().Replace("'", "''") + "'" +
            "      ,[PN] ='" + bs_datedate.BPN.ToString().Replace("'", "''") + "'" +
            "      ,[���߷�ֹλ��] ='" + bs_datedate.B���߷�ֹλ��.ToString().Replace("'", "''") + "'" +
            "      ,[ʵ�ʻ�����] ='" + bs_datedate.Bʵ�ʻ�����.ToString().Replace("'", "''") + "'" +
            "      ,[��ƻ�����] ='" + bs_datedate.B��ƻ�����.ToString().Replace("'", "''") + "'" +
            "      ,[��չ�û�����] ='" + bs_datedate.B��չ�û�����.ToString().Replace("'", "''") + "'" +
            "      ,[�ŵ���] ='" + bs_datedate.B�ŵ���.ToString().Replace("'", "''") + "'" +
            "      ,[LAC���] ='" + bs_datedate.BLAC���.ToString().Replace("'", "''") + "'" +
            "      ,[����BSC����] ='" + bs_datedate.B����BSC����.ToString().Replace("'", "''") + "'" +
            "      ,[�ŵ�������] ='" + bs_datedate.B�ŵ�������.ToString().Replace("'", "''") + "'" +
            " WHERE [basedateID] ='" + bs_datedate.BasedateID.ToString().Replace("'", "''") + "'";

            string UpDateSQL =
            "INSERT INTO  [BS_basedate] " +
            "     ([basedateID] " +
            "     ,[�] " +
            "     ,[�������A] " +
            "     ,[����A] " +
            "     ,[����A] " +
            "     ,[��������A] " +
            "     ,[ָ��A] " +
            "     ,[�������C] " +
            "     ,[����C] " +
            "     ,[����C] " +
            "     ,[��������C] " +
            "     ,[ָ��C] " +
            "     ,[�������B] " +
            "     ,[����B] " +
            "     ,[����B] " +
            "     ,[��������B] " +
            "     ,[ָ��B] " +
            "     ,[����] " +
            "     ,[��վ����] " +
            "     ,[��ַ] " +
            "     ,[��վ����] " +
            "     ,[��������] " +
            "     ,[��վ����] " +
            "     ,[��Ȩ] " +
            "     ,[��վ��] " +
            "     ,[��Ȩ����] " +
            "     ,[�����ز�����] " +
            "     ,[DO�ز�����] " +
            "     ,[CELLTD] " +
            "     ,[�ز����] " +
            "     ,[�����ز����] " +
            "     ,[���߹Ҹ�] " +
            "     ,[PN] " +
            "     ,[���߷�ֹλ��] " +
            "     ,[ʵ�ʻ�����] " +
            "     ,[��ƻ�����] " +
            "     ,[��չ�û�����] " +
            "     ,[�ŵ���] " +
            "     ,[LAC���] " +
            "     ,[����BSC����] " +
            "     ,[�ŵ�������]) " +
            "     VALUES " +
            " ('" + bs_datedate.BasedateID.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�������A.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����A.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����A.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��������A.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.Bָ��A.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�������C.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����C.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����C.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��������C.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.Bָ��C.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�������B.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����B.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����B.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��������B.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.Bָ��B.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��ַ.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��������.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��Ȩ.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��վ��.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��Ȩ����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�����ز�����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.BDO�ز�����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.BCELLTD.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�ز����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�����ز����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B���߹Ҹ�.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.BPN.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B���߷�ֹλ��.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.Bʵ�ʻ�����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��ƻ�����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B��չ�û�����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�ŵ���.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.BLAC���.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B����BSC����.ToString().Replace("'", "''") + "'" +
            ",'" + bs_datedate.B�ŵ�������.ToString().Replace("'", "''") + "')";
            string strSQL = null;
            strSQL += InsertSQL;//= string.Format("Update S_RoleDetail set [Power]='{0}'  where [RoleID]='{1}' and ProgramID  ='{2}'", dt.Rows[i][1].ToString().Replace("'", "''"), dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"));
            strSQL = strSQL + " if @@RowCount=0 ";
            strSQL = strSQL + UpDateSQL;//string.Format("Insert into S_RoleDetail ([RoleID],[ProgramID],[Power]) values ('{0}','{1}','{2}')", dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"), dt.Rows[i][1].ToString().Replace("'", "''"));

            SQLExecute.ExecuteNonQuery(strSQL);
        }
        /// <summary>
        /// ��ѯ
        /// </summary>
        /// <param name="BasedateID"></param>
        /// <returns></returns>
        public static BS_basedate GetBS_basedateByBasedateID(string BasedateID)
        {
            BS_basedate bs_datedate = new BS_basedate(BasedateID);

            string sql = "SELECT [basedateID] " +
            "      ,[�] " +
            "      ,[�������A] " +
            "      ,[����A] " +
            "      ,[����A] " +
            "      ,[��������A] " +
            "      ,[ָ��A] " +
            "      ,[�������C] " +
            "      ,[����C] " +
            "      ,[����C] " +
            "      ,[��������C] " +
            "      ,[ָ��C] " +
            "      ,[�������B] " +
            "      ,[����B] " +
            "      ,[����B] " +
            "      ,[��������B] " +
            "      ,[ָ��B] " +
            "      ,[����] " +
            "      ,[��վ����] " +
            "      ,[��ַ] " +
            "      ,[��վ����] " +
            "      ,[��������] " +
            "      ,[��վ����] " +
            "      ,[��Ȩ] " +
            "      ,[��վ��] " +
            "      ,[��Ȩ����] " +
            "      ,[�����ز�����] " +
            "      ,[DO�ز�����] " +
            "      ,[CELLTD] " +
            "      ,[�ز����] " +
            "      ,[�����ز����] " +
            "      ,[���߹Ҹ�] " +
            "      ,[PN] " +
            "      ,[���߷�ֹλ��] " +
            "      ,[ʵ�ʻ�����] " +
            "      ,[��ƻ�����] " +
            "      ,[��չ�û�����] " +
            "      ,[�ŵ���] " +
            "      ,[LAC���] " +
            "      ,[����BSC����] " +
            "      ,[�ŵ�������] " +
            "  FROM  [BS_basedate] where basedateID = '" + BasedateID.ToString().Replace("'", "''") + "'";

            DataTable dt = new DataTable("BaseStationDB");
            SQLExecute.Convertdrtodt(SQLExecute.ExecuteReader(sql), dt);
            if (dt.Rows.Count == 0)
            {
                bs_datedate = new BS_basedate(BasedateID);
            }
            else
            {
                bs_datedate.BasedateID = dt.Rows[0]["BasedateID"].ToString();
                bs_datedate.B� = dt.Rows[0]["�"].ToString();
                bs_datedate.B�������A = dt.Rows[0]["�������A"].ToString();
                bs_datedate.B����A = dt.Rows[0]["����A"].ToString();
                bs_datedate.B����A = dt.Rows[0]["����A"].ToString();
                bs_datedate.B��������A = dt.Rows[0]["��������A"].ToString();
                bs_datedate.Bָ��A = dt.Rows[0]["ָ��A"].ToString();
                bs_datedate.B�������C = dt.Rows[0]["�������C"].ToString();
                bs_datedate.B����C = dt.Rows[0]["����C"].ToString();
                bs_datedate.B����C = dt.Rows[0]["����C"].ToString();
                bs_datedate.B��������C = dt.Rows[0]["��������C"].ToString();
                bs_datedate.Bָ��C = dt.Rows[0]["ָ��C"].ToString();
                bs_datedate.B�������B = dt.Rows[0]["�������B"].ToString();
                bs_datedate.B����B = dt.Rows[0]["����B"].ToString();
                bs_datedate.B����B = dt.Rows[0]["����B"].ToString();
                bs_datedate.B��������B = dt.Rows[0]["��������B"].ToString();
                bs_datedate.Bָ��B = dt.Rows[0]["ָ��B"].ToString();
                bs_datedate.B���� = dt.Rows[0]["����"].ToString();
                bs_datedate.B��վ���� = dt.Rows[0]["��վ����"].ToString();
                bs_datedate.B��ַ = dt.Rows[0]["��ַ"].ToString();
                bs_datedate.B��վ���� = dt.Rows[0]["��վ����"].ToString();
                bs_datedate.B�������� = dt.Rows[0]["��������"].ToString();
                bs_datedate.B��վ���� = dt.Rows[0]["��վ����"].ToString();
                bs_datedate.B��Ȩ = dt.Rows[0]["��Ȩ"].ToString();
                bs_datedate.B��վ�� = dt.Rows[0]["��վ��"].ToString();
                bs_datedate.B��Ȩ���� = dt.Rows[0]["��Ȩ����"].ToString();
                bs_datedate.B�����ز����� = dt.Rows[0]["�����ز�����"].ToString();
                bs_datedate.BDO�ز����� = dt.Rows[0]["DO�ز�����"].ToString();
                bs_datedate.BCELLTD = dt.Rows[0]["CELLTD"].ToString();
                bs_datedate.B�ز���� = dt.Rows[0]["�ز����"].ToString();
                bs_datedate.B�����ز���� = dt.Rows[0]["�����ز����"].ToString();
                bs_datedate.B���߹Ҹ� = dt.Rows[0]["���߹Ҹ�"].ToString();
                bs_datedate.BPN = dt.Rows[0]["PN"].ToString();
                bs_datedate.B���߷�ֹλ�� = dt.Rows[0]["���߷�ֹλ��"].ToString();
                bs_datedate.Bʵ�ʻ����� = dt.Rows[0]["ʵ�ʻ�����"].ToString();
                bs_datedate.B��ƻ����� = dt.Rows[0]["��ƻ�����"].ToString();
                bs_datedate.B��չ�û����� = dt.Rows[0]["��չ�û�����"].ToString();
                bs_datedate.B�ŵ��� = dt.Rows[0]["�ŵ���"].ToString();
                bs_datedate.BLAC��� = dt.Rows[0]["LAC���"].ToString();
                bs_datedate.B����BSC���� = dt.Rows[0]["����BSC����"].ToString();
                bs_datedate.B�ŵ������� = dt.Rows[0]["�ŵ�������"].ToString();
            }
            return bs_datedate;
        }
 /// <summary>
 /// ����[������IJ��� �����ַ�û����]
 /// </summary>
 /// <param name="bs_datedate"></param>
 public static void InsertBS_basedate(BS_basedate bs_datedate)
 {
     string sql =
     "INSERT INTO  [BS_basedate] " +
     "     ([basedateID] " +
     "     ,[�] " +
     "     ,[�������A] " +
     "     ,[����A] " +
     "     ,[����A] " +
     "     ,[��������A] " +
     "     ,[ָ��A] " +
     "     ,[�������C] " +
     "     ,[����C] " +
     "     ,[����C] " +
     "     ,[��������C] " +
     "     ,[ָ��C] " +
     "     ,[�������B] " +
     "     ,[����B] " +
     "     ,[����B] " +
     "     ,[��������B] " +
     "     ,[ָ��B] " +
     "     ,[����] " +
     "     ,[��վ����] " +
     "     ,[��ַ] " +
     "     ,[��վ����] " +
     "     ,[��������] " +
     "     ,[��վ����] " +
     "     ,[��Ȩ] " +
     "     ,[��վ��] " +
     "     ,[��Ȩ����] " +
     "     ,[�����ز�����] " +
     "     ,[DO�ز�����] " +
     "     ,[CELLTD] " +
     "     ,[�ز����] " +
     "     ,[�����ز����] " +
     "     ,[���߹Ҹ�] " +
     "     ,[PN] " +
     "     ,[���߷�ֹλ��] " +
     "     ,[ʵ�ʻ�����] " +
     "     ,[��ƻ�����] " +
     "     ,[��չ�û�����] " +
     "     ,[�ŵ���] " +
     "     ,[LAC���] " +
     "     ,[����BSC����] " +
     "     ,[�ŵ�������]) " +
     "     VALUES " +
     " ('" + bs_datedate.BasedateID.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�������A.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����A.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����A.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��������A.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.Bָ��A.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�������C.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����C.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����C.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��������C.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.Bָ��C.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�������B.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����B.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����B.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��������B.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.Bָ��B.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��ַ.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��������.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��վ����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��Ȩ.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��վ��.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��Ȩ����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�����ز�����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.BDO�ز�����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.BCELLTD.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�ز����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�����ز����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B���߹Ҹ�.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.BPN.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B���߷�ֹλ��.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.Bʵ�ʻ�����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��ƻ�����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B��չ�û�����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�ŵ���.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.BLAC���.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B����BSC����.ToString().Replace("'", "''") + "' " +
     ",'" + bs_datedate.B�ŵ�������.ToString().Replace("'", "''") + "')";
     SQLExecute.ExecuteNonQuery(sql);
 }