public static bool Login(string EmployeeID) { using (var db = DCHelper.SPhoneContext()) { var info = db.SPhone_LoginLog.Where(x => x.EmployeeID == EmployeeID && SqlFunctions.DateDiff("d", x.LoginDate, DateTime.Now) == 0).FirstOrDefault(); if (info == null) { info = new SPhone_LoginLog() { ID = Guid.NewGuid(), EmployeeID = EmployeeID, FirstloginTime = DateTime.Now, LoginDate = DateTime.Now, CreateTime = DateTime.Now, CreateBy = EmployeeID }; db.SPhone_LoginLog.Add(info); } else { info.LoginDate = DateTime.Now; info.UpdateBy = EmployeeID; info.UpdateTime = DateTime.Now; } db.SaveChanges(); } return(true); }
protected void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var query = db.ivr_sugg_station.Where(x => x.VALID == "1"); if (!string.IsNullOrEmpty(searcher.AGENCY_COVER_AREA)) { query = query.Where(x => x.AGENCY_COVER_AREA == searcher.AGENCY_COVER_AREA); } if (!string.IsNullOrEmpty(searcher.PRODUCT_TYPE)) { query = query.Where(x => x.PRODUCT_TYPE == searcher.PRODUCT_TYPE); } if (!string.IsNullOrEmpty(searcher.AGENCY_ID)) { query = query.Where(x => x.AGENCY_ID == searcher.AGENCY_ID); } pager1.RecordCount = query.Count(); rptList.DataSource = query.OrderBy(item => item.CATEGORY) .Skip((pager1.CurrentPageIndex - 1) * pager1.PageSize).Take(pager1.PageSize).ToList(); rptList.DataBind(); } }
protected void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var query = db.SPhone_DutyManager.Where(item => 1 == 1); if (!string.IsNullOrEmpty(searcher.ManagerName)) { query = query.Where(item => item.ManagerName.IndexOf(searcher.ManagerName) != -1); } if (!string.IsNullOrEmpty(searcher.PhoneNo)) { query = query.Where(item => item.PhoneNo.IndexOf(searcher.PhoneNo) != -1); } if (searcher.DutyDate != default(DateTime)) { query = query.Where(item => item.DutyDate.Value.Date == searcher.DutyDate.Value.Date); } this.pager1.RecordCount = query.Count(); this.rptList.DataSource = query.OrderByDescending(item => item.CreateTime) .Skip((this.pager1.CurrentPageIndex - 1) * this.pager1.PageSize).Take(this.pager1.PageSize).ToList(); this.rptList.DataBind(); } }
protected void PersistData(Guid roleID, List <string> deleteIDs, List <string> addIDs) { using (var db = DCHelper.SPhoneContext()) { if (deleteIDs != null && deleteIDs.Count > 0) { deleteIDs.ForEach(id => { SPhone_RoleModule up = db.SPhone_RoleModule.First(item => item.RoleID == roleID && item.ModuleID == new Guid(id)); if (up != null) { db.SPhone_RoleModule.Remove(up); } }); } if (addIDs != null && addIDs.Count > 0) { addIDs.ForEach(id => { SPhone_RoleModule model = new SPhone_RoleModule(); model.RoleID = roleID; model.ModuleID = new Guid(id); model.CreateBy = this.UserInfo.LogonID; model.CreateTime = DateTime.Now; db.SPhone_RoleModule.Add(model); }); } db.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["date"] != null) { now = DateTime.Parse(Request.QueryString["date"]); } var path = Server.MapPath("~/Documents/TempFolder/Chat详细记录-" + now.ToString("yyMMdd") + ".xlsx"); if (!File.Exists(path)) { //ThreadPool.QueueUserWorkItem(c => // { using (var db = DCHelper.SPhoneContext()) { try { var query = db.SPhone_Chat.Where(x => System.Data.Objects.SqlClient.SqlFunctions.DateDiff("d", x.CreateTime, now) == 0 && x.UpdateTime != x.CreateTime).OrderBy(x => x.CreateTime).ToList(); ExportData(query, path.ToString()); Response.Write("succ:" + now); } catch (Exception ex) { Response.Write("error:" + now + "|" + ex.ToString()); } } //}, path); } else { Response.Write("Exists:" + now); } }
public static void CallEnd(string CallID, string EmployeeID, string CustomerID, string NextQueueName, int IsConference, int IsTransfer, int IsTransferEPOS) { using (var db = DCHelper.SPhoneContext()) { var info = db.Sphone_Call.Find(CallID); if (info != null && info.EmployeeID == EmployeeID) { info.CallEndTime = DateTime.Now; info.UpdateTime = DateTime.Now; info.UpdateBy = EmployeeID; try { if (!string.IsNullOrEmpty(CustomerID)) { info.CustomerID = CustomerID; } } catch { } info.NextQueueName = NextQueueName; info.IsConference = IsConference; info.IsTransfer = IsTransfer; info.IsTransferEPOS = IsTransferEPOS; db.SaveChanges(); } } }
protected override void PersistData(ivr_sugg_station data, bool isCreate) { using (var db = DCHelper.SPhoneContext()) { if (isCreate) { data.VALID = "1"; data.AGENCY_NAME_WAV_FILENAME = data.AGENCY_ID + "s.WAV"; data.AGENCY_WAV_FILENAME = data.AGENCY_ID + ".WAV"; data.RECORD_DATE = DateTime.Now; db.ivr_sugg_station.Add(data); } else { var entity = db.ivr_sugg_station.FirstOrDefault(x => x.AGENCY_ID == data.AGENCY_ID && x.PRODUCT_TYPE == data.PRODUCT_TYPE); entity.AGENCY_COVER_AREA = data.AGENCY_COVER_AREA; entity.AGENCY_NAME = data.AGENCY_NAME; entity.AGENCY_INFO = data.AGENCY_INFO; entity.ADD_TYPE = data.ADD_TYPE; entity.CATEGORY = data.CATEGORY; //entity.AGENCY_NAME_WAV_FILENAME = data.AGENCY_ID + "s.WAV"; //entity.AGENCY_WAV_FILENAME = data.AGENCY_ID + ".WAV"; entity.RECORD_DATE = DateTime.Now; } db.SaveChanges(); } }
private void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var query = db.SPhone_Module.Where(item => 1 == 1); if (searcher.ParentModuleID != Guid.Empty) { query = query.Where(item => item.ParentModuleID == searcher.ParentModuleID); } if (!string.IsNullOrEmpty(searcher.ModuleName)) { query = query.Where(item => item.ModuleName.IndexOf(searcher.ModuleName) != -1); } if (!string.IsNullOrEmpty(searcher.ModuleUrl)) { query = query.Where(item => item.ModuleUrl.IndexOf(searcher.ModuleUrl) != -1); } this.pager1.RecordCount = query.Count(); this.rptList.DataSource = query.OrderBy(item => item.CreateTime) .Skip((this.pager1.CurrentPageIndex - 1) * this.pager1.PageSize).Take(this.pager1.PageSize).ToList(); this.rptList.DataBind(); } }
public static SPhone_ReportUrl Find(Guid GUID) { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_ReportUrl.FirstOrDefault(x => x.GUID == GUID)); } }
protected void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var query = db.SPhone_IPDN.Where(item => item.IsValid == searcher.IsValid); if (!string.IsNullOrEmpty(searcher.Place)) { query = query.Where(item => item.Place.IndexOf(searcher.Place) != -1); } if (!string.IsNullOrEmpty(searcher.PlaceIP)) { query = query.Where(item => item.PlaceIP.IndexOf(searcher.PlaceIP) != -1); } if (!string.IsNullOrEmpty(searcher.DNNo)) { query = query.Where(item => item.DNNo.IndexOf(searcher.DNNo) != -1); } if (!string.IsNullOrEmpty(searcher.BindType)) { query = query.Where(item => item.BindType == searcher.BindType); } if (!string.IsNullOrEmpty(searcher.PhoneType)) { query = query.Where(item => item.PhoneType == searcher.PhoneType); } this.pager1.RecordCount = query.Count(); this.rptList.DataSource = query.OrderBy(item => item.DNNo) .Skip((this.pager1.CurrentPageIndex - 1) * this.pager1.PageSize).Take(this.pager1.PageSize).ToList(); this.rptList.DataBind(); } }
public static List <SPhone_ReportUrl> GetQuery() { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_ReportUrl.AsNoTracking().OrderBy(x => x.ReportName).ToList()); } }
protected void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var query = db.ivr_sugg_agency.Where(x => x.VALID == "1"); if (!string.IsNullOrEmpty(searcher.AGENCY_NAME)) { query = query.Where(x => x.AGENCY_NAME.Contains(searcher.AGENCY_NAME)); } if (!string.IsNullOrEmpty(searcher.PRODUCT_TYPE)) { query = query.Where(x => x.PRODUCT_TYPE == searcher.PRODUCT_TYPE); } if (!string.IsNullOrEmpty(searcher.AGENCY_ID)) { query = query.Where(x => x.AGENCY_ID == searcher.AGENCY_ID); } query = query.OrderBy(x => x.AGENCY_ID).ThenByDescending(x => x.CATEGORY); rptList.DataSource = query.Skip((pager1.CurrentPageIndex - 1) * pager1.PageSize).Take(pager1.PageSize).ToList(); rptList.DataBind(); pager1.RecordCount = query.Count(); } }
protected void BindRepeater() { var searcher = GetSearcher(); using (var db = DCHelper.SPhoneContext()) { var notInRole = Guid.Parse("00000000-0000-0000-0000-000000000001"); var query = db.SPhone_Holiday.Where(x => x.HolidayRoleID != notInRole); if (searcher.HolidayRoleID.HasValue) { query = query.Where(x => x.HolidayRoleID == searcher.HolidayRoleID); } if (!string.IsNullOrEmpty(searcher.QueueName)) { query = query.Where(x => x.QueueName.Contains(searcher.QueueName)); } if (!string.IsNullOrEmpty(searcher.DNIS)) { query = query.Where(x => x.DNIS.Contains(searcher.DNIS)); } int typeID = 0; int.TryParse(this.ddlType.SelectedValue, out typeID); if (typeID > 0) { query = query.Where(x => x.TypeID == typeID); } this.pager1.RecordCount = query.Count(); this.rptList.DataSource = query.OrderByDescending(x => x.CreateTime) .Skip((this.pager1.CurrentPageIndex - 1) * this.pager1.PageSize).Take(this.pager1.PageSize).ToList(); this.rptList.DataBind(); } }
protected void PersistData() { using (var db = DCHelper.SPhoneContext()) { var roleid = Guid.Parse(ddlRole.SelectedValue); db.SPhone_UserPermission.Where(x => x.RoleID == roleid).ToList() .ForEach(x => db.SPhone_UserPermission.Remove(x)); foreach (ListItem item in listUsers.Items) { if (item.Selected) { SPhone_UserPermission model = new SPhone_UserPermission(); model.RoleID = new Guid(this.ddlRole.SelectedValue); model.EmployeeID = item.Value; model.CreateBy = this.UserInfo.LogonID; model.CreateTime = DateTime.Now; db.SPhone_UserPermission.Add(model); } } db.SaveChanges(); } }
protected override Sphone_Call LoadInfo(string id) { using (var db = DCHelper.SPhoneContext()) { return(db.Sphone_Call.FirstOrDefault(item => item.CallID == id)); } }
public static void AddNewChatText(SPhone_ChatText entity) { using (var db = DCHelper.SPhoneContext()) { db.SPhone_ChatText.Add(entity); db.SaveChanges(); } }
protected override SPhone_ChatText LoadInfo(string id) { using (var db = DCHelper.SPhoneContext()) { Guid entityID = new Guid(id); return(db.SPhone_ChatText.FirstOrDefault(item => item.ChatTextID == entityID)); } }
protected override SPhone_BlackListType LoadInfo(string id) { using (var db = DCHelper.SPhoneContext()) { Guid entityID = new Guid(id); return(db.SPhone_BlackListType.FirstOrDefault(item => item.BlackListTypeID == entityID)); } }
protected override SPhone_UserPermission LoadInfo(string id) { using (var db = DCHelper.SPhoneContext()) { Guid entityID = new Guid(id); return(db.SPhone_UserPermission.FirstOrDefault(item => item.RoleID == entityID)); } }
protected override ivr_sugg_station LoadInfo(string id) { using (var db = DCHelper.SPhoneContext()) { var a = id.Split(',')[0]; var b = id.Split(',')[1]; return(db.ivr_sugg_station.FirstOrDefault(x => x.PRODUCT_TYPE == b && x.AGENCY_ID == a && x.VALID == "1")); } }
protected void BindRepeater() { var searcher = GetSearcher(); if (searcher.ChatEndTime == null) { searcher.ChatEndTime = new DateTime(2000, 1, 1); } if (searcher.ChatBeginTime == null) { searcher.ChatBeginTime = new DateTime(2000, 1, 1); } if (searcher.ChatEndTime != null) { searcher.ChatEndTime = ((DateTime)searcher.ChatEndTime).Date.AddDays(1).AddSeconds(-1); } using (var db = DCHelper.SPhoneContext()) { string entitySQL = string.Format("SELECT ChatID,EmployeeID,CustomerID,CustomerName,ChatBeginTime,ChatEndTime,'' AS ContentText" + ",ConnectionID,CurrentQueueName,FromQueueName,NextQueueName,MachineNo,PlaceIP,MailAddress,IsConference" + ",IsTransfer,IsRTO,ServicecardNo,WSISID,Enterid,CreateBy,CreateTime,UpdateBy,UpdateTime FROM SPhone_Chat where ChatBeginTime>='{0}' and ChatBeginTime<='{1}';", searcher.ChatBeginTime.Value.ToString("yyyy-MM-dd"), searcher.ChatEndTime.Value.AddDays(1).ToString("yyyy-MM-dd")); var query = db.SPhone_Chat.SqlQuery(entitySQL).Where(item => item.ChatBeginTime >= searcher.ChatBeginTime && item.ChatBeginTime <= searcher.ChatEndTime); if (!string.IsNullOrEmpty(searcher.ChatID)) { query = query.Where(item => item.ChatID.IndexOf(searcher.ChatID) != -1); } if (!string.IsNullOrEmpty(searcher.CustomerID)) { query = query.Where(item => item.CustomerID.IndexOf(searcher.CustomerID) != -1); } if (!string.IsNullOrEmpty(searcher.EmployeeID)) { query = query.Where(item => item.EmployeeID.IndexOf(searcher.EmployeeID) != -1); } if (!string.IsNullOrEmpty(searcher.PlaceIP)) { query = query.Where(item => item.PlaceIP.IndexOf(searcher.PlaceIP) != -1); } if (!string.IsNullOrEmpty(searcher.CurrentQueueName)) { query = query.Where(item => item.CurrentQueueName.IndexOf(searcher.CurrentQueueName) != -1); } if (!string.IsNullOrEmpty(searcher.MachineNo)) { query = query.Where(item => item.MachineNo.IndexOf(searcher.MachineNo) != -1); } this.pager1.RecordCount = query.Count(); this.rptList.DataSource = query.OrderByDescending(item => item.ChatBeginTime) .Skip((this.pager1.CurrentPageIndex - 1) * this.pager1.PageSize).Take(this.pager1.PageSize); this.rptList.DataBind(); } }
public static void Update <T>(T entity) where T : class { using (var db = DCHelper.SPhoneContext()) { db.Entry(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// 获取单条聊天数据 /// </summary> public static SPhone_Chat GetChat(string chatID) { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_Chat.Where(item => item.ChatID == chatID) .FirstOrDefault()); } }
/// <summary> /// 根据条件获取术语集合 /// </summary> /// <param name="match"></param> public static List <string> GetChatTextList(string queueName, string typeName) { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_ChatText.Where(item => item.QueueName.Equals(queueName, StringComparison.CurrentCultureIgnoreCase) && item.SPhone_ChatTextType.ChatTextTypeName.Equals(typeName) ).OrderBy(item => item.SortID).Select(item => item.ChatContent).ToList()); } }
protected void btnExport_Click(object sender, EventArgs e) { List <SPhone_Chat> data = null; List <string> ids = this.hdChatIDs.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList(); using (var db = DCHelper.SPhoneContext()) { data = db.SPhone_Chat.Where(item => ids.Contains(item.ChatID)).ToList(); } ExportData(data); }
/// <summary> /// 获取坐席某时间段的聊天ID列表 /// </summary> public static List <string> GetChatIDList(string employeeID, DateTime beginDate, DateTime endDate) { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_Chat.Where(item => item.EmployeeID == employeeID && item.ChatBeginTime >= beginDate && item.ChatEndTime <= endDate) .Select(item => item.ChatID).ToList()); } }
public Entity.Model.DNPlace GetPlaceDN(string placeIP) { using (var db = DCHelper.SPhoneContext()) { return(db.SPhone_IPDN .Where(x => x.PlaceIP == placeIP && x.IsValid == 1) .Select(x => new Entity.Model.DNPlace() { DN = x.DNNo, Place = x.Place, Ext1 = x.Ext1, Ext2 = x.Ext2, Ext3 = x.Ext3, IsRealDN = x.IsRealDN, IsSayEmpNO = x.IsSayEmpNO }).FirstOrDefault()); } }
public static void SetDeskTime(string CallID, string EmployeeID) { using (var db = DCHelper.SPhoneContext()) { var info = db.Sphone_Call.Find(CallID); if (info != null && info.EmployeeID == EmployeeID) { info.DeskTime = DateTime.Now; db.SaveChanges(); } } }
public static Dictionary <string, int> GetSelectedIDs(Guid roleID) { Dictionary <string, int> result = new Dictionary <string, int>(); List <SPhone_RoleModule> roleModules = new List <SPhone_RoleModule>(); using (var db = DCHelper.SPhoneContext()) { roleModules = db.SPhone_RoleModule.Where(item => item.RoleID == roleID).ToList(); } roleModules.ForEach(rm => result.Add(rm.ModuleID.ToString(), 1)); return(result); }
protected void BindRepeater() { List <SPhone_LoginLog> lst = null; using (var db = DCHelper.SPhoneContext()) { Predicate <SPhone_LoginLog> match = this.InitSearchData(); Func <SPhone_LoginLog, bool> contidion = new Func <SPhone_LoginLog, bool>(item => match(item)); lst = db.SPhone_LoginLog.Where(contidion).ToList(); } this.rptList.DataSource = lst; this.rptList.DataBind(); }