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