public bool GetDeps(bool isWithIntro) { if (isWithIntro) { dalBase.sql = "SELECT * FROM db_department WHERE depid!=1"; } else { dalBase.sql = "SELECT depid,depname FROM db_department WHERE depid!=1"; } if (dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false)) { while (dalBase.DataRead.Read()) { depInfo = new Department() { ID = Convert.ToInt32(dalBase.DataRead["depid"]), Name = dalBase.DataRead["depname"].ToString() }; if (isWithIntro) { depInfo.Introduce = dalBase.DataRead["depintroduction"].ToString(); depInfo.WeiboId = dalBase.DataRead["weiboId"].ToString(); } list_DepInfo.Add(depInfo); } dalBase.CloseConnect(); return true; } else { dalBase.CloseConnect(); return false; } }
private void SetValue(HttpRequestBase req,Department dep) { dep.Name = req.Form["name"].ToString(); dep.Introduce = req.Form["introduce"].ToString(); }
public ResponseStatus GetDepartment(int id, Department notice) { return service.GetSingle(id, () => notice, () => new DepDAL()); }
public override ResponseStatus GetSingle(int id, object obj) { if (!(obj is Department)) return ResponseStatus.FAILED; depInfo = (Department)obj; dalBase.sql = "SELECT * FROM db_department WHERE depid=@depid"; dalBase.Param = new MySqlParameter("@depid", id); bool isSuccess = dalBase.Run(Behavious.SELECT_WITH_SINGLEPARAM, false); return this.JudgeDBResult(isSuccess, ()=> { dalBase.DataRead.Read(); depInfo.ID = Convert.ToInt32(dalBase.DataRead["depid"]); depInfo.Name = dalBase.DataRead["depname"].ToString(); depInfo.Introduce = dalBase.DataRead["depintroduction"].ToString(); },null); }
public override ResponseStatus GetMuti(object list_obj, Paginate paginate) { if (!(list_obj is List<Department>)) return ResponseStatus.FAILED; List<Department> list_Dep = (List<Department>)list_obj; dalBase.sql = "SELECT * FROM db_department"; bool isSuccess = dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false); return this.JudgeDBResult(isSuccess, ()=> { while (dalBase.DataRead.Read()) { depInfo = new Department() { ID = Convert.ToInt32(dalBase.DataRead["depid"]), Name = dalBase.DataRead["depname"].ToString(), Introduce = dalBase.DataRead["depintroduction"].ToString(), WeiboId = dalBase.DataRead["weiboId"] != DBNull.Value? dalBase.DataRead["weiboId"].ToString():"0" }; list_Dep.Add(depInfo); } },null); }