public ActionResult DeleteBuilding() { if (!AppData.IsManagerLogin) { return(Json(new { success = false, msg = "您未登录后台或会话已过期" })); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 803)) { return(Json(new { success = false, msg = "您没有执行该操作的权限" })); } Validation vld = new Validation(); int buildingID = vld.GetInt("id", false, "未传入楼盘ID"); PackageBLL packageBLL = new PackageBLL(); PackageBuildingObj packageBuildingObj = packageBLL.GetBuildingByID(buildingID); if (packageBuildingObj == null) { return(Json(new { success = false, msg = "该楼盘不存在!" })); } if (vld.HasError) { return(Json(new { success = false, msg = vld.GetError() })); } packageBLL.DeleteBuilding(buildingID); return(Json(new { success = true })); }
public void ModifyBuilding(PackageBuildingObj packageBuildingObj) { using (helper = new SqlHelper()) { string sql = "update PackageBuilding set BuildingName=@BuildingName,RegionID=@RegionID where BuildingID=@BuildingID"; helper.AddIntParameter("@BuildingID", packageBuildingObj.BuildingID); helper.AddIntParameter("@RegionID", packageBuildingObj.RegionID); helper.AddStringParameter("@BuildingName", 200, packageBuildingObj.BuildingName); helper.ExecuteNonQuery(sql, CommandType.Text); } }
public void AddBuilding(PackageBuildingObj packageBuildingObj) { using (helper = new SqlHelper()) { string sql = "insert into PackageBuilding (BuildingName,RegionID) values (@BuildingName,@RegionID) select @BuildingID=@@IDENTITY"; SqlParameter picIDParam = helper.AddOutputParameter("@BuildingID"); helper.AddIntParameter("@RegionID", packageBuildingObj.RegionID); helper.AddStringParameter("@BuildingName", 200, packageBuildingObj.BuildingName); helper.ExecuteNonQuery(sql, CommandType.Text); packageBuildingObj.BuildingID = (int)picIDParam.Value; } }
public ActionResult ModifyBuilding() { if (Request.HttpMethod == "POST") { if (!AppData.IsManagerLogin) { return(Json(new { success = false, msg = "您未登录后台或会话已过期" })); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 802)) { return(Json(new { success = false, msg = "您没有执行该操作的权限" })); } Validation vld = new Validation(); int buildingID = vld.GetInt("id", false, "未传入楼盘ID"); PackageBLL packageBLL = new PackageBLL(); PackageBuildingObj packageBuildingObj = packageBLL.GetBuildingByID(buildingID); if (packageBuildingObj == null) { return(Json(new { success = false, msg = "该楼盘不存在!" })); } packageBuildingObj.BuildingName = vld.Get("name", false, "请填写楼盘名称"); packageBuildingObj.RegionID = vld.GetInt("regionID", false, "请选择省市区"); if (vld.HasError) { return(Json(new { success = false, msg = vld.GetError() })); } packageBLL.ModifyBuilding(packageBuildingObj); return(Json(new { success = true })); } else { if (!AppData.IsManagerLogin) { return(Redirect("/Manage/Error/1.html")); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 802)) { return(Redirect("/Manage/Error/2.html")); } return(View()); } }
public PackageBuildingObj GetBuildingByID(int buildingID) { using (helper = new SqlHelper()) { helper.AddIntParameter("@BuildingID", buildingID); using (SqlDataReader dr = helper.ExecuteReader("select BuildingName,RegionID from PackageBuilding where BuildingID=@BuildingID", CommandType.Text)) { if (dr.HasRows && dr.Read()) { PackageBuildingObj res = new PackageBuildingObj(); res.BuildingID = buildingID; res.BuildingName = dr[0] == DBNull.Value ? null : (string)dr[0]; res.RegionID = dr[1] == DBNull.Value ? 0 : (int)dr[1]; return(res); } return(null); } } }
public void ModifyBuilding(PackageBuildingObj packageBuildingObj) { dal.ModifyBuilding(packageBuildingObj); }
public void AddBuilding(PackageBuildingObj packageBuildingObj) { dal.AddBuilding(packageBuildingObj); }