private void Query()
{
Response.ContentType = "application/json";
int id;
if (int.TryParse(Request.QueryString["id"], out id))
{
model.WebSite data = _webSiteBusiness.GetSingleOrDefault(string.Format("select * from WebSite where Id={0}", id));
Response.Write(new JavaScriptSerializer().Serialize(new { data }));
Response.End();
}
}
private void Update()
{
model.WebSite webSite;
if (Request.Form.AllKeys.Contains("id")) //edit
{
int id = Convert.ToInt32(Request.Form["id"]);
webSite = _webSiteBusiness.GetSingleOrDefault(string.Format("select * from WebSite where Id={0}", id));
if (webSite != null)
{
if (Request.Form.AllKeys.Contains("delete")) //delete
{
//1 删除站点下的服务器
_webServerBusiness.DeleteBySql(string.Format("where WebId = {0}", id));
//2 删除站点信息
_webSiteBusiness.Delete(webSite);
}
else
{
webSite.WebName = Request.Form["WebName"];
webSite.Host = Request.Form["Host"];
webSite.Manager = Request.Form["Manager"];
webSite.ManagerPhone = Request.Form["ManagerPhone"];
webSite.ManagerEmail = Request.Form["ManagerEmail"];
webSite.CheckUrl = Request.Form["CheckUrl"];
bool existsEnable = Request.Form.AllKeys.Contains("Enable");
webSite.Enable = existsEnable ? 1 : 0;
_webSiteBusiness.Update(webSite);
}
}
}
else
{
string webName = Request.Form["WebName"] ?? "";
webSite = _webSiteBusiness.GetSingleOrDefault(string.Format("select * from WebSite where WebName='{0}'", webName));
if (webSite != null)
{
Response.Write("exists");
Response.End();
}
else
{
webSite = new model.WebSite()
{
WebName = Request.Form["WebName"],
Host = Request.Form["Host"],
WebToken = Request.Form["WebToken"],
Manager = Request.Form["Manager"],
ManagerPhone = Request.Form["ManagerPhone"],
ManagerEmail = Request.Form["ManagerEmail"],
CheckUrl = Request.Form["CheckUrl"],
Enable = Request.Form.AllKeys.Contains("Enable") ? 1 : 0
};
_webSiteBusiness.Insert(webSite);
}
}
Response.Write("ok");
Response.End();
}
