public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Model.Msite NewMsite = new Model.Msite();
NewMsite.MsiteName = context.Request["value"].ToString();
NewMsite.AreasID = Convert.ToInt32(context.Request["pk"]);
context.Response.Write(new BLL.Msite().AddMsite(NewMsite));
}
/// <summary>
/// 根据传入的AreasID获取此AreasID下的Msite（测站信息）
/// </summary>
/// <param name="AreasId"></param>
/// <returns></returns>
public List <Model.Msite> GetMsiteByAreasId(int AreasId)
{
List <Model.Msite> Msites = new List <Model.Msite>();
string str = "select * from Msite where AreasID=" + AreasId;
DataTable dt = SqlHelper.ExecuteDataTable(str, CommandType.Text, null);
foreach (DataRow dr in dt.Rows)
{
Model.Msite m = new Model.Msite();
m.MsiteID = Convert.ToInt32(dr["MsiteID"]);
m.MsiteName = dr["MsiteName"].ToString();
m.AreasID = Convert.ToInt32(dr["AreasID"]);
m.MsiteTable = dr["MsiteTable"].ToString();
Msites.Add(m);
}
return(Msites);
}
/// <summary>
/// 增加一个测站
/// </summary>
/// <param name="NewMsite"></param>
/// <returns></returns>
public int AddMsite(Model.Msite NewMsite)
{
string str = "insert into Msite(MsiteName,AreasID) values(@MsiteName,@AreasID)";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@MsiteName", NewMsite.MsiteName),
new SqlParameter("@AreasID", NewMsite.AreasID)
};
int ok = SqlHelper.ExecuteNonQuery(str, System.Data.CommandType.Text, pms);
if (ok == 1)
{
return(200);
}
else
{
return(400);
}
}
public int AddMsite(Model.Msite NewMsite)
{
return(new DAL.Msite().AddMsite(NewMsite));
}
