// 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;
}
