public ActionResult ExportHistory()
{
string xlsName = string.Format("History_{0}", DateTime.Now.ToString("yyyyMMdd_hhmmss"));
HistoryQuery query = HistoryQueryUtility.GetHistoryQuery(base.Request);
int recordCount = 0;
IList <VwWafer_History> list = historyService.HistoryList(query, 0xf423f, 0, 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);
}
}
}
string nextUrl = Exporthelper.GetExport <VwWafer_History>("Historys", list, "/Export/Excels/History/", "/Content/Exports/ExportHistory.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);
}
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 ExportData(Lot_TransformedQuery query)
{
int recordCount = 0;
string xlsName = string.Format("Transform_{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 <Lot_Transformed> list = service.GetAllLots(query, 0xf423f, 0, out recordCount);
if (list != null && list.Count > 0)
{
foreach (Lot_Transformed lot in list)
{
lot.StatusText = WaferHelper.waferStatusDes(lot.Status);
}
}
string nextUrl = Exporthelper.GetExport <Lot_Transformed>("LOTS", list, "/Export/Excels/Transform/", "/Content/Exports/ExportTransform.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);
}
public static void CreateCpOSATConfirmNotificationsWhilePeDispose(string osatID, Lot_Transformed lot, string message, int dispose)
{
new Dictionary <string, string>();
foreach (OSATUser user in UserService.GetCPOSATUsersByOSATID(osatID))
{
//Notification newNotification = new Notification
//{
// CreateTime = DateTime.Now,
// EmailID = Guid.NewGuid().ToString(),
// LotID = lot.ID,
// Message = message,
// MessageID = Guid.NewGuid().ToString(),
// NotificationType = NotificationTypes.Confirm,
// Opened = false,
// ReadTime = Convert.ToDateTime("1999-12-31"),
// RecipientID = user.MD5CID,
// RecordState = 0,
// UpdateTime = DateTime.Now
//};
//notificationGateway.AddNew(newNotification);
string newvalue = WaferHelper.WaferSelectionDes(dispose);
string str = emailGateway.GetEmailByID("OSATNotificationCP").Body.Replace("InsertFullNameHere", user.SupUserName).Replace("insertLotNoHere", lot.LotId).Replace("InsertUrlHere", string.Format("https://lhd.unisoc.com/Lots/wafer/list?transformID={0}", lot.ID)).Replace("InsertTimeHere", DateTime.Now.ToString("yyyy-MM-dd hh:MM:ss")).Replace("insertDisposeTextHere", newvalue);
string subject = string.Format("Please confirm Lot {0} dispose", lot.LotId);
CreateEmail(Guid.NewGuid().ToString(), user.MD5CID, user.SupMail, subject, str, lot.ID);
}
}
public ActionResult mDetail(string id)
{
Lot_Transformed lot = service.GetTransformById(id);
if (lot != null)
{
lot.StatusText = WaferHelper.waferStatusDes(lot.Status);
}
IList <Wafer_Sbin> list = sbinService.GetSbinTextByLotId(id);
LotDetailModel model = new LotDetailModel();
model.LotTransformed = lot;
model.ListSbin = list;
return(base.View(model));
}
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);
}
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);
}
