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);
}
