資源簡介
C#寫的年會抽獎(jiǎng)軟件包含源代碼
代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
using?System.Data.OleDb;
using?System.Text;
using?System.Windows.Forms;
///?
///?DataAccess?為數(shù)據(jù)庫操作等全局定義的一些類
///?
public?class?DataAccess
{
????public?DataAccess()
????{
????}
????public?static?bool?DataIsChange;
????#region?配置數(shù)據(jù)庫連接字符串
????///?
????///?獲取C/S系統(tǒng)根目錄
????///?
????public?static?string?SysRootPath()
????{
????????string?resultPath?=?string.Empty;
????????string?sysPath?=?Application.StartupPath;
????????if?(sysPath.LastIndexOf(“bin“)?>?0)
????????{
????????????resultPath?=?sysPath.Substring(0?sysPath.LastIndexOf(“bin“));
????????}
????????else
????????{
????????????resultPath?=?sysPath;
????????}
????????return?resultPath;
????}
????///?
????///?配置數(shù)據(jù)庫連接字符串
????///?
????private?static?string?ConnectionString?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?System.Environment.CurrentDirectory?+?“\\data\\LD.mdb;Persist?Security?Info=False;Jet?OLEDB:Database?Password=shiyanexperiment;“;
????#endregion
????#region??執(zhí)行SQL語句,返回Bool值
????///?
????///?執(zhí)行SQL語句,返回Bool值
????///?
????///?要執(zhí)行的SQL語句
????///?返回BOOL值,True為執(zhí)行成功
????public?bool?ExecuteSQL(string?sql)
????{
????????OleDbConnection?con?=?new?OleDbConnection(ConnectionString);
????????OleDbCommand?cmd?=?new?OleDbCommand(sql?con);
????????try
????????{
????????????con.Open();
????????????cmd.ExecuteNonQuery();
????????????return?true;
????????}
????????catch
????????{
????????????return?false;
????????}
????????finally
????????{
????????????con.Close();
????????????con.Dispose();
????????????cmd.Dispose();
????????}
????}
????#endregion
????#region?讀取帶參數(shù)的結(jié)果集
????///?
????///?讀取帶參數(shù)的結(jié)果集
????///?
????///?SQL語句
????///?參數(shù)列表
????///?結(jié)果集
????public?OleDbDataReader?ExecuteReader(string?sql)
????{
????????OleDbDataReader?reader?=?null;
????????OleDbConnection?con?=?new?OleDbConnection(ConnectionString);
????????OleDbCommand?cmd?=?new?OleDbCommand(sql?con);
????????try
????????{
????????????con.Open();
????????????reader?=?cmd.ExecuteReader(CommandBehavior.CloseConnection);
????????}
????????catch
????????{
????????}
????????
????????return?reader;
????}
????#endregion
????#region??執(zhí)行SQL語句,返回DataTable
????///?
????///?執(zhí)行SQL語句,返回DataTable
????///?
????///?要執(zhí)行的SQL語句
????///?返回DataTable類型的執(zhí)行結(jié)果
????public?DataTable?GetDataTable(string?sql)
????{
????????DataSet?ds?=?new?DataSet();
????????OleDbConnection?con?=?new?OleDbConnection(ConnectionString);
????????OleDbDataAdapter?da?=?new?OleDbDataAdapter(sql?con);
????????try
????????{
????????????da.Fill(ds?“tb“);
????????}
????????catch?(Exception?ex)
????????{
????????????throw?new?Ex
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\
?????目錄???????????0??2019-01-07?17:43??C#年會抽獎(jiǎng)軟件\Lucky?Draw\
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\
?????文件?????????920??2013-12-30?20:42??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw.sln
?????文件???????52224??2017-12-20?14:28??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw.suo
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\
?????文件??????530028??2014-01-01?15:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\choujiang.wav
?????文件?????1764112??2014-01-01?21:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\gongxi.wav
?????文件?????1764112??2014-01-01?21:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\join.wav
?????文件?????1249280??2014-01-11?08:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\LD.mdb
?????文件????28887664??2013-12-31?17:33??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\data\喜洋洋.wav
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\抽獎(jiǎng)系統(tǒng)_1_0_0_4\
?????文件???????25214??2009-11-01?03:49??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\抽獎(jiǎng)系統(tǒng)_1_0_0_4\logo.ico.deploy
?????文件??????808448??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\抽獎(jiǎng)系統(tǒng)_1_0_0_4\抽獎(jiǎng)系統(tǒng).exe.deploy
?????文件????????7134??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\抽獎(jiǎng)系統(tǒng)_1_0_0_4\抽獎(jiǎng)系統(tǒng).exe.manifest
?????目錄???????????0??2019-01-07?17:44??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\神仙抽獎(jiǎng)系統(tǒng)_1_0_0_1\
?????文件???????25214??2009-11-01?03:49??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\神仙抽獎(jiǎng)系統(tǒng)_1_0_0_1\logo.ico.deploy
?????文件??????806912??2012-10-23?16:31??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\神仙抽獎(jiǎng)系統(tǒng)_1_0_0_1\神仙抽獎(jiǎng)系統(tǒng).exe.deploy
?????文件????????7170??2012-10-23?16:31??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\Application?Files\神仙抽獎(jiǎng)系統(tǒng)_1_0_0_1\神仙抽獎(jiǎng)系統(tǒng).exe.manifest
?????文件??????475576??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\setup.exe
?????文件????????5320??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\抽獎(jiǎng)系統(tǒng).application
?????文件????????5356??2012-10-23?16:31??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\app.publish\神仙抽獎(jiǎng)系統(tǒng).application
?????文件???????25588??2012-10-24?16:00??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\pm3.wav
?????文件????????1587??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\抽獎(jiǎng)系統(tǒng).application
?????文件??????808448??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\抽獎(jiǎng)系統(tǒng).exe
?????文件????????3476??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\抽獎(jiǎng)系統(tǒng).exe.manifest
?????文件???????75264??2012-10-25?08:14??C#年會抽獎(jiǎng)軟件\Lucky?Draw\Lucky?Draw\bin\Debug\抽獎(jiǎng)系統(tǒng).pdb
............此處省略103個(gè)文件信息
評論
共有 條評論