/// <summary>
/// 检查发布的房源信息是否已经被申请完，
/// 先搜索出 房源信息中 可以入住的人数，再查询针对该房源通过申请的记录数，如果相等 则表示该房源已被申请完
/// edit by liujx 2010-5-22
/// </summary>
/// <param name="houselist"></param>
/// <returns></returns>
public bool IsHired(T_OA_HOUSELIST houselist, string StrUserID)
{
try
{
string checkState = ((int)CheckStates.Approved).ToString();
var listhouse = from h in dal.GetObjects <T_OA_HOUSEINFO>()
where h.HOUSEID == houselist.T_OA_HOUSEINFO.HOUSEID
select h;
var listapp = from k in dal.GetTable()
where k.T_OA_HOUSELIST.HOUSELISTID == houselist.HOUSELISTID && k.CHECKSTATE == checkState
select k;
if (listhouse.Count() > 0)
{
if (listhouse.FirstOrDefault().Number == listapp.Count())
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
Tracer.Debug("房源申请HouseHireAppManagementBll-IsHired" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(false);
}
}
//新增房源信息清单
private void AddHouseList(T_OA_HOUSEINFO houseObj, T_OA_HOUSEINFOISSUANCE issuanceObj)
{
T_OA_HOUSELIST houseListTmp = new T_OA_HOUSELIST();
houseListTmp.T_OA_HOUSEINFO = houseObj;
houseListTmp.T_OA_HOUSEINFO.HOUSEID = houseObj.HOUSEID;
houseListTmp.HOUSELISTID = Guid.NewGuid().ToString();
houseListTmp.T_OA_HOUSEINFOISSUANCE = issuanceObj;
houseListTmp.CONTENT = System.Convert.ToString(issuanceObj.CONTENT); //租房协议
houseListTmp.SHAREDDEPOSIT = houseObj.SHAREDDEPOSIT; //合租租金
houseListTmp.SHAREDRENTCOST = houseObj.SHAREDRENTCOST; //合租押金
houseListTmp.RENTCOST = houseObj.RENTCOST; //整套押金
houseListTmp.DEPOSIT = houseObj.DEPOSIT; //整套租金
houseListTmp.MANAGECOST = (int)(houseObj.MANAGECOST / houseObj.Number); //管理费
houseListTmp.CREATEUSERID = Common.CurrentLoginUserInfo.EmployeeID;
houseListTmp.CREATEUSERNAME = Common.CurrentLoginUserInfo.EmployeeName;
houseListTmp.CREATEPOSTID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
houseListTmp.CREATEDEPARTMENTID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
houseListTmp.CREATECOMPANYID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
houseListTmp.CREATEDATE = DateTime.Now;
houseListTmp.OWNERID = Common.CurrentLoginUserInfo.EmployeeID;
houseListTmp.OWNERNAME = Common.CurrentLoginUserInfo.EmployeeName;
houseListTmp.OWNERPOSTID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
houseListTmp.OWNERDEPARTMENTID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
houseListTmp.OWNERCOMPANYID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
houseLists.Add(houseListTmp);
}
public bool AddHouseInfoIssuance(T_OA_HOUSEINFOISSUANCE issuanceObj, List <T_OA_HOUSELIST> houseListObj, List <T_OA_DISTRIBUTEUSER> DistributeListObj)
{
try
{
//issuanceObj.T_OA_HOUSELIST = context.GetObjectByKey(issuanceObj.T_OA_HOUSELIST.EntityKey)
//issuanceObj.EntityKey
//Utility.RefreshEntity(issuanceObj);
T_OA_HOUSEINFOISSUANCE masterent = new T_OA_HOUSEINFOISSUANCE();
Utility.CloneEntity(issuanceObj, masterent);
foreach (var h in houseListObj)
{
//h.T_OA_HOUSEINFO = context.GetObjectByKey(h.T_OA_HOUSEINFO.EntityKey) as T_OA_HOUSEINFO;
//h.T_OA_HOUSEINFOISSUANCE = context.GetObjectByKey(h.T_OA_HOUSEINFOISSUANCE.EntityKey) as T_OA_HOUSEINFOISSUANCE;
T_OA_HOUSELIST houseListObjEnt = new T_OA_HOUSELIST();
Utility.CloneEntity(h, houseListObjEnt);
houseListObjEnt.T_OA_HOUSEINFOISSUANCEReference.EntityKey = new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_HOUSEINFOISSUANCE", "ISSUANCEID", h.T_OA_HOUSEINFOISSUANCE.ISSUANCEID);
houseListObjEnt.T_OA_HOUSEINFOReference.EntityKey = new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_HOUSEINFO", "HOUSEID", h.T_OA_HOUSEINFO.HOUSEID);
//context.AddObject("T_OA_HOUSELIST", houseListObjEnt);
dal.AddToContext(houseListObjEnt);
}
foreach (var h in DistributeListObj)
{
//context.AddObject("T_OA_DISTRIBUTEUSER", h);
dal.AddToContext(h);
}
//context.AddObject("T_OA_HOUSEINFOISSUANCE", masterent);
//int p=dal.Add(masterent);
dal.AddToContext(masterent);
int p = dal.SaveContextChanges();
if (!(p > 0))
{
return(false);
}
return(true);
}
catch (Exception ex)
{
Tracer.Debug("房源发布HouseListBll-AddHouseInfoIssuance" + System.DateTime.Now.ToString() + " " + ex.ToString());
//throw (ex);
return(false);
}
}
//新增房源信息清单
private void AddHouseList(T_OA_HOUSEINFO houseObj, T_OA_HOUSEINFOISSUANCE issuanceObj)
{
T_OA_HOUSELIST houseListTmp = new T_OA_HOUSELIST();
houseListTmp.T_OA_HOUSEINFO = houseObj;
houseListTmp.T_OA_HOUSEINFO.HOUSEID = houseObj.HOUSEID;
houseListTmp.HOUSELISTID = Guid.NewGuid().ToString();
houseListTmp.T_OA_HOUSEINFOISSUANCE = issuanceObj;
houseListTmp.CONTENT = System.Convert.ToString(issuanceObj.CONTENT);//租房协议
houseListTmp.SHAREDDEPOSIT = houseObj.SHAREDDEPOSIT;//合租租金
houseListTmp.SHAREDRENTCOST = houseObj.SHAREDRENTCOST;//合租押金
houseListTmp.RENTCOST = houseObj.RENTCOST;//整套押金
houseListTmp.DEPOSIT = houseObj.DEPOSIT;//整套租金
houseListTmp.MANAGECOST = (int)(houseObj.MANAGECOST/houseObj.Number); //管理费
houseListTmp.CREATEUSERID = Common.CurrentLoginUserInfo.EmployeeID;
houseListTmp.CREATEUSERNAME = Common.CurrentLoginUserInfo.EmployeeName;
houseListTmp.CREATEPOSTID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
houseListTmp.CREATEDEPARTMENTID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
houseListTmp.CREATECOMPANYID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
houseListTmp.CREATEDATE = DateTime.Now;
houseListTmp.OWNERID = Common.CurrentLoginUserInfo.EmployeeID;
houseListTmp.OWNERNAME = Common.CurrentLoginUserInfo.EmployeeName;
houseListTmp.OWNERPOSTID = Common.CurrentLoginUserInfo.UserPosts[0].PostID;
houseListTmp.OWNERDEPARTMENTID = Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
houseListTmp.OWNERCOMPANYID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
houseLists.Add(houseListTmp);
}
/// <summary>
/// 修改房源发布信息
/// 旧版本在审核时会把所有的房源列表删除
/// SubmitFlag 如果为审核状态只对发布表的状态进行改变
/// </summary>
/// <param name="issuanceObj">房源发布</param>
/// <param name="houseListObj">房源列表</param>
/// <param name="DistributeListObj">发布对象</param>
/// <param name="SubmitFlag">审核状态</param>
/// <returns></returns>
public bool UpdateHouseInfoIssuance(T_OA_HOUSEINFOISSUANCE issuanceObj, List <T_OA_HOUSELIST> houseListObj, List <T_OA_DISTRIBUTEUSER> DistributeListObj, bool SubmitFlag)
{
try
{
this.BeginTransaction();
int i = 0;
issuanceObj.UPDATEDATE = System.DateTime.Now;
var entity = dal.GetObjects().Where(s => s.ISSUANCEID == issuanceObj.ISSUANCEID).FirstOrDefault();
//var entity = dal.GetTable().Where(s => s.ISSUANCEID == issuanceObj.ISSUANCEID).FirstOrDefault();
if (entity != null)
{
CloneEntity(issuanceObj, entity);
//if (dal.Update(entity) == -1)
//{
// return false;
//}
}
i = dal.Update(entity);
//先删除houselist
if (!SubmitFlag)
{
var ent = dal.GetObjects <T_OA_HOUSELIST>().Where(s => s.T_OA_HOUSEINFOISSUANCE.ISSUANCEID == entity.ISSUANCEID);
//var ent = houseListBll.dal.GetTable().Where(s => s.T_OA_HOUSEINFOISSUANCE.ISSUANCEID == issuanceObj.ISSUANCEID);
if (ent != null)
{
foreach (var h in ent)
{
dal.DeleteFromContext(h);
}
}
//再插入houselist
foreach (var h in houseListObj)
{
T_OA_HOUSELIST houseListObjEnt = new T_OA_HOUSELIST();
Utility.CloneEntity(h, houseListObjEnt);
houseListObjEnt.HOUSELISTID = h.HOUSELISTID;
houseListObjEnt.T_OA_HOUSEINFOISSUANCEReference.EntityKey = new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_HOUSEINFOISSUANCE", "ISSUANCEID", h.T_OA_HOUSEINFOISSUANCE.ISSUANCEID);
houseListObjEnt.T_OA_HOUSEINFOReference.EntityKey = new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_HOUSEINFO", "HOUSEID", h.T_OA_HOUSEINFO.HOUSEID);
//context.AddObject("T_OA_HOUSELIST", houseListObjEnt);
//dal.Add(houseListObjEnt);
dal.AddToContext(houseListObjEnt);
}
//先删除distributelist
var entdis = dal.GetObjects <T_OA_DISTRIBUTEUSER>().Where(s => s.FORMID == entity.ISSUANCEID);
//var entdis = distributeBll.GetTable().Where(s => s.FORMID == issuanceObj.ISSUANCEID);
if (entdis != null)
{
foreach (var h in entdis)
{
dal.DeleteFromContext(h);
}
}
//再插入distributelist
foreach (var h in DistributeListObj)
{
//context.AddObject("T_OA_DISTRIBUTEUSER", h);
//dal.Add(h);
dal.AddToContext(h);
}
i = dal.SaveContextChanges();
}
if (i > 0)
{
this.CommitTransaction();
return(true);
}
else
{
this.RollbackTransaction();
return(false);
}
}
catch (Exception ex)
{
this.RollbackTransaction();
Tracer.Debug("房源发布HouseListBll-UpdateHouseInfoIssuance" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(false);
throw (ex);
}
}
