/// <summary> /// ���£������룩 /// </summary> /// <param name="����ϵͳ"></param> public static void UpDate����ϵͳ(Def_����ϵͳ ����ϵͳ) { string InsertSQL = "UPDATE [New����ϵͳ] " + " SET " + " [��ѹ��] = '" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "'" + " ,[��ѹ��λ��] = '" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "'" + " ,[�������] = '" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "'" + " ,[�����] = '" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "'" + " ,[�����µ�����ֵ] = '" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "'" + " ,[���ص���] = '" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "'" + " ,[��ѹ��·����] = '" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "'" + " ,[���緽ʽ] = '" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "'" + " ,[������λ��] = '" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "'" + " ,[�����������] = '" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "'" + " ,[���ص�Դ��] = '" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "'" + " ,[����ģ����] = '" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "'" + " ,[����ģ����] = '" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "'" + " ,[�տ������] = '" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "'" + " ,[��ӿ����] = '" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "'" + " ,[��ӿ�ͺ�] = '" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "'" + " ,[��ͷ��ͷλ��] = '" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "'" + " ,[ģ���ͺ�] = '" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "'" + " ,[�ܷ�] = '" + ����ϵͳ.B�ܷ�.ToString().Replace("'", "''") + "'" + " ,[�豸] = '" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "'" + " ,[�豸����1] = '" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "'" + " ,[�豸����2] = '" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "'" + " ,[�豸����3] = '" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "'" + " ,[�豸λ��1] = '" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "'" + " ,[�豸λ��2] = '" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "'" + " ,[�豸λ��3] = '" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "'" + " ,[�豸�ͺ�1] = '" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "'" + " ,[�豸�ͺ�2] = '" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "'" + " ,[�豸�ͺ�3] = '" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "'" + " ,[ʹ�ÿտ���] = '" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "'" + " ,[�Ƿ�������ӿ] = '" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "'" + " ,[�Ƿ�����ͷ��ͷ] = '" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "'" + " ,[���пտ���] = '" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "'" + " ,[����] = '" + ����ϵͳ.B����.ToString().Replace("'", "''") + "'" + " ,[����ʹ�����] = '" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "'" + " ,[һ���µ�����ֵ] = '" + ����ϵͳ.Bһ���µ�����ֵ.ToString().Replace("'", "''") + "'" + " WHERE [basedateID] ='" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "'"; string UpDateSQL = "INSERT INTO [New����ϵͳ] " + " ([basedateID] " + " ,[��ѹ��] " + " ,[��ѹ��λ��] " + " ,[�������] " + " ,[�����] " + " ,[�����µ�����ֵ] " + " ,[���ص���] " + " ,[��ѹ��·����] " + " ,[���緽ʽ] " + " ,[������λ��] " + " ,[�����������] " + " ,[���ص�Դ��] " + " ,[����ģ����] " + " ,[����ģ����] " + " ,[�տ������] " + " ,[��ӿ����] " + " ,[��ӿ�ͺ�] " + " ,[��ͷ��ͷλ��] " + " ,[ģ���ͺ�] " + " ,[�ܷ�] " + " ,[�豸] " + " ,[�豸����1] " + " ,[�豸����2] " + " ,[�豸����3] " + " ,[�豸λ��1] " + " ,[�豸λ��2] " + " ,[�豸λ��3] " + " ,[�豸�ͺ�1] " + " ,[�豸�ͺ�2] " + " ,[�豸�ͺ�3] " + " ,[ʹ�ÿտ���] " + " ,[�Ƿ�������ӿ] " + " ,[�Ƿ�����ͷ��ͷ] " + " ,[���пտ���] " + " ,[����] " + " ,[����ʹ�����] " + " ,[һ���µ�����ֵ]) " + " VALUES " + " ('" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�ܷ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.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="����ϵͳ"></param> public static void Insert����ϵͳ(Def_����ϵͳ ����ϵͳ) { string sql = "INSERT INTO [New����ϵͳ] " + " ([basedateID] " + " ,[��ѹ��] " + " ,[��ѹ��λ��] " + " ,[�������] " + " ,[�����] " + " ,[�����µ�����ֵ] " + " ,[���ص���] " + " ,[��ѹ��·����] " + " ,[���緽ʽ] " + " ,[������λ��] " + " ,[�����������] " + " ,[���ص�Դ��] " + " ,[����ģ����] " + " ,[����ģ����] " + " ,[�տ������] " + " ,[��ӿ����] " + " ,[��ӿ�ͺ�] " + " ,[��ͷ��ͷλ��] " + " ,[ģ���ͺ�] " + " ,[�ܷ�] " + " ,[�豸] " + " ,[�豸����1] " + " ,[�豸����2] " + " ,[�豸����3] " + " ,[�豸λ��1] " + " ,[�豸λ��2] " + " ,[�豸λ��3] " + " ,[�豸�ͺ�1] " + " ,[�豸�ͺ�2] " + " ,[�豸�ͺ�3] " + " ,[ʹ�ÿտ���] " + " ,[�Ƿ�������ӿ] " + " ,[�Ƿ�����ͷ��ͷ] " + " ,[���пտ���] " + " ,[����] " + " ,[����ʹ�����] " + " ,[һ���µ�����ֵ]) " + " VALUES " + " ('" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�ܷ�.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "' " + ",'" + ����ϵͳ.Bһ���µ�����ֵ.ToString().Replace("'", "''") + "') "; SQLExecute.ExecuteNonQuery(sql); }