/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
WorkorderResultInfoModel workorderresultinfo = new WorkorderResultInfoModel();
ret = DbUtil.Current.DeleteMultiple(workorderresultinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workorderresultinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(WorkorderResultInfoModel workorderresultinfo, ParameterCollection pc)
{
int ret = 0;
workorderresultinfo.ModifiedBy = SessionUtil.Current.UserId;
workorderresultinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(workorderresultinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workorderresultinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(WorkorderResultInfoModel workorderresultinfo)
{
int ret = 0;
workorderresultinfo.ModifiedBy = SessionUtil.Current.UserId;
workorderresultinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(workorderresultinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="workorderresultid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string workorderresultid)
{
int ret = 0;
WorkorderResultInfoModel workorderresultinfo = new WorkorderResultInfoModel();
workorderresultinfo.WorkorderResultId = workorderresultid;
ret = DbUtil.Current.Delete(workorderresultinfo);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <WorkorderResultInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <WorkorderResultInfoModel> workorderresultinfos = new List <WorkorderResultInfoModel>();
WorkorderResultInfoModel workorderresultinfo = new WorkorderResultInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(workorderresultinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
workorderresultinfo = new WorkorderResultInfoModel();
workorderresultinfo.ConvertFrom(dt, i);
workorderresultinfos.Add(workorderresultinfo);
}
return(workorderresultinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="workorderresultid"></param>
/// <returns>实体</returns>
public WorkorderResultInfoModel Retrieve(string workorderresultid)
{
WorkorderResultInfoModel workorderresultinfo = new WorkorderResultInfoModel();
workorderresultinfo.WorkorderResultId = workorderresultid;
DataTable dt = DbUtil.Current.Retrieve(workorderresultinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
workorderresultinfo.ConvertFrom(dt);
return(workorderresultinfo);
}
/// <summary>
/// 修改工单处理结果值。
/// </summary>
/// <param name="resultInfo"></param>
/// <returns></returns>
public bool UpdateTypeResultInfo(WorkorderResultInfoModel resultInfo)
{
bool result = false;
WorkOrderTypeDomainModel domain = GetTypeDomainModelById(resultInfo.WorkorderTypeId, false);
if (domain == null)
{
return(false);
}
if (WorkorderResultInfoService.Instance.Update(resultInfo) > 0)
{
result = true;
GetTypeDomainModelById(resultInfo.WorkorderTypeId, true);
}
return(result);
}
/// <summary>
/// 新建工单处理结果值。
/// </summary>
/// <param name="resultInfo"></param>
/// <returns></returns>
public bool CreateTypeResultInfo(WorkorderResultInfoModel resultInfo)
{
bool result = false;
WorkOrderTypeDomainModel domain = GetTypeDomainModelById(resultInfo.WorkorderTypeId, false);
if (domain == null)
{
return(false);
}
resultInfo.SortOrder = domain.ResultList.Count + 1;
if (WorkorderResultInfoService.Instance.Create(resultInfo) > 0)
{
result = true;
GetTypeDomainModelById(resultInfo.WorkorderTypeId, true);
}
return(result);
}
/// <summary>
/// 上移工单类型处理结果值。
/// </summary>
/// <param name="typeId"></param>
/// <param name="typeResultId"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool MoveUpTypeResultSortOrder(string typeId, string typeResultId, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
WorkOrderTypeDomainModel typeInfo = GetTypeDomainModelById(typeId, false);
if (typeInfo == null)
{
message = "操作失败，该工单类型不存在";
return(false);
}
if (typeInfo.ResultList == null || typeInfo.ResultList.ContainsKey(typeResultId) == false)
{
message = "操作失败，该工单类型处理结果不存在";
return(false);
}
WorkorderResultInfoModel resultInfo = typeInfo.ResultList[typeResultId];
if (resultInfo.SortOrder == typeInfo.ResultList.Count)
{
message = "操作失败，该工单类型处理结果已为最上序列号";
return(false);
}
WorkorderResultInfoModel upValueInfo = null;
foreach (WorkorderResultInfoModel item in typeInfo.ResultList.Values)
{
if (item.SortOrder == resultInfo.SortOrder - 1)
{
upValueInfo = item;
}
}
if (upValueInfo != null)
{
string sql = @"UPDATE workorder_result_info SET sort_order = $sort_order$ WHERE workorder_result_id = $workorder_result_id$";
try
{
BeginTransaction();
ParameterCollection pc = new ParameterCollection();
pc.Add("workorder_result_id", resultInfo.WorkorderResultId);
pc.Add("sort_order", resultInfo.SortOrder - 1);
if (ExecuteNonQuery(sql, pc) > 0)
{
pc.Clear();
pc.Add("workorder_result_id", upValueInfo.WorkorderResultId);
pc.Add("sort_order", upValueInfo.SortOrder + 1);
if (ExecuteNonQuery(sql, pc) > 0)
{
CommitTransaction();
GetTypeDomainModelById(typeId, true);
message = "成功上移该工单类型处理结果";
return(true);
}
}
RollbackTransaction();
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("上移工单类型处理结果排序索引异常", ex);
throw ex;
}
}
return(result);
}
