/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
WorkorderStatusInfoModel workorderstatusinfo = new WorkorderStatusInfoModel();
ret = DbUtil.Current.DeleteMultiple(workorderstatusinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workorderstatusinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(WorkorderStatusInfoModel workorderstatusinfo, ParameterCollection pc)
{
int ret = 0;
workorderstatusinfo.ModifiedBy = SessionUtil.Current.UserId;
workorderstatusinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(workorderstatusinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workorderstatusinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(WorkorderStatusInfoModel workorderstatusinfo)
{
int ret = 0;
workorderstatusinfo.ModifiedBy = SessionUtil.Current.UserId;
workorderstatusinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(workorderstatusinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="workorderstatusid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string workorderstatusid)
{
int ret = 0;
WorkorderStatusInfoModel workorderstatusinfo = new WorkorderStatusInfoModel();
workorderstatusinfo.WorkorderStatusId = workorderstatusid;
ret = DbUtil.Current.Delete(workorderstatusinfo);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <WorkorderStatusInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <WorkorderStatusInfoModel> workorderstatusinfos = new List <WorkorderStatusInfoModel>();
WorkorderStatusInfoModel workorderstatusinfo = new WorkorderStatusInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(workorderstatusinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
workorderstatusinfo = new WorkorderStatusInfoModel();
workorderstatusinfo.ConvertFrom(dt, i);
workorderstatusinfos.Add(workorderstatusinfo);
}
return(workorderstatusinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="workorderstatusid"></param>
/// <returns>实体</returns>
public WorkorderStatusInfoModel Retrieve(string workorderstatusid)
{
WorkorderStatusInfoModel workorderstatusinfo = new WorkorderStatusInfoModel();
workorderstatusinfo.WorkorderStatusId = workorderstatusid;
DataTable dt = DbUtil.Current.Retrieve(workorderstatusinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
workorderstatusinfo.ConvertFrom(dt);
return(workorderstatusinfo);
}
/// <summary>
/// 新建工单类型状态值。
/// </summary>
/// <param name="statusInfo"></param>
/// <returns></returns>
public bool CreateTypeStatusInfo(WorkorderStatusInfoModel statusInfo)
{
bool result = false;
WorkOrderTypeDomainModel domain = GetTypeDomainModelById(statusInfo.WorkorderTypeId, false);
if (domain == null)
{
return(false);
}
statusInfo.SortOrder = domain.StatusList.Count + 1;
if (WorkorderStatusInfoService.Instance.Create(statusInfo) > 0)
{
result = true;
GetTypeDomainModelById(statusInfo.WorkorderTypeId, true);
}
return(result);
}
/// <summary>
/// 编辑工单类型状态操作。
/// </summary>
/// <param name="statusInfo"></param>
/// <returns></returns>
public bool EditTypeStatusInfo(WorkorderStatusInfoModel statusInfo)
{
bool result = false;
WorkOrderTypeDomainModel domain = GetTypeDomainModelById(statusInfo.WorkorderTypeId, false);
if (domain == null)
{
return(false);
}
if (WorkorderStatusInfoService.Instance.Update(statusInfo) > 0)
{
result = true;
GetTypeDomainModelById(statusInfo.WorkorderTypeId, true);
}
return(result);
}
/// <summary>
/// 下移工单类型状态值。
/// </summary>
/// <param name="typeStatusId"></param>
/// <returns></returns>
public bool MoveDownTypeStatusSortOrder(string typeId, string typeStatusId, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
WorkOrderTypeDomainModel typeInfo = GetTypeDomainModelById(typeId, false);
if (typeInfo == null)
{
message = "操作失败，该工单类型不存在";
return(false);
}
if (typeInfo.StatusList == null || typeInfo.StatusList.ContainsKey(typeStatusId) == false)
{
message = "操作失败，该工单类型状态值不存在";
return(false);
}
WorkorderStatusInfoModel statusInfo = typeInfo.StatusList[typeStatusId];
if (statusInfo.SortOrder == typeInfo.StatusList.Count)
{
message = "操作失败，该工单类型状态值已为最下序列号";
return(false);
}
WorkorderStatusInfoModel downValueInfo = null;
foreach (WorkorderStatusInfoModel item in typeInfo.StatusList.Values)
{
if (item.SortOrder == statusInfo.SortOrder + 1)
{
downValueInfo = item;
}
}
if (downValueInfo != null)
{
string sql = @"UPDATE workorder_status_info SET sort_order = $sort_order$ WHERE workorder_status_id = $workorder_status_id$";
try
{
BeginTransaction();
ParameterCollection pc = new ParameterCollection();
pc.Add("workorder_status_id", statusInfo.WorkorderStatusId);
pc.Add("sort_order", statusInfo.SortOrder + 1);
if (ExecuteNonQuery(sql, pc) > 0)
{
pc.Clear();
pc.Add("workorder_status_id", downValueInfo.WorkorderStatusId);
pc.Add("sort_order", downValueInfo.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);
}
