資源簡介
WPF 人事管理系統 傳智播客視頻寫的 ,里面附加數據庫 開發環境VS2010+SQLSERVER2005,解壓不了換360解壓,數據庫登陸賬號密碼在appconfig里面,密碼都是MD5加密的,
問題交流留言回復我!
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Text;
using?HRMSys.Model;
namespace?HRMSys.DAL
{
????public?class?DepartmentDAL
????{
????????public?static?Department[]?ListAll()
????????{
????????????DataTable?dt?=?SqlHelper.ExecuteDataSet(“select?*from?T_Department?where?IsStopped=0“);
????????????Department[]?deps?=?new?Department[dt.Rows.Count];
????????????for?(int?i?=?0;?i?????????????{
????????????????deps[i]?=?ToModel(dt.Rows[i]);
????????????}
????????????return?deps;
????????}
????????private?static?Department?ToModel(DataRow?row)
????????{
????????????Department?depart?=?new?Department();
????????????depart.Name?=?(string)SqlHelper.FromDbValue(?row[“Name“]);
????????????depart.Id?=?(Guid)SqlHelper.FromDbValue(?row[“Id“]);
????????????return?depart;
????????}
????????public?static?Department?GetById(Guid?id)
????????{
????????????DataTable?table?=?SqlHelper.ExecuteDataSet(“select?*from?T_Department?where?Id=@Id“
????????????????new?SqlParameter(“@Id“?id));
????????????if?(table.Rows.Count?<=?0)
????????????{
????????????????return?null;
????????????}
????????????else
????????????{
????????????????return?ToModel(table.Rows[0]);
????????????}
????????}
????????public?static?void?Update(Guid?id?string?name)
????????{
????????????SqlHelper.ExecuteNonQuery(“Update?T_Department?set?Name=@Name?where?Id=@Id“
????????????????new?SqlParameter(“@Name“?name)
????????????????new?SqlParameter(“@Id“?id));
????????}
????????public?static?void?Insert(string?name)
????????{
????????????SqlHelper.ExecuteNonQuery(“Insert?into?T_Department?values(newid()@Name0)“
????????????????new?SqlParameter(“@Name“?name));
????????}
????????public?static?void?Delete(Guid?id)
????????{
????????????SqlHelper.ExecuteNonQuery(“Update?T_Department?set?IsStopped=1?where?Id=@Id“
????????????????new?SqlParameter(“@Id“?id));
????????}
????}
}
- 上一篇:員工工資管理
- 下一篇:web版即時通信系統 仿QQ聊天程序asp.net源代碼
評論
共有 條評論