public static WaferQuery GetWaferQuery(HttpRequestBase req) { WaferQuery query = new WaferQuery { SearchType = req.QueryString["SearchType"], ProductName = req.QueryString["ProductName"], WaferCode = req.QueryString["WaferCode"], LotId = req.QueryString["LotId"], WaferID = req.QueryString["WaferID"], TransformID = req.QueryString["TransformID"], PEDispose = StringHelper.isNullOrEmpty(req.QueryString["PEDispose"]) ? -1 : Convert.ToInt32(req.QueryString["PEDispose"]), PEComment = req.QueryString["PEComment"], QADispose = StringHelper.isNullOrEmpty(req.QueryString["QADispose"]) ? -1 : Convert.ToInt32(req.QueryString["QADispose"]), QAComment = req.QueryString["QAComment"], SPRDDecision = StringHelper.isNullOrEmpty(req.QueryString["SPRDDecision"]) ? -1 : Convert.ToInt32(req.QueryString["SPRDDecision"]), VendorComment = req.QueryString["VendorComment"], Osat = req.QueryString["Osat"], Status = StringHelper.isNullOrEmpty(req.QueryString["Status"]) ? -1 : Convert.ToInt32(req.QueryString["Status"]), HoldReason = req.QueryString["HoldReason"], Yield = req.QueryString["Yield"], CompletionDate = req.QueryString["CompletionDate"], OrderBy = req.QueryString["OrderBy"], OrderDesc = StringHelper.isNullOrEmpty(req.QueryString["OrderDesc"]) ? false : Convert.ToBoolean(req.QueryString["OrderDesc"]), LastDays = StringHelper.isNullOrEmpty(req.QueryString["LastDays"]) ? 1 : Convert.ToInt32(req.QueryString["LastDays"]), }; return(query); }
public IList <Wafer> GetAllWaferBy(WaferQuery query, int pageSize, int pageIndex, out int recoedCount) { Conditions conditions = GetCondition(query); OrderExpression orderExpression = null; // List<string> orderList = new List<string>(); if (!StringHelper.isNullOrEmpty(query.OrderBy)) { orderExpression = new OrderExpression(query.OrderBy, query.OrderDesc); // orderList.Add(query.OrderBy); } orderExpression = new OrderExpression("WaferID", false); // orderList.Add("WaferID"); return(this.dbGateway.getRecords(pageIndex, pageSize, conditions, orderExpression, null, Connector.AND, out recoedCount)); }
public ActionResult Search(int pageSize, int pageIndex) { WaferQuery query = WaferQueryUtility.GetWaferQuery(base.Request); if (StringHelper.isNullOrEmpty(query.OrderBy)) { query.OrderBy = "CreateDate"; query.OrderDesc = true; } if (CurrentUserInfo.Role == UserRoles.Fab || CurrentUserInfo.Role == UserRoles.FabAdmin) { query.Osat = CurrentUserInfo.BUName; query.Status = (int)WaferStatus.WaitVendor; } int recordCount = 0; IList <Wafer> list = service.GetAllWaferBy(query, pageSize, pageIndex, out recordCount); if (list != null && list.Count > 0) { foreach (Wafer item in list) { item.StatusText = WaferHelper.waferStatusDes(item.Status); item.PEDisposeText = WaferHelper.WaferSelectionDes(item.PEDispose); item.QADisposeText = WaferHelper.WaferSelectionDes(item.QADispose); item.SPRDDecisionText = WaferHelper.WaferSelectionDes(item.SPRDDecision); Boolean IsTriggered = false; IList <Wafer_Sbin> ListSbin = sbinService.GetWaferSbin(item.TransformID, item.ID); foreach (Wafer_Sbin sbin in ListSbin) { if (sbin.IsTriggered) { IsTriggered = true; } } item.IsTriggered = IsTriggered; } } var json = JsonConvert.SerializeObject(new { currentPage = pageIndex, totalPages = PagerUtility.GetPageCount(recordCount, pageSize), rows = list, }); base.Response.Write(json); return(null); }
public ActionResult ExportData() { WaferQuery query = WaferQueryUtility.GetWaferQuery(base.Request); int recordCount = 0; string xlsName = string.Format("Wafer_{0}", DateTime.Now.ToString("yyyyMMdd_hhmmss")); if (StringHelper.isNullOrEmpty(query.OrderBy)) { query.OrderBy = "CreateDate"; query.OrderDesc = true; } if (CurrentUserInfo.Role == UserRoles.Fab || CurrentUserInfo.Role == UserRoles.FabAdmin) { query.Osat = CurrentUserInfo.BUName; query.Status = (int)WaferStatus.WaitVendor; } IList <Wafer> list = service.GetAllWaferBy(query, 0xf423f, 0, out recordCount); if (list != null && list.Count > 0) { foreach (Wafer item in list) { item.StatusText = WaferHelper.waferStatusDes(item.Status); item.PEDisposeText = WaferHelper.WaferSelectionDes(item.PEDispose); item.QADisposeText = WaferHelper.WaferSelectionDes(item.QADispose); item.SPRDDecisionText = WaferHelper.WaferSelectionDes(item.SPRDDecision); } } string path = "/Export/Excels/Wafer/"; string mp = Server.MapPath("~") + path; if (!Directory.Exists(mp)) { Directory.CreateDirectory(mp); } string nextUrl = Exporthelper.GetExport <Wafer>("LOTS", list, "/Export/Excels/Wafer/", "/Content/Exports/ExportWafer.xml", xlsName, 0, 0); ResponseTypes redirect = ResponseTypes.Redirect; TipTypes information = TipTypes.Information; base.Response.Write(new HandlerResponse("0", "导出Excel文件", redirect.ToString(), information.ToString(), nextUrl, "", "").GenerateJsonResponse()); return(null); }
private Conditions GetCondition(WaferQuery query) { Conditions conditions = new Conditions(); if (!StringHelper.isNullOrEmpty(query.SearchType)) { conditions.ConditionExpressions.Add(new Condition("AutoJudeResult", Operator.EqualTo, query.SearchType)); } if (!StringHelper.isNullOrEmpty(query.ProductName)) { conditions.ConditionExpressions.Add(new Condition("ProductName", Operator.Like, query.ProductName)); } if (!StringHelper.isNullOrEmpty(query.WaferCode)) { conditions.ConditionExpressions.Add(new Condition("WaferCode", Operator.Like, query.WaferCode)); } if (!StringHelper.isNullOrEmpty(query.Osat)) { conditions.ConditionExpressions.Add(new Condition("Vendor", Operator.EqualTo, query.Osat)); } if (!StringHelper.isNullOrEmpty(query.LotId)) { conditions.ConditionExpressions.Add(new Condition("LotId", Operator.Like, query.LotId)); } if (!StringHelper.isNullOrEmpty(query.WaferID)) { conditions.ConditionExpressions.Add(new Condition("WaferID", Operator.EqualTo, query.WaferID)); } if (!StringHelper.isNullOrEmpty(query.TransformID)) { conditions.ConditionExpressions.Add(new Condition("TransformID", Operator.EqualTo, query.TransformID)); } if (query.PEDispose > 0) { conditions.ConditionExpressions.Add(new Condition("PEDispose", Operator.EqualTo, query.PEDispose)); } if (!StringHelper.isNullOrEmpty(query.PEComment)) { conditions.ConditionExpressions.Add(new Condition("PEComment", Operator.Like, query.PEComment)); } if (query.QADispose > 0) { conditions.ConditionExpressions.Add(new Condition("QADispose", Operator.EqualTo, query.QADispose)); } if (!StringHelper.isNullOrEmpty(query.QAComment)) { conditions.ConditionExpressions.Add(new Condition("QAComment", Operator.Like, query.QAComment)); } if (query.SPRDDecision > 0) { conditions.ConditionExpressions.Add(new Condition("SPRDDecision", Operator.EqualTo, query.SPRDDecision)); } if (!StringHelper.isNullOrEmpty(query.VendorComment)) { conditions.ConditionExpressions.Add(new Condition("VendorComment", Operator.Like, query.VendorComment)); } if (!StringHelper.isNullOrEmpty(query.Osat)) { conditions.ConditionExpressions.Add(new Condition("Vendor", Operator.Like, query.Osat)); } if (query.Status > 0) { conditions.ConditionExpressions.Add(new Condition("Status", Operator.EqualTo, query.Status)); } if (!StringHelper.isNullOrEmpty(query.HoldReason)) { conditions.ConditionExpressions.Add(new Condition("HoldReason", Operator.Like, query.HoldReason)); } if (!StringHelper.isNullOrEmpty(query.Yield)) { conditions.ConditionExpressions.Add(new Condition("Yield", Operator.EqualTo, query.Yield)); } if (!StringHelper.isNullOrEmpty(query.CompletionDate)) { string[] dateArray = query.CompletionDate.Split('-'); conditions.ConditionExpressions.Add(new Condition("CompletionDate", Operator.Between, dateArray[0], dateArray[1] + " 23:59:59")); } if (query.LastDays > 0) { var dt = DateTime.Now.ToLocalTime(); if (query.LastDays == 1) { conditions.ConditionExpressions.Add(new Condition("CompletionDate", Operator.Between, dt.AddHours(-24), dt)); } else { string str_startTime = dt.AddDays(-2).ToShortDateString(); conditions.ConditionExpressions.Add(new Condition("CompletionDate", Operator.Between, str_startTime, dt.ToShortDateString())); } } if (!StringHelper.isNullOrEmpty(query.CreateDate)) { string[] dateArray = query.CreateDate.Split('-'); conditions.ConditionExpressions.Add(new Condition("CreateDate", Operator.Between, dateArray[0], dateArray[1] + " 23:59:59")); } conditions.Connector = Connector.AND; return(conditions); }
public IList <Wafer> GetAllWaferBy(WaferQuery query, int pageSize, int pageIndex, out int recoedCount) { return(this.way.GetAllWaferBy(query, pageSize, pageIndex, out recoedCount)); }