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);
}
