public static short GetVid(string vName)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.vendor_info where row.vendor_name == vName select row.vendor_id).FirstOrDefault());
}
}
public static short Gettid(string tName)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.type_info where row.type_name == tName select row.type_id).FirstOrDefault());
}
}
public static short GetDepartmentId(string dName)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.department_info where row.department_name == dName select row.department_id).FirstOrDefault());
}
}
public static string GettName(string tid)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.type_info where row.type_id == Convert.ToInt16(tid) select row.type_name).FirstOrDefault());
}
}
public JsonResult JsonMobileGetMenuItem(string username)
{
IEnumerable <ListModel> items = null;
string Msg = null;
bool IsSuccess = false;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
try
{
var temp = from row in db.MobileLogin where row.login_name == username select row;
if (temp.Any())
{
items = ListModel.GetDepartmentTitleList();
if (items.Count() > 0)
{
IsSuccess = true;
}
}
else
{
IsSuccess = false;
}
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
}
return(this.Json(new { IsSuccess = IsSuccess, Msg = Msg, data = items }, JsonRequestBehavior.AllowGet));
}
public static ATScheduleModel GetATSchedule(int ATSID)
{
ATScheduleModel ATSchedule = new ATScheduleModel();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ATSchedule = (from row in db.ATSchedule_info
where row.ATSID == ATSID
select new ATScheduleModel
{
ATSID = row.ATSID,
ATName = row.ATName,
buileDate = DateTime.Parse(row.buileDate.ToString()).ToString("yyyy-MM-dd"),
ExecuteType = row.ExecuteType,
ExecuteCycle = row.ExecuteCycle,
ExecuteTime = DateTime.FromBinary(row.ExecuteTime.Ticks).ToString("HH:mm"),
ExecuteHour = (byte)row.ExecuteTime.Hours,
ExecuteMinute = (byte)row.ExecuteTime.Minutes,
DataType = row.DataType,
DataCycle = row.DataCycle,
DataRangeTime = DateTime.FromBinary(row.DataRangeTime.Ticks).ToString("HH:mm"),
DataRangeHour = (byte)row.DataRangeTime.Hours,
DataRangeMinute = (byte)row.DataRangeTime.Minutes,
SamplingTime = row.SamplingTime,
Login_name = row.Login_name
}).SingleOrDefault();
}
return(ATSchedule);
}
public static IEnumerable <ATScheduleModel> GetScheduleList(string Login_name)
{
List <ATScheduleModel> ATScheduleList = new List <ATScheduleModel>();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ATScheduleList = (from row in db.ATSchedule_info
where row.Login_name == Login_name
select new ATScheduleModel
{
ATSID = row.ATSID,
ATName = row.ATName,
buileDate = DateTime.Parse(row.buileDate.ToString()).ToString("yyyy-MM-dd"),
ExecuteType = row.ExecuteType,
ExecuteCycle = row.ExecuteCycle,
ExecuteTime = DateTime.FromBinary(row.ExecuteTime.Ticks).ToString("HH:mm"),
DataType = row.DataType,
DataCycle = row.DataCycle,
DataRangeTime = DateTime.FromBinary(row.DataRangeTime.Ticks).ToString("HH:mm"),
SamplingTime = row.SamplingTime,
Login_name = row.Login_name
}).ToList();
}
return(ATScheduleList);
}
public static int GetPid(string Toolid)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.vw_eq_status where row.chamberName == Toolid select row.pid).FirstOrDefault());
}
}
public static List <MachineStatusModel> GetMachineStatus(string vName)
{
List <MachineStatusModel> MachineStatusList = new List <MachineStatusModel>();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var vw_eq_status = (from row in db.vw_eq_status select row).ToList();
var machineGroup = (from row in vw_eq_status where row.vName == vName select row.groupName).Distinct();
foreach (string gname in machineGroup)
{
MachineStatusModel MachineStatusModel1 = new MachineStatusModel();
MachineStatusModel1.GroupName = gname;
MachineStatusModel1.MachineCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName select row).Count();
MachineStatusModel1.NormlCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName && row.sid == 0 select row).Count();
MachineStatusModel1.AlarmCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName && (row.sid == 1 || row.sid == 2) select row).Count();
MachineStatusModel1.PMCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName && row.sid == 8 select row).Count();
MachineStatusModel1.OtherCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName && (row.sid != 0 && row.sid != 1 && row.sid != 2 && row.sid != 8 && row.sid != 16) select row).Count();
MachineStatusModel1.ServiceCount = (from row in vw_eq_status where row.groupName == gname && row.vName == vName && row.sid == 16 select row).Count();
MachineStatusList.Add(MachineStatusModel1);
}
}
return(MachineStatusList);
}
internal static List <string> GetAllDevice()
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.vw_FDC_KEP_Tag_load orderby row.built_date descending select row.channel_name).Distinct().ToList());
}
}
public static Int32 GetDPMPid(string Toolid)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
return((from row in db.vw_dpm_status where row.toolid == Toolid select row.pid).FirstOrDefault());
}
}
public string addPM_ScheduleALL(string toolid, int freqid, int frequency, int tolerance, string UsrName)
{
string DBMsg = null;
try
{
string[] split = toolid.Split(',');
//int i = 0;
//string temp = string.Empty;
foreach (string s in split)
{
if (s.Trim() != string.Empty)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var selectplcid = (from row in db.vw_eq_status where row.toolid == s select row.pid).FirstOrDefault();
//temp = temp + selectplcid;
DBConnector.executeSQL("Intouch", "INSERT INTO PM_Schedule (plc_id, tool_id, freq_id, frequency, tolerance, userlogin) VALUES (" + selectplcid + ", '" + s + "', " + freqid + ", " + frequency + ", " + tolerance + ", '" + UsrName + "')");
}
}
}
//DBConnector.executeSQL("Intouch", "UPDATE PM_Schedule SET frequency = " + frequency + ", tolerance = " + tolerance + ", userlogin = '******' WHERE tool_id = '" + toolid + "'");
//DBConnector.executeSQL("Intouch", "INSERT INTO PM_Schedule (plc_id, tool_id, freq_id, frequency, tolerance, userlogin) VALUES (" + plcid + ", '" + toolid + "', " + freqid + ", " + frequency + ", " + tolerance + ", '" + UsrName + "')");
//DBConnector.executeSQL("Intouch", "UPDATE plc_info SET onoffStatus = " + status + ", PowerOnDate = '" + powerondate + "' WHERE tool_id = '" + toolid + "'");
DBMsg = toolid + "PM週期已新增完成\n";
}
catch (Exception ex)
{
DBMsg += "PM週期設定失敗 原因 : " + ex.Message + "\n";
}
return(DBMsg);
}
//設定PM週期
public string EditPM(string selectvendor, string selectplcid, string selecttoolid, string selectfrequency, int selectfreq_id, string UsrID)
{
string DBMsg = null;
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
//DBMsg += "0";
var count = (from row in db.PM_Schedule where row.tool_id == selecttoolid select row.id).Count();
//DBMsg += "1";
var selecttolerance = (from row in db.PM_frequency_info where row.freq_id == selectfreq_id select row.PM_tolerance).FirstOrDefault();
if (count == 0)
{
DBConnector.executeSQL("Intouch", "INSERT INTO PM_Schedule (plc_id, tool_id, freq_id, frequency, tolerance, userlogin) VALUES (" + selectplcid + ", '" + selecttoolid + "', " + selectfreq_id + ", " + selectfrequency + ", " + selecttolerance + ", '" + UsrID + "')");
DBMsg = selecttoolid + "PM週期設定完成\n";
}
else if (count > 0)
{
DBConnector.executeSQL("Intouch", "UPDATE PM_Schedule SET freq_id = " + selectfreq_id + ", frequency = " + selectfrequency + ", tolerance = " + selecttolerance + ", userlogin = '******' WHERE plc_id = " + selectplcid + " AND tool_id = '" + selecttoolid + "'");
DBMsg = selecttoolid + "PM週期已更新完成\n";
}
}
}
catch (Exception ex)
{
DBMsg += "PM週期設定失敗 原因 : " + ex.Message + "\n";
}
return(DBMsg);
}
internal static string SetPhoneCallSetting(string[] data, string Usr)
{
string rString = string.Empty;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
foreach (string item in data)
{
string fulltagname = item.Split(':')[0];
bool setting = bool.Parse(item.Split(':')[1]);
var rr = (from row in db.vw_PhoneCallSetting where row.FullTagName == fulltagname select row).SingleOrDefault();
try
{
if (rr != null)
{
DBConnector.executeSQL("Intouch", "EXEC [dbo].[uSP_Change_PhoneCallSetting] @FullTagName='" + rr.FullTagName + "',@data_Tag='" + rr.data_Tag + "',@plc_id=" + rr.plc_id + ",@sensorID='" + rr.sensorID + "',@CallOut=" + setting + ",@login_name='" + Usr + "'");
rString = "Setting OK";
}
else
{
rString = "Setting Fail";
}
}
catch (Exception ex)
{
rString = ex.Message;
}
}
}
return(rString);
}
public static string Update(SensorTagModel s)
{
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = (from row in db.plc_info where row.plc_id == s.plc_id select row).SingleOrDefault();
if (r != null)
{
r.LinkProcessData = s.LinkProcessData;
r.SensorTag = s.sensorTag;
r.ChamberTag = s.chamberTag;
//if (!r.Any())
//{
// db.SenSorTag_info.InsertOnSubmit(tmp);
//}
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
return(null);
}
public JsonResult JsonMobileLogout(string username)
{
bool IsSuccess = false;
string Msg = "失敗…";
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var ML = from row in db.MobileLogin where row.login_name == username select row;
db.MobileLogin.DeleteAllOnSubmit(ML.ToList());
db.SubmitChanges();
FormsAuthentication.SignOut();
}
IsSuccess = true;
Msg = "登出成功";
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
return(Json(new { IsSuccess = IsSuccess, Msg = Msg }, JsonRequestBehavior.AllowGet));
}
//for Index pass VendorName & Status
public static IEnumerable <StatusDetialModel> StatusDetial(string vName, string status)
{
List <StatusDetialModel> StatusDetialList = new List <StatusDetialModel>();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
if (status.Equals("others"))
{
StatusDetialList = (from row in db.vw_eq_status
where row.vName == vName && !(new int?[] { 0, 1, 2, 8, 20 }).Contains(row.sid)
select new StatusDetialModel
{
Statusid = row.sid,
gName = row.groupName == null ? string.Empty : row.groupName,
ToolID = row.toolid,
location = row.loc == null ? string.Empty : row.loc,
//LocationID = row.lid,
//LocationSide = row.locSide == null ? string.Empty : row.locSide,
TypeName = row.tName
}).ToList();
}
//service數
else if (status.Equals("Service"))
{
StatusDetialList = (from row in db.vw_eq_status
where row.vName == vName && row.sid == 20
select new StatusDetialModel
{
Statusid = row.sid,
gName = row.groupName == null ? string.Empty : row.groupName,
ToolID = row.toolid,
location = row.loc == null ? string.Empty : row.loc,
//LocationID = row.lid,
//LocationSide = row.locSide == null ? string.Empty : row.locSide,
TypeName = row.tName
}).ToList();
}
//PM數
else if (status.Equals("PM"))
{
StatusDetialList = (from row in db.vw_eq_status
join roww in db.vw_pm_history on row.pid equals roww.plc_id
where row.vName == vName && row.sid == 8 && roww.pm_set != null && roww.pm_unset == null
select new StatusDetialModel
{
Statusid = row.sid,
gName = row.groupName == null ? string.Empty : row.groupName,
ToolID = row.toolid,
location = row.loc == null ? string.Empty : row.loc,
//LocationID = row.lid ,
//LocationSide = row.locSide == null ? string.Empty : row.locSide,
TypeName = row.tName,
UpdateDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", roww.pm_set),
Op = roww.@operator
}).ToList();
}
}
return(StatusDetialList);
}
public JsonResult JsonMobileLogin(string username, string pwd)
{
bool IsSuccess = false;
string Msg = "失敗…";
try
{
if (LoginModel.Login(username.Trim(), pwd.Trim()))
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var login = (from row in db.MobileLogin where row.login_name == username select row).FirstOrDefault();
if (login != null)
{
login.login_Time = DateTime.Now;
db.SubmitChanges();
}
else
{
MobileLogin ML = new MobileLogin();
ML.login_name = username;
ML.login_Time = DateTime.Now;
db.MobileLogin.InsertOnSubmit(ML);
db.SubmitChanges();
}
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
username,//你想要存放在 User.Identy.Name 的值，通常是使用者帳號
DateTime.Now,
DateTime.Now.AddMinutes(30),
false, //將管理者登入的 Cookie 設定成 Session Cookie
"", //userdata看你想存放啥
FormsAuthentication.FormsCookiePath);
string encTicket = FormsAuthentication.Encrypt(ticket);
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));
IsSuccess = true;
Msg = "登入成功";
}
}
else
{
IsSuccess = false;
Msg = "登入失敗";
}
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
return(Json(new { IsSuccess = IsSuccess, Msg = Msg }, JsonRequestBehavior.AllowGet));
}
public ActionResult DownLoadATCPPT(int ATSID)
{
string ExportFileName = "test.pptx";
try
{
System.IO.File.Copy(Server.MapPath("~/ATSchedule/") + "Sample.pptx", Server.MapPath("~/ATSchedule/") + "SampleTemp.pptx", true);
using (PresentationDocument prstDoc = PresentationDocument.Open(Server.MapPath("~/ATSchedule/") + "SampleTemp.pptx", true))
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var ATSLast = db.vw_ATScheduleLastHistory.Where(x => x.ATSID == ATSID).SingleOrDefault();
if (ATSLast != null)
{
string ATSFolderString = Server.MapPath("~/ATSchedule/") + ATSID + "/" + ATSLast.FolderName;
System.IO.DirectoryInfo ATSFolder = new System.IO.DirectoryInfo(ATSFolderString);
if (ATSFolder.Exists)
{
FileInfo[] ATSFiles = ATSFolder.GetFiles();
for (int i = 0; i < ATSFiles.Count(); i++)
{
string imgId = "rId" + ATSFiles[i].Name;
Slide S = InsertNewSlide(prstDoc, i, imgId, ATSFiles[i]);
InsertImageInLastSlide(S, ATSFiles[i].FullName, "image/png");
}
}
}
else
{
return(null);
}
}
SlideIdList slideIdList = prstDoc.PresentationPart.Presentation.SlideIdList;
SlideId slideId = slideIdList.ChildElements[slideIdList.Count() - 1] as SlideId;
string slideRelId = slideId.RelationshipId;
slideIdList.RemoveChild(slideId);
SlidePart slidePart = prstDoc.PresentationPart.GetPartById(slideRelId) as SlidePart;
prstDoc.PresentationPart.DeletePart(slidePart);
prstDoc.PresentationPart.Presentation.Save();
return(File(Server.MapPath("~/ATSchedule/") + "SampleTemp.pptx", "application/mspowerpoint", ExportFileName));
}
}
catch (Exception ex)
{
MemoryStream fs = new MemoryStream();
TextWriter tx = new StreamWriter(fs);
tx.WriteLine(ex.Message);
tx.Flush();
return(File(fs.ToArray(), "text/text", "error.txt"));
}
}
internal static byte[] GetFDCExportFile(string type)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var al = (from row in db.vw_FDC_KEP_Tag select row).ToList();
if (type == "HJ")
{
al = (from row in al where row.tagname.Substring(0, 4) == "1201" select row).ToList();
}
else if (type == "Edward")
{
al = (from row in al where row.tagname.Substring(0, 4) == "1200" select row).ToList();
}
else if (type == "HN2")
{
al = (from row in al where row.tagname.Substring(0, 4) == "1202" select row).ToList();
}
else if (type == "ExtraSensor")
{
al = (from row in al where row.tagname.Substring(0, 4) == "1203" select row).ToList();
}
else if (type == "PFEIFFER")
{
al = (from row in al where row.tagname.Substring(0, 4) == "1204" select row).ToList();
}
ExcelPackage ep = new ExcelPackage();
ep.Workbook.Worksheets.Add("MySheet");
ExcelWorksheet sheet1 = ep.Workbook.Worksheets["MySheet"];
sheet1.Cells["A1"].Value = "Channel";
sheet1.Cells["B1"].Value = "Device";
sheet1.Cells["C1"].Value = "ToolID";
sheet1.Cells["D1"].Value = "Chamber";
sheet1.Cells["E1"].Value = "SVID";
if (al.Count() > 0)
{
int i = 2;
foreach (var item in al)
{
sheet1.Cells["A" + i].Value = item.channel_name.Split('.')[0];
sheet1.Cells["B" + i].Value = item.channel_name.Split('.')[1];
sheet1.Cells["C" + i].Value = item.toolid;
sheet1.Cells["D" + i].Value = item.ChamberID;
sheet1.Cells["E" + i].Value = item.tagname;
i++;
}
sheet1.Cells.AutoFitColumns();
}
return(ep.GetAsByteArray());
}
}
public static IEnumerable <StatusDetialModel> GetStatusDetial(string vName, string GroupName, string sid, string toolId)
{
List <StatusDetialModel> StatusDetialList = new List <StatusDetialModel>();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
if (GroupName.Length > 0)
{
StatusDetialList = (from row in db.vw_eq_status
where row.vName == vName && row.groupName == GroupName
select new StatusDetialModel
{
Statusid = row.sid,
gName = row.groupName == null ? string.Empty : row.groupName,
ToolID = row.toolid,
location = row.loc == null ? string.Empty : row.loc,
//LocationID = row.lid,
//LocationSide = row.locSide == null ? string.Empty : row.locSide,
TypeName = row.tName
}).ToList();
}
else
{
StatusDetialList = (from row in db.vw_eq_status
where row.vName == vName && row.groupName == null
select new StatusDetialModel
{
Statusid = row.sid,
gName = row.groupName == null ? string.Empty : row.groupName,
ToolID = row.toolid,
location = row.loc == null ? string.Empty : row.loc,
//LocationID = row.lid,
//LocationSide = row.locSide == null ? string.Empty : row.locSide,
TypeName = row.tName
}).ToList();
}
if (sid.Length > 0)
{
StatusDetialList = (from row in StatusDetialList
where row.Statusid.ToString() == sid
select row).ToList();
}
if (toolId.Length > 0)
{
StatusDetialList = (from row in StatusDetialList
where row.ToolID.ToUpper().Contains(toolId.ToUpper())
select row).ToList();
}
}
return(StatusDetialList);
}
public ActionResult EditScheduleChart(int ATSID, string ATName, string TCBIDString)
{
if (!string.IsNullOrEmpty((string)Session["UserID"]))
{
ViewBag.Title = WebCMS.Menu.EditTCBook;
try
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ViewData["ATName"] = ATName;
ViewData["TCBookData"] = db.vw_TCBook_info.Where(x => x.Login_name == (string)Session["UserID"]).ToList();
var ATCList = db.ATC_info.Where(x => x.ATSID == ATSID).ToList();
if (ATCList != null && ATCList.Count > 0)
{
db.ATC_info.DeleteAllOnSubmit(ATCList);
db.SubmitChanges();
}
if (TCBIDString.Length > 0)
{
string[] S = TCBIDString.Split(',');
foreach (string item in S)
{
ATC_info ATC = new ATC_info();
ATC.ATSID = ATSID;
ATC.TCBID = int.Parse(item);
db.ATC_info.InsertOnSubmit(ATC);
}
db.SubmitChanges();
}
ViewBag.Message = WebCMS.Menu.Edit + "ok";
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
}
}
else
{
ViewBag.MessageType = "警告";
ViewBag.Message = "您無權限使用本功能或長時間未使用已自動登出，請重新登入，如有疑問請洽管理員，謝謝…";
return(View("Message"));
}
return(View());
}
public ActionResult Accessory(int pid)
{
vw_eq_status codes2; //PUMP
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
codes2 = (from row in db.vw_eq_status where row.pid == pid select row).SingleOrDefault();
//PM_Set PS = (from row in db.PM_Set where row.tool_id == codes2.chamberName select row).SingleOrDefault();
//if (PS != null)
//{
// ViewData["IsPM"] = PS.pmFlag ? 2 : 3;
//}
//else
//{
// ViewData["IsPM"] = codes2.sid == 8 ? 0 : 1;
//}
ViewBag.WEB_code = codes2.WEB_code;
ViewBag.title = codes2.chamberName;
ViewBag.pid = codes2.pid;
ViewBag.AccessoryType = codes2.WEB_code;
ViewBag.ToolID = codes2.chamberName;
ViewBag.plc_name = codes2.plc_name;
ViewBag.vName = codes2.department_name;
ViewBag.bar = codes2.department_name;
//ViewBag.tImageUrl = "/images/" + codes2.tName + ".jpg";
//ViewBag.IsValueNow = db.vw_eq_valuenow.Where(x => x.pid == pid).Any();
//ViewBag.IsValueNow = (from row in db.vw_eq_valuenow.AsParallel() where row.pid == pid select row).Any();
//ViewBag.IsAuth = Session["UserdepartmentName"] != null && ((string)Session["UserdepartmentName"] == codes2.department_name && int.Parse(Session["UserLevel"].ToString()) >= 600) || (Session["UserLevel"] != null && int.Parse(Session["UserLevel"].ToString()) >= 900);
ViewBag.tName = codes2.tName;
//ViewBag.IOGNO = codes2.channel_name;
ViewBag.chamber = codes2.chamber;
//ViewBag.LastFDCUploadTime = codes2.LastCaptureTime.ToString("yyyy-MM-dd HH:mm");
//ViewBag.nextFDCUploadTime = codes2.LastCaptureTime > DateTime.Now.AddMinutes(2) ? "下次資料收集時間延至:" + codes2.LastCaptureTime.ToString("yyyy-MM-dd HH:mm") : "";
//List<vw_eq_status> OtherAccessory = (from row in db.vw_eq_status where row.department_name == codes2.department_name && row.chamber == codes2.chamber && row.toolid == codes2.toolid && row.pid != pid select row).ToList();
//ViewData["OtherAccessory"] = OtherAccessory;
//List<vw_eq_alarmnow> Alarmnow = (from row in db.vw_eq_alarmnow where row.pid==pid select row).ToList();
//ViewData["AlarmNow"] = Alarmnow;
}
return(View());
}
public ActionResult ToolCheck(string vName, string type)
{
if (Session["UserdepartmentName"] != null && string.IsNullOrEmpty(vName))
{
vName = Session["UserdepartmentName"] as string;
}
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
List <vw_eq_status> codes2 = (from row in db.vw_eq_status where row.department_name == vName orderby row.process_name, row.EQID, row.chamber, row.WEB_code descending select row).ToList();
ViewData["Device"] = codes2;
ViewData["bar"] = vName;
ViewData["title"] = vName;
ViewBag.dept = vName;
ViewData["process_name"] = (from row in codes2 select row.process_name).Distinct();
}
return(View());
}
public JsonResult JsonMobileGetMenuLevel()
{
string Msg = null;
bool IsSuccess = false;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
try
{
IsSuccess = true;
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
}
return(this.Json(new { IsSuccess = IsSuccess, Msg = Msg, data = System.Web.Configuration.WebConfigurationManager.AppSettings["MobileMenuLevel"] }, JsonRequestBehavior.AllowGet));
}
internal static byte[] GetFDCDeviceExportFile(string channel_name)
{
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = from row in db.vw_FDC_KEP_Tag_load where row.channel_name == channel_name orderby row.toolid, row.ChamberID select row;
StringBuilder sb = new StringBuilder();
string csvTitle = "Tag Name,Address,Data Type,Respect Data Type,Client Access,Scan Rate,Scaling,Raw Low,Raw High,Scaled Low,Scaled High,Scaled Data Type,Clamp Low,Clamp High,Eng Units,Description,Negate Value";
sb.AppendLine(csvTitle);
foreach (vw_FDC_KEP_Tag_load item in r)
{
string csvItem = "\"" + item.toolid + "." + item.ChamberID + "." + item.tagname + "\",\"" + item.KEP_address + "\"," + item.KepType + ",1," + item.KepAccess + ",100," + (item.Raw_High.HasValue ? "Linear" : "") + "," + (item.Raw_High.HasValue ? item.Raw_Low.Value.ToString() : "") + "," + (item.Raw_High.HasValue ? item.Raw_High.Value.ToString() : "") + "," + (item.Raw_High.HasValue ? item.Scaled_Low.Value.ToString() : "") + "," + (item.Raw_High.HasValue ? item.Scaled_High.Value.ToString() : "") + "," + (item.Raw_High.HasValue ? "Double" : "") + "," + (item.Raw_High.HasValue ? "0" : "") + "," + (item.Raw_High.HasValue ? "0" : "") + ",\"\",\"" + item.Eng_Comment + "\"," + (item.Raw_High.HasValue ? "0" : "");
sb.AppendLine(csvItem);
}
return(Encoding.ASCII.GetBytes(sb.ToString()));
}
}
public JsonResult JsonMobileGetChartValue(string chambers, string TagNames, string StartDate, string EndDate)
{
string Msg = null;
bool IsSuccess = false;
System.Data.DataTable dt = null;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
try
{
dt = PLCCheckModel.GetChartValuedt("aaa", chambers, TagNames, StartDate, EndDate, "3");
IsSuccess = true;
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
}
return(this.Json(new { IsSuccess = IsSuccess, Msg = Msg, data = dt.Rows }, JsonRequestBehavior.AllowGet));
}
public static SensorTagModel GetSensorTag(String SensorId)
{
SensorTagModel tmp = new SensorTagModel();
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
var r = (from row in db.vw_SensorTag_info where row.Sensor == SensorId select row).FirstOrDefault();
tmp.plc_id = r.plc_id;
tmp.chamber = r.chamber;
tmp.chamberTag = r.chamberTag;
tmp.PeriodicReportInterval = r.PeriodicReportInterval;
tmp.LinkProcessData = r.LinkProcessData;
tmp.Sensor = r.Sensor;
tmp.sensorTag = r.sensorTag;
tmp.Tool = r.Tool;
tmp.ToolType = r.ToolType;
}
return(tmp);
}
public ActionResult EditScheduleChart(int ATSID, string ATName)
{
if (!string.IsNullOrEmpty((string)Session["UserID"]))
{
ViewBag.Title = WebCMS.Menu.EditTCBook;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
ViewData["ATName"] = ATName;
ViewData["TCBookData"] = db.vw_TCBook_info.Where(x => x.Login_name == (string)Session["UserID"]).ToList();
ViewData["SelectTCBID"] = db.ATC_info.Where(x => x.ATSID == ATSID).ToList();
}
}
else
{
ViewBag.MessageType = "警告";
ViewBag.Message = "您無權限使用本功能或長時間未使用已自動登出，請重新登入，如有疑問請洽管理員，謝謝…";
return(View("Message"));
}
return(View());
}
public JsonResult JsonMobileGetTypeList()
{
string Msg = null;
bool IsSuccess = false;
using (tsmc14BDataContext db = new tsmc14BDataContext())
{
try
{
var TypeList = from row in db.type_info join v in db.vendor_info on row.vendor_id equals v.vendor_id select new { row.type_id, row.type_name, row.WEB_code, row.type_code, row.vendor_id, v.vendor_name, v.vendor_Code };
IsSuccess = true;
return(this.Json(new { IsSuccess = IsSuccess, Msg = Msg, data = TypeList.ToList() }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
IsSuccess = false;
Msg = ex.Message;
}
}
return(this.Json(new { IsSuccess = IsSuccess, Msg = Msg, data = string.Empty }, JsonRequestBehavior.AllowGet));
}
