目录
1、 PurchasereturnController
1.1、 查询单据数据
1.1.1、 //单号查询
1.1.2、 //时间范围查询
1.1.3、 // 审核
using QXQPS.Models;
using QXQPS.Vo;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace QXQPS.Areas.AccessoriessalesManagment.Controllers
{
public class PurchasereturnController : Controller
{
QXQPEntities myModels = new Models.QXQPEntities();
// GET: AccessoriessalesManagment/Purchasereturn
public ActionResult SelectReturnForm(BsgridPage bsgridPage, string ReturnNum, string Timeone, string Timetow, string ToAudit)//查询单据数据
{
var listReturnForm = (from tbReturnForm in myModels.PW_ReturnForm
join tbSuppli in myModels.SYS_Suppliers on tbReturnForm.SuppliersID equals tbSuppli.SuppliersID
join tbWareho in myModels.SYS_Warehouse on tbReturnForm.WarehouseID equals tbWareho.WarehouseID
join tbBalanc in myModels.SYS_BalanceState on tbReturnForm.BalanceStateID equals tbBalanc.BalanceStateID
join tbUser in myModels.PW_User on tbReturnForm.UserID equals tbUser.UserID
select new ReturnFormVo
{
ReturnFormID = tbReturnForm.ReturnFormID,
SuppliersID = tbSuppli.SuppliersID,
WarehouseID = tbWareho.WarehouseID,
BalanceStateID = tbBalanc.BalanceStateID,
UserID = tbUser.UserID,
BalanceState = tbBalanc.BalanceState,
SuppliersName = tbSuppli.SuppliersName.Trim(),
SuppliersFirm = tbSuppli.SuppliersFirm.Trim(),
MakerDates = tbReturnForm.SheetDate.ToString(),
SheetDate = tbReturnForm.SheetDate,
Maker = tbReturnForm.Maker.Trim(),
ReturnNumber=tbReturnForm.ReturnNumber,
IncomingNumber = tbReturnForm.IncomingNumber,
DeliveryDeadlines = tbReturnForm.PaymentDate.ToString(),
SingleDates = tbReturnForm.SheetDate.ToString(),
WarehouseName = tbWareho.WarehouseName.Trim(),
Amount = tbReturnForm.Amount,
ToAudit = tbReturnForm.ToAudit,
Auditor = tbReturnForm.Auditor.Trim(),
AuditerDates = tbReturnForm.AuditDate.ToString(),
Remark = tbReturnForm.Remark.Trim(),
}).ToList();
if (!string.IsNullOrEmpty(ReturnNum))
{
listReturnForm = listReturnForm.Where(m => m.ReturnNumber.Contains(ReturnNum)).ToList();
}
if (!string.IsNullOrEmpty(Timeone) && !string.IsNullOrEmpty(Timetow))
{
DateTime Time1 = Convert.ToDateTime(Timeone);
DateTime Time2 = Convert.ToDateTime(Timetow);
listReturnForm = listReturnForm.Where(m => m.SheetDate >= Time1 && m.SheetDate <= Time2).ToList();
}
if (ToAudit == "1")
{
listReturnForm = listReturnForm.Where(m => m.ToAudit == true).ToList();
}
else if (ToAudit == "2")
{
listReturnForm = listReturnForm.Where(m => m.ToAudit == false).ToList();
}
int count = listReturnForm.Count();
List<ReturnFormVo> listReturn = listReturnForm.OrderBy(m => m.ToAudit).Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();
Bsgrid<ReturnFormVo> bsgrid = new Bsgrid<ReturnFormVo>()
{
success = true,
totalRows = count,
curPage = bsgridPage.curPage,
data = listReturn,
};
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
