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