public JsonResult ListTH(int page, int rows, string starttime, string endtime, string OrderNum, string ProductName, string username, string status)
{
THQuery fpq = new THQuery();
if (status == "1")
{
fpq.Status = 6;
}
else
{
fpq.Status = 0;
}
long inti;
if (long.TryParse(OrderNum, out inti))
{
fpq.orderNum = long.Parse(OrderNum);
}
fpq.productName = ProductName;
fpq.muserid = 0;
fpq.username = username;
fpq.starttime = starttime;
fpq.endtime = endtime;
fpq.PageSize = rows;
fpq.PageNo = page;
PageModel <TH> fp = ServiceHelper.Create <ITHService>().GetTHListInfo(fpq);
IEnumerable <TH> models =
from info in fp.Models.ToArray()
select new TH()
{
Id = info.Id,
TH_Number = info.TH_Number,
TH_OrderNum = info.TH_OrderNum,
TH_Time = info.TH_Time,
TH_UserId = info.TH_UserId,
TH_UserName = info.TH_UserName,
TH_UserType = info.TH_UserType,
TH_ProductName = info.TH_ProductName,
TH_ProductCount = info.TH_ProductCount,
TH_ProductMoney = info.TH_ProductMoney,
TH_ProductMoneyReal = info.TH_ProductMoneyReal,
TH_ProductMoneyType = info.TH_ProductMoneyType,
TH_ToUserId = info.TH_ToUserId,
TH_ToUserName = info.TH_ToUserName,
TH_ToUserType = info.TH_ToUserType,
TH_Status = info.TH_Status
};
DataGridModel <TH> dataGridModel = new DataGridModel <TH>()
{
rows = models,
total = fp.Total
};
return(Json(dataGridModel));
}
/*查询TH列表*/
public JsonResult List(int page, int rows, string OrderNo, int Type)
{
/* 卖家同意退货后，买家可寄回货填写订单号，卖家收到货确认签收，
* 平台审核完成 并且从供应商扣款给采购商
* <option value="0">请选择</option>
* <option value="1">退货申请中</option>
* <option value="2">同意退货</option>
* <option value="3">拒绝退货</option>
* <option value="4">已寄货</option>
* <option value="5">已签收</option>
* <option value="6">已完成</option>
* <option value="7">仲裁中</option>
*/
/*Type 退货状态*/
if (OrderNo == "")
{
OrderNo = "0";
}
THQuery tq = new THQuery()
{
Status = Type,
PageNo = page,
PageSize = rows,
orderNum = Convert.ToInt64(OrderNo)
};
PageModel <TH> tk = ServiceHelper.Create <ITHService>().GetTHPageModel(tq, base.CurrentUser.Id, 0);
var array =
from item in tk.Models.ToArray()
select new
{
Id = item.Id,
TH_Number = item.TH_Number,
TH_OrderNum = item.TH_OrderNum,
TH_Time = item.TH_Time,
TH_UserId = item.TH_UserId,
TH_UserName = item.TH_UserName,
TH_UserType = item.TH_UserType,
TH_ProductName = item.TH_ProductName,
TH_ProductCount = item.TH_ProductCount,
TH_ProductMoney = item.TH_ProductMoney,
TH_ProductMoneyReal = item.TH_ProductMoneyReal,
TH_ProductMoneyType = item.TH_ProductMoneyType,
TH_ToUserId = item.TH_ToUserId,
TH_ToUserName = item.TH_ToUserName,
TH_ToUserType = item.TH_ToUserType,
TH_Status = item.TH_Status,
TH_Reason = item.TH_Reason
};
return(Json(new { rows = array, total = tk.Total }));
}
public JsonResult ListTH(int page, int rows, string OrderNo, int Type)
{
if (OrderNo == "")
{
OrderNo = "0";
}
THQuery tq = new THQuery()
{
Status = Type,
PageNo = page,
PageSize = rows,
orderNum = Convert.ToInt64(OrderNo)
};
PageModel <TH> tk = ServiceHelper.Create <ITHService>().GetTHListInfo1(tq);
return(Json(new { rows = tk.Models.ToArray(), total = tk.Total }));
}
/// <summary>
/// list search
/// </summary>
/// <param name="fQuery">Query</param>
/// <returns></returns>
public Model.PageModel <TH> GetTHListInfo(THQuery fQuery)
{
int num = 0;
IQueryable <TH> fp = from a in context.TH select a;
/*已审核 未审核*/
if (fQuery.Status == 6)
{
fp =
from d in fp
where d.TH_Status.Equals(fQuery.Status)
select d;
}
else
{
fp =
from d in fp
where d.TH_Status != 6
select d;
}
if (fQuery.orderNum != 0)
{//订单号
fp =
from d in fp
where d.TH_OrderNum.Equals(fQuery.orderNum)
select d;
}
if (!string.IsNullOrWhiteSpace(fQuery.productName))
{//产品
fp =
from d in fp
where d.TH_ProductName.Equals(fQuery.productName)
select d;
}
if (!string.IsNullOrWhiteSpace(fQuery.starttime))
{//开始时间
DateTime dt;
if (DateTime.TryParse(fQuery.starttime, out dt))
{
dt = DateTime.Parse(fQuery.starttime);
fp =
from d in fp
where d.TH_Time >= dt
select d;
}
}
if (!string.IsNullOrWhiteSpace(fQuery.endtime))
{//结束时间
DateTime dt;
if (DateTime.TryParse(fQuery.endtime, out dt))
{
dt = DateTime.Parse(fQuery.endtime);
fp =
from d in fp
where d.TH_Time <= dt
select d;
}
}
if (!string.IsNullOrWhiteSpace(fQuery.username))
{//采购商名字
fp =
from d in fp
where d.TH_UserName.Equals(fQuery.username)
select d;
}
if (fQuery.muserid != 0)
{//供应商用户编号
fp =
from d in fp
where d.TH_ToUserId.Equals(fQuery.muserid)
select d;
}
if (fQuery.musertype != 0)
{//供应商用户类型
fp =
from d in fp
where d.TH_ToUserType.Equals(fQuery.musertype)
select d;
}
if (fQuery.moneytype != 0)
{//支付币种
fp =
from d in fp
where d.TH_ProductMoneyType.Equals(fQuery.moneytype)
select d;
}
fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <TH> d) =>
from o in d
orderby o.TH_Time descending
select o);
return(new PageModel <TH>()
{
Models = fp,
Total = num
});
}
