public ActionResult WorkOrder_FindByPage(Mes_Plan_WorkOrder obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesPlanWorkOrderDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult WorkOrder_Find(Mes_Plan_WorkOrder obj)
{
Mes_Plan_WorkOrder entity = MesPlanWorkOrderDao.Instance.Find(obj);
if (entity == null)
{
return(Json(new { IsSuccess = false, Message = "计划信息不存在，请刷新后重试！" }));
}
return(Json(new { IsSuccess = true, Message = JsonHelper.SerializeObject(entity) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 按照工单号单个查找工单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Mes_Plan_WorkOrder Find(Mes_Plan_WorkOrder obj)
{
string sql = @"SELECT T1.*,T2.WorkShopName FROM Mes_Plan_WorkOrder T1
LEFT JOIN dbo.Mes_Sys_WorkShop T2 ON T1.WorkShopCode = T2.WorkShopCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Plan_WorkOrder>());
}
/// <summary>
/// 强制关闭工单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult WorkOrder_QzClose(Mes_Plan_WorkOrder obj)
{
string sMessage = string.Empty;
bool result = MesPlanWorkOrderDao.Instance.QzCloseWorkOrder(obj);
if (!result)
{
sMessage = "强制关闭失败";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 强制关闭工单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool QzCloseWorkOrder(Mes_Plan_WorkOrder obj)
{
Mes_Plan_WorkOrder entity = new Mes_Plan_WorkOrder();
entity = MesPlanWorkOrderDao.Instance.Find(obj);
int result = -1;
result = this.CurDbSession.Update <Mes_Plan_WorkOrder>(entity);
if (result < 0)
{
return(false);
}
return(true);
}
public List <Mes_Plan_WorkOrder> FindByPage(Mes_Plan_WorkOrder obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.WorkShopName FROM Mes_Plan_WorkOrder T1
LEFT JOIN dbo.Mes_Sys_WorkShop T2 ON T1.WorkShopCode = T2.WorkShopCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
if (!string.IsNullOrEmpty(obj.PlanCode))
{
sql += string.Format(" AND T1.PlanCode LIKE '%{0}%'", obj.PlanCode);
}
if (!string.IsNullOrEmpty(obj.MaterialProNo))
{
sql += string.Format(" AND T1.MaterialProNo= '{0}'", obj.MaterialProNo);
}
if (!string.IsNullOrEmpty(obj.MaterialCode))
{
sql += string.Format(" AND T1.MaterialCode= '{0}'", obj.MaterialCode);
}
if (obj.WorkOrderStatus > 0)
{
sql += string.Format(" AND T1.WorkOrderStatus = {0}", obj.WorkOrderStatus);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Plan_WorkOrder>());
}
/// <summary>
/// 保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Save(Mes_Plan_WorkOrder obj)
{
int result = -1;
if (obj.ID > 0)
{
result = this.CurDbSession.Update <Mes_Plan_WorkOrder>(obj);
}
else
{
result = this.CurDbSession.Insert <Mes_Plan_WorkOrder>(obj);
}
if (result < 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 下达计划
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool GenerateWorkOrder(Mes_Plan_WorkOrder obj)
{
int result = -1;
ProcSection proc = this.CurDbSession.FromProc("")
.AddInParameter("@WorkOrderType", System.Data.DbType.String, 50, obj.WorkOrderType)
.AddInParameter("@WorkOrderNumber", System.Data.DbType.String, 50, obj.WorkOrderNumber)
.AddInParameter("@MaterialProNo", System.Data.DbType.String, 50, obj.MaterialProNo)
.AddInParameter("@MaterialCode", System.Data.DbType.String, 50, obj.MaterialCode)
.AddInParameter("@Version", System.Data.DbType.String, 20, obj.Version)
.AddInParameter("@WorkNum", System.Data.DbType.Int32, obj.WorkNum)
.AddOutParameter("@ErrMsg", System.Data.DbType.String, 100)
.AddOutParameter("@OptionResult", System.Data.DbType.Int32, 1);
proc.ExecuteNonQuery();
Dictionary <string, object> returnValue = proc.GetReturnValues();
Int32 recout = -1;
string sMsg = string.Empty;
foreach (KeyValuePair <string, object> kv in returnValue)
{
if (kv.Key == "OptionResult")
{
recout = Convert.ToInt32(kv.Value);
}
if (kv.Key == "ErrMsg")
{
sMsg = Convert.ToString(kv.Value);
}
}
if (recout < 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 工单保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult WorkOrder_Save(Mes_Plan_WorkOrder obj)
{
string sMessage = string.Empty;
if (string.IsNullOrEmpty(obj.WorkOrderNumber))
{
return(Json(new { IsSuccess = false, Message = "工单单号信息不可谓空" }));
}
if (string.IsNullOrEmpty(obj.PlanCode))
{
return(Json(new { IsSuccess = false, Message = "工单对应的计划批号不能为空！" }));
}
if (string.IsNullOrEmpty(obj.MaterialProNo) || string.IsNullOrEmpty(obj.Version))
{
return(Json(new { IsSuccess = false, Message = "工单对应的产品信息及版本不能为空！" }));
}
if (obj.ID > 0)
{
}
else
{
obj.Creater = base.CurUser.UserId;
obj.CreatedTime = DateTime.Now;
//生成计划批号
obj.WorkOrderNumber = MesPlanWorkOrderDao.Instance.GetWorkOrderNo();
}
bool result = MesPlanWorkOrderDao.Instance.Save(obj);
if (!result)
{
sMessage = "保存失败";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
