public static BG_Unit_Dbbak AddBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { string sql = "INSERT BG_Unit_Dbbak (DbName, DbCreationTime)" + "VALUES (@DbName, @DbCreationTime)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DbName", bG_Unit_Dbbak.DbName), new SqlParameter("@DbCreationTime", bG_Unit_Dbbak.DbCreationTime) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return GetBG_Unit_DbbakByDbID(newId); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { return BG_Unit_DbbakService.ModifyBG_Unit_Dbbak(bG_Unit_Dbbak); }
public static bool DeleteBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { return BG_Unit_DbbakService.DeleteBG_Unit_Dbbak(bG_Unit_Dbbak); }
public static BG_Unit_Dbbak AddBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { return BG_Unit_DbbakService.AddBG_Unit_Dbbak(bG_Unit_Dbbak); }
public static BG_Unit_Dbbak GetBG_Unit_DbbakByDbID(int dbID) { string sql = "SELECT * FROM BG_Unit_Dbbak WHERE DbID = @DbID"; try { SqlParameter para = new SqlParameter("@DbID", dbID); DataTable dt = DBUnity.AdapterToTab(sql, para); if(dt.Rows.Count > 0) { BG_Unit_Dbbak bG_Unit_Dbbak = new BG_Unit_Dbbak(); bG_Unit_Dbbak.DbID = dt.Rows[0]["DbID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DbID"]; bG_Unit_Dbbak.DbName = dt.Rows[0]["DbName"] == DBNull.Value ? "" : (string)dt.Rows[0]["DbName"]; bG_Unit_Dbbak.DbCreationTime = dt.Rows[0]["DbCreationTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["DbCreationTime"]; return bG_Unit_Dbbak; } else { return null; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool DeleteBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { return DeleteBG_Unit_DbbakByDbID( bG_Unit_Dbbak.DbID ); }
public static bool ModifyBG_Unit_Dbbak(BG_Unit_Dbbak bG_Unit_Dbbak) { string sql = "UPDATE BG_Unit_Dbbak " + "SET " + "DbName = @DbName, " + "DbCreationTime = @DbCreationTime " + "WHERE DbID = @DbID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DbID", bG_Unit_Dbbak.DbID), new SqlParameter("@DbName", bG_Unit_Dbbak.DbName), new SqlParameter("@DbCreationTime", bG_Unit_Dbbak.DbCreationTime) }; int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para); if(t>0) { return true; } else { return false; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
protected void btnWinAdd_DirectClick(object sender, DirectEventArgs e) { string dbFileName = ""; dbFileName = AdName.Text; string sql = " CREATE DATABASE {0}" + " DECLARE @sql NVARCHAR (MAX)" + " DECLARE @sql1 NVARCHAR (MAX)" + " DECLARE @sql2 NVARCHAR (MAX)" + " DECLARE @i int" + " DECLARE @tabname NVARCHAR (MAX)" + " set @i=1" + " while @i<=(select count(tab.name) from SysObjects as tab where xtype='u' and name not like '%_Unit_%' )" + " begin" + " set @tabname=(select top(1) * from (select top(@i) tab.name from SysObjects as tab where xtype='u' and name not like" + " '%_Unit_%' order by name asc) as a order by name desc)" + " SET @sql1 = 'select * into {0}.[dbo].'+@tabname+' from ' +@tabname " + " SET @sql2 = 'drop table {0}.[dbo].'+@tabname + @sql1 " + " SET @sql = ''if object_id(N'{0}.[dbo].'+@tabname+'',N'U') is not null EXEC(@sql2) else EXEC(@sql1) " + " EXEC(@sql); " + " set @i= @i+1 " + " end "; sql = string.Format(sql, dbFileName); int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, null); if (t > 0) { BG_Unit_Dbbak dbbak = new BG_Unit_Dbbak(); dbbak.DbName = dbFileName; dbbak.DbCreationTime = DateTime.Now; if (BG_Unit_DbbakService.AddBG_Unit_Dbbak(dbbak).DbID > 0) { X.Msg.Confirm("系统提示", "备份成功!", new MessageBoxButtonsConfig { Yes = new MessageBoxButtonConfig { Handler = "SS.DoYesSSS()", Text = "确定" } }).Show(); } } }