WPF 人事管理系统看传智播客写的
标签:
•
文件类型: .7z
•
文件大小: 6.71MB
•
下载次数: 1
•
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 < dt.Rows.Count; 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));
}
}
}
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)