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