public bool UpLabelContent(M_Zone_Node model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
//return Sql.UpLabel(strTableName, "[Content]=" + model.Content+"[Overflow]=" + model.Overflow+"[Display]=" + model.Display+"[Background]=" + model.Background, "[UserID]=" + model.UserID + " AND [NodeID]=" + model.NodeID + " AND [LabelID]=" + model.LabelID, M_Zone_Node.GetParameters(model));
}
public bool UpLabel(M_Zone_Node model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
public DataTable SelLabel(M_Zone_Node model)
{
return(Sql.Sel(strTableName, "[UserID]=" + model.UserID + " AND [NodeID]=" + model.NodeID, ""));
}
public DataTable SelLabelByLabelID(M_Zone_Node model)
{
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("UserID", model.UserID), new SqlParameter("NodeID", model.NodeID), new SqlParameter("LabelID", model.LabelID) };
return(Sql.Sel(strTableName, "[UserID]=@UserID AND [NodeID]=@NodeID AND [LabelID]=LabelID", "", sp));
}
public int AddLabel(M_Zone_Node model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
