xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

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

資源簡(jiǎn)介

WPF 人事管理系統(tǒng) 傳智播客視頻寫(xiě)的 ,里面附加數(shù)據(jù)庫(kù) 開(kāi)發(fā)環(huán)境VS2010+SQLSERVER2005,解壓不了換360解壓,數(shù)據(jù)庫(kù)登陸賬號(hào)密碼在appconfig里面,密碼都是MD5加密的, 問(wèn)題交流留言回復(fù)我!

資源截圖

代碼片段和文件信息

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

評(píng)論

共有 條評(píng)論

相關(guān)資源