protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["LSH"] != null)
{
LSH.Value = Request.QueryString["LSH"];
}
h_HouseTelList hTel = h_HouseTelList.FindByLSH(Convert.ToDecimal(Request.QueryString["LSH"]));
H_houseinfor hh = H_houseinfor.FindByHouseID(hTel.HouseID);
txtMsg.Text = "房东你好，我是" + (Current.OrgName.Contains("易房") ? "易房" : "中山") + "房产员工，现有客户准备去看你" + hh.HouseDicName + "的房屋，想和你确认什么时间方便看房";
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (context.Request.QueryString["aTyp"] != null && context.Request.QueryString["aTyp"].ToString() == "del")
{
h_HouseTelList hh = h_HouseTelList.FindByKey(context.Request.QueryString["LSH"]);
hh.DelEmployeeID = Employee.Current.EmployeeID;
hh.DelType = true;
hh.Update();
h_FollowUp hfo = new h_FollowUp();
hfo.HouseID = hh.HouseID;
hfo.EmployeeID = Employee.Current.EmployeeID;
hfo.FollowUpText = "电话删除";
hfo.Insert();
// 电话修改记录
string oldTel = hh.Tel2;
TelChange tc = new TelChange();
tc.AddEmployeeID = Employee.Current.EmployeeID;
tc.HouseID = hh.HouseID;
tc.NewTel = "";
tc.OldTel = oldTel.TelDecrypt((Int32)hh.HouseID, 0);
tc.Insert();
context.Response.Write("del");
}
else if (context.Request.QueryString["LSH"] != null)
{
h_HouseTelList hh = h_HouseTelList.FindByKey(context.Request.QueryString["LSH"]);
string result = "";
int ii = i_InternetTel.FindCount(new string[] { "EmployeeID", "IsDel" }, new string[] { Employee.Current.EmployeeID.ToString(), "0" });
if (ii > 0)
{
string tel = "";
//隐号拔打
string houseTel = hh.Tel2.TelDecrypt((Int32)hh.HouseID, TelDecPoint.PC_HouseForm_TelPhone);
if (context.Request.QueryString["mytel"] != null)
{
tel = context.Request.QueryString["mytel"].ToString();
i_InternetPhone iip = new i_InternetPhone();
iip.employeeID = Employee.Current.EmployeeID;
iip.houseID = hh.HouseID;
iip.dateCreated = DateTime.Now.ToString();
iip.fromTel = tel;
iip.toTel = houseTel;
iip.recordUrlDel = 2;
iip.orgID = Convert.ToInt32(Employee.Current.OrgID);
iip.isPcCallTel = 1;
iip.createTime = DateTime.Now;
iip.Source = 2;
iip.CallSystem = 0;
iip.RecrodType = 1;
iip.Insert();
Common.InterPhoneCall ip = new Common.InterPhoneCall();
Common.InterPhoneCall.CallBackMsg cbm = new Common.InterPhoneCall.CallBackMsg();
s_SysParam model = s_SysParam.Find(Share_Personinfo._.ID, 1279);
string sqlnum = @"select COUNT(*)AS Num from i_InternetPhone
where createTime > DATEADD(minute, -15, GETDATE())
and datediff(dd, createTime, GETDATE())= 0
and employeeID =" + Employee.Current.EmployeeID + @"
and houseID =" + hh.HouseID + @"
and callSid !=''";
int CallNum = int.Parse(EntityUtils.DBUtility.DbHelperSQL.Query(sqlnum).Tables[0].Rows[0][0].ToString());
if (CallNum >= int.Parse(model.Value) && int.Parse(model.Value) > 0)
{
result = "1";
}
else
{
cbm = ip.Call(tel, houseTel, iip.phoneID.ToString());
iip.callSid = cbm.taskId;
iip.Update();
result = cbm.errcode;
}
}
else
{
tel = i_InternetTel.Find("EmployeeID=" + Employee.Current.EmployeeID + " and IsDel=0").MyTel;
i_InternetPhone iip = new i_InternetPhone();
iip.employeeID = Employee.Current.EmployeeID;
iip.houseID = hh.HouseID;
iip.dateCreated = DateTime.Now.ToString();
iip.fromTel = tel;
iip.toTel = houseTel;
iip.recordUrlDel = 2;
iip.orgID = Convert.ToInt32(Employee.Current.OrgID);
iip.isPcCallTel = 1;
iip.createTime = DateTime.Now;
iip.Source = 2;
iip.CallSystem = 0;
iip.RecrodType = 1;
iip.Insert();
Common.InterPhoneCall ip = new Common.InterPhoneCall();
Common.InterPhoneCall.CallBackMsg cbm = new Common.InterPhoneCall.CallBackMsg();
s_SysParam model = s_SysParam.Find(Share_Personinfo._.ID, 1279);
string sqlnum = @"select COUNT(*)AS Num from i_InternetPhone
where createTime > DATEADD(minute, -15, GETDATE()) and datediff(dd, createTime, GETDATE())= 0 and employeeID =" + Employee.Current.EmployeeID + "and houseID =" + hh.HouseID + "AND callSid !=''";
int CallNum = int.Parse(HouseMIS.EntityUtils.DBUtility.DbHelperSQL.Query(sqlnum).Tables[0].Rows[0][0].ToString());
if (CallNum >= int.Parse(model.Value) && int.Parse(model.Value) > 0)
{
result = "1";
}
else
{
cbm = ip.Call(tel, houseTel, iip.phoneID.ToString());
iip.callSid = cbm.taskId;
iip.Update();
result = cbm.errcode;
}
}
if (result == "0")
{
context.Response.Write("连接成功！连接手机号：" + tel);
}
else if (result == "1")
{
string timesql = @"select top 1 datediff(SECOND , DATEADD(minute, -15, GETDATE()),createTime)time from i_InternetPhone where datediff(dd, createTime, GETDATE())= 0 and employeeID=" + Employee.Current.EmployeeID + "and callSid !='' and createTime > DATEADD(minute, -15, GETDATE()) and houseID=" + hh.HouseID;
int time = int.Parse(EntityUtils.DBUtility.DbHelperSQL.Query(timesql).Tables[0].Rows[0][0].ToString());
TimeSpan ts = new TimeSpan(0, 0, time);
string times;
if (ts.Minutes > 0)
{
times = ts.Minutes + "分钟" + ts.Seconds + "秒";
}
else
{
times = ts.Seconds + "秒";
}
context.Response.Write("您拨打的太频繁了！</br>请稍作休息！请" + times + "后再试!");
}
else
{
context.Response.Write("连接失败！请联系管理员");
}
}
else
{
context.Response.Write("1," + Employee.Current.EmployeeID.ToString());
}
}
else if (context.Request.QueryString["EmpTelFrom"] != null && context.Request.QueryString["EmpTelTo"] != null)
{
string result = string.Empty;
string telFrom = context.Request.QueryString["EmpTelFrom"];
string telTo = context.Request.QueryString["EmpTelTo"];
i_InternetPhone iip = new i_InternetPhone();
iip.employeeID = Employee.Current.EmployeeID;
iip.houseID = 0;
iip.dateCreated = DateTime.Now.ToString();
iip.fromTel = telFrom;
iip.toTel = telTo;
iip.recordUrlDel = 2;
iip.orgID = Convert.ToInt32(Employee.Current.OrgID);
iip.isPcCallTel = 1;
iip.createTime = DateTime.Now;
iip.Source = 2;
iip.CallSystem = 0;
iip.RecrodType = 4;
iip.Insert();
Common.InterPhoneCall ip = new Common.InterPhoneCall();
Common.InterPhoneCall.CallBackMsg cbm = new Common.InterPhoneCall.CallBackMsg();
s_SysParam model = s_SysParam.Find(Share_Personinfo._.ID, 1279);
string sqlnum = @"select COUNT(*)AS Num from i_InternetPhone
where createTime > DATEADD(minute, -15, GETDATE()) and datediff(dd, createTime, GETDATE())= 0 and employeeID =" + Employee.Current.EmployeeID + "and houseID =0 and callSid !=''";
int CallNum = int.Parse(HouseMIS.EntityUtils.DBUtility.DbHelperSQL.Query(sqlnum).Tables[0].Rows[0][0].ToString());
if (CallNum >= int.Parse(model.Value) && int.Parse(model.Value) > 0)
{
result = "1";
}
else
{
cbm = ip.Call(telFrom, telTo, iip.phoneID.ToString());
iip.callSid = cbm.taskId;
iip.Update();
result = cbm.errcode;
}
if (result == "0")
{
context.Response.Write("连接成功！连接手机号：" + telFrom);
}
else if (result == "1")
{
string timesql = @"select top 1 datediff(SECOND , DATEADD(minute, -15, GETDATE()),createTime)time from i_InternetPhone where datediff(dd, createTime, GETDATE())= 0 and employeeID=" + Employee.Current.EmployeeID + "and callSid !='' and createTime > DATEADD(minute, -15, GETDATE()) and houseID=0";
int time = int.Parse(HouseMIS.EntityUtils.DBUtility.DbHelperSQL.Query(timesql).Tables[0].Rows[0][0].ToString());
TimeSpan ts = new TimeSpan(0, 0, time);
string times;
if (ts.Minutes > 0)
{
times = ts.Minutes + "分钟" + ts.Seconds + "秒";
}
else
{
times = ts.Seconds + "秒";
}
context.Response.Write("您拨打的太频繁了！</br>请稍作休息！请" + times + "后再试!");
}
else
{
context.Response.Write("连接失败！请联系管理员");
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string telFrom = string.Empty;
string telTo = string.Empty;
string result = string.Empty;
decimal houseID = 0;
i_InternetPhone iip = new i_InternetPhone();
if (context.Request.QueryString["aTyp"] != null && context.Request.QueryString["aTyp"].ToString() == "del")
{
h_HouseTelList hh = h_HouseTelList.FindByKey(context.Request.QueryString["LSH"]);
hh.DelEmployeeID = Employee.Current.EmployeeID;
hh.DelType = true;
hh.Update();
h_FollowUp hfo = new h_FollowUp();
hfo.HouseID = hh.HouseID;
hfo.EmployeeID = Employee.Current.EmployeeID;
hfo.FollowUpText = "电话删除";
hfo.Insert();
// 电话修改记录
string oldTel = hh.Tel2;
TelChange tc = new TelChange();
tc.AddEmployeeID = Employee.Current.EmployeeID;
tc.HouseID = hh.HouseID;
tc.NewTel = "";
tc.OldTel = oldTel.TelDecrypt((Int32)hh.HouseID, 0);
tc.Insert();
context.Response.Write("del");
return;
}
//房源电话拨打
else if (context.Request.QueryString["LSH"] != null)
{
int ii = i_InternetTel.FindCount(new string[] { "EmployeeID", "IsDel" }, new string[] { Employee.Current.EmployeeID.ToString(), "0" });
if (ii > 0)
{
iip.RecrodType = 1;
h_HouseTelList hh = h_HouseTelList.FindByKey(context.Request.QueryString["LSH"]);
houseID = hh.HouseID;
telTo = hh.Tel2.TelDecrypt((Int32)hh.HouseID, TelDecPoint.PC_HouseForm_TelPhone);
if (context.Request.QueryString["mytel"] != null)
{
telFrom = context.Request.QueryString["mytel"].ToString();
}
else
{
telFrom = i_InternetTel.Find("EmployeeID=" + Employee.Current.EmployeeID + " and IsDel=0").MyTel;
}
}
else
{
context.Response.Write("1," + Employee.Current.EmployeeID.ToString());
return;
}
}
//装修拨打买家电话
else if (context.Request.QueryString["bTel"] != null)
{
int ii = i_InternetTel.FindCount(new string[] { "EmployeeID", "IsDel" }, new string[] { Employee.Current.EmployeeID.ToString(), "0" });
if (ii > 0)
{
iip.RecrodType = 5;
telTo = context.Request.QueryString["bTel"];
houseID = Convert.ToDecimal(context.Request.QueryString["HouseID"]);
if (context.Request.QueryString["mytel"] != null)
{
telFrom = context.Request.QueryString["mytel"].ToString();
}
else
{
telFrom = i_InternetTel.Find("EmployeeID=" + Employee.Current.EmployeeID + " and IsDel=0").MyTel;
}
}
else
{
context.Response.Write("1," + Employee.Current.EmployeeID.ToString());
return;
}
}
//员工通讯录拨打
else if (context.Request.QueryString["EmpTelFrom"] != null && context.Request.QueryString["EmpTelTo"] != null)
{
iip.RecrodType = 4;
telFrom = context.Request.QueryString["EmpTelFrom"];
telTo = context.Request.QueryString["EmpTelTo"];
houseID = 0;
}
iip.employeeID = Employee.Current.EmployeeID;
iip.houseID = houseID;
iip.dateCreated = DateTime.Now.ToString();
iip.fromTel = telFrom;
iip.toTel = telTo;
iip.recordUrlDel = 2;
iip.orgID = Convert.ToInt32(Employee.Current.OrgID);
iip.isPcCallTel = 1;
iip.createTime = DateTime.Now;
iip.Source = 0;
iip.CallSystem = 0;
iip.Insert();
InterPhoneCall ip = new InterPhoneCall();
InterPhoneCall.CallBackMsg cbm = new InterPhoneCall.CallBackMsg();
//是否大众员工
if (Employee.Current.MyTopOrgA.OrgID == 1062)
{
cbm = ip.Call_Mobile(telFrom, telTo, iip.phoneID.ToString(), 1);
}
else
{
cbm = ip.Call_Mobile(telFrom, telTo, iip.phoneID.ToString());
}
iip.callSid = cbm.taskId;
iip.Update();
result = cbm.errcode;
if (result == "0")
{
context.Response.Write("连接成功！连接手机号：" + telFrom);
}
else
{
context.Response.Write("连接失败！请联系人事-检查是否绑定隐号！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.HTFpagerForm.ID += House.HouseID;
#region 1.显示 [查看电话] 按钮
if (!IsShowTel) //如果不显示电话
{
//判断调电权限
//if (H_houseinfor.NeedTelPower(Convert.ToDecimal(Request["HouseID"]), Convert.ToInt32(Employee.Current.EmployeeID)))
//{
// LokTelButa.Visible = IsCanShowTel;
//}
//if (LokTelButa.Visible == true)
//{
// LokTelButa.Attributes.Add("onclick", "return LookTelClick('" + House.HouseID + "')");
//}
}
else
{
//LokTelButa.Visible = false;
#region 插入调电记录
if (CheckRolePermission("不隐号") || IsCanShowTel)
{
h_SeeTelLog hs = new h_SeeTelLog();
hs.EmployeeID = Employee.Current.EmployeeID;
hs.HouseID = Convert.ToDecimal(HouseID.Value);
hs.IsPower = H_houseinfor.NeedTelPower(House.HouseID, Employee.Current.EmployeeID.ToString().ToInt32());
hs.Insert();
}
#endregion 插入调电记录
//显示室号
room.Value = House.Build_room;
}
cbTel.DataSource = i_InternetTel.FindAll(new string[] { "EmployeeID", "IsDel" }, new string[] { Employee.Current.EmployeeID.ToString(), "0" });
cbTel.DataTextField = "MyTel";
cbTel.DataValueField = "MyTel";
cbTel.DataBind();
#endregion 1.显示 [查看电话] 按钮
}
if (Request.Form["LSH"] != null && Request.Form["LSH"] != "")
{
#region 编辑电话
h_HouseTelList hh = h_HouseTelList.Find("LSH", Request.Form["LSH"]);
hh.EmployeeID = Employee.Current.EmployeeID;
if (Request.Form["HouseID"] != "0")
{
hh.HouseID = Convert.ToDecimal(Request.Form["HouseID"]);
}
else
{
hh.HouseID = 0;
hh.GU_ID = Request.Form["GU_ID"].ToString();
}
hh.landlord_name = Request.Form["frmName"].ToString();
hh.Tel1 = H_houseinfor.TelDispose(Request.Form["Tel"]);
string oldTel = hh.Tel2;
hh.Tel2 = Request.Form["Tel"].TelEncrypt();
hh.TelType = Request.Form["TelType"].ToString();
hh.Update();
#region 插入跟进
h_FollowUp hfo = new h_FollowUp();
hfo.HouseID = hh.HouseID;
hfo.EmployeeID = Employee.Current.EmployeeID;
hfo.FollowUpText = "电话修改";
hfo.Insert();
#endregion 插入跟进
#region 电话修改记录
TelChange tc = new TelChange();
tc.AddEmployeeID = Employee.Current.EmployeeID;
tc.HouseID = hh.HouseID;
tc.NewTel = Request.Form["Tel"];
tc.OldTel = oldTel.TelDecrypt((Int32)hh.HouseID, 0);
tc.Insert();
LSH.Value = "";
#endregion 电话修改记录
#endregion 编辑电话
}
else if (Request.Form["frmName"] != null && Request.Form["frmName"] != "")
{
#region 添加电话
h_HouseTelList hh = new h_HouseTelList();
hh.EmployeeID = Employee.Current.EmployeeID;
if (Request.Form["HouseID"] != "0")
{
hh.HouseID = Convert.ToDecimal(Request.Form["HouseID"]);
}
else
{
hh.HouseID = 0;
hh.GU_ID = Request.Form["GU_ID"].ToString();
}
hh.landlord_name = Request.Form["frmName"].ToString();
hh.Tel1 = H_houseinfor.TelDispose(Request.Form["Tel"]);
hh.Tel2 = Request.Form["Tel"].TelEncrypt();
hh.TelType = Request.Form["TelType"].ToString();
hh.Insert();
if (hh.HouseID > 0)
{
h_FollowUp hfo = new h_FollowUp();
hfo.HouseID = hh.HouseID;
hfo.EmployeeID = Employee.Current.EmployeeID;
hfo.FollowUpText = "添加新电话,编号：" + hh.LSH;
hfo.Insert();
}
#endregion 添加电话
Response.Write("<script>alertMsg.correct(\"操作成功请点调电拨打电话！\");</script>");
}
if (!CheckRolePermission("不隐号"))
{
//if (!CheckRolePermission("添加电话", Convert.ToDecimal(House.OwnerEmployeeID)))
//hTelAdd.Visible = false;
}
else
{
if (CheckRolePermission("不隐号"))
{
h_SeeTelLog hs = new h_SeeTelLog();
hs.EmployeeID = Employee.Current.EmployeeID;
hs.HouseID = Convert.ToDecimal(HouseID.Value);
hs.IsPower = false;
hs.Insert();
}
}
}
protected override void OnPreInit(EventArgs e)
{
//保存
if (Request.Form["doAjax"] == "true")
{
HttpWebRequest hwq = (HttpWebRequest)WebRequest.Create("http://120.27.150.137:8080/softswitch/internal/getDisplayNum.jsp?e164=" + Current.UserName);
HttpWebResponse responseSorce = (HttpWebResponse)hwq.GetResponse();
StreamReader reader = new StreamReader(responseSorce.GetResponseStream(), Encoding.UTF8);
string content = reader.ReadToEnd();
responseSorce.Close();
responseSorce = null;
reader = null;
CallBackMsg cm = JsonConvert.DeserializeObject <CallBackMsg>(content);
if (cm.errcode != "0")
{
ShowMsg(AlertType.error, "没有绑定隐号，请联系人事部绑定隐号");
}
else
{
h_HouseTelList hTel = h_HouseTelList.FindByLSH(Convert.ToDecimal(Request.Form["LSH"]));
if (hTel != null)
{
string tel = hTel.TelDe;
if (!tel.IsNullOrWhiteSpace())
{
i_InternetPhone ip = i_InternetPhone.Find("toTel='" + tel + "' and CONVERT(varchar,createTime,112)='" + DateTime.Now.ToString("yyyyMMdd") + "'");
if (ip == null)
{
ShowMsg(AlertType.error, "请先拨打电话后再发送短信");
}
else
{
List <e_SmsLog> listSMS = e_SmsLog.FindAll("select * from e_SmsLog where phone='" + tel + "' and CONVERT(varchar,datetime,112)='" + DateTime.Now.ToString("yyyyMMdd") + "'");
if (listSMS.Count > 5)
{
ShowMsg(AlertType.error, "该房东今天已发送5次短信，请明天再试");
}
else
{
if (listSMS.Count(x => x.Phone == Current.UserName && x.Datetime.ToShortDateString() == DateTime.Now.ToShortDateString()) > 0)
{
ShowMsg(AlertType.error, "你今天已经给该房东发送过信息，请明天再试");
}
else
{
string txtMsg = Request.Form["txtMsg"];
txtMsg += ",请回电:" + cm.displayNum + ",回T退订【" + (Current.OrgName.Contains("易房") ? "易房网房产" : "中山房产") + "】";
string errMsg = e_SmsLog.SendSMS(Employee.Current.EmployeeID, tel, txtMsg, hTel.HouseID, hTel.LSH);
ShowMsg(AlertType.info, errMsg);
}
}
}
}
else
{
ShowMsg(AlertType.error, "电话号码错误");
}
}
}
}
}
