/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
WorkorderTypeInfoModel workordertypeinfo = new WorkorderTypeInfoModel();
ret = DbUtil.Current.DeleteMultiple(workordertypeinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workordertypeinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(WorkorderTypeInfoModel workordertypeinfo, ParameterCollection pc)
{
int ret = 0;
workordertypeinfo.ModifiedBy = SessionUtil.Current.UserId;
workordertypeinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(workordertypeinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="workordertypeinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(WorkorderTypeInfoModel workordertypeinfo)
{
int ret = 0;
workordertypeinfo.ModifiedBy = SessionUtil.Current.UserId;
workordertypeinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(workordertypeinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="workordertypeid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string workordertypeid)
{
int ret = 0;
WorkorderTypeInfoModel workordertypeinfo = new WorkorderTypeInfoModel();
workordertypeinfo.WorkorderTypeId = workordertypeid;
ret = DbUtil.Current.Delete(workordertypeinfo);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <WorkorderTypeInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <WorkorderTypeInfoModel> workordertypeinfos = new List <WorkorderTypeInfoModel>();
WorkorderTypeInfoModel workordertypeinfo = new WorkorderTypeInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(workordertypeinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
workordertypeinfo = new WorkorderTypeInfoModel();
workordertypeinfo.ConvertFrom(dt, i);
workordertypeinfos.Add(workordertypeinfo);
}
return(workordertypeinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="workordertypeid"></param>
/// <returns>实体</returns>
public WorkorderTypeInfoModel Retrieve(string workordertypeid)
{
WorkorderTypeInfoModel workordertypeinfo = new WorkorderTypeInfoModel();
workordertypeinfo.WorkorderTypeId = workordertypeid;
DataTable dt = DbUtil.Current.Retrieve(workordertypeinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
workordertypeinfo.ConvertFrom(dt);
return(workordertypeinfo);
}
public WorkorderTypeInfoModel GetWorkorderTypeInfoModelById(string workorderTypeId)
{
WorkorderTypeInfoModel result = null;
Dictionary <string, WorkorderTypeInfoModel> dict = GetWorkOrderDictionary(false);
if (dict != null)
{
foreach (WorkorderTypeInfoModel item in dict.Values)
{
if (item.WorkorderTypeId == workorderTypeId)
{
result = item;
break;
}
}
}
return(result);
}
/// <summary>
/// 根据ID从数据库获取工单类型领域模型。
/// </summary>
/// <param name="typeId"></param>
/// <returns></returns>
public WorkOrderTypeDomainModel GetWorkOrderTypeDomainModelFromDatabase(string typeId)
{
WorkOrderTypeDomainModel result = null;
WorkorderTypeInfoModel typeInfo = Retrieve(typeId);
if (typeInfo != null)
{
result = new WorkOrderTypeDomainModel();
result.StatusList = new Dictionary <string, WorkorderStatusInfoModel>();
result.ResultList = new Dictionary <string, WorkorderResultInfoModel>();
result.TypeInfo = typeInfo;
ParameterCollection pc = new ParameterCollection();
pc.Add("workorder_type_id", typeId);
List <WorkorderStatusInfoModel> statusList = WorkorderStatusInfoService.Instance.RetrieveMultiple(pc, OrderByCollection.Create("sort_order", "asc"));
if (statusList != null && statusList.Count > 0)
{
foreach (WorkorderStatusInfoModel status in statusList)
{
if (status.StatusTag == 0)
{
result.BeginStatusInfo = status;
}
if (status.StatusTag == 2)
{
result.EndStatusInfo = status;
}
if (status.CustomStatus == "待审批")
{
result.ApprovalStatusInfo = status;
}
if (status.CustomStatus == "待质检")
{
result.QuilityCheckedStatusInfo = status;
}
result.StatusList.Add(status.WorkorderStatusId, status);
}
}
List <WorkorderResultInfoModel> resultList = WorkorderResultInfoService.Instance.RetrieveMultiple(pc, OrderByCollection.Create("sort_order", "asc"));
if (resultList != null && resultList.Count > 0)
{
foreach (WorkorderResultInfoModel resultItem in resultList)
{
if (resultItem.IsBegin == 0)
{
result.BeginResultInfo = resultItem;
}
result.ResultList.Add(resultItem.WorkorderResultId, resultItem);
}
}
}
return(result);
}
