private void QueryRequest(int?plantId, int?stocktakeType, DateTime?dateStart, DateTime?dateEnd) { ViewStockTakeRequest condition = new ViewStockTakeRequest { RequestNumber = txtRequestNo.Text, UserName = txtRequestBy.Text, PlantID = plantId, PartCode = txtPartCode.Text, StocktakeType = stocktakeType, PartChineseName = txtPartCName.Text }; if (!string.IsNullOrEmpty(ddlIsStatic.SelectedValue)) { condition.IsStatic = Convert.ToBoolean(ddlIsStatic.SelectedValue); } if (!string.IsNullOrEmpty(ddlStatus.SelectedValue)) { condition.Status = Convert.ToInt32(ddlStatus.SelectedValue); } int pageCount; int itemCount; List <StocktakeRequest> requests = Service.QueryStocktakeRequestByPage(condition, dateStart, dateEnd, pagerRequest.PageSize, pagerRequest.CurrentPage, out pageCount, out itemCount); pagerRequest.TotalRecord = itemCount; BindDataControl(gvRequest, requests); }
public ViewStockTakeRequest BuildQueryCondition(long?requestID, string requestNumber, string userName, int?plantID, string partCode, int?stocktakeType, string partChineseName, DateTime?dateStart, DateTime?dateEnd) { ViewStockTakeRequest condition = new ViewStockTakeRequest(); if (requestID != null) { condition.RequestID = requestID.Value; } if (!string.IsNullOrEmpty(requestNumber)) { condition.RequestNumber = requestNumber; } if (!string.IsNullOrEmpty(userName)) { condition.UserName = userName; } if (plantID != null) { condition.PlantID = plantID; } if (!string.IsNullOrEmpty(partCode)) { condition.PartCode = partCode; } if (stocktakeType != null) { condition.StocktakeType = stocktakeType.Value; } if (!string.IsNullOrEmpty(partChineseName)) { condition.PartChineseName = partChineseName; } return(condition); }
public IQueryable <ViewStockTakeRequest> QueryRequestDetails(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd) { IQueryable <ViewStockTakeRequest> requestQuery = _context.ViewStockTakeRequestSet; requestQuery = BuildQuery(condition, dateStart, dateEnd, requestQuery); return(requestQuery); }
public void QueryRequestTest1() { StockTakeReqBLL target = new StockTakeReqBLL(); // TODO: Initialize to an appropriate value ViewStockTakeRequest condition = null; // TODO: Initialize to an appropriate value List <StocktakeRequest> expected = null; // TODO: Initialize to an appropriate value List <StocktakeRequest> actual; actual = target.QueryRequest(condition); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
public void BuildQueryTest1() { StockTakeReqBLL_Accessor target = new StockTakeReqBLL_Accessor(); // TODO: Initialize to an appropriate value ViewStockTakeRequest condition = null; // TODO: Initialize to an appropriate value IQueryable <ViewStockTakeRequest> requestQuery = null; // TODO: Initialize to an appropriate value IQueryable <ViewStockTakeRequest> expected = null; // TODO: Initialize to an appropriate value IQueryable <ViewStockTakeRequest> actual; actual = target.BuildQuery(condition, requestQuery); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
public void QueryRequestDetailsByPageTest() { StockTakeReqBLL target = new StockTakeReqBLL(); // TODO: Initialize to an appropriate value ViewStockTakeRequest condition = null; // TODO: Initialize to an appropriate value int pageSize = 0; // TODO: Initialize to an appropriate value int pageNumber = 0; // TODO: Initialize to an appropriate value int pageCount = 0; // TODO: Initialize to an appropriate value int pageCountExpected = 0; // TODO: Initialize to an appropriate value IQueryable <ViewStockTakeRequest> expected = null; // TODO: Initialize to an appropriate value IQueryable <ViewStockTakeRequest> actual; actual = target.QueryRequestDetailsByPage(condition, pageSize, pageNumber, out pageCount); Assert.AreEqual(pageCountExpected, pageCount); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
private IQueryable <ViewStockTakeRequest> BuildQuery(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd, IQueryable <ViewStockTakeRequest> requestQuery) { if (condition.RequestID != 0) { requestQuery = requestQuery.Where(vq => vq.RequestID == condition.RequestID); } if (!string.IsNullOrEmpty(condition.RequestNumber)) { requestQuery = requestQuery.Where(vq => vq.RequestNumber == condition.RequestNumber); } if (!string.IsNullOrEmpty(condition.UserName)) { requestQuery = requestQuery.Where(vq => vq.UserName == condition.UserName); } if (condition.PlantID != null) { requestQuery = requestQuery.Where(vq => vq.PlantID.Value == condition.PlantID.Value); } if (!string.IsNullOrEmpty(condition.PartCode)) { requestQuery = requestQuery.Where(vq => vq.PartCode == condition.PartCode); } if (condition.StocktakeType != null) { requestQuery = requestQuery.Where(vq => vq.StocktakeType.Value == condition.StocktakeType.Value); } if (!string.IsNullOrEmpty(condition.PartChineseName)) { requestQuery = requestQuery.Where(vq => vq.PartChineseName == condition.PartChineseName); } if (condition.IsStatic != null) { requestQuery = requestQuery.Where(vq => vq.IsStatic.Value == condition.IsStatic.Value); } if (dateStart != null) { requestQuery = requestQuery.Where(vq => vq.DateRequest >= dateStart); } if (dateEnd != null) { requestQuery = requestQuery.Where(vq => vq.DateRequest <= dateEnd); } return(requestQuery); }
public void BuildQueryConditionTest1() { StockTakeReqBLL target = new StockTakeReqBLL(); // TODO: Initialize to an appropriate value Nullable <long> requestID = new Nullable <long>(); // TODO: Initialize to an appropriate value string requestNumber = string.Empty; // TODO: Initialize to an appropriate value string userName = string.Empty; // TODO: Initialize to an appropriate value Nullable <int> plantID = new Nullable <int>(); // TODO: Initialize to an appropriate value string partCode = string.Empty; // TODO: Initialize to an appropriate value Nullable <int> stocktakeType = new Nullable <int>(); // TODO: Initialize to an appropriate value string partChineseName = string.Empty; // TODO: Initialize to an appropriate value Nullable <DateTime> dateStart = new Nullable <DateTime>(); // TODO: Initialize to an appropriate value Nullable <DateTime> dateEnd = new Nullable <DateTime>(); // TODO: Initialize to an appropriate value ViewStockTakeRequest expected = null; // TODO: Initialize to an appropriate value ViewStockTakeRequest actual; actual = target.BuildQueryCondition(requestID, requestNumber, userName, plantID, partCode, stocktakeType, partChineseName, dateStart, dateEnd); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
//public List<StocktakeRequest> QueryRequest(StocktakeDetails condition, DateTime dateStart, DateTime dateEnd) //{ // string esqlStr = "SELECT FROM ECountContext.StocktakeRequest AS r INNER JOIN StocktakeType ON r. LEFT OUTER JOIN ECountContext.StocktakeDetails AS d ON LEFT OUTER JOIN ECountContext.Part AS p ON LEFT OUTER JOIN ECountContext. AS ON LEFT OUTER JOIN ECountContext. AS ON LEFT OUTER JOIN ECountContext. AS ON LEFT OUTER JOIN ECountContext. AS ON LEFT OUTER JOIN ECountContext. AS ON"; // StocktakeDetailBLL detailBLL = new StocktakeDetailBLL(); // string queryWhere = detailBLL.BuildQuery(condition,dateStart,dateEnd); // List<StocktakeRequest> requestList = new ObjectQuery<StocktakeDetails>(queryWhere, _context).Include("Part.PartStatus").Include("Part.Plant").Include("Part.Supplier").Include("Part.PartCategory").Include("Part.CycleCountLevel").Select(d => d.StocktakeRequest).ToList(); // return requestList; // //StocktakeRequest r; // //StringBuilder queryWhere = new StringBuilder(); // //string queryString = "SELECT VALUE r FROM ECountContext.StocktakeRequest as r"; // //if (condition != null) // //{ // // if (condition.StocktakeRequest != null) // // { // // if (condition.StocktakeRequest.RequestID != 0) // // { // // queryWhere.Append(" r.RequestID='" + condition.StocktakeRequest.RequestID + "' AND "); // // } // // if (!string.IsNullOrEmpty(condition.StocktakeRequest.RequestBy.UserName)) // // { // // queryWhere.Append(" r.RequestBy.UserName='******' AND"); // // } // // queryWhere.Append(" r.IsStatic=" + condition.StocktakeRequest.IsStatic + " AND"); // // } // // if (dateStart != null) // // { // // queryWhere.Append(" r.DateRequest>=" + dateStart.ToString() + " AND"); // // } // // if (dateEnd != null) // // { // // queryWhere.Append(" r.DateRequest<=" + dateEnd.ToString() + " AND"); // // } // // //if (condition.Part!=null) // // //{ // // // if (!string.IsNullOrEmpty(condition.Part.PartCode)) // // // { // // // queryWhere.Append(" r.StocktakeDetails // // // } // // //} // //} // //if (queryWhere.Length>0) // //{ // // queryString += " WHERE " + queryWhere.ToString(); // //} // //queryString = queryString.Substring(0, queryString.Length - 3); // //ObjectQuery<StocktakeRequest> requestQuery = new ObjectQuery<StocktakeRequest>(queryString, _context).Include("RequestBy/UserGroup"); // ////ObjectQuery<StocktakeRequest> requests = new ObjectQuery<StocktakeRequest>(queryString, _context).Where(r=>r.StocktakeDetails.Any( // ////requests.Where(r=>r.StocktakeDetails. // //return requestQuery.ToList(); // //_context.StocktakeRequest.Include("RequestBy/UserGroup"); // //return new List<StocktakeRequest>(); //} public IQueryable <ViewStockTakeRequest> QueryRequestDetailsByPage(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd, int pageSize, int pageNumber, out int pageCount, out int itemCount) { IQueryable <ViewStockTakeRequest> query = QueryRequestDetails(condition, dateStart, dateEnd).OrderBy(d => d.RequestNumber).ThenBy(d => d.PartCode); return(GetQueryByPage <ViewStockTakeRequest>(query, pageSize, pageNumber, out pageCount, out itemCount)); }
public IQueryable <StocktakeRequest> QueryRequestByPage(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd, int pageSize, int pageNumber, out int pageCount, out int itemCount) { var queryResult = QueryRequest(condition, dateStart, dateEnd).OrderByDescending(d => d.DateRequest); return(this.GetQueryByPage(queryResult, pageSize, pageNumber, out pageCount, out itemCount)); }
public List <StocktakeRequest> QueryRequestList(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd) { return(QueryRequest(condition, dateStart, dateEnd).ToList()); }
public IQueryable <StocktakeRequest> QueryRequest(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd) { //IQueryable<ViewStockTakeRequest> details = QueryRequestDetails(condition); var requestQuery = from d in _context.StocktakeRequest join v in _context.ViewStockTakeRequestSet on d.RequestID equals v.RequestID select new { v, d }; // string[] requests = details.Select(d => d.RequestID).Distinct().Cast<string>().ToArray(); //string requestStr = string.Join(",",requests); //string esql = string.Format("SELECT VALUE r FROM {0}.StocktakeRequest WHERE r.RequestID IN ({1})", _context.DefaultContainerName,requestStr); //string esql = string.Format("SELECT VALUE DISTINCT r FROM {0}.StocktakeRequest AS r LEFT OUTER JOIN {0}.ViewStockTakeRequestSet AS vr ON r.RequestID=vr.RequestID", _context.DefaultContainerName); StringBuilder strWhere = new StringBuilder(); if (!string.IsNullOrEmpty(condition.RequestNumber)) { //strWhere.Append(" vr.RequestNumber='" + condition.RequestNumber + "' AND"); requestQuery = requestQuery.Where(vq => vq.d.RequestNumber == condition.RequestNumber); } if (!string.IsNullOrEmpty(condition.UserName)) { //strWhere.Append(" vr.UserName='******' AND");// requestQuery = requestQuery.Where(vq => vq.d.RequestBy.UserName == condition.UserName); } if (condition.PlantID != null) { //strWhere.Append(" vr.PlantID=" + condition.PlantID + " AND"); requestQuery = requestQuery.Where(vq => vq.v.PlantID.Value == condition.PlantID.Value); } if (!string.IsNullOrEmpty(condition.PartCode)) { //strWhere.Append(" vr.PartCode='" + condition.PartCode + "' AND"); requestQuery = requestQuery.Where(vq => vq.v.PartCode == condition.PartCode); } if (condition.StocktakeType != null) { //strWhere.Append(" vr.StocktakeType=" + condition.StocktakeType + " AND"); requestQuery = requestQuery.Where(vq => vq.v.StocktakeType.Value == condition.StocktakeType.Value); } if (!string.IsNullOrEmpty(condition.PartChineseName)) { //strWhere.Append(" vr.PartChineseName='" + condition.PartChineseName + "' AND"); requestQuery = requestQuery.Where(vq => vq.v.PartChineseName == condition.PartChineseName); } if (condition.IsStatic != null) { //strWhere.Append(" vr.IsStatic.Value=" + condition.IsStatic.Value + " AND"); requestQuery = requestQuery.Where(vq => vq.v.IsStatic.Value == condition.IsStatic.Value); } if (condition.Status != null) { requestQuery = requestQuery.Where(vq => vq.v.Status == condition.Status); } if (condition.IsCycleCount != null) { requestQuery = requestQuery.Where(vq => vq.v.IsCycleCount == condition.IsCycleCount); } if (dateStart != null) { requestQuery = requestQuery.Where(vq => vq.v.DateRequest >= dateStart); } if (dateEnd != null) { requestQuery = requestQuery.Where(vq => vq.v.DateRequest <= dateEnd); } return(requestQuery.Select(vq => vq.d).Include("RequestBy.UserGroup").Distinct().OrderBy(d => d.RequestNumber)); }
public List <StocktakeRequest> QueryStocktakeRequestByPage(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd, int pageSize, int pageNumber, out int pageCount, out int itemCount) { return(Channel.QueryStocktakeRequestByPage(condition, dateStart, dateEnd, pageSize, pageNumber, out pageCount, out itemCount)); }
public List <SGM.ECount.DataModel.StocktakeRequest> QueryStocktakeRequest(ViewStockTakeRequest condition, DateTime?dateStart, DateTime?dateEnd) //(long? requestID, string requestNumber, string userName, int? plantID, string partCode, int? stocktakeType, string partChineseName, DateTime? dateStart, DateTime? dateEnd) { return(Channel.QueryStocktakeRequest(condition, dateStart, dateEnd)); //(requestID, requestNumber, userName, plantID, partCode, stocktakeType, partChineseName, dateStart, dateEnd); }