91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 6.71MB
    文件類型: .7z
    金幣: 1
    下載: 1 次
    發布日期: 2023-10-22
  • 語言: C#
  • 標簽:

資源簡介

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));
????????}
????}
}

評論

共有 條評論

相關資源