protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["type"] != null)
{
H_houseinfor hh = H_houseinfor.Find("shi_id='" + Request.Form["Shi_id"] + "' and " + GetRolePermissionOrgIds("查看", "OrgID"));
if (hh != null)
{
hh.Shi_id = Request.Form["NewShi_id"];
if (H_houseinfor.FindCount("Shi_id", hh.Shi_id) == 0)
{
hh.Update();
//插入日志
Log log = new Log();
log.Action = "修改";
log.Category = "房源编号修改";
log.IP = HttpContext.Current.Request.UserHostAddress;
log.OccurTime = DateTime.Now;
log.UserID = Convert.ToInt32(HouseMIS.EntityUtils.Employee.Current.EmployeeID);
log.UserName = HouseMIS.EntityUtils.Employee.Current.Em_name;
log.Remark = "原房源编号=" + Request.Form["Shi_id"] + ",新房源编号=" + Request.Form["NewShi_id"];
log.Insert();
JSDo_UserCallBack_Success("", "操作成功!");
}
else
{
JSDo_UserCallBack_Error("", "操作失败!");
}
}
else
{
JSDo_UserCallBack_Error("", "您没有操作该房源的权限!");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
form1.Action += "?HouseID=" + HouseID;
if (!IsPostBack)
{
string seeRecord = GetRolePermissionEmployeeIds("查看录音", "EmployeeID");
string seeRecord_Mask = GetRolePermissionEmployeeIds("查看屏蔽录音", "EmployeeID");
string sql = string.Format(@"select b.recordUrl as a,
d.Name+'('+c.em_id+'-'+c.em_name+')'+' '+CONVERT(varchar,createTime,120) as c,
b.phoneID,b.employeeID,source
from i_InternetPhone b
inner join e_Employee c on b.employeeID=c.EmployeeID
inner join s_Organise d on d.OrgID=c.OrgID
where b.HouseId={0}
and b.recordUrlDel=1
and b.RecrodType=1
and b.talktime>0
and b.EmployeeID in(select EmployeeID
from e_Employee
where {1})
and b.phoneID not in (select a.phoneID
from i_InternetPhone a
inner join h_RecordClose b on a.phoneID = b.phoneID
where a.houseID ={0}
and b.IsCheck = 1
and a.EmployeeID not in (select EmployeeID
from e_Employee
where {2}))
order by b.phoneID desc",
Request.QueryString["HouseID"],
seeRecord,
seeRecord_Mask);
//string sql = string.Format(@"select A.recordUrl as a,C.Name+'('+B.em_id+'-'+B.em_name+')'+' '+CONVERT(varchar,createTime,120) as c,A.phoneID,A.employeeID,source
// from i_InternetPhone A
// left join e_Employee B on A.employeeID=B.EmployeeID
// left join s_Organise C on B.OrgID=C.OrgID
// where houseID={0}
// and A.recordUrlDel=1
// order by a.createTime desc",
// Request.QueryString["HouseID"]);
DataSet dts = DbHelperSQL.Query(sql);
if (dts.Tables[0].Rows.Count > 0)
{
sql = string.Format(@"select phoneID,EmployeeID from h_RecordClose where IsCheck=1 and phoneID in({0})",
string.Join(",", dts.Tables[0].AsEnumerable().Select(x => x.Field <decimal>("phoneID"))));
list_h_RecordClose = h_RecordClose.FindAll(sql);
}
hf_ly2.DataSource = dts.Tables[0];
hf_ly2.DataBind();
frmOldPrice.Text = H_houseinfor.Find("HouseID", HouseID).Min_price.ToString();
}
}
