/// <summary>
/// 删除影院
/// </summary>
/// <param name="en"></param>
/// <returns></returns>
public int delete(Cinema en)
{
string strSql = "delete from Cinema where id=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", en.id)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 新增影院
/// </summary>
/// <param name="en"></param>
/// <returns></returns>
public int add(Cinema en)
{
string strSql = "insert into Cinema (name, areaID, roomNum, person, tel, address) "
+ "values (@name, @areaID, @roomNum, @person, @tel, @address)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@name", en.name),
new SqlParameter("@areaID", en.areaID),
new SqlParameter("@roomNum", en.roomNum),
new SqlParameter("@person", en.person),
new SqlParameter("@tel", en.tel),
new SqlParameter("@address", en.address)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 修改影院
/// </summary>
/// <param name="en"></param>
/// <returns></returns>
public int update(Cinema en)
{
string strSql = "update Cinema set name=@name, areaID=@areaID, roomNum=@roomNum, person=@person, tel=@tel, address=@address where id=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id", en.id),
new SqlParameter("@name", en.name),
new SqlParameter("@areaID", en.areaID),
new SqlParameter("@roomNum", en.roomNum),
new SqlParameter("@person", en.person),
new SqlParameter("@tel", en.tel),
new SqlParameter("@address", en.address)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
/// <summary>
/// 搜索影院列表
/// </summary>
/// <param name="name">影院名称</param>
/// <param name="area">所属地区</param>
/// <returns></returns>
public JsonResult Cinema_search(string sName, string sArea)
{
Cinema en = new Cinema();
en.name = sName;
en.area = sArea;
DaCinema dal = new DaCinema();
var result = new CustomJsonResult();
result.Data = dal.getList(sName, sArea);
return result;
}
/// <summary>
/// 删除影院
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult Cinema_remove(string id)
{
Cinema en = new Cinema();
en.id = Convert.ToInt32(id);
DaCinema dal = new DaCinema();
var result = new CustomJsonResult();
result.Data = dal.delete(en);
return result;
}
public JsonResult Cinema_edit(string id, string name, string area, string roomNum, string person, string tel, string address)
{
Cinema en = new Cinema();
en.id = Convert.ToInt32(id);
en.name = name;
en.areaID = Convert.ToInt32(area);
en.roomNum = Convert.ToInt32(roomNum);
en.person = person;
en.tel = tel;
en.address = address;
DaCinema dal = new DaCinema();
var result = new CustomJsonResult();
result.Data = dal.update(en);
return result;
}
