public int UpdateNum(string id,int type) { int number; OxcoderIDAL.SearchChallengeIDAL sci = new OxcoderDAL.SearchChallengeDAL(); number = Convert.ToInt32(sci.SearchByChallengeID(id).Tables[0].Rows[0]["Challenge_Num"].ToString()); StringBuilder sql2 = new StringBuilder(); sql2.Append("update [Challenge] set Challenge_Num = @number where Challenge_ID like @id"); SqlParameter[] par2 = { new SqlParameter("@number",SqlDbType.Int), new SqlParameter("@id", SqlDbType.VarChar) }; par2[0].Value = number + type; par2[1].Value = id; return Common.DbHelperSQL.ExecuteSql(sql2.ToString(), par2); }
public int UpdateNum(string id, int type) { int number; OxcoderIDAL.SearchChallengeIDAL sci = new OxcoderDAL.SearchChallengeDAL(); number = Convert.ToInt32(sci.SearchByChallengeID(id).Tables[0].Rows[0]["Challenge_Num"].ToString()); StringBuilder sql2 = new StringBuilder(); sql2.Append("update [Challenge] set Challenge_Num = @number where Challenge_ID like @id"); SqlParameter[] par2 = { new SqlParameter("@number", SqlDbType.Int), new SqlParameter("@id", SqlDbType.VarChar) }; par2[0].Value = number + type; par2[1].Value = id; return(Common.DbHelperSQL.ExecuteSql(sql2.ToString(), par2)); }