/// <summary>
/// Initializes a new instance of the <see cref="SystemResourcesDA"/> class.
/// </summary>
public SystemResourcesDA()
{
this.SqlServer = new SqlServer();
}
/// <summary>
/// 构造方法
/// </summary>
public CpsLinkRecordDA()
{
this.sqlServer = new SqlServer();
}
public SystemRightsDA()
{
this.SqlServer = new SqlServer();
}
public OrderProductPromoteDA()
{
this.SqlServer = new SqlServer();
}
public OrderErpLogDA()
{
sqlServer=new SqlServer();
}
public JsonResult GetOrderData(int pageIndex, int pageSize, string search)
{
var userID = this.GetUserID();
var condition = "[UserID] = " + userID + " and " +
(string.IsNullOrEmpty(search) ? "1=1" : "productName like '%" + search + "%'");
var paging = new Paging("[view_Orders]", null, "ID", condition, pageIndex, pageSize, "CreateTime", 1);
int pageCount, rowCount, totalCount;
var Orders = new OrderService(userID, false).Query(paging, out pageCount, out rowCount);
if (Orders == null || Orders.Count < 1)
{
return this.Json(new { data = Orders, rowsCount = rowCount });
}
// 查找订单商品信息
string orderIDs = "";
foreach (var order in Orders)
{
orderIDs += order.ID + ",";
}
orderIDs = orderIDs.Remove(orderIDs.Length - 1, 1);
paging = new Paging("[view_Order_Products]", null, "ID", "[OrderID] in (" + orderIDs + ")", 1, 1000);
var orderProducts = new SqlServer().Paging<Order_Product>(paging, out pageCount, out totalCount, null);
for (var i = 0; i < Orders.Count; i++)
{
Orders[i].Products = new List<Order_Product>();
foreach (var orderProduct in orderProducts)
{
if (orderProduct.OrderID == Orders[i].ID)
{
orderProduct.Path = Utils.GetProductImage(orderProduct.Path, "1");
Orders[i].Products.Add(orderProduct);
}
}
}
return this.Json(new { data = Orders, rowsCount = rowCount });
}
public ActionResult Evaluate(string condition, int pageIndex = 1, int pageSize = 5)
{
ViewBag.searchText = condition;
if (string.IsNullOrWhiteSpace(condition))
{
condition = "UserID=" + this.UserSession.UserID;
}
else
{
condition = "UserID=" + this.UserSession.UserID + " And (ProductName like '%" + condition + "%' Or Content like '%" + condition + "%')";
}
int pageCount, totalCount;
var paging = new Paging("view_UserProductComment", null, "CommentID", condition, pageIndex, pageSize);
var list = new SqlServer().Paging<UserCommentProduct>(paging, out pageCount, out totalCount, null);
ViewBag.pageCount = pageCount;
ViewBag.pageIndex = pageIndex;
return this.View(list);
}