//部门表添加 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);