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