public ActionResult HistorySearch(int pageSize, int pageIndex)
{
HistoryQuery query = HistoryQueryUtility.GetHistoryQuery(base.Request);
int recordCount = 0;
IList <VwWafer_History> list = historyService.HistoryList(query, pageSize, pageIndex, out recordCount);
if (list != null && list.Count > 0)
{
foreach (VwWafer_History history in list)
{
if (history.IsVendor)
{
history.DisposeText = "Confirmed";
}
else
{
history.DisposeText = WaferHelper.WaferSelectionDes(history.Dispose);
}
}
}
var json = JsonConvert.SerializeObject(new
{
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = list,
});
base.Response.Write(json);
return(null);
}
public ActionResult WaferSbin(DetailWaferQuery query, int pageIndex, int pageSize)
{
int recordCount = 0;
IList <Wafer> list = service.GetWaferByLotid(query, pageIndex, pageSize, out recordCount);
if (list != null && list.Count > 0)
{
foreach (Wafer item in list)
{
if (item.StartTime != null)
{
if (item.StartTime.Year == 1900)
{
item.StrStartTime = "";
}
else
{
item.StrStartTime = item.StartTime.ToString("yyyy/MM/dd");
}
}
item.ListSbin = sbinService.GetWaferSbin(query.TransformID, item.ID);
}
}
var json = JsonConvert.SerializeObject(new
{
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = list,
});
base.Response.Write(json);
return(null);
}
public ActionResult CommentList(string lotID, int pageIndex = 0, int pageSize = 5)
{
int recordCount = 0;
IList <TranformedComment> list = null;
if (CurrentUserInfo.Role == UserRoles.Fab || CurrentUserInfo.Role == UserRoles.FabAdmin)
{
list = service.GetCommentsByLotID(lotID, "", true, pageIndex, pageSize, out recordCount);
}
else
{
list = service.GetCommentsByLotID(lotID, "", false, pageIndex, pageSize, out recordCount);
}
bool flag = ConfigurationManager.AppSettings["LocalDownload"] == "1";
string str = ConfigurationManager.AppSettings["RemoteDownloadUrlPrefix"];
for (int i = 0; i <= (list.Count - 1); i++)
{
for (int j = 0; j <= (list[i].Attachments.Count - 1); j++)
{
if (!flag)
{
list[i].Attachments[j].StoreRelativePath = str + list[i].Attachments[j].StoreRelativePath;
}
}
}
var data = new
{
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = list
};
return(base.Json(data));
}
public ActionResult getSWBin(string lotID, string code, string defect, string qty, string failRate, string isPassed, string limited, string orderBy, bool desc = false, int pageIndex = 0, int pageSize = 5)
{
int recordCount = 0;
IList <SWBin> list = LotService.GetSWBinsBy(lotID, code, defect, qty, failRate, isPassed, limited, orderBy, desc, pageIndex, pageSize, out recordCount);
var data = new {
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = list
};
return(base.Json(data));
}
public ActionResult Search(int pageSize, int pageIndex = 0, string orderBy = "", bool desc = false)
{
//if (DateTime.Now <= Convert.ToDateTime("2017-12-31"))
//{
// if (StringHelper.isNullOrEmpty(orderBy))
// {
// orderBy = "UpdateTime";
// desc = true;
// }
// int recordCount = 0;
// LotQuery queryFromRequest = QueryUtility.GetQueryFromRequest(base.Request, BaseController.CurrentUserInfo.UserID);
// if ((BaseController.CurrentUserInfo.Role == UserRoles.OSAT) || (BaseController.CurrentUserInfo.Role == UserRoles.OSATAdmin))
// {
// queryFromRequest.Osat = BaseController.CurrentUserInfo.BUName;
// }
// IList<LotView> list = LotService.GetLotViews(queryFromRequest, orderBy, desc, pageIndex, pageSize, out recordCount);
// string s = JsonConvert.SerializeObject(new { currentPage = pageIndex, totalPages = PagerUtility.GetPageCount(recordCount, pageSize), rows = list });
// base.Response.Write(s);
//}
//return null;
if (StringHelper.isNullOrEmpty(orderBy))
{
orderBy = "UpdateTime";
desc = true;
}
int recordCount = 0;
LotQuery queryFromRequest = QueryUtility.GetQueryFromRequest(base.Request, BaseController.CurrentUserInfo.UserID);
if (BaseController.CurrentUserInfo.Role == UserRoles.OSAT || BaseController.CurrentUserInfo.Role == UserRoles.OSATAdmin)
{
queryFromRequest.Osat = BaseController.CurrentUserInfo.BUName;
}
IList <LotView> lotViews = LotService.GetLotViews(queryFromRequest, orderBy, desc, pageIndex, pageSize, out recordCount);
foreach (LotView lv in lotViews)
{
lv.HoldReason = lv.HoldReason.Replace("failed sublot:", "");
}
string s = JsonConvert.SerializeObject(new
{
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = lotViews
});
base.Response.Write(s);
return(null);
}
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 Search(int pageSize, int pageIndex)
{
Lot_TransformedQuery query = TransformQueryUtility.GetLotTransformQuery(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;
//query.PeVendorState = (int)WaferStatus.WaitPEVendor;
}
int recordCount = 0;
IList <Lot_Transformed> list = service.GetAllLots(query, pageSize, pageIndex, out recordCount);
if (list != null && list.Count > 0)
{
DateTime dt = DateTime.Parse(DateTime.Now.ToLocalTime().ToShortDateString());
foreach (Lot_Transformed lot in list)
{
lot.StatusText = WaferHelper.waferStatusDes(lot.Status);
int recordcount = 0;
IList <File> listFile = FileSystemService.GetFilesBy(lot.ID, "", "", "", "", FileStates.NotSpecified, FileTypes.NotSpecifiled, "", false, 0xf423f, 0, out recordcount);
lot.FileCount = recordcount;
lot.DiesposRemark = waferService.LoadCountByDispose(lot.ID, lot.Status);
lot.dayCount = (dt - DateTime.Parse(lot.CompletionDate.ToShortDateString())).Days;
}
}
var json = JsonConvert.SerializeObject(new
{
currentPage = pageIndex,
totalPages = PagerUtility.GetPageCount(recordCount, pageSize),
rows = list
});
base.Response.Write(json);
return(null);
}
public override void DataBind()
{
//base.DataBind();
MonoXCacheManager cacheManager = MonoXCacheManager.GetInstance(TweetsCacheKey, this.CacheDuration);
KeyValuePair <SyndicationFeed, int> bindContainer = cacheManager.Get <KeyValuePair <SyndicationFeed, int> >(ProfileName, TweetsCount);
if (bindContainer.Value == 0)
{
try
{
TweetsCount = TweetsCount.HasValue ? TweetsCount : 10;
var url = string.Format("http://api.twitter.com/1/statuses/user_timeline.rss?screen_name={0}&count={1}", ProfileName, TweetsCount);
SyndicationFeed feed = LoadFrom(url);
bindContainer = new KeyValuePair <SyndicationFeed, int>(feed, feed.Items.Count());
cacheManager.Store(bindContainer, ProfileName, TweetsCount);
}
catch (Exception ex)
{
log.Error(ex);
}
try
{
if (Page.User.Identity.IsAuthenticated)
{
//Save the Tweets to the DB
Guid listId = Guid.Empty;
if (!Guid.Empty.Equals(ListId))
{
listId = ListId;
}
else if (!String.IsNullOrEmpty(ListName))
{
listId = BaseMonoXRepository.GetInstance().GetFieldValue <Guid>(ListFields.Title, ListName, ListFields.Id);
}
if (Guid.Empty.Equals(listId) && !String.IsNullOrEmpty(ListName))
{
//Create a List
ListEntity list = ListRepository.GetInstance().CreateNewList();
list.Title = ListName;
list.UserId = SecurityUtility.GetUserId();
list.ListType = 0;
ListRepository.GetInstance().SaveEntity(list, true);
listId = list.Id;
}
if (!Guid.Empty.Equals(listId))
{
foreach (var item in bindContainer.Key.Items)
{
Guid urlId = BaseMonoXRepository.GetInstance().GetFieldValue <Guid>(ListItemLocalizationFields.ItemUrl, item.Id, ListItemLocalizationFields.Id);
if (!Guid.Empty.Equals(urlId))
{
break; //Suppose that we have imported upcoming tweets
}
ListItemEntity listItem = ListRepository.GetInstance().CreateNewListItem(listId);
listItem.DateCreated = Convert.ToDateTime(item.PublishDate.ToString());
listItem.ItemTitle = HtmlFormatTweet(item.Title.Text);
listItem.ItemUrl = item.Id;
ListRepository.GetInstance().SaveEntity(listItem);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
}
}
//Note: We need to perform the in-memory paging
List <SyndicationItem> items = bindContainer.Key.Items.Skip(pager.CurrentPageIndex * pager.PageSize).Take(pager.PageSize).ToList();
PagerUtility.BindPager(pager, DataBind, lvItems, items, bindContainer.Value);
if (HideIfEmpty)
{
this.Visible = (bindContainer.Value != 0);
}
}
public ActionResult DisplayUsersByRole(int pageSize, int pageIndex, string hidCurrentRole, string selJobType)
{
int recordCount = 0;
string email = base.Request.QueryString["txtEmail"];
string role = base.Request.QueryString["cmbRoleText"];
string accountState = base.Request.QueryString["cmbAccountState"];
switch (accountState)
{
case "":
case null:
accountState = "Active";
break;
}
IList <User> list = UserService.GetUsersBy(base.Request.QueryString["txtFullName"], email, role, selJobType, accountState, pageIndex, pageSize, out recordCount);
string s = JsonConvert.SerializeObject(new { currentPage = pageIndex, totalPages = PagerUtility.GetPageCount(recordCount, pageSize), rows = list });
base.Response.Write(s);
return(null);
}
