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