public int Add(Tz888.Model.advertise.ADchannelInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ADchannelInfo("); strSql.Append("BName,BDoc)"); strSql.Append(" values ("); strSql.Append("@BName,@BDoc)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BName", SqlDbType.VarChar, 50), new SqlParameter("@BDoc", SqlDbType.VarChar, 100) }; parameters[0].Value = model.BName; parameters[1].Value = model.BDoc; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
public int UpdatechannelInfo(Tz888.Model.advertise.ADchannelInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ADchannelInfo set "); strSql.Append("BName=@BName,"); strSql.Append("BDoc=@BDoc"); strSql.Append(" where BID=@BID "); SqlParameter[] parameters = { new SqlParameter("@BID", SqlDbType.Int, 4), new SqlParameter("@BName", SqlDbType.VarChar, 50), new SqlParameter("@BDoc", SqlDbType.VarChar, 100) }; parameters[0].Value = model.BID; parameters[1].Value = model.BName; parameters[2].Value = model.BDoc; int num = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return(num); }