//部门表添加
public static object department_ADD(department me)
{
sqltext = "insert into department (name)values('" + me.Name + "')";
int i = (int)DAL.SQLHELPER.ExecuteNonQuery(sqltext);
return(i);
}
//部门表假删除
//部门表查询
public static DataSet selectByDID(department me)
{
sqltext = "select did as 部门编号,name as 部门 from department where did='" + me.Did + "'";
DataSet met = DAL.SQLHELPER.ExecuteDataSet(sqltext);
return(met);
}
//修改
public static int departmentXiuGai(department d)
{
NewHope4Entities ent = new NewHope4Entities();
var obj = ent.department.Find(d.Did);
obj.DName = d.DName;
return(ent.SaveChanges());
}
//删除
public static int departmentShanChu(department d)
{
NewHope4Entities ent = new NewHope4Entities();
var obj = ent.department.Find(d.Did);
obj.state = 1;
return(ent.SaveChanges());
}
// role角色表新增
public static int departmentXinZeng(department d)
{
NewHope4Entities ent = new NewHope4Entities();
d.CreationDate = DateTime.Now;
d.state = 0;
ent.department.Add(d);
return(ent.SaveChanges());
}
public void updateks(department m)
{
string sql = "update department set name=@name,pid=@pid,must=@must,valid=@valid,isExam=@isExam where ID=@ID";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@name", m.name),
new SqlParameter("@pid", m.pid),
new SqlParameter("@must", m.must),
new SqlParameter("@valid", m.valid),
new SqlParameter("@isExam", m.isExam),
new SqlParameter("@ID", m.id)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
/// <summary>
/// 保存部门或科室
/// </summary>
/// <param name="m"></param>
public void save(department m)
{
string sql = "insert into department(companyID,name,pid,type,valid,must,isExam)values(@companyID,@name,@pid,@type,@valid,@must,@isExam)";
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@companyID", m.companyID),
new SqlParameter("@name", m.name),
new SqlParameter("@pid", m.pid),
new SqlParameter("@type", m.type),
new SqlParameter("@valid", m.valid),
new SqlParameter("@must", m.must),
new SqlParameter("@isExam", m.isExam)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
private void detach_departments(department entity)
{
this.SendPropertyChanging();
entity.company = null;
}
partial void Deletedepartment(department instance);
partial void Updatedepartment(department instance);
partial void Insertdepartment(department instance);