// GET api/deptapi/5 public CDept Get(int id) { var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]]; if (user == null) { throw new HttpResponseException(new SiginFailureMessage()); } using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0)) { CDept dept; try { dal.Open(); dept = DeptBll.Get(dal, id); dal.Close(); } catch (Exception ex) { LogBll.Write(dal, new CLog { LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName), LogContent = string.Format("{0}#{1}", "Dept.Get", ex.Message), LogType = LogType.系统异常 }); throw new HttpResponseException(new SystemExceptionMessage()); } if (dept == null) { throw new HttpResponseException(new DataNotFoundMessage()); } return(dept); } }
protected override CommandResult UpdateItem(object item) { DeptInfo info = item as DeptInfo; CommandResult reuslt = bll.Update(info); if (reuslt.Result == ResultCode.Successful && DataBaseConnectionsManager.Current.StandbyConnected) { DeptBll srbll = new DeptBll(AppSettings.CurrentSetting.CurrentStandbyConnect); srbll.UpdateOrInsert(info); } return(reuslt); }
protected override List <object> GetDataSource() { DeptBll deptBll = new DeptBll(AppSettings.CurrentSetting.ParkConnect); depts = deptBll.GetAllDepts().QueryObjects.ToList(); List <object> source = new List <object>(); foreach (object o in depts) { source.Add(o); } return(source); }
// GET api/userselecterapi public IEnumerable <CLenovoInputOption> Get(string dataSource, string condition) { var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]]; if (user == null) { throw new HttpResponseException(new SiginFailureMessage()); } using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0)) { CLenovoInputOption[] options; try { dal.Open(); switch (dataSource) { case "User": options = UserBll.GetLenovoInputOption(dal, condition); break; case "Dept": options = DeptBll.GetLenovoInputOption(dal, condition); break; case "UserGroup": options = UserGroupBll.GetLenovoInputOption(dal, condition); break; default: throw new HttpResponseException(new SystemExceptionMessage()); } dal.Close(); } catch (Exception ex) { LogBll.Write(dal, new CLog { LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName), LogContent = string.Format("{0}#{1}", "LenovoInputer.List", ex.Message), LogType = LogType.系统异常 }); throw new HttpResponseException(new SystemExceptionMessage()); } if (options == null) { throw new HttpResponseException(new DataNotFoundMessage()); } return(options); } }
// POST api/deptapi public CDept Post(CDept value) { var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]]; if (user == null) { throw new HttpResponseException(new SiginFailureMessage()); } using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0)) { bool ok; try { dal.Open(); ok = DeptBll.Create(dal, value, string.Format("{0}-{1}", user.UserCode, user.UserName)); } catch (Exception ex) { if (ex.Message.StartsWith("违反了 UNIQUE KEY 约束")) { throw new HttpResponseException(new PrimaryRepeatedMessge()); } LogBll.Write(dal, new CLog { LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName), LogContent = string.Format("{0}#{1}", "Dept.Post", ex.Message), LogType = LogType.系统异常 }); throw new HttpResponseException(new SystemExceptionMessage()); } if (!ok) { LogBll.Write(dal, new CLog { LogContent = string.Format("新建部门{0}-{1}", value.DeptCode, value.DeptName), LogType = LogType.操作失败, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); throw new HttpResponseException(new DealFailureMessage()); } LogBll.Write(dal, new CLog { LogContent = string.Format("新建部门{0}-{1}", value.DeptCode, value.DeptName), LogType = LogType.操作成功, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); dal.Close(); return(value); } }
// DELETE api/deptapi/5 public void Delete(int id) { var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]]; if (user == null) { throw new HttpResponseException(new SiginFailureMessage()); } using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0)) { bool ok; CDept hisDept; try { dal.Open(); ok = DeptBll.Delete(dal, id, out hisDept); } catch (Exception ex) { LogBll.Write(dal, new CLog { LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName), LogContent = string.Format("{0}#{1}", "Dept.Delete", ex.Message), LogType = LogType.系统异常 }); throw new HttpResponseException(new SystemExceptionMessage()); } if (!ok) { if (hisDept != null) { LogBll.Write(dal, new CLog { LogContent = string.Format("删除部门{0}-{1}", hisDept.DeptCode, hisDept.DeptName), LogType = LogType.操作失败, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); } throw new HttpResponseException(new DataNotFoundMessage()); } LogBll.Write(dal, new CLog { LogContent = string.Format("删除部门{0}-{1}", hisDept.DeptCode, hisDept.DeptName), LogType = LogType.操作成功, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); dal.Close(); } }
protected override bool DeletingItem(object item) { DeptBll bll = new DeptBll(AppSettings.CurrentSetting.ParkConnect); DeptInfo info = (DeptInfo)item; CommandResult result = bll.Delete(info); if (result.Result != ResultCode.Successful) { MessageBox.Show(result.Message, Resources.Resource1.Form_Alert, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (DataBaseConnectionsManager.Current.StandbyConnected) { DeptBll srbll = new DeptBll(AppSettings.CurrentSetting.CurrentStandbyConnect); srbll.Delete(info); } return(result.Result == ResultCode.Successful); }
public void Init() { DeptBll bll = new DeptBll(Ralid.Park.BusinessModel.Configuration.AppSettings.CurrentSetting.ParkConnect); //this.DataSource = bll.GetAllDepts().QueryObjects; List <DeptInfo> items = bll.GetAllDepts().QueryObjects; this.Items.Clear(); this.Items.Add(""); foreach (var item in items) { this.Items.Add(item); } this.DisplayMember = "DeptName"; this.ValueMember = "DeptID"; this.DropDownStyle = ComboBoxStyle.DropDownList; }