public ActionResult WorkOrderMaterial_FindByPage(Mes_Plan_Material obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesPlanWorkOrderMaterialDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult WorkOrderMaterial_Find(Mes_Plan_Material obj)
{
Mes_Plan_Material entity = MesPlanWorkOrderMaterialDao.Instance.Find(obj);
if (entity == null)
{
return(Json(new { IsSuccess = false, Message = "工单物料信息不存在，请刷新后重试！" }));
}
return(Json(new { IsSuccess = true, Message = JsonHelper.SerializeObject(entity) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 按照ID单个查找工单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Mes_Plan_Material Find(Mes_Plan_Material obj)
{
string sql = @"SELECT top 1 T1.*,T2.Name as Show_ProcessCode FROM Mes_Plan_Material T1
LEFT JOIN dbo.Mes_Tec_Process T2 ON T1.ProcessCode = T2.ProcessCode
WHERE 1=1 ";
if (obj.ID > 0)
{
sql += string.Format(" AND T1.ID = '{0}'", obj.ID);
}
return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Plan_Material>());
}
/// <summary>
/// 保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Save(Mes_Plan_Material obj)
{
int result = -1;
if (obj.ID > 0)
{
result = this.CurDbSession.Update <Mes_Plan_Material>(obj);
}
else
{
result = this.CurDbSession.Insert <Mes_Plan_Material>(obj);
}
if (result < 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 工单用料保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult WorkOrderMaterial_Save(Mes_Plan_Material obj)
{
string sMessage = string.Empty;
if (string.IsNullOrEmpty(obj.WorkOrderNumber))
{
return(Json(new { IsSuccess = false, Message = "工单单号信息不可谓空" }));
}
if (string.IsNullOrEmpty(obj.MaterialProNo) || string.IsNullOrEmpty(obj.MaterialCode) || string.IsNullOrEmpty(obj.Version))
{
return(Json(new { IsSuccess = false, Message = "产品编码、名称、版本信息不能为空！" }));
}
if (string.IsNullOrEmpty(obj.ProcessCode))
{
return(Json(new { IsSuccess = false, Message = "工单对应的工艺不能为空！" }));
}
if (string.IsNullOrEmpty(obj.SubMaterialProNo) || string.IsNullOrEmpty(obj.SubMaterialCode))
{
return(Json(new { IsSuccess = false, Message = "物料编码或名称不可为空" }, JsonRequestBehavior.AllowGet));
}
if (obj.Num == 0)
{
return(Json(new { IsSuccess = false, Message = "物料用料数量必须填写" }, JsonRequestBehavior.AllowGet));
}
if (obj.ID > 0)
{
}
else
{
obj.Creater = base.CurUser.UserId;
obj.CreatedTime = DateTime.Now;
obj.ActionStatus = 1;
}
bool result = MesPlanWorkOrderMaterialDao.Instance.Save(obj);
if (!result)
{
sMessage = "保存失败";
return(Json(new { IsSuccess = false, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = sMessage }, JsonRequestBehavior.AllowGet));
}
public List <Mes_Plan_Material> FindByPage(Mes_Plan_Material obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.Name as Show_ProcessCode FROM Mes_Plan_Material T1
LEFT JOIN dbo.Mes_Tec_Process T2 ON T1.ProcessCode = T2.ProcessCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
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 (!string.IsNullOrEmpty(obj.ProcessCode))
{
sql += string.Format(" AND T1.ProcessCode= '{0}'", obj.ProcessCode);
}
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_Material>());
}
