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