public bool DeleteItemExt(Mes_Plan_SaleOrderItem obj)
{
string sql = string.Format("DELETE FROM Mes_Plan_SaleOrderItem WHERE ID={0}", obj.ID);
this.CurDbSession.FromSql(sql).ExecuteNonQuery();
return(true);
}
public ActionResult SaleOrderItemMgt_Save(Mes_Plan_SaleOrderItem obj)
{
if (obj.OrderID <= 0)
{
return(Json(new { IsSuccess = false, Message = "请先选择一个订单进行操作！" }));
}
if (string.IsNullOrEmpty(obj.MaterialProNo))
{
return(Json(new { IsSuccess = false, Message = "【产品编码】不能为空！" }));
}
//if (string.IsNullOrEmpty(obj.Version))
//{
// return Json(new { IsSuccess = false, Message = "【产品版本】不能为空！" });
//}
Mes_Plan_SaleOrder order = MesPlanSaleOrderDao.Instance.Find <Mes_Plan_SaleOrder, int>(obj.OrderID);
if (order == null)
{
return(Json(new { IsSuccess = false, Message = "选择的主订单信息有误！" }));
}
Mes_Plan_SaleOrderItem itemObj = null;
if (obj.ID > 0)
{
itemObj = MesPlanSaleOrderDao.Instance.Find <Mes_Plan_SaleOrderItem, int>(obj.ID);
}
else
{
itemObj = new Mes_Plan_SaleOrderItem();
itemObj.OrderType = order.OrderType;
itemObj.OrderNo = order.OrderNo;
itemObj.Creater = base.CurUser.UserId;
itemObj.CreatedTime = DateTime.Now;
//生成订单行号
itemObj.ResNum = MesPlanSaleOrderDao.Instance.GenOrderResNum(order);
}
if (itemObj == null)
{
return(Json(new { IsSuccess = false, Message = "订单明细信息有误，请刷新后重试！" }));
}
itemObj.MaterialProNo = obj.MaterialProNo;
itemObj.MaterialCode = obj.MaterialCode;
itemObj.MaterialSize = obj.MaterialSize;
itemObj.Unit = obj.Unit;
itemObj.Num = obj.Num;
itemObj.Price = obj.Price;
itemObj.Amount = obj.Amount;
itemObj.ShipDate = obj.ShipDate;
itemObj.AlNum = obj.AlNum;
itemObj.Memo = obj.Memo;
int id = MesPlanSaleOrderDao.Instance.Save <Mes_Plan_SaleOrderItem>(itemObj);
return(Json(new { IsSuccess = true, Message = id.ToString() }));
}
public ActionResult SaleOrderItemMgt_FindByPage(Mes_Plan_SaleOrderItem obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesPlanSaleOrderDao.Instance.FindItemByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult SaleOrderItemMgt_Delete(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Plan_SaleOrderItem obj = MesPlanSaleOrderDao.Instance.Find <Mes_Plan_SaleOrderItem, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "订单明细不存在，请刷新后重试！" }));
}
MesPlanSaleOrderDao.Instance.DeleteItemExt(obj);
return(Json(new { IsSuccess = true, Message = "" }));
}
public List <Mes_Plan_SaleOrderItem> FindItemByPage(Mes_Plan_SaleOrderItem obj, ref PagerBase pager)
{
Mes_Plan_SaleOrder order = null;
if (obj.OrderID > 0)
{
order = this.Find <Mes_Plan_SaleOrder, int>(obj.OrderID);
}
if (order == null)
{
order = new Mes_Plan_SaleOrder();
}
string sql = @"SELECT T1.* FROM Mes_Plan_SaleOrderItem T1 WITH(NOLOCK) WHERE 1=1";
if (!string.IsNullOrEmpty(order.OrderType))
{
sql += string.Format(" AND T1.OrderType = '{0}'", order.OrderType);
}
if (!string.IsNullOrEmpty(order.OrderNo))
{
sql += string.Format(" AND T1.OrderNo = '{0}'", order.OrderNo);
}
if (!string.IsNullOrEmpty(obj.OrderNoLike))
{
sql += string.Format(" AND T1.OrderNoLike LIKE '%{0}%'", obj.OrderNoLike);
}
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_SaleOrderItem>());
}
public ActionResult SaleOrderItemMgt_Select(int page, int rows, string q)
{
List <Mes_Plan_SaleOrderItem> list = null;
Mes_Plan_SaleOrderItem obj = new Mes_Plan_SaleOrderItem();
if (!string.IsNullOrEmpty(q))
{
obj.OrderNoLike = q;
}
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
list = MesPlanSaleOrderDao.Instance.FindItemByPage(obj, ref pager);
if (list == null)
{
list = new List <Mes_Plan_SaleOrderItem>();
}
return(Json(new { total = pager.TotalItemCount, rows = list, JsonRequestBehavior.AllowGet }));
}
