public Model.MenuInfoModel GetModel(int Id)
{
string sql = "select * from MenuInfo where MenuId =" + Id;
Model.MenuInfoModel model = new Model.MenuInfoModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
model.MenuId = Convert.ToInt32(dr["MenuId"].ToString());
model.MenuName = dr["MenuName"].ToString();
model.MenuUrl = dr["MenuUrl"].ToString();
model.Bid = Convert.ToInt32(dr["Bid"].ToString());
model.OrderId = Convert.ToInt32(dr["OrderId"].ToString());
model.StatusId = Convert.ToInt32(dr["StatusId"].ToString());
}
return(model);
}
public int Update(Model.MenuInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MenuInfo set ");
strSql.Append("MenuName=@MenuName,MenuUrl=@MenuUrl,OrderId=@OrderId,Bid=@Bid,StatusId=@StatusId ");
strSql.Append(" where MenuId = @MenuId ");
SqlParameter[] parameters =
{
new SqlParameter("@MenuName", model.MenuName),
new SqlParameter("@MenuUrl", model.MenuUrl),
new SqlParameter("@OrderId", model.OrderId),
new SqlParameter("@Bid", model.Bid),
new SqlParameter("@StatusId", model.StatusId),
new SqlParameter("@MenuId", model.MenuId),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.MenuInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MenuInfo(");
strSql.Append("MenuName,MenuUrl,OrderId,Bid,StatusId)");
strSql.Append(" values (");
strSql.Append("@MenuName,@MenuUrl,@OrderId,@Bid,@StatusId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MenuName", model.MenuName),
new SqlParameter("@MenuUrl", model.MenuUrl),
new SqlParameter("@OrderId", model.OrderId),
new SqlParameter("@Bid", model.Bid),
new SqlParameter("@StatusId", model.StatusId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
