資源簡介
企業(yè)人事管理系統(tǒng)(c#.net SQL 含數(shù)據(jù)庫 源代碼)
企業(yè)人事管理系統(tǒng)(c#.net SQL 含數(shù)據(jù)庫 源代碼)

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Windows.Forms;
namespace?s1xiangmu
{
????class?common
????{
????????static?SqlConnection?conn?=?DBHelper.conn;
????????public?static?bool?UpdateSQL(string?sql)
????????{
????????????try
????????????{
????????????????if?(conn?!=?null)
????????????????????conn.Close();
????????????????
????????????????//2)打開連接??---門
????????????????conn.Open();
????????????????//3)命令對象?---取什么
????????????????SqlCommand?cmd?=?new?SqlCommand(sql?conn);
????????????????//4)執(zhí)行--
????????????????int?i?=?cmd.ExecuteNonQuery();
????????????????if?(i?>?0)
????????????????{
????????????????????return?true;
????????????????}
????????????????else
????????????????{
????????????????????return?false;
????????????????}
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(“異常:“?+?ex.InnerException);
????????????}
????????????finally
????????????{
????????????????//5)關(guān)閉連接??---門
????????????????conn.Close();
????????????}
????????????return?false;
????????}
????????///?
????????///?查詢(根據(jù)條件/所有)
????????///?
????????///?
????????///?
????????public?static?SqlDataReader?FindSQL(string?sql)
????????{
????????????try
????????????{
????????????????//1)獲得連接對象?--班主任
????????????????SqlConnection?conn?=?DBHelper.conn;
????????????????if?(conn?!=?null)
????????????????????conn.Close();
????????????????//2)打開連接??---門
????????????????conn.Open();
????????????????//3)命令對象?---取什么
????????????????SqlCommand?cmd?=?new?SqlCommand(sql?conn);
????????????????//4)執(zhí)行--返回是集合對象
????????????????SqlDataReader?data?=?cmd.ExecuteReader();
????????????????return?data;
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(“異常:“?+?ex.Message);
????????????}
????????????//finally
????????????//{
????????????//????//5)關(guān)閉連接??---門
????????????//????conn.Close();
????????????//}
????????????return?null;
????????}
????????///?
????????///?查詢(個(gè)數(shù))
????????///?
????????///?
????????///?
????????public?static?bool?FindSingleSQL(string?sql)
????????{
????????????try
????????????{
????????????????//1)獲得連接對象?--班主任
????????????????SqlConnection?conn?=?DBHelper.conn;
????????????????//2)打開連接??---門
????????????????conn.Open();
????????????????//3)命令對象?---取什么
????????????????SqlCommand?cmd?=?new?SqlCommand(sql?conn);
????????????????//4)執(zhí)行--
????????????????int?i?=?(int)cmd.ExecuteScalar();
????????????????if?(i?>?0)
????????????????{
????????????????????return?true;
????????????????}
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(“異常:“?+?ex.Message);
????????????}
????????????finally
????????????{
????????????????conn.Close();??//關(guān)閉連接
???
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????3145728??2010-01-11?15:51??S1項(xiàng)目C#\s1xiangmu.mdf
?????文件????1048576??2010-01-11?15:51??S1項(xiàng)目C#\s1xiangmu_log.ldf
?????文件????????397??2009-01-18?15:11??S1項(xiàng)目C#\sixiangmu\s1xiangmu\app.config
?????文件?????319488??2010-01-08?13:17??S1項(xiàng)目C#\sixiangmu\s1xiangmu\bin\Debug\s1xiangmu.exe
?????文件????????397??2009-01-18?15:11??S1項(xiàng)目C#\sixiangmu\s1xiangmu\bin\Debug\s1xiangmu.exe.config
?????文件?????251392??2010-01-08?13:17??S1項(xiàng)目C#\sixiangmu\s1xiangmu\bin\Debug\s1xiangmu.pdb
?????文件???????5632??2005-11-11?22:25??S1項(xiàng)目C#\sixiangmu\s1xiangmu\bin\Debug\s1xiangmu.vshost.exe
?????文件????????397??2009-01-18?15:11??S1項(xiàng)目C#\sixiangmu\s1xiangmu\bin\Debug\s1xiangmu.vshost.exe.config
?????文件???????3169??2009-12-29?17:00??S1項(xiàng)目C#\sixiangmu\s1xiangmu\common.cs
?????文件????????433??2009-12-17?17:46??S1項(xiàng)目C#\sixiangmu\s1xiangmu\DBHelper.cs
?????文件????????443??2009-12-17?20:43??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmdate.cs
?????文件???????1847??2009-12-17?20:43??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmdate.Designer.cs
?????文件???????5814??2009-12-17?20:43??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmdate.resx
?????文件???????2087??2009-01-18?13:58??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmdenglu.cs
?????文件???????5274??2009-12-17?20:45??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmdenglu.Designer.cs
?????文件???????5814??2009-12-17?20:45??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmdenglu.resx
?????文件???????8399??2009-12-22?18:13??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmhetong.cs
?????文件??????21082??2009-12-22?18:13??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmhetong.Designer.cs
?????文件???????6848??2009-12-22?15:21??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmhetong.resx
?????文件???????1285??2009-12-21?15:21??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmjiemian.cs
?????文件???????3511??2009-12-21?15:21??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmjiemian.Designer.cs
?????文件?????108141??2009-12-21?15:21??S1項(xiàng)目C#\sixiangmu\s1xiangmu\Frmjiemian.resx
?????文件???????2203??2009-01-18?15:36??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmma.cs
?????文件??????12707??2009-01-18?15:17??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmma.Designer.cs
?????文件???????6412??2009-01-18?15:17??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmma.resx
?????文件???????4271??2009-12-30?12:12??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmminzu.cs
?????文件???????8287??2009-12-30?11:52??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmminzu.Designer.cs
?????文件???????5814??2009-12-30?11:52??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmminzu.resx
?????文件??????18858??2010-01-11?15:50??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmrenshi.cs
?????文件??????37782??2009-12-29?17:26??S1項(xiàng)目C#\sixiangmu\s1xiangmu\frmrenshi.Designer.cs
............此處省略146個(gè)文件信息
評論
共有 條評論