public List <Views.userSign> gethenchmanbyid(string id) { List <Views.userSign> signList = new List <Views.userSign>(); Cook.DAL.henchman_ hen = new Cook.DAL.henchman_(); Cook.DAL.users user = new DAL.users(); List <Cook.Model.henchman_> followList = DataTableToList(hen.GetList("", "", id)); foreach (Cook.Model.henchman_ item in followList) { Views.userSign sign = hen.gethenchman(user.GetModel(item.id.ToString())); sign.time = item.time; signList.Add(sign); } return(signList); }
public bool sethenchman(string tableid, int type) { int num = new Cook.DAL.henchman_().GetRecordCount("", tableid); if (type == 0) { num--; if (num < 0) { num = 0; } } else if (type == 1) { num++; } StringBuilder strSql = new StringBuilder(); strSql.Append("update users set "); strSql.Append(" henchman=@henchman "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@henchman", SqlDbType.VarChar, -1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = num; parameters[1].Value = tableid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }