public RoomInfo[] GetAllRoom() { using (SecureDBEntities db = new SecureDBEntities()) { return db.tblEngineRoomConfig.Select(n => new RoomInfo() { ERName = n.ERName, ERID = n.ERID ,LineID=n.LineID}).ToArray(); } }
public AddCardInfo[] GetCardInfoByMCNSID(string MCNSID) { using (SecureDBEntities db = new SecureDBEntities()) { var q = from n in db.vwMagneticCardDetail where n.MCNSID==MCNSID group (int)n.ERID by new { n.ABA, n.Memo, n.StartDate, n.EndDate, n.Name } into g select new { g.Key.ABA, g, g.Key.Memo, g.Key.EndDate, g.Key.StartDate, Name = g.Key.Name }; System.Collections.Generic.List<AddCardInfo> list = new List<AddCardInfo>(); foreach (var i in q) { list.Add(new AddCardInfo() { CardNo = i.ABA, EndDate = (DateTime)i.EndDate, StartDate = (DateTime)i.StartDate, MCNSID = i.Memo, Name = i.Name, ERIDs = i.g.Distinct().ToArray<int>() }); } return list.ToArray(); } }
public MagneticCardBasicInfo[] GetAllTempMagneticCardBasicInfo() { using (SecureDBEntities db = new SecureDBEntities()) { var q = from n in db.tblMagneticCard where n.Enable == "Y" select new MagneticCardBasicInfo { ABA = n.ABA, Type=n.Type, CardEndDate = n.CardEndDate, CardStartDate = n.CardStartDate, Company = n.Company, EmployeeNo = n.EmployeeNo, EndDate = n.EndDate, IDNumber = n.IDNumber, JobTitle = n.JobTitle, Mobile = n.Mobile, Name = n.Name, StartDate = n.StartDate, Tel = n.Tel }; return q.ToArray(); //System.Collections.Generic.List<MagneticCardBasicInfo> list = new List<MagneticCardBasicInfo>(); //foreach (var i in q) //{ // list.Add(new AddCardInfo() { CardNo = i.ABA, EndDate = (DateTime)i.EndDate, StartDate = (DateTime)i.StartDate, MCNSID = i.Memo, Name = i.Name, ERIDs = i.g.Distinct().ToArray<int>() }); //} //return list.ToArray(); } }
protected void Page_Load(object sender, EventArgs e) { // string json = "{\"name\":\"Joe\"}"; Response.Clear(); Response.ContentType = "application/json; charset=utf-8"; slSecure.Web.SecureDBEntities db=new SecureDBEntities(); var q= from n in db.tblCCTVSplitScreen orderby n.NO join o in db.tblCCTVConfig on n.CCTVID equals o.CCTVID select new CCTVGridInfo { NO= n.NO, CCTVID=n.CCTVID??-1,CCTVName= o.CCTVName, IP= o.IP, Port= o.Port, UserName= o.UserName,Password= o.Password,Type= o.Type??-1 }; DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(CCTVGridInfo[])); MemoryStream ms = new MemoryStream(); CCTVGridInfo[] infos= q.ToArray<CCTVGridInfo>(); ser.WriteObject(ms,infos); string jsonString = Encoding.UTF8.GetString(ms.ToArray()); ms.Close(); Response.Write(jsonString); Response.End(); }
public CardSendingResult[] GetR23CardSendingResult(string mcnsid) { IQueryable<CardSendingResult> q; using (SecureDBEntities db = new SecureDBEntities()) { q = from n in db.vwCardCommandLog where n.MCNSID == mcnsid select new CardSendingResult() { ABA=n.ABA, ComandTypeName=n.CommandTypeName, ERName=n.ERName, IsSuccessName=n.IsSuccessName, Memo=n.Memo, MSNCID=n.MCNSID, Name=n.Name, TimeStamp=n.Timestamp }; if (q == null) return new CardSendingResult[0]; return q.ToArray(); } }