public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
//查詢參數
var qm = new ZzOrderQryModel();
var isOK = this.TryUpdateModel(qm);
var token = collection["__RequestVerificationToken"];
ZZ_OrderDetailDataTable dt = null;
if (!qm.Q_OrderId.isNullOrEmpty())
{
dt = ZzDataService.Instance.ZzOrderDetail_getListByOrderId(qm.Q_OrderId);
}
else
{
dt = ZzDataService.Instance.ZzOrderDetail_getList(qm);
}
//排序
var dtSorted = dt.sort(jtSorting);
if (Request.IsAjaxRequest())
{
return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize));
}
else
{
return(View(dt));
}
}
public ActionResult CodeQuery(FormCollection collection)
{
var qm = new ZzOrderQryModel();
var bln = this.TryUpdateModel(qm);
ViewBag.RequestKey = qm.RequestKey;
return(View(qm));
}
public ActionResult ZZE010(FormCollection collection)
{
var token = collection["__RequestVerificationToken"];
var qm = new ZzOrderQryModel();
var bln = this.TryUpdateModel(qm);
qm.ClientMessage = "After submit post.";
return(View(qm));
}
public ActionResult ZZE010()
{
var qm = new ZzOrderQryModel();
var today = DateTime.Today;
qm.Q_DateFrom = new DateTime(today.Year, today.Month, 1);
qm.Q_DateTo = qm.Q_DateFrom.Value.AddMonths(1).AddDays(-1);
//qm.Q_DateTo = new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month));
return(View(qm));
}
public ZZ_OrderDetailDataTable ZzOrderDetail_getList(ZzOrderQryModel qm)
{
var dt = NsDmHelper.ZZ_OrderDetail
.selectAll(t => t.AllExt)
.where (t =>
t.ZZOD_OrderId == qm.Q_OrderId.toConstOpt1()
& t.ZZOD_OrderNo_XX == qm.Q_OrderNo.toConstOpt1()
& t.ZZOD_OrderDate_XX >= qm.Q_DateFrom.toConstOpt1()
& t.ZZOD_OrderDate_XX <= qm.Q_DateTo.toConstOpt1()
& t.ZZOD_OrderDesc_XX == qm.Q_Desc.toConstOpt1()
& t.ZZOD_Item == qm.Q_Item.toConstOpt1()
)
.query();
return(dt);
}
public ZZ_OrderDataTable ZzOrder_getList(ZzOrderQryModel qm)
{
var dt = NsDmHelper.ZZ_Order
.selectAll(t => t.AllExt)
.where (t =>
t.ZZO_OrderNo == qm.Q_OrderNo.toConstOpt1()
& t.ZZO_Date >= qm.Q_DateFrom.toConstOpt1()
& t.ZZO_Date <= qm.Q_DateTo.toConstOpt1()
& t.ZZO_Desc == qm.Q_Desc.toConstOpt1()
& t.ZZO_IsEnable == qm.Q_IsEnable.toConstOpt1()
& t.ZZO_IsEnableName_XX == qm.Q_IsEnableName_XX.toConstOpt1()
& t.ZZO_OrderAmount_XX >= qm.Q_OrderAmount_XXFrom.toConstOpt1()
& t.ZZO_OrderAmount_XX <= qm.Q_OrderAmount_XXTo.toConstOpt1()
)
.query();
return(dt);
}
public ActionResult Index()
{
var qm = new ZzOrderQryModel();
return(View(qm));
}
