public bool Addfilm(Model.film model) //增加一条电影信息
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into film(F_name,Length,F_type,Price)");
strSql.Append(" values (@F_name,@Length,@F_type,@Price); select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@F_name", SqlDbType.VarChar, 20),
new SqlParameter("@Length", SqlDbType.Int),
new SqlParameter("@F_type", SqlDbType.VarChar, 20),
new SqlParameter("@Price", SqlDbType.Int),
};
parameters[0].Value = model.F_name;
parameters[1].Value = model.Length;
parameters[2].Value = model.F_type;
parameters[3].Value = model.Price;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//根据电影编号，获取电影信息
public Model.film Getfilm(int F_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top 1 F_id,F_name,Length,F_type,Price ");
strSql.Append(" from film where F_id=@F_id");
SqlParameter[] parameters = { new SqlParameter("@F_id", SqlDbType.Int) };
parameters[0].Value = F_id;
Model.film model = new Model.film();
DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["F_id"] != null && dt.Rows[0]["F_id"].ToString() != "")
{
model.F_id = int.Parse(dt.Rows[0]["F_id"].ToString());
}
if (dt.Rows[0]["F_name"] != null && dt.Rows[0]["F_name"].ToString() != "")
{
model.F_name = dt.Rows[0]["F_name"].ToString();
}
if (dt.Rows[0]["Length"] != null && dt.Rows[0]["Length"].ToString() != "")
{
model.Length = int.Parse(dt.Rows[0]["Length"].ToString());
}
if (dt.Rows[0]["F_type"] != null && dt.Rows[0]["F_type"].ToString() != "")
{
model.F_type = dt.Rows[0]["F_type"].ToString();
}
if (dt.Rows[0]["Price"] != null && dt.Rows[0]["Price"].ToString() != "")
{
model.Price = int.Parse(dt.Rows[0]["Price"].ToString());
}
return(model);
}
else
{
return(null);
}
}
//更新一条电影信息
public bool Updatefilm(Model.film model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update film set");
strSql.Append(" F_name=@F_name,");
strSql.Append(" Length=@Length,");
strSql.Append(" F_type=@F_type,");
strSql.Append(" Price=@Price");
strSql.Append(" where F_id=@F_id");
SqlParameter[] parameters =
{
new SqlParameter("@F_name", SqlDbType.VarChar, 20),
new SqlParameter("@Length", SqlDbType.Int),
new SqlParameter("@F_type", SqlDbType.VarChar, 20),
new SqlParameter("@Price", SqlDbType.Int),
new SqlParameter("@F_id", SqlDbType.Int)
};
parameters[0].Value = model.F_name;
parameters[1].Value = model.Length;
parameters[2].Value = model.F_type;
parameters[3].Value = model.Price;
parameters[4].Value = model.F_id;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}